Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             STANDTIME FILE

                      Payroll Standard Time Record

The Payroll Standard Time Card file contains standard time records for
individual employees or employee groups. PR30.1 (Standard Time Record) is the
program that updates this file. PR134 (Automatic Time Records) uses these
records to create Employee Time Cards file records.

REFERENCED BY

BN401     BN51.2    PR134     PR136     PR230     HR55.1
PR229

UPDATED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN430     BN45.1    BN531     BS32.1    HR511     HR650
PA502     PA513     PR13.1    PR13.5    PR13.6    PR13.8
PR30.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

STM-COMPANY          Numeric 4                                   BN100   BN101
Company              The company number represents an            BN102   BN103
                     established company and is entered on       BN105   BN145
                     all function codes.                         BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1
                                                                 PR30.1

STM-EMPLOYEE         Numeric 9                                   BN100   BN101
Employee             Contains the employee number for whom a     BN102   BN103
                     standard time record is to be created.      BN105   BN145
                     Each record has a value in this field or    BN31.1  BN31.2
                     in the Employee Group field. For an         BN32.1  BN32.2
                     employee to be eligible, the value in       BN32.3  BN45.1
                     the Auto Time Record field must be S        BN531   BS32.1
                     (Standard) or Y (Yes).                      PR30.1

STM-TIME-GROUP       Alpha 10                                    BN100   BN101
Employee Group       Contains the employee group for which       BN102   BN103
                     standard time records are to be created.    BN105   BN145
                     The value in this field represents an       BN31.1  BN31.2
                     employee group and exists in the            BN32.1  BN32.2
                     Employee Group Header file.                 BN32.3  BN45.1
                                                                 BN531   BS32.1
                                                                 PR30.1

STM-PAY-CODE         Alpha 4                                     BN100   BN101
Payment Code         Contains the standard time record pay       BN102   BN103
                     code. The value in this field must be       BN105   BN145
                     valid in the Pay Code Parameters file.      BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1
                                                                 PR30.1

STM-SEQ-NBR          Numeric 4                                   BN100   BN101
Sequence Number      Contains the standard time record           BN102   BN103
                     sequence number. The system                 BN105   BN145
                     automatically sequences this field based    BN31.1  BN31.2
                     on the last sequence number for employee    BN32.1  BN32.2
                     standard time records or on the last        BN32.3  BN45.1
                     sequence number for employee group          BN531   BS32.1
                     standard time records.                      PR30.1

STM-HOURS            Signed 7.2                                  BN100   BN101
Hours                Contains the hours.                         BN102   BN103
                                                                 BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1
                                                                 PR30.1

STM-RATE             Signed 13.4                                 BN100   BN101
Rate                 Contains the rate of pay for the            BN102   BN103
                     standard time record.                       BN104   BN105
                                                                 BN145   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BS32.1  HR511
                                                                 HR650   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR30.1

STM-EFFECT-DATE      Numeric 8  (yyyymmdd)                       BN100   BN101
Effective Date       Contains the standard time record           BN102   BN103
                     effective date. When you run PR134          BN105   BN145
                     (Automatic Time Records), the system        BN31.1  BN31.2
                     compares this field to the system date      BN32.1  BN32.2
                     to determine if an Employee Time Cards      BN32.3  BN45.1
                     file record should be created.              BN531   BS32.1
                                                                 PR30.1

STM-END-DATE         Numeric 8  (yyyymmdd)                       BN100   BN101
Ending Date          Contains the date when the standard         BN102   BN103
                     time record is no longer effective. When    BN105   BN145
                     you run PR134 (Automatic Time Records),     BN31.1  BN31.2
                     the system compares this field with the     BN32.1  BN32.2
                     system date to determine if the Employee    BN32.3  BN45.1
                     Time Cards file record should be            BN531   BS32.1
                     created.                                    PR30.1

STM-PROCESS-LEVEL    Alpha 5                                     PR30.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

STM-DEPARTMENT       Alpha 5                                     PR30.1
Department           Contains the department.

STM-DST-ACCT-UNIT    Alpha 15                                    PR30.1
Distribution         Contains the general ledger accounting
Accounting Unit      unit to which the amount is posted.

STM-DST-ACCOUNT      Numeric 6                                   PR30.1
Distribution         Contains the general ledger account to
Account Number       which the amount is posted.

STM-DST-SUB-ACCT     Numeric 4                                   PR30.1
Distribution         Contains the general ledger subaccount
Subaccount Number    to which the amount is posted.

STM-DIST-COMPANY     Numeric 4                                   PR30.1
Distribution Company Contains the company number to which a
                     transaction is posted. A valid
                     intercompany relationship must be
                     defined in the General Ledger system.

STM-JOB-CODE         Alpha 9                                     PR30.1
Job Code             Contains a user-defined code that
                     identifies a type of job.

STM-ATTEND-CODE      Alpha 2                                     BN100   BN101
Attendance Code      Contains the attendance code to which       BN102   BN103
                     the hours are to be posted. The Time and    BN105   BN145
                     Attendance system uses this field.          BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1
                                                                 PR30.1

STM-OCCURRENCE       Alpha 1                                     BN100   BN101
Occurrence           Contains the value that indicates if        BN102   BN103
                     the referenced time is a new occurrence     BN105   BN145
                     or a continuation of an existing            BN31.1  BN31.2
                     occurrence. The Time and Attendance         BN32.1  BN32.2
                     system uses this field.                     BN32.3  BN45.1
                     N = Continuation of an occurrence.          BN531   BS32.1
                     Y = An attendance occurrence.               PR30.1

STM-DED-CYCLE        Alpha 1 Occurs 9 Times                      BN100   BN101
Deduction Cycle      Contains the value that identifies the      BN102   BN103
                     cycles in which a deduction is taken.       BN104   BN105
                     X                                           BN145   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BS32.1  PR30.1

STM-FLEX-DOLLARS     Signed 13.2                                 BN100   BN101
Flex Dollars         Contains the flex dollars associated        BN102   BN103
                     with the standard time record.              BN105   BN145
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BS32.1

STM-OBJ-ID           Numeric 12                                  BN100   BN101
Object               This is the object identifier. It is        BN102   BN103
Identification       used to relate commitments or posted        BN105   BN145
                     transactions back to the originating        BN31.1  BN31.2
                     subsystems. Each subsystem record that      BN32.1  BN32.2
                     is updated as a commitment or posted        BN32.3  BN45.1
                     transaction is assigned an object           BN531   BS32.1
                     identifier. The object identifier is        PR30.1
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

STM-ACTIVITY         Alpha 15                                    PR30.1
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


STM-ACCT-CATEGORY    Alpha 5                                     PR30.1
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

STM-POSITION         Alpha 12                                    PR30.1
Position             Contains the user-defined code that
                     represents a position in the company.

STM-LOCAT-CODE       Alpha 10                                    PR30.1
Location

STM-CURRENCY-CODE    Alpha 5                                     PR30.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

STM-CURR-ND          Numeric 1                                   PR30.1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

STM-BUS-NBR-GRP      Alpha 4                                     PR30.1
Bus Nbr Grp          Contains the business number group.

STM-QC-ENT-NBR-GRP   Alpha 4                                     PR30.1
Qc Ent Nbr Grp       Contains the Quebec enterprise number
                     group.

STM-PENS-SEQ-NBR     Numeric 4                                   PR30.1
Pens Seq Nbr

STM-CHECK-GRP        Alpha 1                                     PR30.1
Payment Group        1
                     2
                     3
                     4
                     5
                     6
                     7
                     8
                     9
                     A
                     B
                     C
                     D
                     E
                     F
                     G
                     H
                     I
                     J
                     K
                     L
                     M
                     N
                     O
                     P
                     Q
                     R
                     S
                     T
                     U
                     V
                     W
                     X
                     Y
                     Z

STM-PROCESS-GRP      Alpha 1                                     PR30.1
Process Group

STM-TAX-FREQ-OVER    Numeric 1                                   PR30.1
Tax Freq Over        1 = Weekly
                     2 = Biweekly
                     3 = Semimonthly
                     4 = Monthly
                     5 = Daily
                     6 = Quarterly
                     7 = Semiannually
                     8 = Anually

                         STANDTIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

STMSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          TIME-GROUP                                             BN104   BN105
          PAY-CODE                                               BN145   BN31.1
          SEQ-NBR                                                BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN401   BN45.1
                                                                 BN51.2  BN531
                                                                 BS32.1  HR00.1
                                                                 HR01.1  HR511
                                                                 HR650   PA502
                                                                 PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR134
                                                                 PR136   PR197
                                                                 ...

STMSET2   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          TIME-GROUP                                             BN105   BN145
          SEQ-NBR                                                BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN430
                                                                 BN45.1  BN531
                                                                 BS32.1  PR30.1

STMSET3   COMPANY                                                HR55.1  PR134
          TIME-GROUP
          EMPLOYEE
          PAY-CODE
          SEQ-NBR

STMSET4   OBJ-ID        KeyChange

STMSET5   COMPANY       KeyChange
          EFFECT-DATE
          EMPLOYEE
          TIME-GROUP
          PAY-CODE
          SEQ-NBR

STMSET6   COMPANY       Subset                                   PR229   PR30.1
          EMPLOYEE      Where PENS-SEQ-NBR != Zeroes
          PENS-SEQ-NBR
          TIME-GROUP
          PAY-CODE
          SEQ-NBR

                         STANDTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Category  ACACCTCAT    Required
                            When STM-ACCT-CATEGORY != Spaces

                            STM-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When STM-ACTIVITY != Spaces

                            STM-ACTIVITY         -> ACV-ACTIVITY

Attend Code    ATTENDCODE   Required
                            When STM-ATTEND-CODE != Spaces

                            STM-COMPANY          -> ATC-COMPANY
                            STM-ATTEND-CODE      -> ATC-ATTEND-CODE

Company        PRSYSTEM     Required

                            STM-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When STM-DEPARTMENT != Spaces

                            STM-COMPANY          -> DPT-COMPANY
                            STM-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            STM-DEPARTMENT       -> DPT-DEPARTMENT

Dist Company   GLSYSTEM     Required
                            When STM-DIST-COMPANY != Zeroes

                            STM-DIST-COMPANY     -> GLS-COMPANY

Dst Account    GLMASTER     Required
                            When STM-DST-ACCT-UNIT != Spaces
                            Or   STM-DST-ACCOUNT   != Zeroes

                            STM-DIST-COMPANY     -> GLM-COMPANY
                            STM-DST-ACCT-UNIT    -> GLM-ACCT-UNIT
                            STM-DST-ACCOUNT      -> GLM-ACCOUNT
                            STM-DST-SUB-ACCT     -> GLM-SUB-ACCOUNT

Employee       EMPLOYEE     Required
                            When STM-EMPLOYEE != Zeroes

                            STM-COMPANY          -> EMP-COMPANY
                            STM-EMPLOYEE         -> EMP-EMPLOYEE

Job Code       JOBCODE      Required
                            When STM-JOB-CODE != Spaces

                            STM-COMPANY          -> JBC-COMPANY
                            STM-JOB-CODE         -> JBC-JOB-CODE

Pay Code       PRPAYCODE    Required

                            STM-COMPANY          -> PCD-COMPANY
                            STM-PAY-CODE         -> PCD-PAY-CODE
                            Spaces               -> PCD-PROCESS-LEVEL
                            Spaces               -> PCD-JOB-CODE

Pens Payment   PRPENPAY     Not Required

                            STM-COMPANY          -> PNP-COMPANY
                            STM-EMPLOYEE         -> PNP-EMPLOYEE
                            STM-PENS-SEQ-NBR     -> PNP-PENS-SEQ-NBR

Personnel Grp  PERSGROUP    Required
                            When STM-TIME-GROUP != Spaces

                            STM-COMPANY          -> PRG-COMPANY
                            STM-TIME-GROUP       -> PRG-GROUP-NAME

Process Level  PRSYSTEM     Required
                            When STM-PROCESS-LEVEL != Spaces

                            STM-COMPANY          -> PRS-COMPANY
                            STM-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL