STANDTIME

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.
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 PR13.9 PR29.1 PR30.1
PR529 PR560 PR582 PR82.1 UK560 BN51.2
HR00.1 HR01.1 PR134 PR136 PR230 PR80.1
PR80.4 HR55.1 PR229

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STM-COMPANY
Element: Company Hr
Numeric 4
BN100 BN101
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
PR582 PR82.1
UK560
STM-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number for whom a standard time record is to be created. Each record has a value in this field or in the Employee Group field. For an employee to be eligible, the value in the Auto Time Record field must be S (Standard) or Y (Yes).
BN100 BN101
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
PR582 PR82.1
UK560
STM-TIME-GROUP
Element: Time Group
Alpha 10
Contains the employee group for which standard time records are to be created. The value in this field represents an employee group and exists in the Employee Group Header file.
BN100 BN101
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
PR582 PR82.1
UK560
STM-PAY-CODE
Element: Pay Code
Alpha 4
Contains the standard time record pay code. The value in this field must be valid in the Pay Code Parameters file.
BN100 BN101
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
PR582 PR82.1
UK560
STM-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the standard time record sequence number. The system automatically sequences this field based on the last sequence number for employee standard time records or on the last sequence number for employee group standard time records.
BN100 BN101
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
PR582 PR82.1
UK560
STM-HOURS
Element: Hours
Signed 7.2
Contains the hours.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
PR30.1
STM-RATE
Element: Rate
Signed 13.4
Contains the rate of pay for the standard time record.
BN100 BN101
BN102 BN103
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
PR13.9 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560
STM-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the standard time record effective date. When you run PR134 (Automatic Time Records), the system compares this field to the system date to determine if an Employee Time Cards file record should be created.
BN100 BN101
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
PR582 PR82.1
UK560
STM-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the date when the standard time record is no longer effective. When you run PR134 (Automatic Time Records), the system compares this field with the system date to determine if the Employee Time Cards file record should be created.
BN100 BN101
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
PR582 PR82.1
UK560
STM-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-DEPARTMENT
Element: Department
Alpha 5
Contains the department.
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the general ledger accounting unit to which the amount is posted.
PR30.1
STM-DST-ACCOUNT
Element: Account
Numeric 6
Contains the general ledger account to which the amount is posted.
PR30.1
STM-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the general ledger subaccount to which the amount is posted.
PR30.1
STM-DIST-COMPANY
Element: Company
Numeric 4
Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger system.
PR30.1
STM-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that identifies a type of job.
PR30.1
STM-ATTEND-CODE
Element: Attend Code
Alpha 2
Contains the attendance code to which the hours are to be posted. The Time and Attendance system uses this field.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
PR30.1
STM-OCCURRENCE
Element: Occurrence
Alpha 1
Contains the value that indicates if the referenced time is a new occurrence or a continuation of an existing occurrence. The Time and Attendance system uses this field.
N = Continuation of an occurrence.
Y = An attendance occurrence.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
PR30.1
STM-DED-CYCLE
Element: Ded Cycle
Alpha 1 Occurs 9 Times
Contains the value that identifies the cycles in which a deduction is taken.
X
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BS32.1 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560
STM-FLEX-DOLLARS
Element: Flex Dollars
Signed 13.2
Contains the flex dollars associated with the standard time record.
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BS32.1
STM-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is 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.
BN100 BN101
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
PR582 PR82.1
UK560
STM-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
PR30.1
STM-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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
PR30.1
STM-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
PR30.1
STM-LOCAT-CODE
Element: Locat Code
Alpha 10
PR30.1
STM-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PR30.1
STM-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
PR30.1
STM-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
PR30.1
STM-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-CHECK-GRP
Element: Check Grp
Alpha 1

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
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-PROCESS-GRP
Element: Process Grp
Alpha 1
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-TAX-FREQ-OVER
Element: Tax Freq Over
Numeric 3

001 = Weekly
002 = Biweekly
003 = Semi-monthly
004 = Monthly
005 = Daily
006 = Quarterly
007 = Semi-annually
008 = Annually
009 = 9 Month Academic Monthly
010 = 10 Month Academic Monthly
PR29.1 PR30.1
PR529 PR560
PR582 PR82.1
UK560
STM-REASON-CODE
Element: Ta Reason Cd
Alpha 4
PR30.1
STM-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN100 BN101
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
PR582 PR82.1
UK560
STM-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN101
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
PR582 PR82.1
UK560
STM-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN100 BN101
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
PR582 PR82.1
UK560
STM-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN100 BN101
BN102 BN103
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
PR13.9 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560
STM-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN101
BN102 BN103
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
PR13.9 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560
STM-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN100 BN101
BN102 BN103
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
PR13.9 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560


STANDTIME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
STMSET1 COMPANY
EMPLOYEE
TIME-GROUP
PAY-CODE
SEQ-NBR
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN305
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
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
STMSET2 COMPANY
EMPLOYEE
TIME-GROUP
SEQ-NBR
BN100 BN101
BN102 BN103
BN105 BN145
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN430
BN45.1 BN531
BS32.1 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560
STMSET3 COMPANY
TIME-GROUP
EMPLOYEE
PAY-CODE
SEQ-NBR
HR55.1 PR134
STMSET4 OBJ-ID
KeyChange
STMSET6 COMPANY
EMPLOYEE
PENS-SEQ-NBR
TIME-GROUP
PAY-CODE
SEQ-NBR
Subset
WherePENS-SEQ-NBR !=Zeroes
PR229 PR29.1
PR30.1 PR529
PR560 PR582
PR82.1 UK560


STANDTIME FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
OrSTM-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


File created: Wed Jun 08 20:51:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.