Create a PY Employee Pay History

Identify the Pay Run Code

Identify the Year related to the Pay

Indentify the Pay Period

Indentify the Sub Pay Period

The unique identifier of an employee

The system generated Sequence Number per Employee per Pay Period

The Date from Employee worked during current Pay Period

The Company for whom Employee worked during transaction period

The type of Line that is entered. Either G" or J

The working Department of the Employee

The respected GL A/C Code for posting of calculated amount to GL

The respected GL A/C Code for posting of calculated amount to GL

The Job Code assigned to the Employee

The Job Phase on which the Employee worked

The Job Category on which employee worked

The respected Equipment Number

The Equipment Category if applicable

The Equipment Transaction Number if applicable

The Rate applied to calculate the cost for a piece of equipment

The Union Code for whom the Employee worked durint Transaction pe

The Trade Code being used during calculation

The Work Location of Employee for the calculated Transaction

The predefined Type to identify the type of Transaction like "BN"

The respected Code for which the calculations are made

The Quantity used for Amount calculation if applicable

The Quantity used for Amount calculation if applicable

The Rate applied to calculate the Amount for a Coe and its Type

The Rate applied to calculate the Amount for a Coe and its Type

The Rate applied to calculate the Amount for a Coe and its Type

The Rate applied to calculate the Amount for a Coe and its Type

The calculated Amount against the Code and its respective Type

The calculated Amount against the Code and its respective Type

The calculated Amount against the Code and its respective Type

The calculated Amount against the Code and its respective Type

The calculated Amount against the Code and its respective Type

The Batch Number referencing to the GL

Used to join to PYEMPSALADJ, PYEMPTIMSHT, PYEMPEXPSHTto decide which tables process flag to nullify in CHECK VOIDING.

The Date the data was posted

The name of the user who made the last update

Date and Time stamp of the last update

Charge Out Amount

Bill Amount

Work Order Code.

Work Item Number.

Work Order Expense Code

Flag to indicate whether input transactions were retained after checks were voided

Employee`s work location GeoCode.

Employee`s residence location GeoCode.

Pay date sets on table PYCOMPAYPRD as PPR_PAY_DATE.

Expected post date, sets on table PYCOMPPAYPRD as PPR_POSTING_DATE.

Month Number.

Flag to indicate whether this transaction was the actual transaction which was adjusted during redistribution of costs. (Y)es or (N)o

Date referrening to Period from which wages and burdens were redistributed

Description referrening to Period from which wages and burdens were redistributed

Sequence number to identify the original job from which the cost was transferred

Sequence number to identify the job to which the cost was transferred

Plan Code For The Transacation. Applicable Only To Benefits And Deductions.

The Option Against The Plan For The Transaction. Applicable Only To Benefits And Deductions.

Flag to indicate whether the transaction originated from a receivable - (Y)es, (R)eturned i.e. extra amount was received and the extra amount was returned back

Flag to mention, expense has been entered from expense claim entry.

Flag to indicate whether the transaction originated from a loan receivable - G is for with GL entried, W is for without GL, N is normal adjustment and R is returned if an excess amount was paid against loan.

Public Liability Code.

Pay date when checks have been printed. For void check reverse transactions, it is the check void date (ie. void effective date).

Job phase code for the piece of equipment. It can be different from the phase to which time is being charged.

Field to enter Equipment Hours.

Field to enter equipment charge rate

Field to enter equipment bill rate

Field to enter equipment charge amt

Field to enter equipment bill amt

Field to enter wm code for equipment.

Field to enter Equipment Job category.

Actual Start Date For Expense Entered From E-Expense. Automatically Populated By E-Expense When Expense Approved

Actual End Date For Expense Entered From E-Expense. Automatically Populated By E-Expense When Expense Approved

Feild to populate the SUI work location from employee profile

Payroll Salary Debit account code setup on employee profile. It will be populate at the time of timesheet posting

Payroll Salary Debit department code setup on employee profile. It will be populate at the time of timesheet posting

Transfer labor costs WC/PL recalculate flag ie. column pyredistribute_batch_emp.rbe_recal_wcpl

Shift code. Null means unspecified, or D/E/N for Day/Evening/Night shift.

Check location code

Y/null. Y indicates a reversal transaction created by the void check program.

Correct NULL PHY_ACTUAL_PAY_DATE for paid transactions from payroll 2006 onwards; and subsequently by trigger. See version script 0789197.sql.

Prevailing wage rate.

Federal Reporting Jurisdiction: null=not yet determined, *=proper US/CA, GU=Guam,...,see PYFEDTERR.

This is the Reference Check Number

This is the Actual Date that Employee Worked on

Employee normal base union pay rate.

Crew Code

N: Record will be excluded from the Certified Payroll Report

Rate code multiplier from table column Pypayrcd.rcd_prem_multiplier.

Rate code premium per hour from table column Pypayrcd.rcd_prem_per_hour_amt.

Base pay rate to use in determining prevailing wage rate differential. Currently equivalent to phy_pay_rate less the hourly premium and multiplier.

Prevailing wage job-trade calculated payroll fringe rate (per hr worked).

Prevailing wage job-trade contract fringe rate (per hr worked).

Apply overtime premium on contract fringe rate (Y/N/null).

Calculated prevailing wage differential rate.

Calculated prevailing wage differential amount.

Calculated prevailing wage differential destination benefit code.

Prevailing wage differential calculation done (Y/null). Y also indicates that this BW/LE line is a prevailing wage job-trade.

Y/null: Indicates whether this benefit (BN) line contains the prevailing wage differential.

Prevailing wage job company for Mechanics/Truckers who work on equipments or deliver materials to a PW job but whose labor is costed against the equipment/trucking job.

Prevailing wage job code for Mechanics/Truckers who work on equipments or deliver materials to a PW job but whose labor is costed against the equipment/trucking job.

Equipment location code.

Job code for cost pooling burdens. Blank if not applicable.

Employee Home company at the time of processing payroll

Employee Home department at the time of processing payroll

Store The Leave Taken Year Based On The Timesheet Date

Employee Leave Calculation Period Start Date

Employee Leave Calculation Method

United Kingdom PAYE tax code

United Kingdom NIC category code

Vertex Employee Resident PSD Codes Based On The Vertex Geocode And School District Code Of The Employee

Field Is Used When COST ALLOCATION ON EQUIPMENT WORKORDER Alternative Feature Is Installed; Indicates That The Record Is Already Posted To Avoid Duplicate Entry When Repost The Same Period

Vertex School District Code

PY Salary Adjustment Benefit Accrual Paid-out Sequence Number

Ireland PAYE exclusion order flag (Y/N/null).

Ireland PAYE/USC Calculation Method: C=Cumulative, 1=Week/Month 1, E=Emergency, T=Temporary

Ireland PRSI subclass for employee.

Ireland PRSI subclass for employer.

Only for Information purpose-Indicate whether input transactions were retained after checks were voided

Unique Row ID