 |
Lawson Insight Technical Documentation |
|
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
|