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.

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
COMPANY		Numeric 4Contains the company number.TR07.1
INS-EMPLOYEE
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
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
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
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-CONSENT
CONSENT		Alpha 1" " = No
  • N No
  • Y Yes
TR07.1
INS-EMP-SHORT-NAME
EMP_SHORT_NAME		Derived——
INS-INS-SHORT-NAME
INS_SHORT_NAME		Derived——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
INSSET1INSTRUCTPrimaryHR30.1, TR07.1, TR08.1, TR09.1, TR14.1, TR200, TR201, TR202 +7 more
INSSET2INSTRUCT*TR07.1
INSSET3COMPANY, EMPLOYEE, LAST-NAME, FIRST-NAME, MIDDLE-INIT, INSTRUCTKeyChangeBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

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 CascadesINS-INSTRUCT → INC-INSTRUCT, → INC-COURSE
Session InstrPAINSTSESDelete CascadesINS-INSTRUCT → ISE-INSTRUCT, → ISE-COURSE, → ISE-SESSION, → ISE-START-DATE, → ISE-INSTR-TYPE

Programs

Updated by (1)

Referenced by (46)