PRTIMEFORM

The Web Time Record Form file contains the records that make up a Web Time Entry Form.
UPDATED BY
HS01.1 HS20.1 HS22.1 HS36.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRF-COMPANY
Element: Company Hr		Numeric 4
HS01.1
TRF-FORM-TYPE
Element: Form Type		Alpha 1
Contains the value that determines the type of time record form. Valid values are: 0 = Employee. M = Manager.
" " = Employee
P = Proxy
HS01.1
TRF-GROUP-NAME
Element: Group Name		Alpha 10
Contains the Employee Group name.
HS01.1
TRF-FORM-FIELD
Element: Form Field		Alpha 10
Contains 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
Element: Order		Numeric 2
Contains the field order value.
HS01.1
TRF-LABEL
Element: Label		Alpha 20
Contains the value to be used as the field label.
HS01.1
TRF-SIZE-FIELD
Element: Size Field		Signed 4.1
Contains the value of the field size.
HS01.1
TRF-DEFAULT-FIELD
Element: Default Field		Alpha 30
Contains the value of the field default.
HS01.1
TRF-REQUIRED
Element: All Flag		Alpha 1
Contains the value that determines if the form field is required. Valid values are: Y = Yes. N = No.
HS01.1
TRF-USE-DESC
Element: Use Desc		Alpha 1

Y = Yes
N = No
HS01.1


PRTIMEFORM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRFSET1 COMPANY
FORM-TYPE
GROUP-NAME
FORM-FIELD
HS01.1 HS20.1
HS22.1 HS36.1


PRTIMEFORM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
Valid When TRF-FORM-FIELD ="ACCT CAT"
TRF-FORM-FIELD->AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
Valid When TRF-FORM-FIELD ="ACTIVITY"
TRF-FORM-FIELD->ACV-ACTIVITY
Attendcode ATTENDCODE Not Required
Valid When TRF-FORM-FIELD ="ATTEND CD"
TRF-COMPANY->ATC-COMPANY
TRF-FORM-FIELD->ATC-ATTEND-CODE
Group Name PERSGROUP Required
TRF-COMPANY->PRG-COMPANY
TRF-GROUP-NAME->PRG-GROUP-NAME
Jobcode JOBCODE Not Required
Valid When TRF-FORM-FIELD ="JOB"
TRF-COMPANY->JBC-COMPANY
TRF-FORM-FIELD->JBC-JOB-CODE
Prsystem PRSYSTEM Not Required
TRF-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


PRTIMEFORM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Deptcode DEPTCODE
Valid When TRF-FORM-FIELD ="DEPARTMENT"
TRF-COMPANY->DPT-COMPANY
  DPT-PROCESS-LEVEL
  DPT-DEPARTMENT
Glmaster GLMASTER
Valid When TRF-FORM-FIELD ="ACCOUNT"
TRF-COMPANY->GLM-COMPANY
  GLM-ACCOUNT
  GLM-SUB-ACCOUNT
  GLM-VAR-LEVELS
  GLM-ACCT-UNIT
Glnames GLNAMES
Valid When TRF-FORM-FIELD ="ACCT UNIT"
TRF-COMPANY->GLN-COMPANY
  GLN-ACCT-UNIT
Paycode PRPAYCODE
Valid When TRF-FORM-FIELD ="PAY CODE"
TRF-COMPANY->PCD-COMPANY
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE
  PCD-PAY-CODE
Schedule PRSAGHEAD
TRF-COMPANY->SGH-COMPANY
  SGH-INDICATOR
  SGH-SCHEDULE
  SGH-EFFECT-DATE

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

Home
Contact Us



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