Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

STANDTIME

                             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     PR80.1
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    HR11.1    HR11.2
HR511     HR650     PA02.1    PA100     PA102     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    PR29.1    PR30.1    PR529     PR560
PR82.1    UK560     HR00.1    HR01.1    PA115     PBIP.1
PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

STM-COMPANY            Numeric 4                                 BN100   BN101
Element: 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
                                                                 PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-EMPLOYEE           Numeric 9                                 BN100   BN101
Element: 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).                    PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-TIME-GROUP         Alpha 10                                  BN100   BN101
Element: Employee GroupContains 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
                                                                 PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-PAY-CODE           Alpha 4                                   BN100   BN101
Element: 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
                                                                 PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-SEQ-NBR            Numeric 4                                 BN100   BN101
Element: Sequence NumbeContains 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.                    PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-HOURS              Signed 7.2                                BN100   BN101
Element: 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
Element: 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  HR11.1
                                                                 HR11.2  HR511
                                                                 HR650   PA02.1
                                                                 PA100   PA102
                                                                 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  PR29.1
                                                                 PR30.1  PR529
                                                                 PR560   PR82.1
                                                                 UK560

STM-EFFECT-DATE        Numeric 8  (yyyymmdd)                     BN100   BN101
Element: 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
                                                                 PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-END-DATE           Numeric 8  (yyyymmdd)                     BN100   BN101
Element: 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.                                  PR29.1  PR30.1
                                                                 PR529   PR560
                                                                 PR82.1  UK560

STM-PROCESS-LEVEL      Alpha 5                                   PR29.1  PR30.1
Element: Process Level This field contains the process level,    PR529   PR560
                       which is the reporting hierarchy below    PR82.1  UK560
                       company.

STM-DEPARTMENT         Alpha 5                                   PR29.1  PR30.1
Element: Department    Contains the department.                  PR529   PR560
                                                                 PR82.1  UK560

STM-DST-ACCT-UNIT      Alpha 15                                  PR30.1
Element: Accounting UniContains the general ledger accounting
                       unit to which the amount is posted.

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

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

STM-DIST-COMPANY       Numeric 4                                 PR30.1
Element: 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
Element: Job Code      Contains a user-defined code that
                       identifies a type of job.

STM-ATTEND-CODE        Alpha 2                                   BN100   BN101
Element: Attendance CodContains 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
Element: 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
Element: Deduction CyclContains 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  PR29.1
                                                                 PR30.1  PR529
                                                                 PR560   PR82.1
                                                                 UK560

STM-FLEX-DOLLARS       Signed 13.2                               BN100   BN101
Element: 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      PR29.1  PR30.1
                       maintained in the subsystem files and in  PR529   PR560
                       the Activity Commitments Detail and       PR82.1  UK560
                       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
Element: 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
Element: Account CategoAccount 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
Element: Position      Contains the user-defined code that
                       represents a position in the company.

STM-LOCAT-CODE         Alpha 10                                  PR30.1
Element: Location

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

STM-CURR-ND            Numeric 1                                 PR30.1
Account Currency
Code

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

STM-QC-ENT-NBR-GRP     Alpha 4                                   PR30.1
Element: Qc Ent Nbr GrpContains the Quebec enterprise number
                       group.

STM-PENS-SEQ-NBR       Numeric 4                                 PR29.1  PR30.1
Element: Pens Seq Nbr                                            PR529   PR560
                                                                 PR82.1  UK560

STM-CHECK-GRP          Alpha 1                                   PR29.1  PR30.1
Element: Payment Group 1                                         PR529   PR560
                       2                                         PR82.1  UK560
                       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                                   PR29.1  PR30.1
Element: Process Group                                           PR529   PR560
                                                                 PR82.1  UK560

STM-TAX-FREQ-OVER      Numeric 1                                 PR29.1  PR30.1
Element: Tax Freq Over 1 = Weekly                                PR529   PR560
                       2 = Biweekly                              PR82.1  UK560
                       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  HR11.1
                                                                 HR11.2  HR511
                                                                 HR650   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 ...

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  PR29.1
                                                                 PR30.1  PR529
                                                                 PR560   PR82.1
                                                                 UK560

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   PR29.1
          EMPLOYEE      Where PENS-SEQ-NBR != Zeroes             PR30.1  PR529
          PENS-SEQ-NBR                                           PR560   PR82.1
          TIME-GROUP                                             UK560
          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