Lawson Insight Technical Documentation |
|
PRTIME
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
PR282 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 UK13.1 UK141
UK145 UK201 UK202 UK330 UK50.3 UK50.4
TA147 UK120 PR292 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
AC196 AC542 BN500 PR195 PR197 PR300
PR560 PR82.1 PR85.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY Numeric 4 AC542 BN500
Element: Company The company number represents an PR195 PR197
established company and is entered on PR560 PR82.1
all function codes. PR85.1 UK560
PRT-EMPLOYEE Numeric 9 AC542 BN500
Element: 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 UK560
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 UK560
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 UK560
PRT-TIME-SEQ Numeric 12 AC542 BN500
Element: Sequence NumbeContains the sequence number assigned PR195 PR197
to the time record. PR560 PR82.1
PR85.1 UK560
PRT-JOB-CODE Alpha 9 AC542 BN500
Element: Job Code Contains a user-defined code that PR195 PR197
represents a type of job. PR560 PR82.1
PR85.1 UK560
PRT-PROCESS-LEVEL Alpha 5 AC542 BN500
Element: Process Level This field contains the process level, PR195 PR197
which is the reporting hierarchy below PR560 PR82.1
company. PR85.1 UK560
PRT-WORK-STATE Alpha 2 AC542 BN500
Element: Work State Contains the 2-character value that PR195 PR197
identifies employee's work state. PR560 PR82.1
PR85.1 UK560
PRT-HOURS Signed 7.2 AC542 BN31.1
Element: 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 UK560
PRT-RATE Signed 13.4 AC542 BN500
Element: Rate Contains the rate associated with the PR195 PR197
time record. PR82.1 PR85.1
UK50.3
PRT-WAGE-AMOUNT Signed 13.2 AC542 BN500
Element: 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
UK560
PRT-DEPARTMENT Alpha 5 AC542 BN500
Element: Department Contains the department associated with PR195 PR197
the time record. PR560 PR82.1
PR85.1 UK560
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
Element: Shift Contains the shift number associated PR195 PR197
with the pay. PR560 PR82.1
PR85.1 UK560
PRT-DST-ACCT-UNIT Alpha 15 AC542 BN500
Element: Accounting UniContains the general ledger accounting PR195 PR197
unit to which the amount is posted. PR560 PR82.1
PR85.1 UK560
PRT-DST-ACCOUNT Numeric 6 AC542 BN500
Element: Account Contains the general ledger account to PR195 PR197
which the amount is posted. PR560 PR82.1
PR85.1 UK560
PRT-DST-SUB-ACCT Numeric 4 AC542 BN500
Element: Subaccount Contains the general ledger subaccount PR195 PR197
to which the amount is posted. PR560 PR82.1
PR85.1 UK560
PRT-DIST-COMPANY Numeric 4 AC542 BN500
Element: Company Contains the company number to which PR195 PR197
the transaction is posted. A valid PR560 PR82.1
intercompany relationship must be PR85.1 UK560
defined in the General Ledger system.
PRT-TR-DATE Numeric 8 (yyyymmdd) AC542 BN500
Element: Time Record DaContains the time record date. PR195 PR197
PR560 PR82.1
PR85.1 UK560
PRT-UNION-CODE Alpha 10 AC542 BN500
Element: Union Code Contains the union code associated with PR195 PR197
the time record. PR560 PR82.1
PR85.1 UK560
PRT-OT-PREM-AMT Signed 13.2 AC542 BN500
Element: Ot Prem Amt Contains the overtime premium amount PBWC.1 PR195
for the time record. PR197 PR278
PR560 PR82.1
PR85.1 PRWC.1
UK560
PRT-SHIFT-DIFF Signed 13.2 AC542 BN500
Element: Shift DifferenContains the shift premium rate PR195 PR197
associated with the time record. PR82.1 PR85.1
PRT-PAYROLL-YEAR Numeric 4 AC542 BN500
Element: Current PayrolContains the payroll year associated PR195 PR197
with the time record. PR560 PR82.1
PR85.1 UK560
PRT-QUARTER Numeric 1 AC542 BN500
Element: Quarter Contains the fiscal quarter for the PR195 PR197
data stored in this record. PR560 PR82.1
PR85.1 UK560
PRT-PCD-SEQ-NBR Numeric 4 AC542 BN500
Element: Pcd Seq Nbr Contains the sequence number associated PR195 PR197
with the time record relative to the pay PR560 PR82.1
code. PR85.1 UK560
PRT-PER-END-DATE Numeric 8 (yyyymmdd) AC542 BN500
Element: Date Contains the period end date associated PR195 PR197
with the time record. PR560 PR82.1
PR85.1 UK560
PRT-CHECK-TYPE Alpha 1 AC542 BN500
Element: Payment Type Contains the payment type. PR195 PR197
S = System PR560 PR82.1
M = Manual PR85.1 UK560
J = Adjustment
P = Partial ACH
R = Reversal
G = Gross Up
PRT-LOCAT-CODE Alpha 10 AC542 BN500
Element: Location PR195 PR197
PR82.1 PR85.1
PRT-WC-STATE Alpha 2 AC542 BN500
Element: Wc State Contains the workers' compensation PR195 PR197
state associated with the time record. PR560 PR82.1
PR85.1 UK560
PRT-OT-RECORD Alpha 1 AC542 BN500
Element: 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
Element: Position Contains the user-defined code that PR197 PR82.1
represents a position in the company. PR85.1
PRT-ACTIVITY Alpha 15 AC542 PR195
Element: Activity Activities are the processes or PR197 PR560
procedures that produce work. Cost PR82.1 PR85.1
objects (products, services, customers, UK560
and so on) are the reasons for
performing the activity.
PRT-ACCT-CATEGORY Alpha 5 AC542 PR195
Element: Account CategoAccount categories are groupings of PR197 PR560
costs, revenues, or a combination of PR82.1 PR85.1
both used for reporting and inquiries UK560
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
Element: 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
Element: Shft Diff Rate PR197 PR82.1
PR85.1
PRT-OT-RATE Signed 13.4 AC542 PR195
Element: Ot Rate PR197 PR82.1
PR85.1
PRT-ATN-OBJ-ID Numeric 12 AC542 PR195
Object PR197 PR82.1
Identification PR85.1
PRT-GLT-OBJ-ID Numeric 12 AC542 PR195
Object PR197 PR82.1
Identification PR85.1
PRT-RECONCILED Alpha 1 AC196 AC542
Element: Reconciled Y = Yes PR195 PR197
" " = No PR82.1 PR85.1
PRT-TAX-FREQ-OVER Numeric 1 AC542 PR195
Element: 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
Element: Remun Code Contains the remuneration code. Valid PR197 PR82.1
value is C001 = Bonus. PR85.1
PRT-BUS-NBR-GRP Alpha 4 AC542 PR195
Element: Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
UK560
PRT-REPORT-ENTITY Alpha 5 AC542 PR195
Element: Process Level Contains the report entity. PR197 PR560
PR82.1 PR85.1
Report Entity is the Process Level or UK560
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
Element: Qc Ent Nbr GrpContains the Quebec Enterprise number PR197 PR560
group. PR82.1 PR85.1
UK560
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
Element: Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ). UK560
PRT-CURR-ND Numeric 1 AC542 PR195
Account Currency PR197 PR560
Code PR82.1 PR85.1
UK560
PRT-HM-PROCESS-LEV Alpha 5 AC542 PR195
Element: Hm Process Lev PR197 PR560
PR82.1 PR85.1
UK560
PRT-CA-WC-CLASS Alpha 10 AC542 PR195
Element: 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
Element: 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). UK560
PRT-PENS-SEQ-NBR Numeric 4 AC542 PR195
Element: Pens Seq Nbr PR197 PR560
PR82.1 PR85.1
UK560
PRT-ABN-OBJ-ID Numeric 12 AC542 PR195
Element: Abn Obj Id PR197 PR82.1
PR85.1
PRT-PAY-UNITS Signed 7.2
Element: Pay Units
PRT-UNIT-MEASURE Alpha 12
Element: Unit Measure
PRT-USER-ID Alpha 10 (Lower Case) AC542 PR195
Element: User PR197 PR82.1
PR85.1
PRT-DATE-STAMP Numeric 8 (yyyymmdd) AC542 PR195
Element: 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
Element: Non Earnings 0 = No - wages
1 = Yes - other remuneration
PRT-ORIG-OBJ-ID Numeric 12 AC542 PR195
Element: Orig Obj Id PR197 PR82.1
PR85.1
PRT-RECORD-TYPE Alpha 1 AC542 PR195
Element: Record Type This field identifies the type of PR197 PR82.1
record defined. PR85.1
Valid values are:
S = Summary
D = Detail
PRT-ATTEND-CODE Alpha 2 AC542 PR195
Element: Attendance CodA user-defined alphanumeric code that PR197 PR82.1
represents a reason for an employee's PR85.1
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.
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 PR292
QUARTER PR80.1 PR89.1
PAY-SUM-GRP
PROCESS-LEVEL
WORK-STATE
CHECK-ID
TIME-SEQ
PRTSET3 COMPANY KeyChange PR289 TA146
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
BN340 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
...
PRTSET5 RECONCILED KeyChange, Subset AC196
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 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
UK560
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
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
|