PRTIME FILE
Employee Pay/Hours History
Contains employee pay and hours history information.
REFERENCED BY
BN150 BN340 BN345 BN66.1 HCOP.1 HR170
HR70.1 PR05.1 PR128 PR131 PR132 PR134
PR136 PR137 PR139 PR140 PR141 PR160
PR180 PR260 PR270 PR278 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1
PR45.1 PR51.1 PR530 PR80.1 PR80.2 PR86.1
PR89.1 UK102 UK330 UK120 TA170 BN100
BN101 BN102 BN103 BN105 BN145 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN45.1
BN531 BN71.1 BN72.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 PBWC.1 PR289 PRWC.1 UK110
TM570 TM70.1 TM71.1
UPDATED BY
AC196 BN500 PR150 PR195 PR199 PR300
PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY Numeric 4 BN500 PR150
Company The company number represents an PR195 PR199
established company and is entered on PR560 PR82.1
all function codes. PR85.1
PRT-EMPLOYEE Numeric 9 BN500 PR150
Employee Contains the employee number. Each PR195 PR199
person employed by the company is PR560 PR82.1
assigned a unique number. The system PR85.1
uses the employee number to correlate
all of the information related to that
person.
PRT-CHECK-ID Numeric 12 BN500 PR150
Internal Check ID Contains the payment identification PR195 PR199
Number number (unique payment identifier used PR560 PR82.1
in tracking payment information). PR85.1
PRT-PAY-SUM-GRP Alpha 3 BN500 PR150
Payment Summary Contains the pay summary group PR195 PR199
Group associated with the time record. PR560 PR82.1
PR85.1
PRT-TIME-SEQ Numeric 12 BN500 PR150
Sequence Number Contains the sequence number assigned PR195 PR199
to the time record. PR560 PR82.1
PR85.1
PRT-JOB-CODE Alpha 9 BN500 PR150
Job Code Contains a user-defined code that PR195 PR199
represents a type of job. PR560 PR82.1
PR85.1
PRT-PROCESS-LEVEL Alpha 5 BN500 PR150
Process Level This field contains the process level, PR195 PR199
which is the reporting hierarchy below PR560 PR82.1
company. PR85.1
PRT-WORK-STATE Alpha 2 BN500 PR150
Work State Contains the 2-character value that PR195 PR199
identifies employee's work state. PR560 PR82.1
PR85.1
PRT-HOURS Signed 7.2 BN31.1 BN31.2
Hours Contains the hours associated with the BN32.1 BN32.2
time record. BN32.3 BN500
PBWC.1 PR150
PR195 PR199
PR278 PR560
PR82.1 PR85.1
PRWC.1
PRT-RATE Signed 13.4 BN500 PR150
Rate Contains the rate associated with the PR195 PR199
time record. PR82.1 PR85.1
PRT-WAGE-AMOUNT Signed 11.2 BN500 PBWC.1
Wage Amount Contains the wage amount associated PR150 PR195
with the time record. PR199 PR278
PR560 PR80.1
PR82.1 PR85.1
PRWC.1
PRT-DEPARTMENT Alpha 5 BN500 PR150
Department Contains the department associated with PR195 PR199
the time record. PR560 PR82.1
PR85.1
PRT-PCT-DIST-FLAG Alpha 1 BN500 PR150
Percent Contains the value that indicates if PR195 PR199
Distribution Flag the system is to use the defined PR82.1 PR85.1
override distribution information
instead of the normal general ledger
account defaulting for this time record.
PRT-SHIFT Numeric 1 BN500 PR150
Shift Contains the shift number associated PR195 PR199
with the pay. PR560 PR82.1
PR85.1
PRT-DST-ACCT-UNIT Alpha 15 BN500 PR150
Distribution Contains the general ledger accounting PR195 PR199
Accounting Unit unit to which the amount is posted. PR560 PR82.1
PR85.1
PRT-DST-ACCOUNT Numeric 6 BN500 PR150
Distribution Contains the general ledger account to PR195 PR199
Account Number which the amount is posted. PR560 PR82.1
PR85.1
PRT-DST-SUB-ACCT Numeric 4 BN500 PR150
Distribution Contains the general ledger subaccount PR195 PR199
Subaccount Number to which the amount is posted. PR560 PR82.1
PR85.1
PRT-DIST-COMPANY Numeric 4 BN500 PR150
Distribution Company Contains the company number to which PR195 PR199
the transaction is posted. A valid PR560 PR82.1
intercompany relationship must be PR85.1
defined in the General Ledger system.
PRT-TR-DATE Numeric 8 (yyyymmdd) BN500 PR150
Time Record Date Contains the time record date. PR195 PR199
PR560 PR82.1
PR85.1
PRT-UNION-CODE Alpha 10 BN500 PR150
Union Code Contains the union code associated with PR195 PR199
the time record. PR560 PR82.1
PR85.1
PRT-OT-PREM-AMT Signed 11.2 BN500 PBWC.1
Ot Prem Amt Contains the overtime premium amount PR150 PR195
for the time record. PR199 PR278
PR560 PR82.1
PR85.1 PRWC.1
PRT-SHIFT-DIFF Signed 11.2 BN500 PR150
Shift Differential Contains the shift premium rate PR195 PR199
associated with the time record. PR82.1 PR85.1
PRT-PAYROLL-YEAR Numeric 4 BN500 PR150
Current Payroll Year Contains the payroll year associated PR195 PR199
with the time record. PR560 PR82.1
PR85.1
PRT-QUARTER Numeric 1 BN500 PR150
Quarter Contains the fiscal quarter for the PR195 PR199
data stored in this record. PR560 PR82.1
PR85.1
PRT-PCD-SEQ-NBR Numeric 4 BN500 PR150
Pcd Seq Nbr Contains the sequence number associated PR195 PR199
with the time record relative to the pay PR560 PR82.1
code. PR85.1
PRT-PER-END-DATE Numeric 8 (yyyymmdd) BN500 PR150
Period End Date Contains the period end date associated PR195 PR199
with the time record. PR560 PR82.1
PR85.1
PRT-CHECK-TYPE Alpha 1 BN500 PR150
Payment Type Contains the payment type. PR195 PR199
S = System PR560 PR82.1
M = Manual PR85.1
J = Adjustment
P = Partial ACH
R = Reversal
PRT-TAX-GROUP Alpha 10 BN500 PR150
Reportable Income Contains the tax group associated with PR195 PR199
Group the time record. PR82.1 PR85.1
PRT-WC-STATE Alpha 2 BN500 PR150
Wc State Contains the workers' compensation PR195 PR199
state associated with the time record. PR560 PR82.1
PR85.1
PRT-OT-RECORD Alpha 1 BN500 PR150
Ot Record Contains the value that indicates if PR195 PR199
the time record was created for PR82.1 PR85.1
retroactive or overtime pay.
Y = Yes
R = Retro
PRT-POSITION Alpha 12 PR150 PR195
Position Contains the user-defined code that PR199 PR82.1
represents a position in the company. PR85.1
PRT-ACTIVITY Alpha 15 PR150 PR195
Activity Activities are the processes or PR199 PR560
procedures that produce work. Cost PR82.1 PR85.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
PRT-ACCT-CATEGORY Alpha 5 PR150 PR195
Account Category Account categories are groupings of PR199 PR560
costs, revenues, or a combination of PR82.1 PR85.1
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
PRT-TIME-ACC-FLAG Alpha 1 PR150 PR195
Time Acc Flag Contains an L (Last) if an employee is PR199 PR82.1
terminating employment with the company PR85.1
and you are issuing the final payment
through PR80.1 (Manual Payment).
PRT-SHFT-DIFF-RATE Signed 13.4 PR150 PR195
Shft Diff Rate PR199 PR82.1
PR85.1
PRT-OT-RATE Signed 13.4 PR150 PR195
Ot Rate PR199 PR82.1
PR85.1
PRT-ATN-OBJ-ID Numeric 12 PR150 PR195
AC System Object ID The system-defined object id PR199 PR82.1
(Sales) representing the Activity Management PR85.1
committment.
PRT-RECONCILED Alpha 1 AC196 PR150
Reconciled Y = Yes PR195 PR199
" " = No PR82.1 PR85.1
PRT-TAX-FREQ-OVER Numeric 1 PR150 PR195
Tax Freq Over PR199 PR82.1
PR85.1
PRT-WC-CLASS Alpha 4
Workers Comp Contains the workers' compensation
Classification class.
PRTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRTSET1 COMPANY BN150 BN340
EMPLOYEE BN345 BN500
CHECK-ID BN66.1 HCOP.1
PAY-SUM-GRP HR170 HR70.1
TIME-SEQ PR05.1 PR128
PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR141
PR150 PR160
PR180 PR195
PR199 PR260
PR270 PR278
PR300 PR32.1
PR32.2 PR33.1
...
PRTSET2 COMPANY KeyChange
EMPLOYEE
PAYROLL-YEAR
QUARTER
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
CHECK-ID
TIME-SEQ
PRTSET3 COMPANY KeyChange TA170
EMPLOYEE
PER-END-DATE
CHECK-ID
TIME-SEQ
PRTSET4 COMPANY KeyChange BN100 BN101
EMPLOYEE BN102 BN103
TR-DATE BN105 BN145
TIME-SEQ BN245 BN31.1
CHECK-ID BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN71.1 BN72.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 PBWC.1
PR131 PR132
PR278 PR289
PRWC.1 UK110
TM570 TM70.1
...
PRTSET5 RECONCILED KeyChange, Subset AC196
ACTIVITY Where ACTIVITY != Spaces
TR-DATE And ATN-OBJ-ID != Zeroes
ATN-OBJ-ID
PRTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When PRT-ACCT-CATEGORY != Spaces
PRT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When PRT-ACTIVITY != Spaces
And PRT-ATN-OBJ-ID != Zeroes
PRT-ACTIVITY -> ACV-ACTIVITY
Actrans ACTRANS Not Required
PRT-COMPANY -> ATN-COMPANY
PRT-ATN-OBJ-ID -> ATN-OBJ-ID
Company PRSYSTEM Required
PRT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When PRT-DEPARTMENT != Spaces
PRT-COMPANY -> DPT-COMPANY
PRT-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PRT-DEPARTMENT -> DPT-DEPARTMENT
Dist Account GLMASTER Required
When PRT-DST-ACCOUNT != Zeroes
PRT-DIST-COMPANY -> GLM-COMPANY
PRT-DST-ACCT-UNIT -> GLM-ACCT-UNIT
PRT-DST-ACCOUNT -> GLM-ACCOUNT
PRT-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Dist Company GLSYSTEM Required
When PRT-DIST-COMPANY != Zeroes
PRT-DIST-COMPANY -> GLS-COMPANY
Employee EMPLOYEE Required
PRT-COMPANY -> EMP-COMPANY
PRT-EMPLOYEE -> EMP-EMPLOYEE
Job Code JOBCODE Required
When PRT-JOB-CODE != Spaces
PRT-COMPANY -> JBC-COMPANY
PRT-JOB-CODE -> JBC-JOB-CODE
Pay Code PRPAYCODE Required
PRT-COMPANY -> PCD-COMPANY
PRT-PCD-SEQ-NBR -> PCD-SEQ-NBR
Pay Sum Group PAYSUMGRP Required
PRT-COMPANY -> PSG-COMPANY
PRT-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
Paymastr PAYMASTR Required
PRT-COMPANY -> PYM-COMPANY
PRT-EMPLOYEE -> PYM-EMPLOYEE
PRT-CHECK-ID -> PYM-CHECK-ID
Process Level PRSYSTEM Required
PRT-COMPANY -> PRS-COMPANY
PRT-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Trsgblck TRSGBLCK Not Required
PRT-COMPANY -> TRS-COMPANY
PRT-EMPLOYEE -> TRS-EMPLOYEE
PRT-TIME-SEQ -> TRS-TIME-SEQ
Union PCODES Required
When PRT-UNION-CODE != Spaces
"UN" -> PCO-TYPE
PRT-UNION-CODE -> PCO-CODE
Wc State PRSTATE Required
When PRT-WC-STATE != Spaces
PRT-WC-STATE -> PSA-STATE
Work State PRSTATE Required
When PRT-WORK-STATE != Spaces
PRT-WORK-STATE -> PSA-STATE
PRTIME FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pay Classes PSGRELATE
PRT-COMPANY -> PSR-COMPANY
PRT-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
PSR-PAY-CLASS
Position PAPOSITION
Valid When PRT-POSITION != Spaces
PRT-COMPANY -> POS-COMPANY
PRT-POSITION -> POS-POSITION
POS-EFFECT-DATE
|