PAINSTRUCT

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
TR07.1 TR207 BN305 HR11.1 HR11.2 HR511
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9

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

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
EMPLOYEE
LAST-NAME
FIRST-NAME
MIDDLE-INIT
INSTRUCT
KeyChange
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
TR07.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9


PAINSTRUCT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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 Required
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
NAME
RELATED 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


File created: Wed Jun 08 20:50:24 2016

Home
Contact Us



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