Employee Pay/Hours History
Contains employee pay and hours history information.
REFERENCED BY
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. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-CHECK-ID Element: Check Id | Numeric 12 Contains the payment identification number (unique payment identifier used in tracking payment information). |
|
||||||||||||||||||||||||||
PRT-PAY-SUM-GRP Element: Pay Sum Grp | Alpha 3 Contains the pay summary group associated with the time record. |
|
||||||||||||||||||||||||||
PRT-TIME-SEQ Element: Time Seq | Numeric 12 Contains the sequence number assigned to the time record. |
|
||||||||||||||||||||||||||
PRT-JOB-CODE Element: Job Code | Alpha 9 Contains a user-defined code that represents a type of job. |
|
||||||||||||||||||||||||||
PRT-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 |
|
||||||||||||||||||||||||||
PRT-WORK-STATE Element: Work State | Alpha 2 Contains the 2-character value that identifies employee's work state. |
|
||||||||||||||||||||||||||
PRT-HOURS Element: Hours | Signed 7.2 Contains the hours associated with the time record. |
|
||||||||||||||||||||||||||
PRT-RATE Element: Rate | Signed 13.4 Contains the rate associated with the time record. |
|
||||||||||||||||||||||||||
PRT-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Contains the wage amount associated with the time record. |
|
||||||||||||||||||||||||||
PRT-DEPARTMENT Element: Department | Alpha 5 Contains the department associated with the time record. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-SHIFT Element: Shift | Numeric 1 Contains the shift number associated with the pay. |
|
||||||||||||||||||||||||||
PRT-DST-ACCT-UNIT Element: Acct Unit | Alpha 15 Contains the general ledger accounting unit to which the amount is posted. |
|
||||||||||||||||||||||||||
PRT-DST-ACCOUNT Element: Account | Numeric 6 Contains the general ledger account to which the amount is posted. |
|
||||||||||||||||||||||||||
PRT-DST-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the general ledger subaccount to which the amount is posted. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-TR-DATE Element: Tr Date | Numeric 8 (yyyymmdd) Contains the time record date. |
|
||||||||||||||||||||||||||
PRT-UNION-CODE Element: Union Code | Alpha 10 Contains the union code associated with the time record. |
|
||||||||||||||||||||||||||
PRT-OT-PREM-AMT Element: Ot Prem Amt | Signed 13.2 Contains the overtime premium amount for the time record. |
|
||||||||||||||||||||||||||
PRT-SHIFT-DIFF Element: Shift Diff | Signed 13.2 Contains the shift premium rate associated with the time record. |
|
||||||||||||||||||||||||||
PRT-PAYROLL-YEAR Element: Payroll Year | Numeric 4 Contains the payroll year associated with the time record. |
|
||||||||||||||||||||||||||
PRT-QUARTER Element: Quarter | Numeric 1 Contains the fiscal quarter for the data stored in this record. |
|
||||||||||||||||||||||||||
PRT-PCD-SEQ-NBR Element: Pcd Seq Nbr | Numeric 8 Contains the sequence number associated with the time record relative to the pay code. |
|
||||||||||||||||||||||||||
PRT-PER-BEG-DATE Element: Per Beg Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
PRT-PER-END-DATE Element: Per End Date | Numeric 8 (yyyymmdd) Contains the period end date associated with the time record. |
|
||||||||||||||||||||||||||
PRT-WRK-BEG-DATE Element: Wrk Beg Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
PRT-WRK-END-DATE Element: Wrk End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
PRT-LOCAT-CODE Element: Locat Code | Alpha 10 |
|
||||||||||||||||||||||||||
PRT-WC-STATE Element: Wc State | Alpha 2 Contains the workers' compensation state associated with the time record. |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
PRT-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
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). |
|
||||||||||||||||||||||||||
PRT-SHFT-DIFF-RATE Element: Shft Diff Rate | Signed 13.4 |
|
||||||||||||||||||||||||||
PRT-OT-RATE Element: Ot Rate | Signed 13.4 |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-RECONCILED Element: Reconciled | Alpha 1 Y = Yes " " = No |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
PRT-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec Enterprise number group. |
|
||||||||||||||||||||||||||
PRT-WC-CLASS Element: Wc Class | Alpha 4 Contains the workers' compensation class. |
|
||||||||||||||||||||||||||
PRT-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||||||
PRT-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||
PRT-HM-PROCESS-LEV Element: Process Lev Hr | Alpha 5 |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
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). |
|
||||||||||||||||||||||||||
PRT-PENS-SEQ-NBR Element: Pens Seq Nbr | Numeric 4 |
|
||||||||||||||||||||||||||
PRT-ABN-OBJ-ID Element: Abn Obj Id | Numeric 12 This element is not used. |
|
||||||||||||||||||||||||||
PRT-PAY-UNITS Element: Pay Units | Signed 7.2 |
|
||||||||||||||||||||||||||
PRT-UNIT-MEASURE Element: Unit Measure | Alpha 12 |
|
||||||||||||||||||||||||||
PRT-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-NON-EARNINGS Element: Non Earnings | Numeric 1 0 = No - wages 1 = Yes - other remuneration |
|
||||||||||||||||||||||||||
PRT-ORIG-OBJ-ID Element: Orig Obj Id | Numeric 12 |
|
||||||||||||||||||||||||||
PRT-RECORD-TYPE Element: Record Type | Alpha 1 This field identifies the type of record defined. Valid values are: S = Summary D = Detail |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-REASON-CODE Element: Ta Reason Cd | Alpha 4 |
|
||||||||||||||||||||||||||
PRT-TES-OBJ-ID Element: Tes Obj Id | Numeric 12 |
|
||||||||||||||||||||||||||
PRT-RETRO-PENSION Element: Retro Pension | Alpha 1 " " = No N = No Y = Yes; open payment |
|
||||||||||||||||||||||||||
PRT-SERVICE-CODE Element: Ta Service Cd | Alpha 10 |
|
||||||||||||||||||||||||||
PRT-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||
PRT-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||||||
PRT-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
||||||||||||||||||||||||||
PRT-LNK-TIME-SEQ Element: Time Seq | Numeric 12 Used to associate user created time records with LP created time records. |
|
||||||||||||||||||||||||||
PRT-CONTRACT-YEAR Element: Cw Contract Yr | Numeric 4 |
|
||||||||||||||||||||||||||
PRT-CONT-SEQ-NBR Element: Cw Cont Seq No | Numeric 12 |
|
||||||||||||||||||||||||||
PRT-CWC-EFFECT-DT Element: Effective Dt | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
PRT-CONTRACT-NBR Element: Seq Number | Numeric 6 |
|
||||||||||||||||||||||||||
PRT-SEGMENT-NBR Element: Seq Number | Numeric 6 |
|
||||||||||||||||||||||||||
PRT-CYC-START-DATE Element: Pay Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
PRT-CYC-END-DATE Element: Pay End Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||
PRT-CM130-FLAG Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
||||||||||||||||||||||||||
PRT-MEMO Element: Text Comment | Alpha 64 (Lower Case) |
|
||||||||||||||||||||||||||
PRT-EXP-RPT-NBR Element: Invoice | Alpha 22 |
|
||||||||||||||||||||||||||
PRT-REC-TYPE Element: Seq Nbr | Numeric 4 |
|
||||||||||||||||||||||||||
PRT-NOTIONAL Element: Notional | Signed 13.4 |
|
||||||||||||||||||||||||||
PRT-ADDTL-RATE Element: Addtl Rate | Numeric 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRTSET1 |
COMPANY EMPLOYEE CHECK-ID PAY-SUM-GRP TIME-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET10 |
COMPANY HM-PROCESS-LEV EMPLOYEE CHECK-ID PAY-SUM-GRP TIME-SEQ |
|
|||||||||||||||||||||||||||||||||||||
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 |
|
|||||||||||||||||||||||||||||||||||||
PRTSET13 |
COMPANY CREATE-DATE* DATE-STAMP* EMPLOYEE CHECK-ID PAY-SUM-GRP TIME-SEQ |
|
|||||||||||||||||||||||||||||||||||||
PRTSET2 |
COMPANY EMPLOYEE PAYROLL-YEAR QUARTER PAY-SUM-GRP PROCESS-LEVEL WORK-STATE CHECK-ID TIME-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET3 |
COMPANY EMPLOYEE PER-END-DATE CHECK-ID TIME-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET4 |
COMPANY EMPLOYEE TR-DATE TIME-SEQ CHECK-ID |
|
|||||||||||||||||||||||||||||||||||||
PRTSET6 |
COMPANY PROCESS-LEVEL TR-DATE EMPLOYEE TIME-SEQ CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET7 |
COMPANY TR-DATE EMPLOYEE TIME-SEQ CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET8 |
COMPANY EMPLOYEE PENS-SEQ-NBR CHECK-ID TIME-SEQ |
|
| ||||||||||||||||||||||||||||||||||||
PRTSET9 |
COMPANY EMPLOYEE ORIG-OBJ-ID TIME-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acct Category | ACACCTCAT |
Required
| ||||||||||||||||||
Activity | ACACTIVITY |
Required
| ||||||||||||||||||
Actrans | ACTRANS |
Not Required
| ||||||||||||||||||
Assignment | CWASSIGN |
Required
| ||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||
Department | DEPTCODE |
Required
| ||||||||||||||||||
Dist Account | GLMASTER |
Required
| ||||||||||||||||||
Dist Company | GLSYSTEM |
Required
| ||||||||||||||||||
Emp Contract | CWCONTRACT |
Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Glnames | GLNAMES |
Required
| ||||||||||||||||||
Job Code | JOBCODE |
Required
| ||||||||||||||||||
Pay Code | PRPAYCODE |
Required
| ||||||||||||||||||
Pay Sum Group | PAYSUMGRP |
Required
| ||||||||||||||||||
Paymastr | PAYMASTR |
Required
| ||||||||||||||||||
Prcheck | PRCHECK |
Required
| ||||||||||||||||||
Process Level | PRSYSTEM |
Required
| ||||||||||||||||||
Prqcentgrp | PRQCENTGRP |
Not Required
| ||||||||||||||||||
Reason Code | TAREASCODE |
Required
| ||||||||||||||||||
Service Code | TASERVCODE |
Required
| ||||||||||||||||||
Taempserv | TAEMPSERV |
Not Required
| ||||||||||||||||||
Trsgblck | TRSGBLCK |
Not Required
| ||||||||||||||||||
Union | PCODES |
Required
| ||||||||||||||||||
Wc Province | PRPROVINCE |
Required
| ||||||||||||||||||
Wc State | PRSTATE |
Required
| ||||||||||||||||||
Work Province | PRPROVINCE |
Required
| ||||||||||||||||||
Work State | PRSTATE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Pay Classes | PSGRELATE |
| |||||||||||||||
Position | PAPOSITION |
|
All trademarks and registered trademarks are the property of their
respective owners.