PAINSTRUCT – Instructor Information

System
Personnel (PA)
Prefix
INS
Primary key
INSTRUCT
Fields
28
Updated by
1 program
Referenced by
46 programs

PAINSTRUCT is the Instructor Information table in Lawson Personnel (prefix INS). It is indexed by INSTRUCT (INSSET1); alternate indexes: INSSET2 and INSSET3. It is related 1:1 to PRSYSTEM, INSTCTRYCD, EMPLOYEE and PAEMPLOYEE and 1:M to HRCORRESP, PAINSCOURS and PAINSTSES. It is updated by TR07.1 and referenced by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR30.1, HR511, LT101 and 38 more. The table has 28 fields, 3 indexes and 7 documented relations.

About PAINSTRUCT

Contains instructor definition information.

Fields (28)

Column = COBOL field name without the INS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#INS-INSTRUCT PK
INSTRUCT		Numeric 10Contains the instructor number.TR07.1
#INS-INSTRUCT-EMPLR
INSTRUCT_EMPLR		Alpha 60 (Lower Case)Contains the instructor's employer.TR07.1
#INS-COMPANY SET3
COMPANY		Numeric 4Contains the company number.TR07.1
#INS-EMPLOYEE SET3
EMPLOYEE		Numeric 9Contains 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 SET3
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 SET3
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 SET3
MIDDLE_INIT		Alpha 1Contains the instructor's middle initial if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-ADDR1
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
ADDR2		Alpha 30 (Lower Case)Contains the second line of address information if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-ADDR3
ADDR3		Alpha 30 (Lower Case)Contains the third line of address information if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-ADDR4
ADDR4		Alpha 30 (Lower Case)Contains the fourth line of address information if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-CITY
CITY		Alpha 58 (Lower Case)Contains the city of the address if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-STATE
STATE		Alpha 2Contains the two-character state code if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-ZIP
ZIP		Alpha 10Contains the postal code of the instructor's address if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6Contains 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
HM_PHONE_NBR		Alpha 15Contains the instructor's home telephone number if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains 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
WK_PHONE_NBR		Alpha 15Contains the instructor's work telephone number if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the instructor's work telephone extension if the instructor is not an employee.
  • Blank employee
TR07.1
#INS-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the first date the instructor can teach a course.TR07.1
#INS-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the last date the instructor can teach a course.TR07.1
#INS-E-MAIL-ADDR
E_MAIL_ADDR		Alpha 60 (Lower Case)Contains the instructor's internal E-Mail address.TR07.1
#INS-SHORT-NAME
SHORT_NAME		DerivedContains the instructor's short name.—
#INS-SHORT-EMPLOYER
SHORT_EMPLOYER		DerivedContains an abbreviated form of the instructor's employer if the instructor is not an employee.
  • Blank employee
—
#INS-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Contains the country of the instructor's address.TR07.1
#INS-EMP-SHORT-NAME
EMP_SHORT_NAME		Derived——
#INS-INS-SHORT-NAME
INS_SHORT_NAME		Derived——

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
INSSET1
  1. INSTRUCT
PrimaryHR30.1, TR07.1, TR08.1, TR09.1, TR14.1, TR200, TR201, TR202 +7 more
INSSET2
  1. INSTRUCT ↓
TR07.1
INSSET3
  1. COMPANY
  2. EMPLOYEE
  3. LAST-NAME
  4. FIRST-NAME
  5. MIDDLE-INIT
  6. INSTRUCT
KeyChangeBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMINSTCTRYCDEMPLOYEEPAEMPLOYEEHRCORRESPPAINSCOURSPAINSTSESPAINSTRUCT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMNot RequiredValid When (INS-COMPANY != Zeroes)
INS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (INS-COUNTRY-CODE != Spaces)
INS-COUNTRY-CODE→INT-COUNTRY-CODE
EmployeeEMPLOYEERequiredWhen (INS-EMPLOYEE != Zeroes)
INS-COMPANY→EMP-COMPANY
INS-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEENot RequiredValid When (INS-EMPLOYEE != Zeroes)
INS-COMPANY→PEM-COMPANY
INS-EMPLOYEE→PEM-EMPLOYEE

One to many (3) — child tables

RelationTableRulesConditionField map
CorrespondenceHRCORRESP
"5"→HCP-REQ-TYPE
INS-INSTRUCT→HCP-ID-NBR
Zeroes→HCP-COMPANY
Zeroes→HCP-DEPENDENT
—→HCP-SEQ-NBR
Course InstrPAINSCOURSDelete Cascades
INS-INSTRUCT→INC-INSTRUCT
—→INC-COURSE
Session InstrPAINSTSESDelete Cascades
INS-INSTRUCT→ISE-INSTRUCT
—→ISE-COURSE
—→ISE-SESSION
—→ISE-START-DATE
—→ISE-INSTR-TYPE

Programs

Updated by (1)

Referenced by (46)