 |
Lawson Insight Technical Documentation |
|
PRTIME FILE
Employee Pay/Hours History
Contains employee pay and hours history information.
REFERENCED BY
AC541 BN150 BN340 BN345 BN66.1 HCOP.1
HR170 HR70.1 PA594 PR05.1 PR128 PR130
PR131 PR132 PR134 PR136 PR137 PR139
PR140 PR141 PR160 PR180 PR188 PR189
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 PR36.1 PR37.1 PR418 PR45.1 PR51.1
PR51.3 PR529 PR530 PR80.1 PR80.2 PR84.1
PR86.1 PR89.1 UK102 UK330 TA147 UK120
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 PR09.1 PR229
UPDATED BY
AC196 AC542 BN500 PR195 PR197 PR300
PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY Numeric 4 AC542 BN500
Company The company number represents an PR195 PR197
established company and is entered on PR560 PR82.1
all function codes. PR85.1
PRT-EMPLOYEE Numeric 9 AC542 BN500
Employee Contains the employee number. Each PR195 PR197
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 AC542 BN500
Internal Check ID Contains the payment identification PR195 PR197
Number number (unique payment identifier used PR560 PR82.1
in tracking payment information). PR85.1
PRT-PAY-SUM-GRP Alpha 3 AC542 BN500
Payment Summary Contains the pay summary group PR195 PR197
Group associated with the time record. PR560 PR82.1
PR85.1
PRT-TIME-SEQ Numeric 12 AC542 BN500
Sequence Number Contains the sequence number assigned PR195 PR197
to the time record. PR560 PR82.1
PR85.1
PRT-JOB-CODE Alpha 9 AC542 BN500
Job Code Contains a user-defined code that PR195 PR197
represents a type of job. PR560 PR82.1
PR85.1
PRT-PROCESS-LEVEL Alpha 5 AC542 BN500
Process Level This field contains the process level, PR195 PR197
which is the reporting hierarchy below PR560 PR82.1
company. PR85.1
PRT-WORK-STATE Alpha 2 AC542 BN500
Work State Contains the 2-character value that PR195 PR197
identifies employee's work state. PR560 PR82.1
PR85.1
PRT-HOURS Signed 7.2 AC542 BN31.1
Hours Contains the hours associated with the BN31.2 BN32.1
time record. BN32.2 BN32.3
BN500 PBWC.1
PR195 PR197
PR278 PR560
PR82.1 PR85.1
PRWC.1
PRT-RATE Signed 13.4 AC542 BN500
Rate Contains the rate associated with the PR195 PR197
time record. PR82.1 PR85.1
PRT-WAGE-AMOUNT Signed 13.2 AC542 BN500
Wage Amount Contains the wage amount associated PBWC.1 PR195
with the time record. PR197 PR278
PR418 PR560
PR80.1 PR82.1
PR85.1 PRWC.1
PRT-DEPARTMENT Alpha 5 AC542 BN500
Department Contains the department associated with PR195 PR197
the time record. PR560 PR82.1
PR85.1
PRT-PCT-DIST-FLAG Alpha 1 AC542 BN500
Percent Contains the value that indicates if PR195 PR197
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 AC542 BN500
Shift Contains the shift number associated PR195 PR197
with the pay. PR560 PR82.1
PR85.1
PRT-DST-ACCT-UNIT Alpha 15 AC542 BN500
Distribution Contains the general ledger accounting PR195 PR197
Accounting Unit unit to which the amount is posted. PR560 PR82.1
PR85.1
PRT-DST-ACCOUNT Numeric 6 AC542 BN500
Distribution Contains the general ledger account to PR195 PR197
Account Number which the amount is posted. PR560 PR82.1
PR85.1
PRT-DST-SUB-ACCT Numeric 4 AC542 BN500
Distribution Contains the general ledger subaccount PR195 PR197
Subaccount Number to which the amount is posted. PR560 PR82.1
PR85.1
PRT-DIST-COMPANY Numeric 4 AC542 BN500
Distribution Company Contains the company number to which PR195 PR197
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) AC542 BN500
Time Record Date Contains the time record date. PR195 PR197
PR560 PR82.1
PR85.1
PRT-UNION-CODE Alpha 10 AC542 BN500
Union Code Contains the union code associated with PR195 PR197
the time record. PR560 PR82.1
PR85.1
PRT-OT-PREM-AMT Signed 13.2 AC542 BN500
Ot Prem Amt Contains the overtime premium amount PBWC.1 PR195
for the time record. PR197 PR278
PR560 PR82.1
PR85.1 PRWC.1
PRT-SHIFT-DIFF Signed 13.2 AC542 BN500
Shift Differential Contains the shift premium rate PR195 PR197
associated with the time record. PR82.1 PR85.1
PRT-PAYROLL-YEAR Numeric 4 AC542 BN500
Current Payroll Year Contains the payroll year associated PR195 PR197
with the time record. PR560 PR82.1
PR85.1
PRT-QUARTER Numeric 1 AC542 BN500
Quarter Contains the fiscal quarter for the PR195 PR197
data stored in this record. PR560 PR82.1
PR85.1
PRT-PCD-SEQ-NBR Numeric 4 AC542 BN500
Pcd Seq Nbr Contains the sequence number associated PR195 PR197
with the time record relative to the pay PR560 PR82.1
code. PR85.1
PRT-PER-END-DATE Numeric 8 (yyyymmdd) AC542 BN500
Period End Date Contains the period end date associated PR195 PR197
with the time record. PR560 PR82.1
PR85.1
PRT-CHECK-TYPE Alpha 1 AC542 BN500
Payment Type Contains the payment type. PR195 PR197
S = System PR560 PR82.1
M = Manual PR85.1
J = Adjustment
P = Partial ACH
R = Reversal
G = Gross Up
PRT-LOCAT-CODE Alpha 10 AC542 BN500
Location PR195 PR197
PR82.1 PR85.1
PRT-WC-STATE Alpha 2 AC542 BN500
Wc State Contains the workers' compensation PR195 PR197
state associated with the time record. PR560 PR82.1
PR85.1
PRT-OT-RECORD Alpha 1 AC542 BN500
Ot Record Contains the value that indicates if PR195 PR197
the time record was created for PR82.1 PR85.1
retroactive or overtime pay.
Y = Yes
R = Retro
PRT-POSITION Alpha 12 AC542 PR195
Position Contains the user-defined code that PR197 PR82.1
represents a position in the company. PR85.1
PRT-ACTIVITY Alpha 15 AC542 PR195
Activity Activities are the processes or PR197 PR560
procedures that produce work. Cost PR82.1 PR85.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PRT-ACCT-CATEGORY Alpha 5 AC542 PR195
Account Category Account categories are groupings of PR197 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 AC542 PR195
Time Acc Flag Contains an L (Last) if an employee is PR197 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 AC542 PR195
Shft Diff Rate PR197 PR82.1
PR85.1
PRT-OT-RATE Signed 13.4 AC542 PR195
Ot Rate PR197 PR82.1
PR85.1
PRT-ATN-OBJ-ID Numeric 12 AC542 PR195
Atn Object ID The system-defined object id PR197 PR82.1
representing the Activity Management PR85.1
commitment.
PRT-GLT-OBJ-ID Numeric 12 AC542 PR195
Subsystem GL This is a subsystem GL interface PR197 PR82.1
Interface ID identification number. It is used for PR85.1
Drill Around purposes.
PRT-RECONCILED Alpha 1 AC196 AC542
Reconciled Y = Yes PR195 PR197
" " = No PR82.1 PR85.1
PRT-TAX-FREQ-OVER Numeric 1 AC542 PR195
Tax Freq Over 1 = Weekly PR197 PR82.1
2 = Biweekly PR85.1
3 = Semi-monthly
4 = Monthly
5 = Daily
6 = Quarterly
7 = Semi-annually
8 = Annually
PRT-REMUN-CODE Alpha 4 AC542 PR195
Remun Code Contains the remuneration code. Valid PR197 PR82.1
value is C001 = Bonus. PR85.1
PRT-BUS-NBR-GRP Alpha 4 AC542 PR195
Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
PRT-REPORT-ENTITY Alpha 5 AC542 PR195
Report Entity Contains the report entity. PR197 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 AC542 PR195
Qc Ent Nbr Grp Contains the Quebec Enterprise number PR197 PR560
group. PR82.1 PR85.1
PRT-WC-CLASS Alpha 4 AC542 PR195
Workers Comp Contains the workers' compensation PR197 PR82.1
Classification class. PR85.1
PRT-CURRENCY-CODE Alpha 5 AC542 PR195
Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ).
PRT-CURR-ND Numeric 1 AC542 PR195
Currency Number of Represents the number of decimals PR197 PR560
Decimals defined for the currency of the object. PR82.1 PR85.1
PRT-HM-PROCESS-LEV Alpha 5 AC542 PR195
Hm Process Lev PR197 PR560
PR82.1 PR85.1
PRT-CA-WC-CLASS Alpha 10 AC542 PR195
Ca Wc Class Contains the Canadian WC Class from PR197 PR82.1
employees job. Use to identify the PR85.1
PRTIME wages by WC Class.
PRT-COUNTRY-CODE Alpha 2 AC542 PR195
Country Code The country code. Required for VAT and PR197 PR560
intrastat reporting. Must be defined in PR82.1 PR85.1
IN01.1 (Country Maintenance).
PRT-PENS-SEQ-NBR Numeric 4 AC542 PR195
Pens Seq Nbr PR197 PR560
PR82.1 PR85.1
PRT-ABN-OBJ-ID Numeric 12 AC542 PR195
Abn Obj Id PR197 PR82.1
PR85.1
PRT-PAY-UNITS Signed 7.2
Pay Units
PRT-UNIT-MEASURE Alpha 12
Unit Measure
PRT-USER-ID Alpha 10 (Lower Case) AC542 PR195
User ID Name Contains the user ID of the person who PR197 PR82.1
last changed this record. PR85.1
PRT-DATE-STAMP Numeric 8 (yyyymmdd) AC542 PR195
Date Stamp This field contains the server date PR197 PR82.1
(month, date, and year) of the last PR85.1
change to this record.
PRT-NON-EARNINGS Numeric 1
Non Earnings 0 = No - wages
1 = Yes - other remuneration
PRT-ORIG-OBJ-ID Numeric 12 AC542 PR195
Orig Obj Id PR197 PR82.1
PR85.1
PRT-RECORD-TYPE Alpha 1 AC542 PR195
Record Type This field identifies the type of PR197 PR82.1
record defined. PR85.1
Valid values are:
S = Summary
D = Detail
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
PA594 PR05.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR141
PR160 PR180
PR188 PR189
PR195 PR197
PR250 PR251
...
PRTSET2 COMPANY KeyChange BN66.1 PR139
EMPLOYEE PR140 PR189
PAYROLL-YEAR PR195 PR80.1
QUARTER PR89.1
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 PR418
PRWC.1 UK110
TA147 TM570
...
PRTSET5 RECONCILED KeyChange, Subset AC196
ACTIVITY Where ACTIVITY != Spaces
TR-DATE And ATN-OBJ-ID != Zeroes
ATN-OBJ-ID
PRTSET6 COMPANY KeyChange PR09.1 PR131
PROCESS-LEVEL
TR-DATE
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET7 COMPANY KeyChange PR131
TR-DATE
EMPLOYEE
TIME-SEQ
CHECK-ID
PRTSET8 COMPANY Subset AC542 PR160
EMPLOYEE Where PENS-SEQ-NBR != Zeroes PR180 PR195
PENS-SEQ-NBR PR197 PR229
CHECK-ID PR29.1 PR529
TIME-SEQ PR560 PR80.2
PR82.1 PR85.1
PRTSET9 COMPANY Subset AC542
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
Abtrans ABTRANS Not Required
Valid When PRT-ABN-OBJ-ID != Zeroes
PRT-ABN-OBJ-ID -> ABN-OBJ-ID
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
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
|