|
|
PAINSTRUCT FILE
Instructor Information
Contains instructor definition information.
REFERENCED BY
HR30.1 TR08.1 TR09.1 TR14.1 TR200 TR201
TR202 TR204 TR207 TR21.1 TR22.1 TR220
TR26.1 TR500 HR11.1 HR11.2 HR511 HR650
PA02.1 PA100 PA102 PA502 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR113 PR120 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
Element: Instruct Contains the instructor number.
INS-INSTRUCT-EMPLR Alpha 60 (Lower Case) TR07.1
Element: Instruct EmplrContains the instructor's employer.
INS-COMPANY Numeric 4 TR07.1
Element: Company Contains the company number.
INS-EMPLOYEE Numeric 9 TR07.1
Element: 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
Element: 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
Element: Name Contains the instructor's last name if
the instructor is not an employee.
Blank = employee
INS-MIDDLE-INIT Alpha 1 TR07.1
Element: Middle InitialContains the instructor's middle
initial if the instructor is not an
employee.
Blank = employee
INS-ADDR1 Alpha 30 (Lower Case) TR07.1
Element: 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
Element: Address 1 Contains the second line of address
information if the instructor is not an
employee.
Blank = employee
INS-ADDR3 Alpha 30 (Lower Case) TR07.1
Element: Address 1 Contains the third line of address
information if the instructor is not an
employee.
Blank = employee
INS-ADDR4 Alpha 30 (Lower Case) TR07.1
Element: Address 1 Contains the fourth line of address
information if the instructor is not an
employee.
Blank = employee
INS-CITY Alpha 18 (Lower Case) TR07.1
Element: City Contains the city of the address if the
instructor is not an employee.
Blank = employee
INS-STATE Alpha 2 TR07.1
Element: State or ProviContains the two-character state code
if the instructor is not an employee.
Blank = employee
INS-ZIP Alpha 10 TR07.1
Element: 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
Element: Hm Phone CntryContains 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
Element: 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
Element: Work TelephoneContains 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
Element: Date Contains the first date the instructor
can teach a course.
INS-END-DATE Numeric 8 (yyyymmdd) TR07.1
Element: Date Contains the last date the instructor
can teach a course.
INS-E-MAIL-ADDR Alpha 60
Element: E Mail Addr Contains the instructor's internal
E-Mail address.
INS-SHORT-NAME Derived
Element: Short Name Contains the instructor's short name.
INS-SHORT-EMPLOYER Derived
Element: Short EmployerContains an abbreviated form of the
instructor's employer if the instructor
is not an employee.
Blank = employee
INS-COUNTRY-CODE Alpha 2 TR07.1
Element: Country Code Contains the country of the
instructor's address.
INS-CONSENT Alpha 1 TR07.1
Element: Consent N = No
Y = Yes
" " = No
INS-EMP-SHORT-NAME Derived
Element: Emp Short Name
INS-INS-SHORT-NAME Derived
Element: 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
TR21.1 TR22.1
TR220 TR26.1
TR500
INSSET2 INSTRUCT* TR07.1
INSSET3 COMPANY KeyChange HR11.1 HR11.2
EMPLOYEE HR511 HR650
LAST-NAME PA02.1 PA100
FIRST-NAME PA102 PA502
MIDDLE-INIT PA52.1 PA52.3
INSTRUCT PA52.4 PA52.5
TR07.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
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
|
