PRTIME – Employee Pay/Hours History

System: Payroll (PR)
Prefix: PRT
Primary key: COMPANY, EMPLOYEE, CHECK-ID, PAY-SUM-GRP, TIME-SEQ
Fields: 86
Updated by: 60 programs
Referenced by: 63 programs

PRTIME is the Employee Pay/Hours History table in Lawson Payroll (prefix PRT). It is indexed by COMPANY, EMPLOYEE, CHECK-ID, PAY-SUM-GRP, TIME-SEQ (PRTSET1); alternate indexes: PRTSET10, PRTSET11, PRTSET12, PRTSET13, PRTSET2, PRTSET3, PRTSET4, PRTSET6 and 3 more. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACTRANS, CWASSIGN, PRSYSTEM, DEPTCODE, GLMASTER, GLSYSTEM and 16 more and 1:M to PSGRELATE and PAPOSITION. It is updated by BN150, BN66.1, EXI2.1, EXI4.1, HR00.1, HR01.1, LP130, LP353 and 52 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN260 and 55 more. The table has 86 fields, 12 indexes and 29 documented relations.

About PRTIME

Contains employee pay and hours history information.

Fields (86)

Column = COBOL field name without the PRT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PRT-COMPANY` PK COMPANY	Numeric 4	Identifies the HR company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each 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.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CHECK-ID` PK CHECK_ID	Numeric 12	Contains the payment identification number (unique payment identifier used in tracking payment information).	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PAY-SUM-GRP` PK PAY_SUM_GRP	Alpha 3	Contains the pay summary group associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-TIME-SEQ` PK TIME_SEQ	Numeric 12	Contains the sequence number assigned to the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-JOB-CODE` JOB_CODE	Alpha 9	Contains a user-defined code that represents a type of job.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-WORK-STATE` WORK_STATE	Alpha 2	Contains the 2-character value that identifies employee's work state.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-HOURS` HOURS	Signed 7.2	Contains the hours associated with the time record.	BN31.1, BN31.2, BN32.1, BN32.2, BN32.3, BN66.1, PR140, PR189 +18 more
`PRT-RATE` RATE	Signed 13.4	Contains the rate associated with the time record.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-WAGE-AMOUNT` WAGE_AMOUNT	Signed 13.2	Contains the wage amount associated with the time record.	BN66.1, PR140, PR189, PR195, PR197, PR278, PR418, PR560 +7 more
`PRT-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the department associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PCT-DIST-FLAG` PCT_DIST_FLAG	Alpha 1	Contains the value that indicates if the system is to use the defined override distribution information instead of the normal general ledger account defaulting for this time record.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-SHIFT` SHIFT	Numeric 1	Contains the shift number associated with the pay.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-DST-ACCT-UNIT` DST_ACCT_UNIT	Alpha 15	Contains the general ledger accounting unit to which the amount is posted.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-DST-ACCOUNT` DST_ACCOUNT	Numeric 6	Contains the general ledger account to which the amount is posted.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-DST-SUB-ACCT` DST_SUB_ACCT	Numeric 4	Contains the general ledger subaccount to which the amount is posted.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-DIST-COMPANY` DIST_COMPANY	Numeric 4	Contains the company number to which the transaction is posted. A valid intercompany relationship must be defined in the General Ledger system.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-TR-DATE` TR_DATE	Numeric 8 (yyyymmdd)	Contains the time record date.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-UNION-CODE` UNION_CODE	Alpha 10	Contains the union code associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-OT-PREM-AMT` OT_PREM_AMT	Signed 13.2	Contains the overtime premium amount for the time record.	BN66.1, PR140, PR189, PR195, PR197, PR278, PR560, PR582 +6 more
`PRT-SHIFT-DIFF` SHIFT_DIFF	Signed 13.2	Contains the shift premium rate associated with the time record.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-PAYROLL-YEAR` PAYROLL_YEAR	Numeric 4	Contains the payroll year associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-QUARTER` QUARTER	Numeric 1	Contains the fiscal quarter for the data stored in this record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PCD-SEQ-NBR` PCD_SEQ_NBR	Numeric 8	Contains the sequence number associated with the time record relative to the pay code.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PER-BEG-DATE` PER_BEG_DATE	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-PER-END-DATE` PER_END_DATE	Numeric 8 (yyyymmdd)	Contains the period end date associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-WRK-BEG-DATE` WRK_BEG_DATE	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-WRK-END-DATE` WRK_END_DATE	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-CHECK-TYPE` CHECK_TYPE	Alpha 1	Contains the payment type. `S` System `M` Manual `J` Adjustment `P` Partial ACH `R` Reversal `G` Gross Up `A` ACH	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-LOCAT-CODE` LOCAT_CODE	Alpha 10	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-WC-STATE` WC_STATE	Alpha 2	Contains the workers' compensation state associated with the time record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-OT-RECORD` OT_RECORD	Alpha 1	Contains the value that indicates if the time record was created for retroactive or overtime pay. `Y` Yes `R` Retro `F` Flex `T` Tips `U` Updated `X` Exemption Processed `O` Offset Time Record `P` Payout `C` Created by Employee Contract `I` Created by BN150	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-POSITION` POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of 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	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-TIME-ACC-FLAG` TIME_ACC_FLAG	Alpha 1	Contains an L (Last) if an employee is terminating employment with the company and you are issuing the final payment through PR80.1 (Manual Payment).	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-SHFT-DIFF-RATE` SHFT_DIFF_RATE	Signed 13.4	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-OT-RATE` OT_RATE	Signed 13.4	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-RECONCILED` RECONCILED	Alpha 1	" " = No `Y` Yes	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-TAX-FREQ-OVER` TAX_FREQ_OVER	Numeric 3	— `001` Weekly `002` Biweekly `003` Semi-monthly `004` Monthly `005` Daily `006` Quarterly `007` Semi-annually `008` Annually `009` 9 Month Academic Monthly `010` 10 Month Academic Monthly	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-REMUN-CODE` REMUN_CODE	Alpha 4	Contains the remuneration code. Valid value is C001 = Bonus. `E002` US Pay Advances `E003` US Athletic Facilities `E004` US Non-Qual Plan Awrds and Prz `E005` US Back Pay `E006` US Bonuses `E007` US Business Expense `E009` US Gifts `E010` US Commissions `E013` US Discounts `E014` US Dismissal/Severance `E015` US Educational Assistance `E016` US Employment Agency `E017` US Qual Equip/Tool/Uniform `E018` US Business Use of Company Car `E019` US Personal Use of Company Car `E020` US No Additional Cost Services `E021` US Golden Parachute `E022` US Group Legal Services `E023` US Guaranteed Wage `E024` US Jury Duty Pay `E025` US Below Market Loans to Empl `E026` US Meals and Lodging `E027` US Supplemental Military Pay `E028` US Qualified Moving Expenses `E029` US Non-Cash Fringe `E030` US Outplacement Services `E031` US Overtime `E032` US Qualified Parking `E033` US Pre-employment Reimbursmnt `E034` US Probationary Pay `E035` US Regular Wages `E036` US Scholarships `E037` US Sick/Disability Pay `E038` US Standby/Idle Time `E039` US Stock Purch & Incentive Pln `E040` US Supper Money `E041` US Supplemental Unemployment `E042` US Taxes Paid by Employer `E043` US Tips `E044` US Travel; Exp Reimbursement `E045` US Tuition Reimbursement `E046` US Union Pay `E047` US Vacation Pay `E048` US Group Term Life G.T. 50000 `E049` US Ministers Housing Allowance `E999` US Custom Earnings `E051` US Income Under Section 409A `E052` US Transportation CHV `E055` US Commuter Benefits `E067` US Tips Non-Taxable `E068` US Diff Pay - Active Mil Duty `E070` US EE Adult Child Hlth Ins `E071` US ER Adult Child Hlth Ins	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-BUS-NBR-GRP` BUS_NBR_GRP	Alpha 4	Contains the business number group.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-REPORT-ENTITY` REPORT_ENTITY	Alpha 5	Contains the report entity. 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.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-QC-ENT-NBR-GRP` QC_ENT_NBR_GRP	Alpha 4	Contains the Quebec Enterprise number group.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-WC-CLASS` WC_CLASS	Alpha 4	Contains the workers' compensation class.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-HM-PROCESS-LEV` HM_PROCESS_LEV	Alpha 5	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CA-WC-CLASS` CA_WC_CLASS	Alpha 10	Contains the Canadian WC Class from employees job. Use to identify the PRTIME wages by WC Class.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-PENS-SEQ-NBR` PENS_SEQ_NBR	Numeric 4	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ABN-OBJ-ID` ABN_OBJ_ID	Numeric 12	This element is not used.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-PAY-UNITS` PAY_UNITS	Signed 7.2	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP353, LP54.1, PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP353, LP54.1, PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-NON-EARNINGS` NON_EARNINGS	Numeric 1	— `0` No - wages `1` Yes - other remuneration	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ORIG-OBJ-ID` ORIG_OBJ_ID	Numeric 12	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-RECORD-TYPE` RECORD_TYPE	Alpha 1	This field identifies the type of record defined. Valid values are: `S` Summary `D` Detail	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ATTEND-CODE` ATTEND_CODE	Alpha 2	A user-defined alphanumeric code that 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.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-REASON-CODE` REASON_CODE	Alpha 4	—	LP54.1, PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-TES-OBJ-ID` TES_OBJ_ID	Numeric 12	—	LP353, PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-RETRO-PENSION` RETRO_PENSION	Alpha 1	" " = No `N` No `Y` Yes; open payment	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-SERVICE-CODE` SERVICE_CODE	Alpha 10	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP353, LP54.1, PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-LNK-TIME-SEQ` LNK_TIME_SEQ	Numeric 12	Used to associate user created time records with LP created time records.	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-CONTRACT-YEAR` CONTRACT_YEAR	Numeric 4	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CONT-SEQ-NBR` CONT_SEQ_NBR	Numeric 12	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CWC-EFFECT-DT` CWC_EFFECT_DT	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-CONTRACT-NBR` CONTRACT_NBR	Numeric 6	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-SEGMENT-NBR` SEGMENT_NBR	Numeric 6	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CYC-START-DATE` CYC_START_DATE	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CYC-END-DATE` CYC_END_DATE	Numeric 8 (yyyymmdd)	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CM-REG-FLAG` CM_REG_FLAG	Numeric 1	— `0` Non-contract `1` Regular pay `2` Reserve pay `3` Docking pay `4` Adjustment `5` Summer Deferral	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-CM130-FLAG` CM130_FLAG	Numeric 1	— `0` No `1` Yes	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-MEMO` MEMO	Alpha 64 (Lower Case)	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-EXP-RPT-NBR` EXP_RPT_NBR	Alpha 22	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-REC-TYPE` REC_TYPE	Numeric 4	—	PR195, PR197, PR582, PR82.1, PR85.1
`PRT-NOTIONAL` NOTIONAL	Signed 13.4	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1
`PRT-ADDTL-RATE` ADDTL_RATE	Numeric 1	—	PR195, PR197, PR560, PR582, PR82.1, PR85.1

Indexes (12)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PRTSET1`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`	Primary		BN305, BN340, BN345, BN66.1, HCDL.1, HR00.1, HR01.1, HR170 +22 more (list truncated in source)
`PRTSET10`	`COMPANY`, `HM-PROCESS-LEV`, `EMPLOYEE`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`	KeyChange		—
`PRTSET11`	`COMPANY`, `EMPLOYEE`, `CONTRACT-YEAR`, `POSITION`, `CONT-SEQ-NBR`, `PER-END-DATE*`, `CWC-EFFECT-DT`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`			—
`PRTSET12`	`COMPANY`, `EMPLOYEE`, `CONTRACT-NBR`, `SEGMENT-NBR`, `CYC-END-DATE*`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`	Subset	Where (CONTRACT-NBR != Zeroes)	—
`PRTSET13`	`COMPANY`, `CREATE-DATE`, `DATE-STAMP`, `EMPLOYEE`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`	KeyChange		—
`PRTSET2`	`COMPANY`, `EMPLOYEE`, `PAYROLL-YEAR`, `QUARTER`, `PAY-SUM-GRP`, `PROCESS-LEVEL`, `WORK-STATE`, `CHECK-ID`, `TIME-SEQ`	KeyChange		BN66.1, PR139, PR140, PR189, PR195, PR292, PR50.1, PR80.1 +3 more
`PRTSET3`	`COMPANY`, `EMPLOYEE`, `PER-END-DATE`, `CHECK-ID`, `TIME-SEQ`	KeyChange		BN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131 +22 more (list truncated in source)
`PRTSET4`	`COMPANY`, `EMPLOYEE`, `TR-DATE`, `TIME-SEQ`, `CHECK-ID`	KeyChange		BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN260 +22 more (list truncated in source)
`PRTSET6`	`COMPANY`, `PROCESS-LEVEL`, `TR-DATE`, `EMPLOYEE`, `TIME-SEQ`, `CHECK-ID`	KeyChange		HR00.1, HR01.1, PR09.1, PR131
`PRTSET7`	`COMPANY`, `TR-DATE`, `EMPLOYEE`, `TIME-SEQ`, `CHECK-ID`	KeyChange		PR131
`PRTSET8`	`COMPANY`, `EMPLOYEE`, `PENS-SEQ-NBR`, `CHECK-ID`, `TIME-SEQ`	Subset	Where PENS-SEQ-NBR != Zeroes	PR160, PR180, PR195, PR197, PR229, PR29.1, PR529, PR560 +4 more
`PRTSET9`	`COMPANY`, `EMPLOYEE`, `ORIG-OBJ-ID`, `TIME-SEQ`	Subset	Where ORIG-OBJ-ID != Zeroes	—

Relations

One to one (27) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`
Assignment	CWASSIGN	Required		`PRT-COMPANY` → `CWA-COMPANY`, `PRT-EMPLOYEE` → `CWA-EMPLOYEE`, `PRT-CONTRACT-YEAR` → `CWA-CONTRACT-YEAR`, `PRT-POSITION` → `CWA-POSITION`, `PRT-PER-END-DATE` → `CWA-ASG-EFFECT-DTE`, `PRT-PCD-SEQ-NBR` → `CWA-PCD-SEQ-NBR`
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`
Emp Contract	CWCONTRACT	Required		`PRT-COMPANY` → `CCT-COMPANY`, `PRT-EMPLOYEE` → `CCT-EMPLOYEE`, `PRT-CONTRACT-YEAR` → `CCT-CONTRACT-YEAR`, `PRT-POSITION` → `CCT-POSITION`, `PRT-CONT-SEQ-NBR` → `CCT-CONT-SEQ-NBR`
Employee	EMPLOYEE	Required		`PRT-COMPANY` → `EMP-COMPANY`, `PRT-EMPLOYEE` → `EMP-EMPLOYEE`
Glnames	GLNAMES	Required		`PRT-DIST-COMPANY` → `GLN-COMPANY`, `PRT-DST-ACCT-UNIT` → `GLN-ACCT-UNIT`
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`
Taempserv	TAEMPSERV	Not Required	Valid When PRT-TES-OBJ-ID != Zeroes	`PRT-COMPANY` → `TES-COMPANY`, `PRT-EMPLOYEE` → `TES-EMPLOYEE`, `PRT-TES-OBJ-ID` → `TES-TES-OBJ-ID`
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (60)

BN150 Life Insurance Reportable Income
BN66.1 Estimated Pay Calculation
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR00.1 Company
HR01.1 Process Level
LP130 Absence Plan Payout
LP353 Employee Service History Purge
LP54.1 Employee Event History Update
PA495 IPEDS Report
PR01.2 Bank Code
PR128 Offset Time Record Creation
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR20.4 Pay Code
PR261 Payment Detail Listing By Report Entity
PR262 Taxable Wage CSV
PR289 Weeks Worked Calculation
PR29.1 Pension Payment Maintenance
PR292 Quarterly Unemployment Ins
PR300 History Purge
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update

Referenced by (63)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN245 Benefit Election Form
BN260 Employee Benefit Extract
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN340 ADP and ACP Tests
BN345 Percentage Test
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
HCDL.1 Olap Data Load
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PA594 EECRS CSV Interface
PR05.1 Deduction
PR09.1 Head Process Level
PR141 Payroll Register
PR160 Payment Print
PR180 Manual Payment Print
PR188 Payroll Hours Update
PR229 Pension Participant Listing
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR253 1099-R Reporting
PR260 Payment Detail Listing
PR270 Employee Wage Report
PR271 US Affordable Care Act
PR274 Statistics Canada
PR278 United States Workers Compensation Report
PR282 Canada Record of Employment
PR418 Canada Workers Compensation Report
PR50.1 United States Quarterly Payment Inquiry
PR51.1 Pay Stub Inquiry
PR84.1 Seniority Recalculation Inquiry
PR86.1 Payment Replacement
TM570 Attendance History Conversion
TM70.1 Employee Attendance History
TM71.1 Attendance History Speed Entry
UK110 Pay Rate Table Update
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH568 Reed Employee Census Interface
ZP554 Union Dues - BiWeekly