At least one record exists for each payment cycle (monthly, biweekly) for each employee paid on that date - key is EMPLOYEE_ID, PAY_CYCLE_CODE, PAY_CYCLE_END_DATE. This entity acts as a header record containing gross totals, tax and bank information, hours worked, and check information. Check information exists only if a physical check is written, no check information exists for a surepay bank transmittal. The reason for the occasional duplicated record is still under research.
The data originates from the payment cycle-produced Payroll Audit Record (PAR). The
PAREUD table has been split by fiscal year. THE PAREUD table is for the current fiscal
year with PAREUD96 containing the 1995-1996 fiscal year.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ACRU_IND | ACCRUAL INDICATOR | VARCHAR2(1) | The code indicating whether leave hours have been accrued for the current accrual period. (values are Y or BLANK) |
| ACRU_PTO_HRS | PAID TIME-OFF HOURS ACCRUED | NUMBER(9,6) | The number of hours of paid time off hours accrued for the pay cycle. |
| ACRU_PTO_HRS_LOST | PAID TIME-OFF HOURS LOST | NUMBER(9,6) | The number of paid time off hours not accrued during the pay cycle because they exceed the maximum limit on accrued paid time off. |
| ACRU_SICK_HRS | SICK LEAVE HOURS ACCRUED | NUMBER(9,6) | The number of hours of sick leave accrued for the pay cycle. |
| ACRU_SICK_HRS_LOST | SICK LEAVE HOURS LOST | NUMBER(9,6) | The number of sick leave hours not accrued for the pay cycle because they exceed the maximum limit on accrued sick leave. |
| ACRU_VAC_HRS | VACATION HOURS ACCRUED | NUMBER(9,6) | The number of hours of vacation accrued for the pay cycle. |
| ACRU_VAC_HRS_LOST | VACATION HOURS LOST | NUMBER(9,6) | The number of vacation hours not accrued for the pay cycle because they exceed the maximum limit on accrued vacation. |
| ADV_PAY_AMT | ADVANCED PAY AMOUNT | NUMBER(7,2) | For current activity PAR records, the amount of advance being paid. For cancellation or overpayment PAR records, the amount of advance being cancelled or returned. For handdrawn check PAR records, the amount being recorded. |
| BANK_ACCTNO | BANK ACCOUNT NUMBER | VARCHAR2(13) | The number of the bank account into which an individuals pay is to be deposited. |
| BANK_TBL_KEY | BANK TABLE KEY | VARCHAR2(5) | The key used to access the bank table to obtain the bank address to which an employees pay was sent. |
| CHK_DATE | CHECK DATE | DATE | For cancellation, handdrawn, or current activity PAR records, the date the check or the check/advice was issued. For overpayment PAR records, the date on which the overpayment worksheet was prepared (transaction date). |
| CHK_DISP_CODE | PAY DISPOSITION CODE | VARCHAR2(1) | The code indicating the pay distribution method selected by the individual. (values are 0=override, can be system generated or manually entered, 1=hold at central campus distribution point, 2=hold for departmental pick-up or 3=individually through campus mail to campus or hospital address, 4=bulk mail to bank, 5=US mail to local address, 6=US mail to distant address, 7=US mail to foreign address, 8=surepay direct deposit) |
| CHK_NO | CHECK NUMBER | VARCHAR2(6) | The number of the payroll check or account payable check associated with a transaction. Checks paid through the direct-deposit (Surepay) process will not have a payroll check number. |
| CITIZEN_CODE | CITIZENSHIP CODE | VARCHAR2(1) | The code indicating an individuals citizenship status with respect to the United States. |
| DCP_PLAN_CODE | DCP PLAN CODE | VARCHAR2(1) | The code indicating the defined contribution plan fund option selected by the employee. |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (primary key) |
| EMP_CBUC | COLLECTIVE BARGAINING UNIT | VARCHAR2(2) | The code indicating the collective bargaining unit of an individual. (translation in CTLBUT table) |
| EMP_DIST_UNIT_CODE | DISTRIBUTION UNIT CODE | VARCHAR2(1) | The code indicating the distribution unit code of the predominant distribution of the predominant appointment of an individual for collective bargaining purposes. (values are BLANK=no predominant distribution unit code, ?=indeterminate, or *=to be determined) |
| EMP_NAME | EMPLOYEE NAME | VARCHAR2(26) | The name of the employee. Format is last,first m. |
| EMP_REL_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | The code indicating whether the predominant appointment of an individual is eligible to be represented, for collective bargaining purposes (values are C=covered, S=supervisor-uncovered, U=uncovered, ?=interminate, or *=to be determined) |
| EMP_REL_UNIT | EMPLOYMENT RELATIONS UNIT | VARCHAR2(2) | The code indicating the employee relation unit of an individual. (translation in CTLBUT table) |
| EMP_REP_CODE | EMPLOYEE REPRESENTATION CODE | VARCHAR2(1) | The code indicating whether the predominant appointment of an individual is eligible to be represented, for collective bargaining purposes. (values are C=covered, S=supervisor-uncovered, U=uncovered, ?=indeterminate, or *=to be determined) |
| EMP_SPCL_HAND | SPECIAL HANDLING CODE | VARCHAR2(1) | The code indicating the title special handling code of the predominant appointment of an individual for collective bargaining purposes. (values are BLANK=no predominant title special handling code, ?=indeterminate or *=to be determined) |
| EMP_STATUS | EMPLOYMENT STATUS | VARCHAR2(1) | The code indicating the individuals university employment status. values are A=active, I=inactive, N=leave without pay, P=leave with pay, S=separated) |
| ENTRY_DEDUCTIONS | DEDUCTIONS ENTRY | NUMBER(5) | The number of entries in the deductions portion (PARDBL) of the payroll audit record. |
| ENTRY_DOLLARS_ADJ | DOLLAR ADJUSTMENT ENTRY | NUMBER(5) | The number of entries in the dollar adjustments portion (PARDAT) of the payroll audit record. |
| ENTRY_EARNINGS | EARNINGS ENTRY | NUMBER(5) | The number of entries in the earnings portion (PARERN) of the payroll audit record. |
| ENTRY_HRS_ADJ | HOURS ADJUSTMENT ENTRY | NUMBER(5) | The number of entries in the hours adjustments portion (PARHAT) of the payroll audit record. |
| ET_AUTO_SRCE | ELECTRONIC TRANSFER SOURCE | VARCHAR2(1) | Under research. |
| ET_KEY_MO_PG_LN | PAGE/LINE KEY NUMBER | NUMBER(11) | Under Research. |
| EXEC_BEN_ELIG | EXECUTIVE BENEFITS FLAG | VARCHAR2(1) | The code indicating how a special benefits contribution is to be applied. |
| EXEC_BEN_GROSS | EXECUTIVE BENEFIT GROSS | NUMBER(9,2) | The total of all earnings distribution amounts which were eligible for executive benefits, as indicated by the Earnings Distribution Executive Eligibility Indicator. |
| FEDTAX_EXEMPT | FED TAX EXEMPTIONS | NUMBER(5) | The number of withholding allowance claimed by an individual. (values are 000-150=no if allowance, 998=no liability, or 999=income is not subject to federal tax) If not entered, default is 001. |
| FEDTAX_MARITAL | FED TAX MARITAL STATUS | VARCHAR2(1) | The code indicating an individuals marital status for federal income tax withholding calculations. (values are S=single, M=married) |
| FICA_AT_MAX_IND | FICA AT MAX INDICATOR | VARCHAR2(1) | The code indicating whether an individuals OASDI gross YTD-employee was at maximum when the payroll audit record was created. (values are Y or BLANK) |
| FICA_ELIG_CODE | FICA ELIGIBLE CODE | VARCHAR2(1) | The code indicating whether the individual was eligible for OASDI and/or Medicare deductions. (values are E=eligible for OASDI and Medicare deductions, M=eligible for Medicare deductions only, N=not eligible for either OASDI or Medical deductions) |
| FICA_ELIG_GROSS | FICA ELIGIBLE GROSS | NUMBER(9,2) | The total of all eligible FICA gross earnings distribution amounts. |
| FICA_GROSS | FICA GROSS | NUMBER(9,2) | The total of all eligible FICA gross earnings distribution amount. |
| FWT_GROSS | FEDERAL WITHHOLDING TAX GROSS | NUMBER(9,2) | The total of all earnings distribution amounts which were subject to federal taxation and/or reporting. |
| GROSS_IND_OVERRIDE | GROSS OVERRIDE INDICATOR | VARCHAR2(1) | The code indicating whether all of the following gross amounts were calculated from individual earnings distribution records or were input for a cancellation, overpayment, or handdrawn check transaction to override the following calculated grosses. Total Gross, Federal Withholding Tax Gross, State Withholding Tax Gross, FICA Gross-Employee, and Retirement Gross. (values are Y=yes - override calculated grosses with input grosses, N=no - normal, use calculated grosses or BLANK) |
| GROSS_IND_QTD | QUARTER-TO-DATE GROSS INDICATOR | VARCHAR2(1) | The code indicating which quarters balances are affected by the items recorded on the PAR. (values are 0=prior year, 1=current year-1st quarter, 2=current year-2nd quarter, 3=current year-3rd quarter, 4=current year-4th quarter, or BLANK=current quarter) |
| GROSS_IND_YTD | YEAR-TO-DATE GROSS INDICATOR | VARCHAR2(1) | The code indicating whether year-to-date balances are affected by the gross amounts. (values are Y or N) |
| GTN_PROCESS_IND | GROSS-TO-NET PROCESS INDICATOR | VARCHAR2(1) | The code indicating whether or not a payroll audit record required gross-to-net processing. |
| HOME_DEPT | HOME DEPARTMENT CODE | VARCHAR2(6) | The code indicating the administrative department responsible for coordinating the employees employment and/or pay disposition. (translation in CTLHME table) |
| INS_REDUCT_IND | INSURANCE REDUCTION INDICATOR | VARCHAR2(1) | The code indicating the insurance tax savings plan option selected by the individual. |
| LAST_ACTION_DATE | LAST ACTION DATE | DATE | The effective date of the most recent, highest priority, personnel action. |
| LAST_PAY_DATE | LAST PAY DATE | DATE | The date of the last payroll compute activity for the individual. |
| LIABILITY_FAU | LIABILITY FULL ACCOUNTING UNIT | VARCHAR2(30) | The liability full accounting unit of the associated Rush check earnings. |
| LOCATION_ID | LOCATION ID | VARCHAR2(2) | The code indicating the campus or Office of the President location with which a distribution expenditure account is associated. |
| MEDICR_GROSS | MEDICARE GROSS AMOUNT | NUMBER(9,2) | The total of all earnings distribution amounts that were used to determine employee contributions to Medicare. |
| NAMESUFFIX | EMPLOYEE NAME SUFFIX | VARCHAR2(4) | The suffix appended to an employees name. |
| NET_PAY_AMT | NET PAY AMOUNT | NUMBER(9,2) | Either the net amount of a current activity PAR record, or the net amount of a cancellation or handdrawn check PAR record, or the net amount of an overpayment PAR record. |
| OASDI_GROSS | OASDI GROSS AMOUNT | NUMBER(9,2) | The total of all earnings distribution amounts that were used to determine employee contributions to OASDI. |
| PAR_ACAD_PROG_UNIT | ACADEMIC PROGRAMMATIC UNIT CODE | VARCHAR2(6) | The code indicating the unit to which a health science faculty member has been assigned for purposes of determining the approved health sciences salary rate. |
| PAR_UI_ELIG_CODE | UNEMPLOYMENT INSURANCE COVERAGE CODE | VARCHAR2(1) | The code indicating whether the individual is covered by unemployment insurance. |
| PAY_CYCLE_CODE | PAY CYCLE CODE | VARCHAR2(2) | The code indicating the pay cycle for which the payroll audit record was generated. (values are BW=bi-weekly, SM=semi-monthly, MO=monthly current, or MA=monthly arrears) (primary key) |
| PAY_CYCLE_END_DATE | PAY CYCLE END DATE | DATE | The last date in the pay cycle for which the payroll audit record was generated. (primary key) |
| PAY_VENDOR_IND | VENDOR INDICATOR | VARCHAR2(1) | Under research. |
| PRIORITY_GROSS | PRIORITY GROSS AMOUNT | NUMBER(9,2) | The sum of all earnings distribution gross amounts (from cancellation, overpayment, and handdrawn check transactions) with the highest priority, as determined by the Description of Service (DOS) Table attribute. This amount is only present for activity for the pay months prior to the current pay month as defined by the record generation pay cycle date. |
| PRIORITY_GRS_CODE | PRIORITY GROSS CODE | NUMBER(5) | The highest earnings distribution priority gross number which is the priority number associated with the Distribution Priority Gross. (values are 1=highest, 4=lowest) |
| PRIORITY_GRS_DATE | PRIORITY GROSS DATE | DATE | The date of earnings associated with the distribution priority gross. |
| PRIOR_EMP_ID | PRIOR EMPLOYEE ID NUMBER | VARCHAR2(9) | The previous identification number - employee for an individual. |
| PRI_GROSS_CTL | PAYROLL AUDIT RECORD GENERATION NUMBER | VARCHAR2(3) | The number identifying the payroll audit record generation produced for the individual. |
| PRI_PAY_SCHED | PRIMARY PAY SCHEDULE CODE | VARCHAR2(2) | The code indicating the employees primary pay schedule at the time of pay computation. (BW=bi-weekly, MO=monthly current, MA=monthly arrears, SM=semi-monthly) |
| RECORD_TYPE | PAR RECORD TYPE | VARCHAR2(2) | The code indicating the process that generated the PAR record. (values are 65=expense transfers, 70=cancellations, 75=overpayments, 80=hand-drawn checks, 82=rush hand-drawn checks, 85=current activity) |
| RET_GROSS | RETIREMENT GROSS | NUMBER(9,2) | The total of all earnings distribution which were subject to employee contributions under one the Universitys retirement plans. |
| RET_GRS_OVER_FICA | RETIREMENT GROSS OVER FICA | NUMBER(7,2) | The amount of the UCRS eligible gross earnings over the OASDI maximum. |
| RET_PLAN_CODE | RETIREMENT PLAN CODE | VARCHAR2(1) | The code indicating the retirement plan to which the individual belongs. |
| RET_RATE | RETIREMENT RATE | NUMBER(5,2) | The percentage rate that was used to calculate an employees retirement contribution. |
| SOC_SEC_NO | SOCIAL SECURITY NUMBER | VARCHAR2(9) | The number assigned to an individual by the Social Security Administration. |
| SPCL_BEN_CODE | SPECIAL BENEFITS CODE | VARCHAR2(1) | The code indicating whether the individual was eligible for special benefits plans under this distribution. (values are 0=not eligible for special contribution, 2=safety title eligibility) |
| STATE_TAX_ITMDED | STATE TAX ITEM DEDUCTION | NUMBER(5) | The number of withholding allowance for itemized deductions claimed by an individual. |
| STATE_TAX_MARITAL | STATE TAX MARITAL STATUS | VARCHAR2(1) | The code indicating an individuals marital status for California state income tax withholding calculations. (values are S=single, M=married, or H=head of household) |
| STATE_TAX_PERDED | STATE TAX PERSONAL DEDUCTION | NUMBER(5) | The number of personal withholding allowances claimed by an individual. (values are 000-150=no of allowance, 997=non-resident, income not subject to California taxes) If not entered, default is 001. |
| STOP_UNCLAIM_IND | STOP PAYMENT/UNCLAIMED FLAG | VARCHAR2(1) | The code indicating whether a payroll audit record was used to stop payment processing or unclaimed check processing. (values are S=stop payment, U=unclaimed check, or BLANK) |
| STUDENT_STATUS | STUDENT STATUS CODE | VARCHAR2(1) | The code indicating whether the employee is a UC student. |
| SWT_GROSS | STATE WITHHOLDING TAX GROSS | NUMBER(9,2) | The total of all earnings distribution which were subject to State of California taxation and reporting. |
| TOTAL_GROSS | TOTAL GROSS | NUMBER(9,2) | The total of all earnings distribution amounts or an amount entered to override the calculated amount. |
| TOTAL_HRS_NONWORK | TOTAL NON-WORKED HOURS | NUMBER(5,2) | The total of all earnings distribution hours for which the Type of Hours attributes on the Description of Service (DOS) Table is N (non-worked hours) and the Pay Category Code is not A or D (additional pay or pay differential). |
| TOTAL_HRS_OT | TOTAL OVERTIME HOURS | NUMBER(5,2) | The total of all earnings distribution hours for which the Type of Hours attribute on the Description of Service (DOS) Table is O (overtime). |
| TOTAL_HRS_REG | TOTAL REGULAR HOURS | NUMBER(5,2) | The total of all earnings distribution hours for which the Type of Hours attribute on the Description of Services (DOS) Table is R (regular) and for which the Pay Category Code is not L (leave). |
| UI_GROSS | UNEMPLOYMENT INSURANCE GROSS | NUMBER(9,2) | The total of all earnings distribution amounts which were subject to Unemployment Insurance premium assessment and reporting. |
| UNCLAIM_SOURCE_ID | UNCLAIMED CHECK FUND SOURCE CODE | VARCHAR2(1) | The code indicating the source of the funds associated with an unclaimed check. (values are F=federal funds, U=university funds) |
| WC_GROSS | WORKERS COMPENSATION GROSS | NUMBER(9,2) | The total of all earnings distribution amounts which were subject to Workers Compensation premium assessment. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: January 12, 1999