PRTIMEFORM – The Web Time Record Form file contains the records that make up a Web Time Entry Form.

System
Payroll (PR)
Prefix
TRF
Primary key
COMPANY, FORM-TYPE, GROUP-NAME, FORM-FIELD
Fields
10
Updated by
1 program
Referenced by
3 programs

PRTIMEFORM is the The Web Time Record Form file contains the records that make up a Web Time Entry Form. table in Lawson Payroll (prefix TRF). It is indexed by COMPANY, FORM-TYPE, GROUP-NAME, FORM-FIELD (TRFSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY, ATTENDCODE, PERSGROUP, JOBCODE and PRSYSTEM and 1:M to DEPTCODE, GLMASTER, GLNAMES, PRPAYCODE and PRSAGHEAD. It is updated by HS01.1 and referenced by HS20.1, HS22.1 and HS36.1. The table has 10 fields, 1 index and 11 documented relations.

About PRTIMEFORM

The Web Time Record Form file contains the records that make up a Web Time Entry Form.

Fields (10)

Column = COBOL field name without the TRF- 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 / columnTypeDescription & valuesUpdated by
#TRF-COMPANY PK
COMPANY		Numeric 4—HS01.1
#TRF-FORM-TYPE PK
FORM_TYPE		Alpha 1Contains the value that determines the type of time record form. Valid values are: " " = Employee
  • 0 Employee.
  • M Manager.
  • P Proxy
HS01.1
#TRF-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains the Employee Group name.HS01.1
#TRF-FORM-FIELD PK
FORM_FIELD		Alpha 10Contains the time record field name to be used on the Web time record form.
  • ACCT CAT Account Category
  • ACCT UNIT Accounting Unit
  • GL ACCOUNT GL Account
  • ACT GRP Activity Group
  • ACTIVITY Activity
  • ATTEND CD Attendance Code
  • COMMENTS Comments
  • DEPARTMENT Department
  • GL COMPANY GL Company
  • GRADE Grade
  • HOURS Hours
  • JOB CODE Job Code
  • OCCURRENCE Occurrence
  • PAY CODE Pay Code
  • PROC LEVEL Process Level
  • POSITION Position
  • RATE Rate
  • SCHEDULE Schedule
  • SHIFT Shift
  • STEP Step
  • SUB ACCT GL Sub Account
  • USERFIELD1 User Field 1
  • USERFIELD2 User Field 2
HS01.1
#TRF-ORDER
ORDER		Numeric 2Contains the field order value.HS01.1
#TRF-LABEL
LABEL		Alpha 20Contains the value to be used as the field label.HS01.1
#TRF-SIZE-FIELD
SIZE_FIELD		Signed 4.1Contains the value of the field size.HS01.1
#TRF-DEFAULT-FIELD
DEFAULT_FIELD		Alpha 30Contains the value of the field default.HS01.1
#TRF-REQUIRED
REQUIRED		Alpha 1Contains the value that determines if the form field is required. Valid values are:
  • Y Yes.
  • N No.
HS01.1
#TRF-USE-DESC
USE_DESC		Alpha 1—
  • Y Yes
  • N No
HS01.1

Indexes (1)

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.

IndexKeysFlagsConditionUsed in
TRFSET1
  1. COMPANY
  2. FORM-TYPE
  3. GROUP-NAME
  4. FORM-FIELD
PrimaryHS01.1, HS20.1, HS22.1, HS36.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYATTENDCODEPERSGROUPJOBCODEPRSYSTEMDEPTCODEGLMASTERGLNAMESPRPAYCODEPRSAGHEADPRTIMEFORM

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot RequiredValid When TRF-FORM-FIELD = "ACCT CAT"
TRF-FORM-FIELD→AAX-ACCT-CATEGORY
AcactivityACACTIVITYNot RequiredValid When TRF-FORM-FIELD = "ACTIVITY"
TRF-FORM-FIELD→ACV-ACTIVITY
AttendcodeATTENDCODENot RequiredValid When TRF-FORM-FIELD = "ATTEND CD"
TRF-COMPANY→ATC-COMPANY
TRF-FORM-FIELD→ATC-ATTEND-CODE
Group NamePERSGROUPRequired
TRF-COMPANY→PRG-COMPANY
TRF-GROUP-NAME→PRG-GROUP-NAME
JobcodeJOBCODENot RequiredValid When TRF-FORM-FIELD = "JOB"
TRF-COMPANY→JBC-COMPANY
TRF-FORM-FIELD→JBC-JOB-CODE
PrsystemPRSYSTEMNot Required
TRF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (5) — child tables

RelationTableRulesConditionField map
DeptcodeDEPTCODEValid When TRF-FORM-FIELD = "DEPARTMENT"
TRF-COMPANY→DPT-COMPANY
—→DPT-PROCESS-LEVEL
—→DPT-DEPARTMENT
GlmasterGLMASTERValid When TRF-FORM-FIELD = "ACCOUNT"
TRF-COMPANY→GLM-COMPANY
—→GLM-ACCOUNT
—→GLM-SUB-ACCOUNT
—→GLM-VAR-LEVELS
—→GLM-ACCT-UNIT
GlnamesGLNAMESValid When TRF-FORM-FIELD = "ACCT UNIT"
TRF-COMPANY→GLN-COMPANY
—→GLN-ACCT-UNIT
PaycodePRPAYCODEValid When TRF-FORM-FIELD = "PAY CODE"
TRF-COMPANY→PCD-COMPANY
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE
—→PCD-PAY-CODE
SchedulePRSAGHEAD
TRF-COMPANY→SGH-COMPANY
—→SGH-INDICATOR
—→SGH-SCHEDULE
—→SGH-EFFECT-DATE

Programs

Updated by (1)

Referenced by (3)