|
|
PAINSTRUCT FILE
Instructor Information
Contains instructor defintion information.
REFERENCED BY
HR30.1 TR08.1 TR09.1 TR14.1 TR200 TR201
TR202 TR204 TR207 TR220 HR11.1 HR511
PA02.1 PA100 PA102 PA502 PA52.1 PA52.3
PA52.4 PA52.5 PR13.1
UPDATED BY
HR704 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-COUNTRY Alpha 30 (Lower Case)
Country or Other Contains the country of the address or
additional information such as an
attention name 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 HR704 TR07.1
Country Code Contains the country of the instructor's
address.
INS-CONSENT Alpha 1 TR07.1
Consent N = No
Y = Yes
" " = No
PAINSTRUCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INSSET1 INSTRUCT HR30.1 HR704
TR07.1 TR08.1
TR09.1 TR14.1
TR200 TR201
TR202 TR204
TR207 TR220
INSSET2 INSTRUCT* TR07.1
INSSET3 COMPANY KeyChange HR11.1 HR511
EMPLOYEE PA02.1 PA100
LAST-NAME PA102 PA502
FIRST-NAME PA52.1 PA52.3
MIDDLE-INIT PA52.4 PA52.5
INSTRUCT TR07.1 PR13.1
PAINSTRUCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Not Required
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
|