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 LP09.2 PR134 PR136 PR230 PR80.1
HR55.1 PR229
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN305 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 PA115
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STM-COMPANY Numeric 4 BN100 BN101
Element: Company Hr BN102 BN103
BN105 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-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: Time 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
PR29.1 PR30.1
PR529 PR560
PR82.1 UK560
STM-PAY-CODE Alpha 4 BN100 BN101
Element: Pay 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: Seq Nbr 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. 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 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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: Effect 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: End 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 Lev Hr PR529 PR560
PR82.1 UK560
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: Acct Unit Contains 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: Sub Acct 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: Attend 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
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: Ded 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 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
Element: Obj Id This is the object identifier. It is BN102 BN103
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: Acct 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.
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: Locat Code
STM-CURRENCY-CODE Alpha 5 PR29.1 PR30.1
Element: Currency Code This field contains the company base PR529 PR560
currency code established in Company PR82.1 UK560
(GL10.1 ).
STM-CURR-ND Numeric 1 PR30.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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: Check Grp 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 Grp 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
STM-REASON-CODE Alpha 4 PR30.1
Element: Ta Reason Cd
STM-CREATE-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN105 BN145
change to this record. 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-CREATE-TIME Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN105 BN145
changed. 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-CREATE-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User Id Contains the user ID of the person who BN102 BN103
last changed this record. BN105 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-DATE-STAMP Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN104 BN105
change to this record. BN145 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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-TIME-STAMP Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN104 BN105
changed. BN145 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User Id Contains the user ID of the person who BN102 BN103
last changed this record. BN104 BN105
BN145 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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
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 BN305
SEQ-NBR BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN51.2 BN531
BS32.1 HR00.1
HR01.1 HR11.1
HR11.2 HR511
LP09.2 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
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
Reason Code TAREASCODE Required
When (STM-REASON-CODE != Spaces )
STM-COMPANY -> TRE-COMPANY
STM-REASON-CODE -> TRE-REASON-CODE
|