PRTIME

Employee Pay/Hours History

Contains employee pay and hours history information.

REFERENCED BY
PR262 PR278 PR282 PR289 TA146 BN954
PR131 PR132 UK110 TA147


UPDATED BY
LP353 LP54.1 PR195 PR197 PR300 PR560
PR582 PR82.1 PR85.1 UK560 BN305 BN340
BN345 BN66.1 HCDL.1 HR170 HR70.1 PA594
PR05.1 PR139 PR140 PR141 PR160 PR180
PR188 PR189 PR250 PR251 PR253 PR260
PR261 PR270 PR274 PR418 PR51.1 PR80.1
PR80.2 PR80.4 PR84.1 PR86.1 PR89.1 UK13.1
UK141 UK145 UK201 UK202 UK50.3 UK50.4
PR292 PR50.1 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 BN729 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 PR271 XR901 TM570 TM70.1 TM71.1
HR00.1 HR01.1 PR09.1 PR229 PR29.1 PR529

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRT-COMPANY
Element: Company Hr		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
UK560
PRT-EMPLOYEE
Element: 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
UK560
PRT-CHECK-ID
Element: 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
UK560
PRT-PAY-SUM-GRP
Element: Pay Sum Grp		Alpha 3
Contains the pay summary group associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-TIME-SEQ
Element: Time Seq		Numeric 12
Contains the sequence number assigned to the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-WORK-STATE
Element: Work State		Alpha 2
Contains the 2-character value that identifies employee's work state.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-HOURS
Element: 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
PR195 PR197
PR278 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
UK560
PRT-RATE
Element: Rate		Signed 13.4
Contains the rate associated with the time record.
PR195 PR197
PR582 PR82.1
PR85.1 UK50.3
PRT-WAGE-AMOUNT
Element: Wage Amount		Signed 13.2
Contains the wage amount associated with the time record.
BN66.1 PR140
PR189 PR195
PR197 PR278
PR418 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
UK560
PRT-DEPARTMENT
Element: Department		Alpha 5
Contains the department associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-PCT-DIST-FLAG
Element: 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
Element: Shift		Numeric 1
Contains the shift number associated with the pay.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-DST-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the general ledger accounting unit to which the amount is posted.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-DST-ACCOUNT
Element: Account		Numeric 6
Contains the general ledger account to which the amount is posted.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-DST-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the general ledger subaccount to which the amount is posted.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-DIST-COMPANY
Element: 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
UK560
PRT-TR-DATE
Element: Tr Date		Numeric 8 (yyyymmdd)
Contains the time record date.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-UNION-CODE
Element: Union Code		Alpha 10
Contains the union code associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-OT-PREM-AMT
Element: Ot Prem Amt		Signed 13.2
Contains the overtime premium amount for the time record.
BN66.1 PR140
PR189 PR195
PR197 PR278
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 UK560
PRT-SHIFT-DIFF
Element: 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
Element: Payroll Year		Numeric 4
Contains the payroll year associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-QUARTER
Element: Quarter		Numeric 1
Contains the fiscal quarter for the data stored in this record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 4
Contains the sequence number associated with the time record relative to the pay code.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-PER-BEG-DATE
Element: Per Beg Date		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-PER-END-DATE
Element: Per End Date		Numeric 8 (yyyymmdd)
Contains the period end date associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
TA170 UK560
PRT-WRK-BEG-DATE
Element: Wrk Beg Date		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-WRK-END-DATE
Element: Wrk End Date		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CHECK-TYPE
Element: 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
UK560
PRT-LOCAT-CODE
Element: Locat Code		Alpha 10
PR195 PR197
PR582 PR82.1
PR85.1
PRT-WC-STATE
Element: Wc State		Alpha 2
Contains the workers' compensation state associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-OT-RECORD
Element: Ot Record		Alpha 1
Contains the value that indicates if the time record was created for retroactive or overtime pay or K12 Teacher Contract Assignment.
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
Element: 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
Element: 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
UK560
PRT-ACCT-CATEGORY
Element: 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
UK560
PRT-TIME-ACC-FLAG
Element: 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
Element: Shft Diff Rate		Signed 13.4
PR195 PR197
PR582 PR82.1
PR85.1
PRT-OT-RATE
Element: Ot Rate		Signed 13.4
PR195 PR197
PR582 PR82.1
PR85.1
PRT-ATN-OBJ-ID
Element: 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
Element: 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
Element: Reconciled		Alpha 1

Y = Yes
" " = No
PR195 PR197
PR582 PR82.1
PR85.1
PRT-TAX-FREQ-OVER
Element: Tax Freq Over		Numeric 3
Number of Pay Periods Per Year that is used to determine how to calculate amount of taxes withheld.
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
Element: 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
PR195 PR197
PR582 PR82.1
PR85.1
PRT-BUS-NBR-GRP
Element: Bus Nbr Grp		Alpha 4
Contains the business number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-REPORT-ENTITY
Element: 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
UK560
PRT-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp		Alpha 4
Contains the Quebec Enterprise number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-WC-CLASS
Element: Wc Class		Alpha 4
Contains the workers' compensation class.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CURRENCY-CODE
Element: 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
UK560
PRT-CURR-ND
Element: Acct 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
UK560
PRT-HM-PROCESS-LEV
Element: Process Lev Hr		Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-CA-WC-CLASS
Element: 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
Element: 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
UK560
PRT-PENS-SEQ-NBR
Element: Pens Seq Nbr		Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-ABN-OBJ-ID
Element: Abn Obj Id		Numeric 12
This element is not used.
PRT-PAY-UNITS
Element: Pay Units		Signed 7.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-UNIT-MEASURE
Element: Unit Measure		Alpha 12
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-USER-ID
Element: User		Alpha 10 (Lower Case)
LP353 LP54.1
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-DATE-STAMP
Element: 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
UK560
PRT-NON-EARNINGS
Element: Non Earnings		Numeric 1

0 = No - wages
1 = Yes - other remuneration
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-ORIG-OBJ-ID
Element: Orig Obj Id		Numeric 12
PR195 PR197
PR582 PR82.1
PR85.1
PRT-RECORD-TYPE
Element: 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
Element: 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
Element: Ta Reason Cd		Alpha 4
LP54.1 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK560
PRT-TES-OBJ-ID
Element: Tes Obj Id		Numeric 12
LP353 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK560
PRT-RETRO-PENSION
Element: Retro Pension		Alpha 1

" " = No
N = No
Y = Yes; open payment
PR195 PR197
PR582 PR82.1
PR85.1
PRT-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PRT-TIME-STAMP
Element: 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
UK560
PRT-CREATE-DATE
Element: Date Stamp		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
UK560
PRT-CREATE-TIME
Element: Time Stamp		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
UK560
PRT-CREATE-USER-ID
Element: 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
UK560
PRT-LNK-TIME-SEQ
Element: 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
Element: Cw Contract Yr		Numeric 4
Identifies the employee contract year for K12 processing.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CONT-SEQ-NBR
Element: Cw Cont Seq No		Numeric 12
Identifies the contract segment for K12 Teacher Contract payout processing.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CWC-EFFECT-DT
Element: Effective Dt		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CONTRACT-NBR
Element: Seq Number		Numeric 6
PR195 PR197
PR582 PR82.1
PR85.1
PRT-SEGMENT-NBR
Element: Seq Number		Numeric 6
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CYC-START-DATE
Element: Pay Start Date		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CYC-END-DATE
Element: Pay End Date		Numeric 8 (yyyymmdd)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CM-REG-FLAG
Element: Flag Num		Numeric 1

0 = Non-contract
1 = Regular pay
2 = Reserve pay
3 = Docking pay
PR195 PR197
PR582 PR82.1
PR85.1
PRT-CM130-FLAG
Element: Flag Num		Numeric 1

0 = No
1 = Yes
PR195 PR197
PR582 PR82.1
PR85.1
PRT-MEMO
Element: Text Comment		Alpha 64 (Lower Case)


PRTIME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRTSET1 COMPANY
EMPLOYEE
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
...
BN305 BN340
BN345 BN66.1
HCDL.1 HR170
HR70.1 PA594
PR05.1 PR139
PR140 PR141
PR160 PR180
PR188 PR189
PR195 PR197
PR250 PR251
PR253 PR260
PR261 PR262
PR270 PR274
PR278 PR282
PR300 PR418
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)
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
PR80.4 PR89.1
PRTSET3 COMPANY
EMPLOYEE
PER-END-DATE
CHECK-ID
TIME-SEQ
KeyChange
PR289 TA146
TA170
PRTSET4 COMPANY
EMPLOYEE
TR-DATE
TIME-SEQ
CHECK-ID
KeyChange
...
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN340 BN45.1
BN531 BN66.1
BN71.1 BN72.1
BN729 BN954
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 LP353
LP54.1 PR131
PR132 PR140
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
WherePENS-SEQ-NBR !=Zeroes
PR160 PR180
PR195 PR197
PR229 PR29.1
PR529 PR560
PR582 PR80.2
PR82.1 PR85.1
UK560
PRTSET9 COMPANY
EMPLOYEE
ORIG-OBJ-ID
TIME-SEQ
Subset
WhereORIG-OBJ-ID !=Zeroes


PRTIME FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
AndPRT-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


PRTIME FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:51:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.