|
|
PROTACCTS FILE
This file contains expense accounts for premium portions of pay by job codes.
It is assigned to the pay code file.
REFERENCED BY
AC542 PR195 PR197 PR220 PR82.1 PR85.1
UPDATED BY
PR20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTA-COMPANY Numeric 4 PR20.7
Element: Company The company number represents an
established company and is entered on
all function codes.
OTA-PROCESS-LEVEL Alpha 5 PR20.7
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
OTA-JOB-CODE Alpha 9 PR20.7
Element: Job Code Contains a user-defined code that
represents a type of job.
OTA-PAY-CODE Alpha 4 PR20.7
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
OTA-OT-JOB-CODE Alpha 9 PR20.7
Element: Ot Job Code Contains the job code for which
overtime expensing is being defined.
OTA-OT-ACCOUNT Numeric 6 PR20.7
Element: Ot Account Contains the expense account to which
overtime premium expenses for this job
code/pay code should be posted.
OTA-OT-SUB-ACCT Numeric 4 PR20.7
Element: Ot Sub Acct Contains the subaccount to which
overtime premium expenses for this job
code/pay code should be posted.
PROTACCTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTASET1 COMPANY AC542 PR195
PROCESS-LEVEL PR197 PR20.4
JOB-CODE PR20.7 PR220
PAY-CODE PR82.1 PR85.1
OT-JOB-CODE
PROTACCTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
OTA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Jobcode JOBCODE Required
OTA-COMPANY -> JBC-COMPANY
OTA-JOB-CODE -> JBC-JOB-CODE
Paycode PRPAYCODE Required
OTA-COMPANY -> PCD-COMPANY
OTA-PROCESS-LEVEL -> PCD-PROCESS-LEVEL
OTA-JOB-CODE -> PCD-JOB-CODE
OTA-PAY-CODE -> PCD-PAY-CODE
Process Level PRSYSTEM Required
OTA-COMPANY -> PRS-COMPANY
OTA-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
|
