Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PATSTSETUP


                            PATSTSETUP FILE

Contains test setup information. Maintained primarily by PA49.1 (Employee
Tests).

REFERENCED BY

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR54.1    HR55.1
HRS1.1    HRSC.1    PA100     PA102     PA149     PA248
PA249     PA349     PA49.1    PA49.2    PA49.3    PA52.1
PA52.3    PA52.4    PA52.5    PA54.1    PA549     PA81.1
PA81.2    PRSC.1

UPDATED BY

PA48.1    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAP-COMPANY            Numeric 4                                 PA48.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PAP-TEST               Alpha 10                                  PA48.1
Element: Test          Contains the test.

PAP-DESCRIPTION        Alpha 30  (Lower Case)                    PA48.1
Element: Description   Contains the test description.

PAP-WEB-DESC           Alpha 15  (Lower Case)                    PA48.1
Element: Web Desc

PAP-WEB-AVAILABLE      Alpha 1                                   PA48.1
Element: Web Available Indicates whether the test is available
                       via the World Wide Web.
                       N = No
                       Y = Yes

PAP-WEB-AVAIL-SUPV     Alpha 1                                   PA48.1
Element: Web Avail SupvIndicates whether the test is available
                       to the employee's supervisor via the
                       World Wide Web.
                       1 = Not Available
                       2 = Direct Supervisor
                       3 = Indirect Supervisor
                       4 = Direct;Indirect Supv

PAP-ACTIVE-FLAG        Alpha 1                                   PA48.1
Element: Status        Indicates whether the test is active or
                       inactive.
                       A = Active
                       I = Inactive

PAP-TEST-TYPE          Alpha 10                                  PA48.1
Element: Test Type     Contains the user-defined test type.

PAP-TEST-SOURCE        Alpha 10                                  PA48.1
Element: Test Source   Contains the user-defined test source.

PAP-EMP-APP            Numeric 1                                 PA48.1
Element: Type          Indicates whether the test applies to
                       employees, applicants, or both.
                       1 = Applicant
                       2 = Employee
                       3 = Applicant;Emp

PAP-RESULT-FL          Alpha 1                                   PA48.1
Element: Result Fl     Indicates the type of results used for
                       the test.
                       1 = None
                       2 = Positive;Negative
                       3 = Other

PAP-USER-FIELD-1       Alpha 30                                  PA48.1
Item Mster User        Contains user-defined test information.
Defined Field1

PAP-USER2              Alpha 10                                  PA48.1
Element: User2         Contains user-defined test information.

PAP-USER3              Alpha 10                                  PA48.1
Element: User3         Contains user-defined test information.

PAP-PREREQ-TEST        Alpha 10                                  PA48.1
Element: Prereq Test   Contains the test prerequisite.

PAP-REQ-FLAG           Alpha 1                                   PA48.1
Element: Req Flag      Indicates whether the test prerequisite
                       is required.
                       N = No
                       Y = Yes

PAP-PREREQ-RESULT1     Alpha 10                                  PA48.1
Element: Prereq Result1Contains the first result for the
                       prerequisite result range.

PAP-PREREQ-RESULT2     Alpha 10                                  PA48.1
Element: Prereq Result2Contains the second result for the
                       prerequisite result range.

PAP-PREREQ-FLAG        Alpha 1                                   PA48.1
Element: Prereq Flag   Indicates whether   the prerequisite
                       period is measured by the date on which
                       the perquisite test was  schedule or the
                       date on which the prerequisite test was
                       completed.
                       1 = Schedule Date
                       2 = Status Date

PAP-ELIG-FLAG          Alpha 1                                   PA48.1
Element: Elig Flag     Indicates whether all employees or only
                       specified employees are eligible for the
                       test.
                       1 = All Paid Employees
                       2 = Specified Criteria

PAP-TEST-COPY          Alpha 10                                  PA48.1
Element: Test Copy     Indicates the test from which
                       eligibility criteria is copied.

PAP-GROUP-NAME         Alpha 10                                  PA48.1
Element: Group Name    Contains the employee group.

PAP-EMP-STATUS         Alpha 2 Occurs 10 Times                   PA48.1
Element: Employee StatuContains the employee status.

PAP-POS-FLAG           Alpha 1                                   PA48.1
Element: Pos Flag      Indicates whether employees who hold
                       specific positions or jobs are eligible
                       for the test.
                       N = No
                       Y = Yes

PAP-DATE-MEASURE       Numeric 3                                 PA48.1
Element: Date Measure  Indicates the period in which the test
                       needs to be renewed.

PAP-UNIT-TYPE          Alpha 1                                   PA48.1
Element: EEO Unit Type Indicates the unit of measure for the
                       date measure.
                       1 = Days
                       2 = Months
                       3 = Years

PAP-RENEW-FLAG         Alpha 1                                   PA48.1
Element: Renew Flag    Indicates whether the renewal date is
                       measured by the date on which the test
                       is scheduled or by the date on which the
                       test was completed.
                       1 = Schedule Date
                       2 = Status Date

PAP-RENEW-TEST         Alpha 10                                  PA48.1
Element: Renew Test    Contains the renewal test name.

PAP-RESULT1            Alpha 10                                  PA48.1
Element: Result1       Contains the first result for the test.

PAP-RESULT2            Alpha 10                                  PA48.1
Element: Result2       Contains the second result for the test.

PAP-DATE-MEASURE2      Numeric 3                                 PA48.1
Element: Date Measure2 Indicates the time period during which
                       a follow up test must be taken.

PAP-DATE-MEASURE3      Numeric 3                                 PA48.1
Element: Date Measure3 Indicates the time period during which
                       the employee needs to complete the
                       prerequisite.

PAP-UNIT-TYPE2         Alpha 1                                   PA48.1
Element: Unit Type2    Indicates the unit of measure for the
                       date measure 2.
                       1 = Days
                       2 = Months
                       3 = Years

PAP-UNIT-TYPE3         Alpha 1                                   PA48.1
Element: Unit Type3    Indicates the unit of measure for the
                       date measure 3.
                       1 = Days
                       2 = Months
                       3 = Years

PAP-FOLLOW-UP-FLAG     Alpha 1                                   PA48.1
Element: Follow Up FlagIndicates whether the follow up period
                       is measured from the date on which the
                       test is scheduled or the date on which
                       the test is completed.
                       1 = Schedule Date
                       2 = Status Date

PAP-FOLLOW-TEST        Alpha 10                                  PA48.1
Element: Follow Test   Contains the name of the follow up test.

PAP-LETTER             Alpha 10                                  PA48.1
Element: Letter        Contains the user-defined follow up
                       letter type.

PAP-TEST-LOCATION      Alpha 10                                  PA48.1
Element: Test Location Contains the follow up test location.

PAP-EXP-COMPANY        Numeric 4                                 PA48.1
Element: Exp Company   Contains the distribution expense
                       company to which the test costs should
                       be posted.

PAP-EXP-ACCT-UNIT      Alpha 15                                  PA48.1
Element: Accounting UniContains the expense accounting unit to
                       which the test costs should be posted.

PAP-EXP-ACCOUNT        Numeric 6                                 PA48.1
Element: Account       Contains the expense account to which
                       the test costs should be posted.

PAP-EXP-SUB-ACCT       Numeric 4                                 PA48.1
Element: Subaccount    Contains the general ledger sub account
                       to which the test costs should be
                       posted.

PAP-COST               Signed 11.2                               PA48.1
Element: Cost          Contains the test cost.

PAP-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA48.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PAP-TIME-STAMP         Numeric 6  (hhmmss)                       PA48.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PAP-USER-ID            Alpha 10  (Lower Case)                    PA48.1
Element: User

PAP-CURRENCY-CODE      Alpha 5                                   PA48.1
Element: Currency Code Contains the currency in which the test
                       cost is recorded.

PAP-CURR-ND            Numeric 1                                 PA48.1
Account Currency
Code

PAP-BASE-CURRENCY      Alpha 5                                   PA48.1
To Company Base        Contains the company's base currency.
Currency

PAP-BASE-ND            Numeric 1                                 PA48.1
Account Currency
Code

PAP-BASE-AMOUNT        Signed 15.2                               PA48.1
Element: Adj Amt       Contains the test cost in the company's
                       base currency.

                         PATSTSETUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAPSET1   COMPANY                                                HGLM.1  HPOS.1
          TEST                                                   HPQC.1  HPRS.1
                                                                 HR00.1  HR01.1
                                                                 HR54.1  HR55.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA149   PA248
                                                                 PA249   PA349
                                                                 PA48.1  PA48.2
                                                                 PA48.3  PA48.4
                                                                 PA49.1  PA49.2
                                                                 PA49.3  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PA549   PA81.1
                                                                 ...

                         PATSTSETUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required
                            When (PAP-CURRENCY-CODE != Spaces )

                            PAP-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            PAP-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (PAP-CURRENCY-CODE != Spaces )

                            PAP-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Exp Account    GLMASTER     Required
                            When (PAP-EXP-ACCOUNT != Zeroes )

                            PAP-EXP-COMPANY       -> GLM-COMPANY
                            PAP-EXP-ACCT-UNIT     -> GLM-ACCT-UNIT
                            PAP-EXP-ACCOUNT       -> GLM-ACCOUNT
                            PAP-EXP-SUB-ACCT      -> GLM-SUB-ACCOUNT

Follow Test    PATSTSETUP   Required
                            When (PAP-FOLLOW-TEST != Spaces )

                            PAP-COMPANY           -> PAP-COMPANY
                            PAP-FOLLOW-TEST       -> PAP-TEST

Group          PERSGROUP    Required
                            When (PAP-GROUP-NAME != Spaces )

                            PAP-COMPANY           -> PRG-COMPANY
                            PAP-GROUP-NAME        -> PRG-GROUP-NAME

Prereq Result1 PATSTRESLT   Required
                            When (PAP-PREREQ-RESULT1 != Spaces )

                            PAP-COMPANY           -> PTR-COMPANY
                            PAP-PREREQ-TEST       -> PTR-TEST
                            PAP-PREREQ-RESULT1    -> PTR-CODE

Prereq Result2 PATSTRESLT   Required
                            When (PAP-PREREQ-RESULT2 != Spaces )

                            PAP-COMPANY           -> PTR-COMPANY
                            PAP-PREREQ-TEST       -> PTR-TEST
                            PAP-PREREQ-RESULT2    -> PTR-CODE

Prereq Test    PATSTSETUP   Required
                            When (PAP-PREREQ-TEST != Spaces )

                            PAP-COMPANY           -> PAP-COMPANY
                            PAP-PREREQ-TEST       -> PAP-TEST

Renew Test     PATSTSETUP   Required
                            When (PAP-RENEW-TEST != Spaces )

                            PAP-COMPANY           -> PAP-COMPANY
                            PAP-RENEW-TEST        -> PAP-TEST

Result1        PATSTRESLT   Required
                            When (PAP-RESULT1 != Spaces )

                            PAP-COMPANY           -> PTR-COMPANY
                            PAP-TEST              -> PTR-TEST
                            PAP-RESULT1           -> PTR-CODE

Result2        PATSTRESLT   Required
                            When (PAP-RESULT2 != Spaces )

                            PAP-COMPANY           -> PTR-COMPANY
                            PAP-TEST              -> PTR-TEST
                            PAP-RESULT2           -> PTR-CODE

Test Copy      PATSTSETUP   Required
                            When (PAP-TEST-COPY != Spaces )

                            PAP-COMPANY           -> PAP-COMPANY
                            PAP-TEST-COPY         -> PAP-TEST

Test Letter    PCODES       Required
                            When (PAP-LETTER != Spaces )

                            "TL"                  -> PCO-TYPE
                            PAP-LETTER            -> PCO-CODE

Test Location  PCODES       Required
                            When (PAP-TEST-LOCATION != Spaces )

                            "TO"                  -> PCO-TYPE
                            PAP-TEST-LOCATION     -> PCO-CODE

Test Source    PCODES       Required
                            When (PAP-TEST-SOURCE != Spaces )

                            "TS"                  -> PCO-TYPE
                            PAP-TEST-SOURCE       -> PCO-CODE

Test Type      PCODES       Required
                            When (PAP-TEST-TYPE != Spaces )

                            "TT"                  -> PCO-TYPE
                            PAP-TEST-TYPE         -> PCO-CODE

                         PATSTSETUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicants     PAEMPAPTST

                            PAP-COMPANY           -> PTS-COMPANY
                            PAP-TEST              -> PTS-TEST
                            1                     -> PTS-EMP-APP
                                                     PTS-EMPLOYEE
                                                     PTS-SEQ-NBR

Employees      PAEMPAPTST

                            PAP-COMPANY           -> PTS-COMPANY
                            PAP-TEST              -> PTS-TEST
                            Zeroes                -> PTS-EMP-APP
                                                     PTS-EMPLOYEE
                                                     PTS-SEQ-NBR

Override       PATESTOVER

                            PAP-COMPANY           -> PAV-COMPANY
                            PAP-TEST              -> PAV-TEST
                                                     PAV-EMPLOYEE

Pos Job Req    JOBRELATE

                            PAP-COMPANY           -> JBR-COMPANY
                            Spaces                -> JBR-PROCESS-LEVEL
                            "TS"                  -> JBR-TYPE
                            PAP-TEST              -> JBR-PERS-CODE
                                                     JBR-SUBJECT-CODE
                                                     JBR-JOB-CODE
                                                     JBR-POSITION

Results        PATSTRESLT

                            PAP-COMPANY           -> PTR-COMPANY
                            PAP-TEST              -> PTR-TEST
                                                     PTR-CODE