|
|
PRTIME FILE
Employee Pay/Hours History
Contains employee pay and hours history information.
REFERENCED BY
BN150 BN340 BN345 HCDL.1 HR170 HR70.1
PA495 PA594 PR05.1 PR128 PR130 PR131
PR132 PR134 PR136 PR137 PR141 PR160
PR180 PR188 PR250 PR251 PR253 PR260
PR270 PR278 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR37.1
PR418 PR45.1 PR51.1 PR51.3 PR529 PR530
PR84.1 PR86.1 UK102 UK141 UK145 UK201
UK202 UK330 UK50.3 UK50.4 TA147 TP135
TP140 PR292 PR282 PR289 TA146 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 PRWC.1 UK110
TM570 TM70.1 TM71.1 HR00.1 HR01.1 PBIP.1
PR09.1 PR229
UPDATED BY
PR197 PR300 PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY Numeric 4 PR197 PR560
Element: Company Hr Identifies the AP company if the PR82.1 PR85.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PRT-EMPLOYEE Numeric 9 PR197 PR560
Element: Employee Contains the employee number. Each PR82.1 PR85.1
person employed by the company is
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 PR197 PR560
Internal Check ID Contains the payment identification PR82.1 PR85.1
Number number (unique payment identifier used
in tracking payment information).
PRT-PAY-SUM-GRP Alpha 3 PR197 PR560
Payment Summary Contains the pay summary group PR82.1 PR85.1
Group associated with the time record.
PRT-TIME-SEQ Numeric 12 PR197 PR560
Element: Sequence NumbeContains the sequence number assigned PR82.1 PR85.1
to the time record.
PRT-JOB-CODE Alpha 9 PR197 PR560
Element: Job Code Contains a user-defined code that PR82.1 PR85.1
represents a type of job.
PRT-PROCESS-LEVEL Alpha 5 PR197 PR560
Element: Process Lev HrThis field contains the process level, PR82.1 PR85.1
which is the reporting hierarchy below
company.
PRT-WORK-STATE Alpha 2 PR197 PR560
Element: Work State Contains the 2-character value that PR82.1 PR85.1
identifies employee's work state.
PRT-HOURS Signed 7.2 BN31.1 BN31.2
Element: Hours Contains the hours associated with the BN32.1 BN32.2
time record. BN32.3 PBWC.1
PR197 PR278
PR560 PR82.1
PR85.1 PRWC.1
PRT-RATE Signed 13.4 PR197 PR82.1
Element: Rate Contains the rate associated with the PR85.1
time record.
PRT-WAGE-AMOUNT Signed 13.2 PBWC.1 PR197
Element: Wage Amount Contains the wage amount associated PR278 PR418
with the time record. PR560 PR82.1
PR85.1 PRWC.1
PRT-DEPARTMENT Alpha 5 PR197 PR560
Element: Department Contains the department associated with PR82.1 PR85.1
the time record.
PRT-PCT-DIST-FLAG Alpha 1 PR197 PR82.1
Percent Contains the value that indicates if PR85.1
Distribution Flag the system is to use the defined
override distribution information
instead of the normal general ledger
account defaulting for this time record.
PRT-SHIFT Numeric 1 PR197 PR560
Element: Shift Contains the shift number associated PR82.1 PR85.1
with the pay.
PRT-DST-ACCT-UNIT Alpha 15 PR197 PR560
Element: Accounting UniContains the general ledger accounting PR82.1 PR85.1
unit to which the amount is posted.
PRT-DST-ACCOUNT Numeric 6 PR197 PR560
Element: Account Contains the general ledger account to PR82.1 PR85.1
which the amount is posted.
PRT-DST-SUB-ACCT Numeric 4 PR197 PR560
Element: Subaccount Contains the general ledger subaccount PR82.1 PR85.1
to which the amount is posted.
PRT-DIST-COMPANY Numeric 4 PR197 PR560
Element: Company Contains the company number to which PR82.1 PR85.1
the transaction is posted. A valid
intercompany relationship must be
defined in the General Ledger system.
PRT-TR-DATE Numeric 8 (yyyymmdd) PR197 PR560
Element: Time Record DaContains the time record date. PR82.1 PR85.1
PRT-UNION-CODE Alpha 10 PR197 PR560
Element: Union Code Contains the union code associated with PR82.1 PR85.1
the time record.
PRT-OT-PREM-AMT Signed 13.2 PBWC.1 PR197
Element: Ot Prem Amt Contains the overtime premium amount PR278 PR560
for the time record. PR82.1 PR85.1
PRWC.1
PRT-SHIFT-DIFF Signed 13.2 PR197 PR82.1
Element: Shift DifferenContains the shift premium rate PR85.1
associated with the time record.
PRT-PAYROLL-YEAR Numeric 4 PR197 PR560
Element: Current PayrolContains the payroll year associated PR82.1 PR85.1
with the time record.
PRT-QUARTER Numeric 1 PR197 PR560
Element: Quarter Contains the fiscal quarter for the PR82.1 PR85.1
data stored in this record.
PRT-PCD-SEQ-NBR Numeric 4 PR197 PR560
Element: Pcd Seq Nbr Contains the sequence number associated PR82.1 PR85.1
with the time record relative to the pay
code.
PRT-PER-END-DATE Numeric 8 (yyyymmdd) PR197 PR560
Element: Period End DatContains the period end date associated PR82.1 PR85.1
with the time record. TA170
PRT-CHECK-TYPE Alpha 1 PR197 PR560
Element: Payment Type Contains the payment type. PR82.1 PR85.1
S = System
M = Manual
J = Adjustment
P = Partial ACH
R = Reversal
G = Gross Up
A = ACH
PRT-LOCAT-CODE Alpha 10 PR197 PR82.1
Element: Location PR85.1
PRT-WC-STATE Alpha 2 PR197 PR560
Element: Wc State Contains the workers' compensation PR82.1 PR85.1
state associated with the time record.
PRT-OT-RECORD Alpha 1 PR197 PR82.1
Element: Ot Record Contains the value that indicates if PR85.1
the time record was created for
retroactive or overtime pay.
Y = Yes
R = Retro
PRT-POSITION Alpha 12 PR197 PR82.1
Element: Position Contains the user-defined code that PR85.1
represents a position in the company.
PRT-ACTIVITY Alpha 15 PR197 PR560
Element: Activity Activities are the processes or PR82.1 PR85.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PRT-ACCT-CATEGORY Alpha 5 PR197 PR560
Element: Account CategoAccount categories are groupings of PR82.1 PR85.1
costs, revenues, or a combination of
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.
Valid account category types are:
cost
revenue
accrual
pass thru
PRT-TIME-ACC-FLAG Alpha 1 PR197 PR82.1
Element: Time Acc Flag Contains an L (Last) if an employee is 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 PR197 PR82.1
Element: Shft Diff Rate PR85.1
PRT-OT-RATE Signed 13.4 PR197 PR82.1
Element: Ot Rate PR85.1
PRT-ATN-OBJ-ID Numeric 12 PR197 PR82.1
Object The system-defined object id PR85.1
Identification representing the Activity Management
commitment.
PRT-GLT-OBJ-ID Numeric 12 PR197 PR82.1
Object This is a subsystem GL interface PR85.1
Identification identification number. It is used for
Drill Around purposes.
PRT-RECONCILED Alpha 1 PR197 PR82.1
Element: Reconciled Y = Yes PR85.1
" " = No
PRT-TAX-FREQ-OVER Numeric 1 PR197 PR82.1
Element: Tax Freq Over 1 = Weekly PR85.1
2 = Biweekly
3 = Semi-monthly
4 = Monthly
5 = Daily
6 = Quarterly
7 = Semi-annually
8 = Annually
PRT-REMUN-CODE Alpha 4 PR197 PR82.1
Element: Remun Code Contains the remuneration code. Valid PR85.1
value is C001 = Bonus.
PRT-BUS-NBR-GRP Alpha 4 PR197 PR560
Element: Bus Nbr Grp Contains the business number group. PR82.1 PR85.1
PRT-REPORT-ENTITY Alpha 5 PR197 PR560
Element: Report Entity Contains the report entity. 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 PR197 PR560
Element: Qc Ent Nbr GrpContains the Quebec Enterprise number PR82.1 PR85.1
group.
PRT-WC-CLASS Alpha 4 PR197 PR82.1
Workers Comp Contains the workers' compensation PR85.1
Classification class.
PRT-CURRENCY-CODE Alpha 5 PR197 PR560
Element: Currency Code This field contains the company base PR82.1 PR85.1
currency code established in Company
(GL10.1 ).
PRT-CURR-ND Numeric 1 PR197 PR560
Account Currency Represents the number of decimals PR82.1 PR85.1
Code defined for the currency of the object.
PRT-HM-PROCESS-LEV Alpha 5 PR197 PR560
Element: Process Lev Hr PR82.1 PR85.1
PRT-CA-WC-CLASS Alpha 10 PR197 PR82.1
Element: Ca Wc Class Contains the Canadian WC Class from PR85.1
employees job. Use to identify the
PRTIME wages by WC Class.
PRT-COUNTRY-CODE Alpha 2 PR197 PR560
Element: Country Code The country code. Required for VAT and PR82.1 PR85.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PRT-PENS-SEQ-NBR Numeric 4 PR197 PR560
Element: Pens Seq Nbr PR82.1 PR85.1
PRT-ABN-OBJ-ID Numeric 12
Element: Abn Obj Id This element is not used.
PRT-PAY-UNITS Signed 7.2 PR197 PR560
Element: Pay Units PR82.1 PR85.1
PRT-UNIT-MEASURE Alpha 12 PR197 PR560
Element: Unit Measure PR82.1 PR85.1
PRT-USER-ID Alpha 10 (Lower Case) PR197 PR82.1
Element: User Contains the user ID of the person who PR85.1
last changed this record.
PRT-DATE-STAMP Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Date Stamp This field contains the server date PR85.1
(month, date, and year) of the last
change to this record.
PRT-NON-EARNINGS Numeric 1 PR197 PR560
Element: Non Earnings 0 = No - wages PR82.1 PR85.1
1 = Yes - other remuneration
PRT-ORIG-OBJ-ID Numeric 12 PR197 PR82.1
Element: Orig Obj Id PR85.1
PRT-RECORD-TYPE Alpha 1 PR197 PR82.1
Element: Record Type This field identifies the type of PR85.1
record defined.
Valid values are:
S = Summary
D = Detail
PRT-ATTEND-CODE Alpha 2 PR197 PR82.1
Element: Attendance CodA user-defined alphanumeric code that PR85.1
represents a reason for an employee's
absence or hours worked. Examples of
attendance codes are, sick, vacation,
overtime, on the job injury, snow day,
tardy, left early, and so on. Validated
in the Attendance Code file.
PRT-REASON-CODE Alpha 4 PR197 PR560
Element: Ta Reason Cd This field contains the reason code, PR82.1 PR85.1
which indicates the cause for credit
memos.
PRT-TES-OBJ-ID Numeric 12 PR197 PR560
Element: Tes Obj Id PR82.1 PR85.1
PRT-RETRO-PENSION Alpha 1 PR197 PR82.1
Element: Retro Pension " " = No PR85.1
N = No
Y = Yes; open payment
PRT-SERVICE-CODE Alpha 4 PR197 PR560
Element: Ta Service Cd PR82.1 PR85.1
PRTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRTSET1 COMPANY BN150 BN340
EMPLOYEE BN345 HCDL.1
CHECK-ID HR170 HR70.1
PAY-SUM-GRP PA495 PA594
TIME-SEQ PR05.1 PR128
PR130 PR131
PR132 PR134
PR136 PR137
PR141 PR160
PR180 PR188
PR197 PR250
PR251 PR253
PR260 PR270
PR278 PR29.1
PR300 PR32.1
...
PRTSET10 COMPANY KeyChange
HM-PROCESS-LEV
EMPLOYEE
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
PRTSET2 COMPANY KeyChange PR292
EMPLOYEE
PAYROLL-YEAR
QUARTER
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
CHECK-ID
TIME-SEQ
PRTSET3 COMPANY KeyChange PR282 PR289
EMPLOYEE TA146 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 PRWC.1
UK110 TA147
TM570 TM70.1
...
PRTSET5 RECONCILED KeyChange, Subset
ACTIVITY Where ACTIVITY != Spaces
TR-DATE And ATN-OBJ-ID != Zeroes
ATN-OBJ-ID
PRTSET6 COMPANY KeyChange HR00.1 HR01.1
PROCESS-LEVEL PBIP.1 PR09.1
TR-DATE PR131 PR197
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET7 COMPANY KeyChange PR131
TR-DATE
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET8 COMPANY Subset PR160 PR180
EMPLOYEE Where PENS-SEQ-NBR != Zeroes PR197 PR229
PENS-SEQ-NBR PR29.1 PR529
CHECK-ID PR560 PR82.1
TIME-SEQ PR85.1
PRTSET9 COMPANY Subset
EMPLOYEE Where ORIG-OBJ-ID != Zeroes
ORIG-OBJ-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-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
Prcheck PRCHECK Required
PRT-COMPANY -> PCH-COMPANY
PRT-CHECK-ID -> PCH-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
Reason Code TAREASCODE Required
When (PRT-REASON-CODE != Spaces )
PRT-COMPANY -> TRE-COMPANY
PRT-REASON-CODE -> TRE-REASON-CODE
Service Code TASERVCODE Required
When (PRT-SERVICE-CODE != Spaces )
PRT-COMPANY -> TSC-COMPANY
PRT-SERVICE-CODE -> TSC-SERVICE-CODE
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
|
