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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRFSET1COMPANY, FORM-TYPE, GROUP-NAME, FORM-FIELDPrimaryHS01.1, HS20.1, HS22.1, HS36.1

Relations

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 NamePERSGROUPRequiredTRF-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 RequiredTRF-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
SchedulePRSAGHEADTRF-COMPANY → SGH-COMPANY, → SGH-INDICATOR, → SGH-SCHEDULE, → SGH-EFFECT-DATE

Programs

Updated by (1)

Referenced by (3)