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
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 HR511
PA02.1 PA100 PA102 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR120
PR13.1 PR30.1 HR00.1 HR01.1 PBIP.1
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 HR11.1
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR120 PR13.1
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 11.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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
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-TAX-GROUP Alpha 10 PR30.1
Reportable Income A reportable income group is a
Group user-defined code that represents a
group of accounts payable companies and
process levels. Used to process and
report reportable vendor income.
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
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
...
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
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
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
|