PRTIME FILE
Employee Pay/Hours History
Contains employee pay and hours history information.
REFERENCED BY
AC541 AC542 BN150 BN340 BN345 BN66.1
HCOP.1 HR170 HR70.1 PR05.1 PR128 PR131
PR132 PR134 PR136 PR137 PR139 PR141
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 PR418
PR45.1 PR51.1 PR530 PR86.1 PR89.1 UK102
UK330 UK120 PR282 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 TM70.1
TM71.1 PR229
UPDATED BY
AC196 BN500 PR195 PR197 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY Numeric 4 BN500 PR195
Company The company number represents an PR197 PR560
established company and is entered on PR82.1 PR85.1
all function codes.
PRT-EMPLOYEE Numeric 9 BN500 PR195
Employee Contains the employee number. Each PR197 PR560
person employed by the company is PR82.1 PR85.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PRT-CHECK-ID Numeric 12 BN500 PR195
Internal Check ID Contains the payment identification PR197 PR560
Number number (unique payment identifier used PR82.1 PR85.1
in tracking payment information).
PRT-PAY-SUM-GRP Alpha 3 BN500 PR195
Payment Summary Contains the pay summary group PR197 PR560
Group associated with the time record. PR82.1 PR85.1
PRT-TIME-SEQ Numeric 12 BN500 PR195
Sequence Number Contains the sequence number assigned PR197 PR560
to the time record. PR82.1 PR85.1
PRT-JOB-CODE Alpha 9 BN500 PR195
Job Code Contains a user-defined code that PR197 PR560
represents a type of job. PR82.1 PR85.1
PRT-PROCESS-LEVEL Alpha 5 BN500 PR195
Process Level This field contains the process level, PR197 PR560
which is the reporting hierarchy below PR82.1 PR85.1
company.
PRT-WORK-STATE Alpha 2 BN500 PR195
Work State Contains the 2-character value that PR197 PR560
identifies employee's work state. 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 PR195
PR197 PR278
PR560 PR82.1
PR85.1 PRWC.1
PRT-RATE Signed 13.4 BN500 PR195
Rate Contains the rate associated with the PR197 PR82.1
time record. PR85.1
PRT-WAGE-AMOUNT Signed 13.2 BN500 PBWC.1
Wage Amount Contains the wage amount associated PR195 PR197
with the time record. PR278 PR418
PR560 PR82.1
PR85.1 PRWC.1
PRT-DEPARTMENT Alpha 5 BN500 PR195
Department Contains the department associated with PR197 PR560
the time record. PR82.1 PR85.1
PRT-PCT-DIST-FLAG Alpha 1 BN500 PR195
Percent Contains the value that indicates if PR197 PR82.1
Distribution Flag the system is to use the defined PR85.1
override distribution information
instead of the normal general ledger
account defaulting for this time record.
PRT-SHIFT Numeric 1 BN500 PR195
Shift Contains the shift number associated PR197 PR560
with the pay. PR82.1 PR85.1
PRT-DST-ACCT-UNIT Alpha 15 BN500 PR195
Distribution Contains the general ledger accounting PR197 PR560
Accounting Unit unit to which the amount is posted. PR82.1 PR85.1
PRT-DST-ACCOUNT Numeric 6 BN500 PR195
Distribution Contains the general ledger account to PR197 PR560
Account Number which the amount is posted. PR82.1 PR85.1
PRT-DST-SUB-ACCT Numeric 4 BN500 PR195
Distribution Contains the general ledger subaccount PR197 PR560
Subaccount Number to which the amount is posted. PR82.1 PR85.1
PRT-DIST-COMPANY Numeric 4 BN500 PR195
Distribution Company Contains the company number to which PR197 PR560
the transaction is posted. A valid PR82.1 PR85.1
intercompany relationship must be
defined in the General Ledger system.
PRT-TR-DATE Numeric 8 (yyyymmdd) BN500 PR195
Time Record Date Contains the time record date. PR197 PR560
PR82.1 PR85.1
PRT-UNION-CODE Alpha 10 BN500 PR195
Union Code Contains the union code associated with PR197 PR560
the time record. PR82.1 PR85.1
PRT-OT-PREM-AMT Signed 13.2 BN500 PBWC.1
Ot Prem Amt Contains the overtime premium amount PR195 PR197
for the time record. PR278 PR560
PR82.1 PR85.1
PRWC.1
PRT-SHIFT-DIFF Signed 13.2 BN500 PR195
Shift Differential Contains the shift premium rate PR197 PR82.1
associated with the time record. PR85.1
PRT-PAYROLL-YEAR Numeric 4 BN500 PR195
Current Payroll Year Contains the payroll year associated PR197 PR560
with the time record. PR82.1 PR85.1
PRT-QUARTER Numeric 1 BN500 PR195
Quarter Contains the fiscal quarter for the PR197 PR560
data stored in this record. PR82.1 PR85.1
PRT-PCD-SEQ-NBR Numeric 4 BN500 PR195
Pcd Seq Nbr Contains the sequence number associated PR197 PR560
with the time record relative to the pay PR82.1 PR85.1
code.
PRT-PER-END-DATE Numeric 8 (yyyymmdd) BN500 PR195
Period End Date Contains the period end date associated PR197 PR560
with the time record. PR82.1 PR85.1
PRT-CHECK-TYPE Alpha 1 BN500 PR195
Payment Type Contains the payment type. PR197 PR560
S = System PR82.1 PR85.1
M = Manual
J = Adjustment
P = Partial ACH
R = Reversal
PRT-LOCAT-CODE Alpha 10 BN500 PR195
Location PR197 PR82.1
PR85.1
PRT-WC-STATE Alpha 2 BN500 PR195
Wc State Contains the workers' compensation PR197 PR560
state associated with the time record. PR82.1 PR85.1
PRT-OT-RECORD Alpha 1 BN500 PR195
Ot Record Contains the value that indicates if PR197 PR82.1
the time record was created for PR85.1
retroactive or overtime pay.
Y = Yes
R = Retro
PRT-POSITION Alpha 12 PR195 PR197
Position Contains the user-defined code that PR82.1 PR85.1
represents a position in the company.
PRT-ACTIVITY Alpha 15 PR195 PR197
Activity Activities are the processes or PR560 PR82.1
procedures that produce work. Cost PR85.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PRT-ACCT-CATEGORY Alpha 5 PR195 PR197
Account Category Account categories are groupings of PR560 PR82.1
costs, revenues, or a combination of 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 PR195 PR197
Time Acc Flag Contains an L (Last) if an employee is PR82.1 PR85.1
terminating employment with the company
and you are issuing the final payment
through PR80.1 (Manual Payment).
PRT-SHFT-DIFF-RATE Signed 13.4 PR195 PR197
Shft Diff Rate PR82.1 PR85.1
PRT-OT-RATE Signed 13.4 PR195 PR197
Ot Rate PR82.1 PR85.1
PRT-ATN-OBJ-ID Numeric 12 PR195 PR197
Atn Object ID The system-defined object id PR82.1 PR85.1
representing the Activity Management
commitment.
PRT-RECONCILED Alpha 1 AC196 PR195
Reconciled Y = Yes PR197 PR82.1
" " = No PR85.1
PRT-TAX-FREQ-OVER Numeric 1 PR195 PR197
Tax Freq Over 1 = Weekly PR82.1 PR85.1
2 = Biweekly
3 = Semi-monthly
4 = Monthly
5 = Daily
6 = Quarterly
7 = Semi-annually
8 = Annually
PRT-REMUN-CODE Alpha 4 PR195 PR197
Remun Code Contains the remuneration code. Valid PR82.1 PR85.1
value is C001 = Bonus.
PRT-BUS-NBR-GRP Alpha 4 PR195 PR197
Bus Nbr Grp Contains the business number group. PR560 PR82.1
PR85.1
PRT-REPORT-ENTITY Alpha 5 PR195 PR197
Report Entity Contains the report entity. PR560 PR82.1
PR85.1
Report Entity is the Process Level or
Company that this Process Level reports
to for tax reporting. If the Process
Level itself is independent then the
independent Process Level is the Report
Entity. If the Process Level is non
independent and is associated to a
independent head Process Level then the
independent head Process Level is the
Report Entity. If the Process Level is
non independent and is not associated to
a independent head Process Level then
the Company is the Report Entity.
PRT-QC-ENT-NBR-GRP Alpha 4 PR195 PR197
Qc Ent Nbr Grp Contains the Quebec Enterprise number PR560 PR82.1
group. PR85.1
PRT-WC-CLASS Alpha 4 PR195 PR197
Workers Comp Contains the workers' compensation PR82.1 PR85.1
Classification class.
PRT-CURRENCY-CODE Alpha 5 PR195 PR197
Currency Code This field contains the company base PR560 PR82.1
currency code established in Company PR85.1
(GL10.1 ).
PRT-CURR-ND Numeric 1 PR195 PR197
Currency Number of Represents the number of decimals PR560 PR82.1
Decimals defined for the currency of the object. PR85.1
PRT-HM-PROCESS-LEV Alpha 5 PR195 PR197
Hm Process Lev PR560 PR82.1
PR85.1
PRT-CA-WC-CLASS Alpha 10 PR195 PR197
Ca Wc Class Contains the Canadian WC Class from PR82.1 PR85.1
employees job. Use to identify the
PRTIME wages by WC Class.
PRT-COUNTRY-CODE Alpha 2 PR195 PR197
Country Code The country code. Required for VAT and PR560 PR82.1
intrastat reporting. Must be defined in PR85.1
IN01.1 (Country Maintenance).
PRT-PENS-SEQ-NBR Numeric 4 PR195 PR197
Pens Seq Nbr PR560 PR82.1
PR85.1
PRTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRTSET1 COMPANY AC541 AC542
EMPLOYEE BN150 BN340
CHECK-ID BN345 BN500
PAY-SUM-GRP BN66.1 HCOP.1
TIME-SEQ HR170 HR70.1
PR05.1 PR128
PR131 PR132
PR134 PR136
PR137 PR139
PR141 PR195
PR197 PR260
PR270 PR278
PR300 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
PRTSET2 COMPANY KeyChange BN66.1 PR139
EMPLOYEE PR195 PR89.1
PAYROLL-YEAR
QUARTER
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
CHECK-ID
TIME-SEQ
PRTSET3 COMPANY KeyChange AC542 PR282
EMPLOYEE TA170
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
PR418 PRWC.1
UK110 TM70.1
...
PRTSET5 RECONCILED KeyChange, Subset AC196
ACTIVITY Where ACTIVITY != Spaces
TR-DATE And ATN-OBJ-ID != Zeroes
ATN-OBJ-ID
PRTSET6 COMPANY KeyChange PR131
PROCESS-LEVEL
TR-DATE
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET7 COMPANY KeyChange PR131
TR-DATE
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET8 COMPANY Subset PR195 PR197
EMPLOYEE Where PENS-SEQ-NBR != Zeroes PR229 PR82.1
PENS-SEQ-NBR PR85.1
CHECK-ID
TIME-SEQ
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-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
Prqcentgrp PRQCENTGRP Not Required
PRT-COMPANY -> PQC-COMPANY
PRT-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
PRT-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
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 Province PRPROVINCE Required
When (PRT-WC-STATE != Spaces )
And (PRT-CA-WC-CLASS != Spaces )
PRT-WC-STATE -> PPV-PROVINCE
Wc State PRSTATE Required
When (PRT-WC-STATE != Spaces )
And (PRT-WC-CLASS != Spaces )
PRT-WC-STATE -> PSA-STATE
Work Province PRPROVINCE Required
When (PRT-WORK-STATE != Spaces )
And (PRT-CA-WC-CLASS != Spaces )
PRT-WORK-STATE -> PPV-PROVINCE
Work State PRSTATE Required
When (PRT-WORK-STATE != Spaces )
And (PRT-WC-CLASS != 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
|
