Lawson Insight Technical Documentation |
|
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
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 HR11.1 HR11.2
HR511 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
HR00.1 HR01.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STM-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Identifies the AP company if the BN102 BN103
resource type = V. Identifies the HR BN105 BN145
company if the resource type = E. It is BN31.1 BN31.2
blank for type A, P or Q resources. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
PR29.1 PR30.1
PR529 PR560
PR82.1
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
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
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
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
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
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
STM-EFFECT-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Effective DateContains 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
STM-END-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: 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. PR29.1 PR30.1
PR529 PR560
PR82.1
STM-PROCESS-LEVEL Alpha 5 PR29.1 PR30.1
Element: Process Lev HrThis field contains the process level, PR529 PR560
which is the reporting hierarchy below PR82.1
company.
STM-DEPARTMENT Alpha 5 PR29.1 PR30.1
Element: Department Contains the department. PR529 PR560
PR82.1
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
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
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.
Valid account category types are:
cost
revenue
accrual
pass thru
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 Represents the number of decimals
Code defined for the currency of the object.
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
STM-CHECK-GRP Alpha 1 PR29.1 PR30.1
Element: Payment Group 1 PR529 PR560
2 PR82.1
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
STM-TAX-FREQ-OVER Numeric 1 PR29.1 PR30.1
Element: Tax Freq Over 1 = Weekly PR529 PR560
2 = Biweekly PR82.1
3 = Semimonthly
4 = Monthly
5 = Daily
6 = Quarterly
7 = Semiannually
8 = Anually
STM-REASON-CODE Alpha 4 PR30.1
Element: Ta Reason Cd This field contains the reason code,
which indicates the cause for credit
memos.
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
BN45.1 BN51.2
BN531 BS32.1
HR00.1 HR01.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
...
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
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
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
Reason Code TAREASCODE Required
When (STM-REASON-CODE != Spaces )
STM-COMPANY -> TRE-COMPANY
STM-REASON-CODE -> TRE-REASON-CODE
|