|
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
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 Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OTA-PROCESS-LEVEL Alpha 5 PR20.7
Element: Process Lev HrThis 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: 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: Subaccount 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 PR197 PR20.4
PROCESS-LEVEL PR20.7 PR220
JOB-CODE PR82.1 PR85.1
PAY-CODE
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
|