Instructor Information

Contains instructor definition information.

REFERENCED BY

HR30.1	TR08.1	TR09.1	TR14.1	TR200	TR201
TR202	TR204	TR21.1	TR22.1	TR220	TR26.1
TR500

UPDATED BY

BN305	HR11.1	HR11.2	HR28.1	HR511	LT101
ZH510	PA02.1	PA100	PA102	PA115	PA13.1
PA13.2	PA502	PA513	PA52.1	PA52.3	PA52.4
PA52.5	TR07.1	TR207	PR110	PR113	PR12.6
PR120	PR13.1	PR13.5	PR13.6	PR13.8	PR13.9
PR30.2

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
INS-INSTRUCT Element: Instruct	Numeric 10 Contains the instructor number.	TR07.1
INS-INSTRUCT-EMPLR Element: Instruct Emplr	Alpha 60 (Lower Case) Contains the instructor's employer.	TR07.1
INS-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	TR07.1
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.	TR07.1
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.	TR07.1
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	TR07.1
INS-MIDDLE-INIT Element: Middle Init	Alpha 1 Contains the instructor's middle initial if the instructor is not an employee. Blank = employee	TR07.1
INS-ADDR1 Element: Addr1	Alpha 30 (Lower Case) Contains the first line of address information if the instructor is not an employee. Blank = employee	TR07.1
INS-ADDR2 Element: Addr1	Alpha 30 (Lower Case) Contains the second line of address information if the instructor is not an employee. Blank = employee	TR07.1
INS-ADDR3 Element: Addr1	Alpha 30 (Lower Case) Contains the third line of address information if the instructor is not an employee. Blank = employee	TR07.1
INS-ADDR4 Element: Addr1	Alpha 30 (Lower Case) Contains the fourth line of address information if the instructor is not an employee. Blank = employee	TR07.1
INS-CITY Element: City	Alpha 18 (Lower Case) Contains the city of the address if the instructor is not an employee. Blank = employee	TR07.1
INS-STATE Element: State	Alpha 2 Contains the two-character state code if the instructor is not an employee. Blank = employee	TR07.1
INS-ZIP Element: Zip	Alpha 10 Contains the postal code of the instructor's address if the instructor is not an employee. Blank = employee	TR07.1
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	TR07.1
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	TR07.1
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	TR07.1
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	TR07.1
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	TR07.1
INS-EFFECTIVE-DATE Element: Effective Date	Numeric 8 (yyyymmdd) Contains the first date the instructor can teach a course.	TR07.1
INS-END-DATE Element: End Date	Numeric 8 (yyyymmdd) Contains the last date the instructor can teach a course.	TR07.1
INS-E-MAIL-ADDR Element: Email Address	Alpha 60 (Lower Case) Contains the instructor's internal E-Mail address.	TR07.1
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.	TR07.1
INS-CONSENT Element: Consent	Alpha 1 N = No Y = Yes " " = No	TR07.1
INS-EMP-SHORT-NAME Element: Emp Short Name	Derived
INS-INS-SHORT-NAME Element: Ins Short Name	Derived

PAINSTRUCT FILE INDEX

PAINSTRUCT FILE RELATIONS

ONE TO ONE RELATIONS

PAINSTRUCT FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.