Instructor Information
Contains instructor definition information.
REFERENCED BY
TR07.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
INS-INSTRUCT Element: Instruct | Numeric 10 Contains the instructor number. |
|
||
INS-INSTRUCT-EMPLR Element: Instruct Emplr | Alpha 60 (Lower Case) Contains the instructor's employer. |
|
||
INS-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||
INS-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. |
|
||
INS-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) Contains the instructor's first name, if the instructor is not an employee. Blank = employee. |
|
||
INS-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) Contains the instructor's last name if the instructor is not an employee. Blank = employee |
|
||
INS-MIDDLE-INIT Element: Middle Init | Alpha 1 Contains the instructor's middle initial if the instructor is not an employee. Blank = employee |
|
||
INS-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) Contains the first line of address information if the instructor is not an employee. Blank = employee |
|
||
INS-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) Contains the second line of address information if the instructor is not an employee. Blank = employee |
|
||
INS-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) Contains the third line of address information if the instructor is not an employee. Blank = employee |
|
||
INS-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) Contains the fourth line of address information if the instructor is not an employee. Blank = employee |
|
||
INS-CITY Element: Hr City | Alpha 58 (Lower Case) Contains the city of the address if the instructor is not an employee. Blank = employee |
|
||
INS-STATE Element: State | Alpha 2 Contains the two-character state code if the instructor is not an employee. Blank = employee |
|
||
INS-ZIP Element: Zip | Alpha 10 Contains the postal code of the instructor's address if the instructor is not an employee. Blank = employee |
|
||
INS-HM-PHONE-CNTRY Element: Hm Phone Cntry | Alpha 6 Contains the country code for the instructor's home telephone number if the instructor is not an employee. Blank = employee |
|
||
INS-HM-PHONE-NBR Element: Hm Phone Nbr | Alpha 15 Contains the instructor's home telephone number if the instructor is not an employee. Blank = employee |
|
||
INS-WK-PHONE-CNTRY Element: Wk Phone Cntry | Alpha 6 Contains the country code for the instructor's work telephone number if the instructor is not an employee. Blank = employee |
|
||
INS-WK-PHONE-NBR Element: Wk Phone Nbr | Alpha 15 Contains the instructor's work telephone number if the instructor is not an employee. Blank = employee |
|
||
INS-WK-PHONE-EXT Element: Wk Phone Ext | Alpha 5 Contains the instructor's work telephone extension if the instructor is not an employee. Blank = employee |
|
||
INS-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the first date the instructor can teach a course. |
|
||
INS-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the last date the instructor can teach a course. |
|
||
INS-E-MAIL-ADDR Element: Email Address | Alpha 60 (Lower Case) Contains the instructor's internal E-Mail address. |
|
||
INS-SHORT-NAME Element: Short Name | Derived Contains the instructor's short name. |
|
||
INS-SHORT-EMPLOYER Element: Short Employer | Derived Contains an abbreviated form of the instructor's employer if the instructor is not an employee. Blank = employee |
|
||
INS-COUNTRY-CODE Element: Country Code | Alpha 2 Contains the country of the instructor's address. |
|
||
INS-CONSENT Element: Consent | Alpha 1 N = No Y = Yes " " = No |
|
||
INS-EMP-SHORT-NAME Element: Emp Short Name | Derived |
|
||
INS-INS-SHORT-NAME Element: Ins Short Name | Derived |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INSSET1 |
INSTRUCT |
|
| ||||||||||||||||||||||
INSSET2 |
INSTRUCT* |
|
| ||||||||||||||||||||||
INSSET3 |
COMPANY EMPLOYEE LAST-NAME FIRST-NAME MIDDLE-INIT INSTRUCT |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Not Required
| ||||||||||||
Country | INSTCTRYCD |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Correspondence | HRCORRESP |
| |||||||||||||||
Course Instr | PAINSCOURS |
Delete Cascades
| |||||||||||||||
Session Instr | PAINSTSES |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.