PS_BOND_LOG

Bond Log

O

This record applies only to U.S. conversions and is required if you use the Bond Processing feature in Payroll for North America. The record contains detailed information about each bond that the employee purchases. The only records of concern are those that are still in process—that is, when the employee is making contributions toward a bond, but has not yet accumulated enough to actually purchase it. The system populates this record after producing each paycheck for an employee.

PS_CHECK_YTD

Check YTD

O

This record contains fields that are currently used only in the following standard PeopleSoft reports:

• Check Print (PAY003).

• Employee Earnings Snapshot (PAY013).

• Employee Earnings Record (PAY014).

• Direct Deposit Advice Print (DDP003).

PS_CHECK_YTD contains YTD information about total gross, total taxes, total deductions, and net pay. Make sure that these totals represents the correct transition from gross to net.

If you don’t require this data on your paychecks, don’t convert this data.

PS_DEDUCTION_BAL

Deduction Balance

R

This record is required for deductions on which you impose a YTD limit, such as 401(k) deductions. You must also load other deductions that are reported on Form W-2, such as the taxable benefit portion of group-term life insurance (imputed income). Also, if your check design incorporates YTD and current balance information, consider importing YTD data for all deductions.

PS_EARNINGS_BAL

Earnings Balance

R

This record is required for earnings types that are necessary for W-2 processing and for earnings on which you impose a YTD limit. Also consider check-printing YTD data requirements.

Use this record to load special accumulator data. For example, you might require special accumulators to track earnings for pension calculations or retirement wages.

If you do not require full detail of earnings, you might substitute a summary earnings type to record the employee’s total YTD earnings.

PS_TAX_BALANCE

Tax Balance

R

Tax balances are the most critical set of records to convert. Without these balances, you could have incorrect tax data and tax reports. YTD data is your biggest concern. If you convert at the beginning of a quarter, you do not need quarter-to-date (QTD) or month-to-date (MTD) data.

PS_CAN_CHECK_YTD

Check YTD

O

This record contains fields that are currently used only in the following standard PeopleSoft reports:

• Cheque Print (PAY003CN).

• Statistics Canada, Educational Institutions (PAY110CN).

• Direct Deposit Advice Print (DDP003CN).

PS_CAN_CHECK_YTD contains YTD information about total gross, total taxes, total deductions, and net pay. Make sure that these totals represents the correct transition from gross to net.

If you don’t require this data on your paycheques, don’t convert this data.

PS_CAN_DED_BALANCE

Deduction Balance

R

This record is required for deductions on which you impose a YTD limit, most frequently your pension deduction. You must also load other deductions that you report at year-end, such as the taxable benefit for company-paid life insurance. Also, if your check design incorporates YTD and current balance information, consider importing YTD data for all deductions.

PS_CAN_ERN_BALANCE

Earnings Balance

R

This record is required for earnings types that are necessary for year-end processing and for earnings on which you impose a YTD limit. Also consider cheque-printing YTD data requirements.

Use this record to load special accumulator data. For example, you might require special accumulators to track earnings for pension calculations or retirement wages.

If you do not require full detail of earnings, you might substitute a summary earnings type to record the employee’s total YTD earnings.

PS_CAN_TAX_BALANCE

Tax Balance

R

See the U.S. Tax Balance record, PS_TAX_BALANCE.

PS_INS_EARNS_BAL

Insurable Earnings Balance

O

The system creates this record during payroll processing and tracks Canadian Employment Insurance (EI) insurable earnings balances and related information for employees by company, wage loss plan, EI period, and earnings end date.

The system uses this data during the ROE Creation process. You must convert your weekly EI earnings to Insurable Earnings records.

PS_ROE

ROE

O

This is not a balance record. It is a data record that the system uses to print the ROE that you send to the government upon terminating an employee. To use the PeopleSoft ROE Automated Create process, you must enter your submitted ROEs for the past reportable periods. This enables the system to generate amended ROEs. (Only enter data for old ROEs; the system generates new ones).

Enter this data on the ROE Data 1 page. PeopleSoft recommends this procedure only if the amount of data is relatively small; alternatively, you can use a conversion process to build the records.

PS_ROE_FUTURE_PAY

ROE Future Pay

O

This record contains information about ROE-reportable payments (other than regular pay) to include in the final or future pay for an employee.

Note. Use this record only for entering online expected future pay data at the time that you produce a ROE. Do not enter conversion data in this record.

PS_ADDL_PAY_DATA

Additional Pay Data

O

This record operates identically to the GENL_DEDUCTION record, except that it is for earnings instead of deductions. The GOAL_BAL field contains the to-date amount that you’ve paid to the employee.

PS_ADDL_PAY_EFFDT

Additional Pay Effective Date

O

This record is the effective-dated control record for ADDL_PAY_DATA. It is also the child record of PS_ADDL_PAY_ERNCD.

PS_ADDL_PAY_ERNCD

Additional Pay Earnings Code

O

This record is the earnings code control record for ADDL_PAY_DATA.

PS_DED_ARREARS

Deduction Arrears

O

Use this record to record employee deductions that are in arrears in the current system.

If the number of employees with arrears balances is very small, consider manually converting this information after you go live. Use the By Paysheet - One-Time Deductions page to input the arrears amount as a one-time additional amount.

If you decide to load these records, the system attempts to take the amount that is in arrears during the first payroll run.

These deductions should be valid for the benefit or deduction program in which the employee is currently enrolled.

PS_GARN_BALANCE

Garnishment Balance

O

Use this record to record balance data for each garnishment ID.

Before loading garnishment balance data into this record, load the PS_DEDUCTION_BAL record with YTD, QTD, and MTD data for the combined total of all garnishments for an employee. PeopleSoft defines garnishments as tax levies, wage assignments, child or spouse support, and bankruptcies. PeopleSoft identifies each garnishment with a garnishment ID.

PS_GENL_DED_CD

Garnishment Deduction Code

O

This record contains the top level keys for employee general deduction data.

PS_GENL_DEDUCTION

General Deduction Detail

O

This record contains employee-specific deduction limits. The GOAL_BAL field contains the to-date amount that the system deducted toward a goal limit. The system might have already loaded this for a previous conversion. It is also the child record of PS_GENL_DED_CD.

PS_LEAVE_ACCRUAL

Leave Accrual

O

This record contains employee balances for vacation and sick leave.

(USF) PS_GVT_ERN_ACR_CLS

Leave Accrual

O

See the standard Leave Accrual record, PS_LEAVE_ACCRUAL.

BOND_ID

Required. Value of the bond, such as 100 USD, 500 USD, and so on.

BOND_OWNER_ID

Required. ID of the owner of the bond. If the current system does not contain this information, enter EE (employee). Otherwise, this field represents the ID that is assigned to one of the Dependent or Beneficiary records.

BOND_OTH_REG_TYPE

Required. Indicates whether there are co-owners or beneficiaries. If you do not have this information, enter N (none).

BOND_OTHER_REG_ID

Required. Indicates the co-owner or beneficiary. If you do not have this information, enter EE (employee).

BOND_LOG_SEQ

Required. Indicates a sequential number for each bond. Populate with a 1.

BOND_LOG_STATUS

Required. Indicates the status of each record:

D: Funds disbursed.

N: Funds not ready to disburse.

R: Funds ready to disburse.

Load only records for funds with a status of N.

F

T

REVERSED

Required. Indicates whether the entry has been reversed due to a check reversal. Set to N.

FORM_ID

Required. Form ID from the Pay Group table.

PAYCHECK_NBR

Required. Indicates the PS_PAYCHECK where the system deducted the amount. Enter a dummy check number, such as 999999.

CHECK_DT

Required. The check date of the paycheck when the system deducted the amount. You can use the conversion date.

BOND_COLLECT_AMT

Required. The amount that the system deducted for each bond. If this data is not available, enter 0.

BOND_DISBURSE_AMT

Amount that was used to purchase a bond. Leave blank.

BOND_PURCH_UNITS

Indicates how many bonds were purchased for each paycheck. Leave blank.

BOND_ACCUM_AMT

Balance remaining since the last bond was purchased. Load data into this field.

COMPANY

Company.

PAYGROUP

Pay group.

PAY_END-DT

Pay period end date.

OFF_CYCLE

Off-cycle.

AP_STATUS

Indicates if the bond purchase details have been sent to PeopleSoft Enterprise Accounts Payable. Leave blank.

TOTAL_GROSS_YTD

TOTAL_TAXES_YTD

TOTAL_DEDNS_YTD

NET_PAY_YTD

See PS_CHECK_YTD.

PLAN_TYPE

BENEFIT_PLAN

DEDCD

DED_CLASS

See PS_DEDUCTION_BAL.

DED_SLSTX_CLASS

B: None.

G: Goods and services tax.

H: Harmonized sales tax.

I: Provincial sales tax on insurance.

P: Provincial sales tax.

Q: QC provincial sales tax on insurance.

S: QC provincial sales tax.

T: Provincial premium tax.

U: QC provincial premium tax.

DED_YTD

DED_QTD

DED_MTD

See PS_DEDUCTION_BAL.

SPCL_BALANCE

ERNCD

HRS_YTD

HRS_QTD

HRS_MTD

GRS_YTD

GRS_QTD

GRS_MTD

See PS_EARNINGS_BAL.

TAX_CLASS_CAN

Use the following values for each tax class type:

ALL: Total gross.

CBT: Canadian bonus tax.

CIT: Canadian income tax (T4).

CPA: Pension adjustment.

CPP: Canada Pension Plan employee.

CPR: Canada Pension Plan employer.

EIE: Employment Insurance employee.

EIR: Employment Insurance employer.

HTX: Provincial health tax.

PYT: Payroll tax.

QBT: Quebec bonus tax.

QIT: Quebec income tax (RL-1).

QPP: Quebec Pension Plan employee.

QPR: Quebec Pension Plan employer.

RV2: Quebec income tax (RL-2).

T4A: Canadian income tax (T4A).

TRV: True RL.

TT4: True T4.

NLGRS_YTD*

NLGRS_QTD*

NLGRS_MTD*

TXGRS_YTD

TXGRS_QTD

TXGRS_MTD

TAX_YTD

TAX_QTD

TAX_MTD

See PS_TAX_BALANCE.

TOTAL_GROSS_YTD

Total of all earnings that add to gross (Earnings table).

TOTAL_TAXES_YTD

Total of all employee-paid taxes.

TOTAL_DEDNS_YTD

All before-tax and after-tax deductions.

NET_PAY_YTD

Remaining amount.

PLAN_TYPE

(USA) See PS_DEDUCTION_BAL.

(CAN) See PS_CAN_DED_BALANCE.

BENEFIT_PLAN

Enter the benefit plan for your benefit deductions only. Leave blank for general deductions (Plan Type = 00).

DED_CLASS

(USA) See PS_DEDUCTION_BAL.

(CAN) See PS_CAN_DED_BALANCE.

ARREARS_BAL

Amount that the employee owes for each deduction.

PLAN_TYPE

00: General deductions.

01: Benefit program.

10 – 17: Medical plans

20 – 27: Life insurance plans.

30: Short-term disability.

31: Long-term disability.

40 – 49: Employee investment plans.

4A: Employed stock purchase plan.

50: Sick (no loading required for this record).

51: Vacation (no loading required for this record).

52: Personal (no loading required for this record).

53: Family and medical leave (no loading required for this record).

5A: Company car.

60: Flex Spending Health - U.S.

61: Flex Spending Dependent Care.

65: Flex Spending Health - Canada.

66: Retirement counseling Canada.

70: PERS.

80: Standard pension.

81: Supplementary pension.

82: USDB pension plan 1.

83: USDB pension plan 2.

84: USDB pension plan 3.

85: USDB pension plan 4.

86: USDB pension plan 5.

87: USDB pension plan 6.

90: Vacation buy.

91: Vacation sell.

BENEFIT_PLAN

Enter the benefit plan for your benefit deductions only. Leave blank for general deductions (Plan Type = 00).

DEDCD

Enter the deduction code.

DED_CLASS

A: After-tax.

B: Before-tax.

L: QC (Quebec) taxable benefit.

N: Nontaxable benefit.

P: Nontaxable benefit for before-tax match.

T: Taxable benefit.

DED_YTD

YTD deduction amount.

DED_QTD

(optional) QTD deduction amount.

DED_MTD

(optional) MTD deduction amount

SPCL_BALANCE

Set to Y if you are loading a special accumulator. Otherwise, set to N.

ERNCD

Enter the earnings code. When loading special accumulators, enter the special accumulator code.

HRS_YTD

YTD hours.

HRS_QTD

QTD hours.

HRS_MTD

MTD hours.

GRS_YTD

YTD amount.

GRS_QTD

QTD amount.

GRS_MTD

MTD amount.

PLAN_TYPE

(USA) See PS_DEDUCTION_BAL.

(CAN) See PS_CAN_DED_BALANCE.

BENEFIT_PLAN

Enter the benefit plan for your benefit deductions only. Leave blank for general deductions (Plan Type = 00).

DEDCD

Enter the deduction code.

DED_CLASS

(USA) See PS_DEDUCTION_BAL.

(CAN) PS_CAN_DED_BALANCE.

GARNID

Unique identifier for each garnishment. It must match the ID in the employee’s GARN_SPEC record.

DED_YTD

Total YTD deduction amount, including the deduction and processing fees.

DED_QTD

Total QTD deduction amount, including the deduction and processing fees.

DED_MTD

Total MTD deduction amount, including the deduction and processing fees.

DED_GARN_YTD

Year-to-date amount collected for the garnishment itself, minus processing fees.

DED_GARN_QTD

QTD amount collected for the garnishment itself, minus processing fees.

DED_GARN_MTD

MTD amount collected for the garnishment itself, minus processing fees.

DED_CFEE_YTD

YTD processing fees paid to the company.

DED_CFEE_QTD

QTD processing fees paid to the company.

DED_CFEE_MTD

MTD processing fees paid to the company.

DED_PFEE_YTD

YTD processing fees paid to the payee.

DED_PFEE_QTD

QTD processing fees paid to the payee.

DED_PFEE_MTD

MTD processing fees paid to the payee.

UI_PERIOD_DT

EI period date (pay period end date).

EARNS_END_DT

Earnings end date (Saturday of each week in the pay period).

UI_PERIODS_PER_YR

EI pay periods per year.

UI_CALC_SEQ

EI calculation sequence.

UI_USE_WKLY

EI use weekly values. Set to N if entire pay period is insured. Set to Y to revert to weekly rules of insurability. For EI period dates of January 1, 1997, or later, set to N.

UI_EARNS_CUR

Total insurable earnings in this EI period.

UI_EQUIV_WEEKS_CUR

Total number of weeks in this insured EI period. If all weeks in a biweekly cycle are insured, this is 2. If all weeks in a monthly cycle are insured, it is 4.33. For EI period dates of January 1, 1997, or later, leave this field blank.

UI_EE_PREMIUM_CUR

Current employee premium.

UI_ER_RT

EI employer rate.

UI_WKLY_EARNS

EI earnings this week (no limit). All earnings that fall between Sunday and Saturday.

UI_WKLY_HOURS

EI hours this week.

ROE_NBR

ROE number (normally blank).

INS_EARNS_AMENDED

Insurable earnings amended:

A: Amended. Next run of PAY124CN changes to R.

N: Not applicable (normal status).

R: Amended and reported.

PLAN_TYPE

50: Sick.

51: Vacation.

52: Personal.

53: Family and medical leave.

ACCRUAL_PROC_DT

Last time you ran the Leave Accruals Processing COBOL SQL process (FGPACCRL). You can leave this field blank.

SERVICE_HRS

Accumulated service hours used to calculate an employee’s accrual. If your accrual is based on length of service, you can leave this field blank.

HRS_CARRYOVER

Accrual hours carried over from the previous year.

HRS_EARNED_YTD

Number of hours accrued this year.

HRS_TAKEN_YTD

Number of hours taken for each plan.

HRS_ADJUST_YTD

Number of hours used to adjust an employee’s plan balance. Can be left blank.

HRS_BOUGHT_YTD

Number of hours that an employee bought during the year.

HRS_SOLD_YTD

Number of hours that an employee sold during the year.

SERVICE_HRS_UNPROC

Service hours that have accumulated in payroll, but have not yet been updated by the Leave Accruals Processing process. Leave blank.

HRS_TAKEN_UNPROC

Taken hours that have accumulated in payroll, but have not yet been updated by the Leave Accruals Processing process. Leave blank.

HRS_ADJUST_UNPROC

Adjusted hours that have accumulated in payroll, but have not yet been updated by the Leave Accruals Processing process. Leave blank.

HRS_BOUGHT_UNPROC

Bought hours that have accumulated in payroll, but have not yet been updated by the Leave Accruals Processing process. Leave blank.

HRS_SOLD_UNPROC

Sold hours that have accumulated in payroll, but have not yet been updated by the Leave Accruals Processing process. Leave blank.

GVT_ERN_ACCR_CLASS (key)

Class code.

EFFDT (key)

Effective date.

EFF_STATUS

Active or inactive.

DESCR

Long description.

DESCRSHORT

Short description.

GVT_ACCR_TYPE

Earnings accrual type:

A: Annual.

C: Credit time.

G: Religious comp.

L: LWOP.

N: Nonpay.

P: Compensatory time.

R: Restored.

S: Sick.

T: Time-off award.

GVT_ADJ_ALLOWED

Adjustments allowed: yes (Y) or no (N).

ACCRUAL_FREQUENCY

Accrual frequency:

H: Hours per hour.

M: Hours per month.

P: Hours per pay period.

Y: Hours per year.

SERVICE_INTERVAL

Service units:

H: Hours.

M: Months.

Y: Years.

HRS_GO_NEGATIVE

Accrued balance go negative: Y or N.

SPECIAL_CALCULATN

Special calculation routine: Y or N.

YEAR_BEGIN_CALC

Service calculation at year begin: Y or N.

GVT_EFF_RATE_PAY

Effective rate disposition:

E: Use rate when earned.

C: Use current rate.

P: Use percentage of current rate.

GVT_ERNCD_EXPIRE

Expiration earnings code.

GVT_EXP_INTERVAL

Expiration interval:

H: Hours.

M: Months.

Y: Years.

GVT_EXP_INTERVALS

Expiration intervals.

GVT_EXP_DISP

Expiration disposition:

P: Convert to pay.

F: Forfeit.

C: Convert to other.

GVT_EXP_ERNCD

Termination earnings code.

GVT_EOY_FLAG

End-of-year indicator: Y or N.

GVT_CEILING_SET

Ceiling indicator: Y or N.

GVT_MAX_CEILING

Maximum compensation hours.

GVT_CEIL_INTERVAL

Ceiling interval:

H: Hours.

M: Months.

Y: Years.

GVT_CEIL_INTERVALS

Ceiling intervals.

GVT_CEILING_DISP

Ceiling disposition:

A: Allow to exceed.

U: Use of lose.

P: Convert to pay.

F: Forfeit.

O: Convert to other.

GVT_CEILING_ERNCD

Ceiling earnings code.

GVT_MAX_CARRYOVER

Maximum carryover indicator: Y or N.

MAXIMUM_CARRYOVER

Maximum leave carryover.

GVT_COORD_WITH_GF

Coordinate with grandfather: Y or N.

GVT_COVR_DISP

Carryover disposition:

A: Allow to exceed.

U: Use of lose.

P: Convert to pay.

F: Forfeit.

O: Convert to other.

GVT_COVR_INTERVAL

Carryover interval:

H: Hours.

M: Months.

Y: Years.

GVT_COVR_INTERVALS

Carryover intervals.

GVT_MAX_COVR_ERNCD

Carryover earnings code.

PAY_TERM_PCT

Pay percentage of hours at term.

GVT_PAY_TERM_DISP

Termination disposition:

P: Convert to pay.

F: Forfeit.

GVT_PAY_TERM_ERNCD

Termination earnings code.

GVT_USE_OLD_FIRST

Use oldest hours first indicator: Y or N.

EMPLID (key)

Employee ID.

EMPL_RCD# (key)

Employee record number.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

COVERAGE_ELECT

Coverage election:

E: Elect.

T: Term.

W: Waive.

COVERAGE_ELECT_DT

Leave plan coverage date.

GVT_ALT_WORK_SCHED

Work schedule.

GVT_GFATH_CYOVER

Grandfather carryover.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

ERNCD (key)

Earnings code.

GVT_R_ADJ_HRS_ADD

Add to restored hours adjusted: Y or N.

GVT_R_TAK_HRS_ADD

Add to restored hours taken: Y or N.

HRS_TAKEN_ADD

Add to hours taken.

SERVICE_HRS_ADD

Add to service hours.

ADJUST_HRS_ADD

Add to adjust hours.

BOUGHT_HRS_ADD

Add to hours bought.

SOLD_HRS_ADD

Add to hours sold.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

SERVICE_INTERVALS (key)

Service intervals.

HOURS_EARNED

Hours earned.

GVT_SUPPL_HRS

Hours in last pay period.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

SERVICE_INTERVALS (key)

Service intervals.

HOURS_EARNED

Hours earned.

EMPLID (key)

Employee ID.

EMPL_RCD# (key)

Employee record number.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

ERNCD (key)

Earnings code.

SERVICE_HRS

Hours of service.

HOURS_EARNED

Hours earned.

HRS_TAKEN

Hours taken.

HRS_ADJ

Hours adjustment.

GVT_HRS_BOUGHT

Hours bought.

GVT_HRS_SOLD

Hours sold.

GVT_NONPAY_HRS

Nonpay hours.

GVT_CR_REDUC_HR

Credit reduction hours.

GVT_FORFEIT_HRS

Forfeited hours.

GVT_MUSTUSE_USE

Must-use hours.

EXPIRATN_DT

Expiration date.

RATE_AMOUNT

Rate amount.

EMPLID (key)

Employee ID.

EMPL_RCD# (key)

Employee record number.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

ERNCD (key)

Earnings code.

SEQUENCE_NBR (key)

Sequence number.

GVT_ADJ_DT

Adjustment date.

ADJ_REASON

Adjustment reason.

GVT_ADJ_APPLIED

Adjustment applied: Y or N.

SERVICE_HRS

Hours of service.

HOURS_EARNED

Hours earned.

HRS_TAKEN

Hours taken.

HRS_ADJ

Hours adjustment.

GVT_HRS_BOUGHT

Hours bought.

GVT_HRS_SOLD

Hours sold.

GVT_NONPAY_HRS

Nonpay hours.

GVT_CR_REDUC_HRS

Credit reduction hours.

GVT_FORFEIT_HRS

Forfeited hours.

GVT_MUSTUSE_HRS

Must-use hours.

EXPIRATN_DT

Expiration date.

RATE_AMOUNT

Rate amount.

EMPLID (key)

Employee ID.

EMPL_RCD# (key)

Employee record number.

GVT_ERN_ACCR_CLASS (key)

Earnings code class.

EFFDT (key)

Effective date.

HRS_CARRYOVER

Hours carried over − previous year.

HRS_EARNED_YTD

Hours earned YTD.

HRS_TAKEN_YTD

Hours taken YTD.

HRS_ADJUST_YTD

Hours adjusted YTD.

HRS_BOUGHT_YTD

Hours bought YTD.

HRS_SOLD_YTD

Hours sold YTD.

GVT_NONPAY_YTD

Hours nonpay YTD.

MAXIMUM_CARRYOVER

Maximum leave carryover.

GVT_GFATH_CYOVER

Grandfather carryover.

GVT_R_HRS_1

Restored hours balance.

GVT_R_HRS_TAK_1

Restored hours taken.

GVT_R_EXPIRE_DT_1

Expiration date.

GVT_R_HRS_2

Restored hours balance 2.

GVT_R_HRS_TAK_2

Restored hours taken 2.

GVT_R_EXPIRE_DT_2

Expiration date 2.

GVT_R_HRS_3

Restored hours balance 3.

GVT_R_HRS_TAK_3

Restored hours taken 3.

GVT_R_EXPIRE_DT_3

Expiration date 3.

GVT_ADJ_APPLIED

Adjustment made.

ADJ_ENTRY_DT

Adjustment entry date.

GVT_AUDITED

Audited indicator: Y or N.

GVT_YEAR

Year.

GVT_YEAR_FY

Fiscal year begin indicator: Y or N.

GVT_YEAR_CY

Calendar year begin indicator: Y or N.

GVT_PP_NBR

Pay period sequence number.

GVT_ACCR_RUN

Accrual year begin indicator: Y or N.

GVT_YEAR_PY

Pay year begin indicator: Y or N.

GVT_YEAR_LY

Leave year begin indicator: Y or N.

UI_PAYABLE_DT

EI premium payable up-to-date.

ROE_SEQ

ROE sequence number.

ROE_PROCESS

C: Complete.

D: Delete.

G: Generate.

H: Hold.

ROE_NBR

ROE number.

ROE_NBR_REPL

ROE number amended or replaced.

ROE_DT

ROE date created or completed.

MULTIPLE_JOBS

Employee has multiple jobs (Y or N).

PAYGROUP

Pay group on the employee’s Job data.

JOBCODE

Job code for extraction of job description.

Valid action code from PS_ACTION_TBL

ADL: Additional job.

ASC: Assignment completion.

ASG: Assignment.

DEM: Demotion.

DTA: Data change.

FSC: Family status change.

HIR: Hire.

INT: Completion of introductory Per.

JED: Earnings distribution change.

JRC: Job reclassification.

LOA: Leave of absence.

LOF: Layoff.

LTD: Long-term disability with pay.

LTO: Long-term disability.

PAY: Pay rate change.

PLA: Paid leave of absence.

POS: Position change.

PRB: Probation.

PRC: Completion of probation.

PRO: Promotion.

Valid action code from PS_ACTION_TBL (continued)

REC: Recall from suspension or layoff.

REH: Rehire.

RET: Retirement.

RFD: Return from disability.

RFL: Return from leave.

RWP: Retirement with pay.

STD: Short-term disability with pay.

STO: Short-term disability.

SUS: Suspension.

TER: Termination.

TWB: Terminated with benefits.

TWP: Termination with pay.

XFR: Transfer.

ACTION_REASON

Valid Reason Code from PS_ACTN_REASON_TBL.

ROE_ISSUER_ID

EMPLID of issuer.

ROE_CONTACT_ID

EMPLID of contact.

FIRST_DATE_WORKED

First date worked.

LAST_DATE_WORKED

Last date worked.

PD_LEAVE_START_DT

Paid leave start date.

PD_LEAVE_INTERVAL

Paid leave interval.

Duration interval:

D: Daily.

W: Weekly.

PD_LEAVE_AMT

Paid leave amount.

EXPECTED_RETURN_DT

Expected return date.

NOT_RETURNING

Not returning (Y or N).

OVRD_HRS

To override the system-calculated hours for this ROE.

BUSINESS_UNIT

Business unit on the employee’s Job data.

SETID_JOBCODE

SetID for the job code.

COMMENTS

Comments.

STATE

For federal taxes, use $U. For state and local taxes, use the two-character state code.

LOCALITY

For federal and state taxes, leave blank. Otherwise, use the PS local tax code.

TAX_CLASS

Use the following values for each tax:

A: Non-resident alien (1042).

B: Local employer and employee.

C: Earned income credit.

D: OASDI or disability − employee.

E: OASDI or disability − employer.

F: FICA Medicare Hospital Insurance - employee.

G: OASDI/EE- tips.

H: Withholding.

J: OASDI/ER- tips.

K: Excise.

L: NJ Supl Workforce Admin Fund.

M: New Jersey WFDP.

N: New Jersey HCSF.

P: Occupational privilege tax.

Q: FICA Med Hospital Ins/ER.

R: Local employer.

S: Unemployment - special.

T: FICA Med Hospital Ins/EE- tips.

U: Unemployment ER. Use for employer-paid federal and state unemployment taxes.

V: Unemployment EE. Use for employee-paid state unemployment.

W: Voluntary Disability Plan − employee.

X: Voluntary Disability Plan − employer.

Z: FICA Med Hospital Ins/ER-tips.

NLGRS_YTD*

YTD no-limit gross wages.

NLGRS_QTD*

NLGRS_MTD*

Not required, if going live at quarter start.

TXGRS_YTD

Enter the amount, up to the taxable limit.

TXGRS_QTD

TXGRS_MTD

Not required, if going live at quarter start.

TAX_YTD

Enter the tax amount taken.

TAX_QTD

TAX_MTD

Not required, if going live at quarter start.

Gross wages (all payroll-processed earnings).

Gross wages (all payroll-processed earnings).

Federal W-2, FICA and FUTA wages.

Taxable wages.

Withheld tax totals by each tax type (FWT, SWT by state, FICA, SDI, and so on).

Withheld tax totals by each tax type (CIT, QIT, CPP, QPP, and EI).