PRTIME

Employee Pay/Hours History

Contains employee pay and hours history information.

REFERENCED BY
BN305 BN340 BN345 HCDL.1 HR170 HR70.1
ZH568 PA594 PR05.1 PR141 PR160 PR180
PR188 PR250 PR251 PR253 PR260 PR270
PR274 PR278 PR282 PR418 PR51.1 PR84.1
PR86.1 ZP554 PR50.1 BN100 BN101 BN102
BN103 BN105 BN145 BN245 BN260 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 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 PR271 UK110 TM570 TM70.1
TM71.1 PR09.1 PR229


UPDATED BY
LP353 LP54.1 PR195 PR197 PR300 PR560
PR582 PR82.1 PR85.1 BN66.1 HR00.1 HR01.1
PA495 PR01.2 PR139 PR140 PR189 PR20.4
PR261 PR262 PR292 PR80.1 PR80.4 PR89.1
PRAT.1 BN150 PR521 EXI2.1 EXI4.1 LP130
PR128 PR131 PR132 PR134 PR135 PR136
PR137 PR289 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 PR36.4
PR37.1 PR45.1 PR529 PR530 UK102 TA147

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
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
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
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
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
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
PRT-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
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
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
PRAT.1 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
PRT-RATE
Element: Rate
Signed 13.4
Contains the rate associated with the time record.
PR195 PR197
PR582 PR82.1
PR85.1
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
PRAT.1
PRT-DEPARTMENT
Element: Department
Alpha 5
Contains the department associated with the time record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
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
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
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
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
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
PRT-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
Contains the time record date.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
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
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 PRAT.1
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
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
PRT-PCD-SEQ-NBR
Element: 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
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
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
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
PRT-OT-RECORD
Element: 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
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
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
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

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
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
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
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
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
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
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
PRT-HM-PROCESS-LEV
Element: Process Lev Hr
Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
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
PRT-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-ABN-OBJ-ID
Element: Abn Obj Id
Numeric 12
This element is not used.
PR195 PR197
PR582 PR82.1
PR85.1
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
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
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
PRT-TES-OBJ-ID
Element: Tes Obj Id
Numeric 12
LP353 PR195
PR197 PR560
PR582 PR82.1
PR85.1
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
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
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
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
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
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
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CONT-SEQ-NBR
Element: Cw Cont Seq No
Numeric 12
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
PR560 PR582
PR82.1 PR85.1
PRT-SEGMENT-NBR
Element: Seq Number
Numeric 6
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CYC-START-DATE
Element: Pay Start Date
Numeric 8 (yyyymmdd)
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-CYC-END-DATE
Element: Pay End Date
Numeric 8 (yyyymmdd)
PR195 PR197
PR560 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
4 = Adjustment
5 = Summer Deferral
PR195 PR197
PR560 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)
PR195 PR197
PR582 PR82.1
PR85.1
PRT-EXP-RPT-NBR
Element: Invoice
Alpha 22
PR195 PR197
PR582 PR82.1
PR85.1
PRT-REC-TYPE
Element: Seq Nbr
Numeric 4
PR195 PR197
PR582 PR82.1
PR85.1
PRT-NOTIONAL
Element: Notional
Signed 13.4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PRT-ADDTL-RATE
Element: Addtl Rate
Numeric 1
PR195 PR197
PR560 PR582
PR82.1 PR85.1


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 HR00.1
HR01.1 HR170
HR70.1 ZH568
PA495 PA594
PR01.2 PR05.1
PR139 PR140
PR141 PR160
PR180 PR188
PR189 PR195
PR197 PR20.4
PR250 PR251
PR253 PR260
PR261 PR262
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
PR80.4 PR89.1
PRAT.1
PRTSET3 COMPANY
EMPLOYEE
PER-END-DATE
CHECK-ID
TIME-SEQ
KeyChange
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR140
PR189 PR195
PR289 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
PRTSET4 COMPANY
EMPLOYEE
TR-DATE
TIME-SEQ
CHECK-ID
KeyChange
...
BN100 BN101
BN102 BN103
BN105 BN145
BN245 BN260
BN31.1 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 ZB10.1
ZB10.2 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
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
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: Thu Jun 09 02:30:46 2016

Home
Contact Us



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