STANDTIME – Payroll Standard Time Record
- System
- Payroll (PR)
- Prefix
STM- Primary key
COMPANY,EMPLOYEE,TIME-GROUP,PAY-CODE,SEQ-NBR- Fields
- 40
- Updated by
- 63 programs
- Referenced by
- 8 programs
STANDTIME is the Payroll Standard Time Record table in Lawson Payroll (prefix STM). It is indexed by COMPANY, EMPLOYEE, TIME-GROUP, PAY-CODE, SEQ-NBR (STMSET1); alternate indexes: STMSET2, STMSET3, STMSET4, STMSET6 and STMSET7. It is related 1:1 to ACACCTCAT, ACACTIVITY, ATTENDCODE, PRSYSTEM, DEPTCODE, GLSYSTEM, GLMASTER, EMPLOYEE and 5 more. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN305 and 55 more and referenced by BN51.2, HR55.1, PR134, PR136, PR229, PR230, PR80.1 and PR80.4. The table has 40 fields, 6 indexes and 14 documented relations.
About STANDTIME
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.
Fields (40)
Column = COBOL field name without the STM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#STM-COMPANY PKCOMPANY | Numeric 4 | — | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +18 more |
#STM-EMPLOYEE PKEMPLOYEE | 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 +18 more |
#STM-TIME-GROUP PKTIME_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 +18 more |
#STM-PAY-CODE PKPAY_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 +18 more |
#STM-SEQ-NBR PKSEQ_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 +18 more |
#STM-HOURSHOURS | Signed 7.2 | Contains the hours. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +13 more |
#STM-RATERATE | Signed 13.4 | Contains the rate of pay for the standard time record. | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN305 +51 more |
#STM-EFFECT-DATEEFFECT_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 +18 more |
#STM-END-DATEEND_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 +18 more |
#STM-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | — | PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
#STM-DEPARTMENTDEPARTMENT | Alpha 5 | Contains the department. | PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
#STM-DST-ACCT-UNITDST_ACCT_UNIT | Alpha 15 | Contains the general ledger accounting unit to which the amount is posted. | PR30.1 |
#STM-DST-ACCOUNTDST_ACCOUNT | Numeric 6 | Contains the general ledger account to which the amount is posted. | PR30.1 |
#STM-DST-SUB-ACCTDST_SUB_ACCT | Numeric 4 | Contains the general ledger subaccount to which the amount is posted. | PR30.1 |
#STM-DIST-COMPANYDIST_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-CODEJOB_CODE | Alpha 9 | Contains a user-defined code that identifies a type of job. | PR30.1 |
#STM-ATTEND-CODEATTEND_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 +13 more |
#STM-OCCURRENCEOCCURRENCE | 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.
| BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +13 more |
#STM-DED-CYCLEDED_CYCLE | Alpha 1 Occurs 9 Times ×9 | Contains the value that identifies the cycles in which a deduction is taken. X | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN31.1 +19 more |
#STM-FLEX-DOLLARSFLEX_DOLLARS | Signed 13.2 | Contains the flex dollars associated with the standard time record. | BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more |
#STM-OBJ-ID SET4OBJ_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 +18 more |
#STM-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-POSITIONPOSITION | Alpha 12 | Contains the user-defined code that represents a position in the company. | PR30.1 |
#STM-LOCAT-CODELOCAT_CODE | Alpha 10 | — | PR30.1 |
#STM-CURRENCY-CODECURRENCY_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 |
#STM-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | PR30.1 |
#STM-BUS-NBR-GRPBUS_NBR_GRP | Alpha 4 | Contains the business number group. | PR30.1 |
#STM-QC-ENT-NBR-GRPQC_ENT_NBR_GRP | Alpha 4 | Contains the Quebec enterprise number group. | PR30.1 |
#STM-PENS-SEQ-NBR SET6PENS_SEQ_NBR | Numeric 4 | — | PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
#STM-CHECK-GRPCHECK_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 |
#STM-PROCESS-GRPPROCESS_GRP | Alpha 1 | — | PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
#STM-TAX-FREQ-OVERTAX_FREQ_OVER | Numeric 3 | —
| PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
#STM-REASON-CODEREASON_CODE | Alpha 4 | — | PR30.1 |
#STM-CREATE-DATE SET7CREATE_DATE | 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 +18 more |
#STM-CREATE-TIMECREATE_TIME | 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 +18 more |
#STM-CREATE-USER-IDCREATE_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 +18 more |
#STM-DATE-STAMP SET7DATE_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 +51 more |
#STM-TIME-STAMPTIME_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 +51 more |
#STM-USER-IDUSER_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 +51 more |
Indexes (6)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
STMSET1 |
| Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN305 +22 more (list truncated in source) | |
STMSET2 |
| BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +19 more | ||
STMSET3 |
| HR55.1, PR134 | ||
STMSET4 |
| KeyChange | — | |
STMSET6 |
| Subset | Where PENS-SEQ-NBR != Zeroes | PR229, PR29.1, PR30.1, PR529, PR560, PR582, PR82.1 |
STMSET7 |
| KeyChange | — |
Relations
One to one (14) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Category | ACACCTCAT | Required | When STM-ACCT-CATEGORY != Spaces |
| ||||||||||||
| Activity | ACACTIVITY | Required | When STM-ACTIVITY != Spaces |
| ||||||||||||
| Attend Code | ATTENDCODE | Required | When STM-ATTEND-CODE != Spaces |
| ||||||||||||
| Company | PRSYSTEM | Required |
| |||||||||||||
| Department | DEPTCODE | Required | When STM-DEPARTMENT != Spaces |
| ||||||||||||
| Dist Company | GLSYSTEM | Required | When STM-DIST-COMPANY != Zeroes |
| ||||||||||||
| Dst Account | GLMASTER | Required | When STM-DST-ACCT-UNIT != Spaces Or STM-DST-ACCOUNT != Zeroes |
| ||||||||||||
| Employee | EMPLOYEE | Required | When STM-EMPLOYEE != Zeroes |
| ||||||||||||
| Job Code | JOBCODE | Required | When STM-JOB-CODE != Spaces |
| ||||||||||||
| Pay Code | PRPAYCODE | Required |
| |||||||||||||
| Pens Payment | PRPENPAY | Not Required |
| |||||||||||||
| Personnel Grp | PERSGROUP | Required | When STM-TIME-GROUP != Spaces |
| ||||||||||||
| Process Level | PRSYSTEM | Required | When STM-PROCESS-LEVEL != Spaces |
| ||||||||||||
| Reason Code | TAREASCODE | Required | When (STM-REASON-CODE != Spaces) |
|
Programs
Updated by (63)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN104 Frequency Table Update
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN305 Highly Compensated Employees
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN430 Benefit Purge
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BS32.1 Web Enrollment Stop Benefits Update
- HR00.1 Company
- HR01.1 Process Level
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LP09.2 Reason Code
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR29.1 Pension Payment Maintenance
- PR30.1 Standard Time Record
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- PR529 Pension Payroll Conversion
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR82.1 Adjustment
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add
- ZH510 Update PCP from ZPENDPCP