Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PR941


                               PR941 FILE

REFERENCED BY

PR287

UPDATED BY

PR87.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PR9-COMPANY            Numeric 4                                 PR87.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PR9-PAYROLL-YEAR       Numeric 4                                 PR87.1
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

PR9-QUARTER            Numeric 1                                 PR87.1
Element: Quarter       Contains the fiscal quarter for the
                       data stored in this record.

PR9-REPORT-ENTITY      Alpha 5                                   PR87.1
Element: Report Entity

PR9-STATE              Alpha 2                                   PR87.1
Element: State or ProviThis field contains the two-character
                       state code of the address.

PR9-ADDRESS-BOX        Alpha 1                                   PR87.1
Element: Address Box

PR9-FUTURE-BOX         Alpha 1                                   PR87.1
Element: Future Box

PR9-FINAL-DATE         Numeric 8  (yyyymmdd)                     PR87.1
Element: Final Date

PR9-SEASONAL-BOX       Alpha 1                                   PR87.1
Element: Seasonal Box

PR9-SOC-SEC-BOX        Alpha 1                                   PR87.1
Element: Soc Sec Box

PR9-INC-TAX-ADJ        Signed 11.2                               PR87.1
Element: Inc Tax Adj

PR9-SICK-PAY           Signed 11.2                               PR87.1
Element: Sick Pay

PR9-FRACTIONS-PAY      Signed 11.2                               PR87.1
Element: Fractions Pay

PR9-OTH-PAY            Signed 11.2                               PR87.1
Element: Oth Pay

PR9-DEP-AMT-941        Signed 15.2                               PR87.1
Element: Dep Amt 941

PR9-EMPLOYEE-COUNT     Numeric 11                                PR87.1
Element: Employee Count

PR9-NEXT-OR-REF-BX     Alpha 1                                   PR87.1
Element: Next Or Ref Bx

PR9-SEMI-OR-MNTHLY     Alpha 1                                   PR87.1
Element: Semi Or Mnthly

                         PR941 FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PR9SET1   COMPANY                                                PR287   PR87.1
          PAYROLL-YEAR
          QUARTER
          REPORT-ENTITY

                         PR941 FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PR9-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Report Entity  PRSYSTEM     Required

                            PR9-COMPANY          -> PRS-COMPANY
                            PR9-REPORT-ENTITY    -> PRS-PROCESS-LEVEL

State          PRSTATE      Required
                            When PR9-STATE != Spaces

                            PR9-STATE            -> PSA-STATE