PAINSTRUCT FILE
Instructor Information
Contains instructor definition information.
REFERENCED BY
HR30.1 TR08.1 TR09.1 TR14.1 TR200 TR201
TR202 TR204 TR207 TR22.1 TR220 TR500
HR511 HR650 PA502 PR13.1 PR13.5 PR13.6
PR13.8
UPDATED BY
TR07.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
INS-INSTRUCT Numeric 10 TR07.1
Instruct Contains the instructor number.
INS-INSTRUCT-EMPLR Alpha 60 (Lower Case) TR07.1
Instruct Emplr Contains the instructor's employer.
INS-COMPANY Numeric 4 TR07.1
Company Contains the company number.
INS-EMPLOYEE Numeric 9 TR07.1
Employee 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 Alpha 15 (Lower Case) TR07.1
First Name Contains the instructor's first name,
if the instructor is not an employee.
Blank = employee.
INS-LAST-NAME Alpha 30 (Lower Case) TR07.1
Last Name Contains the instructor's last name if
the instructor is not an employee.
Blank = employee
INS-MIDDLE-INIT Alpha 1 TR07.1
Middle Initial Contains the instructor's middle
initial if the instructor is not an
employee.
Blank = employee
INS-ADDR1 Alpha 30 (Lower Case) TR07.1
Address 1 Contains the first line of address
information if the instructor is not an
employee.
Blank = employee
INS-ADDR2 Alpha 30 (Lower Case) TR07.1
Address 2 Contains the second line of address
information if the instructor is not an
employee.
Blank = employee
INS-ADDR3 Alpha 30 (Lower Case) TR07.1
Address 3 Contains the third line of address
information if the instructor is not an
employee.
Blank = employee
INS-ADDR4 Alpha 30 (Lower Case) TR07.1
Address 4 Contains the fourth line of address
information if the instructor is not an
employee.
Blank = employee
INS-CITY Alpha 18 (Lower Case) TR07.1
City Contains the city of the address if the
instructor is not an employee.
Blank = employee
INS-STATE Alpha 2 TR07.1
State or Province Contains the two-character state code
if the instructor is not an employee.
Blank = employee
INS-ZIP Alpha 10 TR07.1
Postal Code Contains the postal code of the
instructor's address if the instructor
is not an employee.
Blank = employee
INS-HM-PHONE-CNTRY Alpha 6 TR07.1
Hm Phone Cntry Contains the country code for the
instructor's home telephone number if
the instructor is not an employee.
Blank = employee
INS-HM-PHONE-NBR Alpha 15 TR07.1
Hm Phone Nbr Contains the instructor's home
telephone number if the instructor is
not an employee.
Blank = employee
INS-WK-PHONE-CNTRY Alpha 6 TR07.1
Work Telephone Contains the country code for the
Country instructor's work telephone number if
the instructor is not an employee.
Blank = employee
INS-WK-PHONE-NBR Alpha 15 TR07.1
Work Telephone Contains the instructor's work
telephone number if the instructor is
not an employee.
Blank = employee
INS-WK-PHONE-EXT Alpha 5 TR07.1
Work Telephone Contains the instructor's work
Extension telephone extension if the instructor is
not an employee.
Blank = employee
INS-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR07.1
Effective Date Contains the first date the instructor
can teach a course.
INS-END-DATE Numeric 8 (yyyymmdd) TR07.1
Ending Date Contains the last date the instructor
can teach a course.
INS-E-MAIL-ADDR Alpha 60
E Mail Addr Contains the instructor's internal
E-Mail address.
INS-SHORT-NAME Derived
Short Name Contains the instructor's short name.
INS-SHORT-EMPLOYER Derived
Short Employer Contains an abbreviated form of the
instructor's employer if the instructor
is not an employee.
Blank = employee
INS-COUNTRY-CODE Alpha 2 TR07.1
Country Code Contains the country of the
instructor's address.
INS-CONSENT Alpha 1 TR07.1
Consent N = No
Y = Yes
" " = No
INS-EMP-SHORT-NAME Derived
Emp Short Name
INS-INS-SHORT-NAME Derived
Ins Short Name
PAINSTRUCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INSSET1 INSTRUCT HR30.1 TR07.1
TR08.1 TR09.1
TR14.1 TR200
TR201 TR202
TR204 TR207
TR22.1 TR220
TR500
INSSET2 INSTRUCT* TR07.1
INSSET3 COMPANY KeyChange HR511 HR650
EMPLOYEE PA502 TR07.1
LAST-NAME PR13.1 PR13.5
FIRST-NAME PR13.6 PR13.8
MIDDLE-INIT
INSTRUCT
PAINSTRUCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Not Required
Valid When (INS-COMPANY != Zeroes )
INS-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (INS-COUNTRY-CODE != Spaces )
INS-COUNTRY-CODE -> INT-COUNTRY-CODE
Employee EMPLOYEE Not Required
Valid When (INS-EMPLOYEE != Zeroes )
INS-COMPANY -> EMP-COMPANY
INS-EMPLOYEE -> EMP-EMPLOYEE
Paemployee PAEMPLOYEE Not Required
Valid When (INS-EMPLOYEE != Zeroes )
INS-COMPANY -> PEM-COMPANY
INS-EMPLOYEE -> PEM-EMPLOYEE
PAINSTRUCT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Correspondence HRCORRESP
"5" -> HCP-REQ-TYPE
INS-INSTRUCT -> HCP-ID-NBR
Zeroes -> HCP-COMPANY
Zeroes -> HCP-DEPENDENT
HCP-SEQ-NBR
Course Instr PAINSCOURS Delete Cascades
INS-INSTRUCT -> INC-INSTRUCT
INC-COURSE
Session Instr PAINSTSES Delete Cascades
INS-INSTRUCT -> ISE-INSTRUCT
ISE-COURSE
ISE-SESSION
ISE-START-DATE
ISE-INSTR-TYPE
|
