Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAINSTRUCT


                            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     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

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 Hr    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: Last 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 Init   Contains the instructor's middle
                       initial if the instructor is not an
                       employee.
                       Blank = employee

INS-ADDR1              Alpha 30  (Lower Case)                    TR07.1
Element: Addr1         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: Addr1         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: Addr1         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: Addr1         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         Contains the two-character state code
                       if the instructor is not an employee.
                       Blank = employee

INS-ZIP                Alpha 10                                  TR07.1
Element: Zip           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
Element: Wk Phone CntryContains the country code for the
                       instructor's work telephone number if
                       the instructor is not an employee.
                       Blank = employee

INS-WK-PHONE-NBR       Alpha 15                                  TR07.1
Element: Wk Phone Nbr  Contains the instructor's work
                       telephone number if the instructor is
                       not an employee.
                       Blank = employee

INS-WK-PHONE-EXT       Alpha 5                                   TR07.1
Element: Wk Phone Ext  Contains the instructor's work
                       telephone extension if the instructor is
                       not an employee.
                       Blank = employee

INS-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR07.1
Element: Effective DateContains the first date the instructor
                       can teach a course.

INS-END-DATE           Numeric 8  (yyyymmdd)                     TR07.1
Element: End Date      Contains the last date the instructor
                       can teach a course.

INS-E-MAIL-ADDR        Alpha 60  (Lower Case)                    TR07.1
Element: Email Address 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                                BN305   HR11.1
          EMPLOYEE                                               HR11.2  HR511
          LAST-NAME                                              PA02.1  PA100
          FIRST-NAME                                             PA102   PA115
          MIDDLE-INIT                                            PA13.1  PA13.2
          INSTRUCT                                               PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 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     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       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