One record exists for each employee containing the to-date totals (calendar
year-to-date and quarter-to-date) and pay indicators. The data originates from the
Employee Data Base (EDB).
NOTE: The HOLD_PAYSTAT_## fields are set for the calendar month with HOLD_PAYSTAT_01
containing the hours pay status for the month of January. The previous year's totals are
not blanked out for the new calendar year. So, if the current month is January 2000 then
the following months (i.e. HOLD_PAYSTAT_02 -February) are actually the totals from the
prior year (i.e. February 1999.)
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| C_YTD_ADDL_COMP_SM | ADDITIONAL COMPENSATION - SUMMER YTD | NUMBER(9,2) | The accumulated gross balance for compensation paid to eligible faculty members in a calendar year having the Description of Service Code values for summer compensation. |
| C_YTD_REG_PAY | REGULAR PAY-CALENDAR - YTD | NUMBER(9,2) | The total wages earned by an employee within the calendar year for regular pay (i.e., having DOS Time Benefits Indicator value of 'Y'). |
| CHK_DISP_CODE | PAY DISPOSIITON 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 pint, 2=hold for departmental pick-up, 3=hold for individually through campus or hospital address, 4=hold for bulk mail to bank, 5=hold for U.S. mail or local address, 6=hold for U.S. mail to distant address, 7=hold for U.S. mail to foreign address, 8=hold for surpay direct deposit) |
| DCP_RATE_CURRMO | DCP RATE - CURRENT MONTH | NUMBER(9,2) | The percentage rate that was used to calculated the Defined Contribution Plan (DCP) portion of an employees retirement contribution in the current month. |
| DCP_RATE_PRIOR1 | DCP RATE - ONE MONTH OLD | NUMBER(9,2) | The percentage rate that was used to calculated the Defined Contribution Plan (DCP) portion of an employees retirement contribution from one month ago. |
| DCP_RATE_PRIOR2 | DCP RATE - TWO MONTH OLD | NUMBER(9,2) | The percentage rate that was used to calculated the Defined Contribution Plan (DCP) portion of an employees retirement contribution from two months ago. |
| DCP_RATE_PRIOR3 | DCP RATE - THREE MONTH OLD | NUMBER(9,2) | The percentage rate that was used to calculated the Defined Contribution Plan (DCP) portion of an employees retirement contribution from three months ago. |
| DCP_RATE_PRIOR4 | DCP RATE - FOUR MONTH OLD | NUMBER(9,2) | The percentage rate that was used to calculated the Defined Contribution Plan (DCP) portion of an employees retirement contribution from four months ago. |
| DEN_CON_ACT_MONTH | MONTH OF LAST DENTAL CONTRIBUTION/DEDUCTION | NUMBER(2,0) | Code indicating the payroll processing month in which a Dental benefit contribution/deduction was taken on a payroll activity record. It is used to trigger a full contribution on the first pay period of the month for which the employee has activity. |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (key) |
| ETD_TT_GROSS | TAX TREATY GROSS YTD - EMPLOYEE | NUMBER(9,2) | The total of all gross earning paid to an employee during the calendar year that have been claimed as exempt from federal tax under the provisions of a tax treaty. |
| F_YTD_ADDL_COMP | ADDITIONAL COMPENSAITON - UNEX FYTD | NUMBER(9,2) | The accumulated gross balance of all money paid to an employee within the fiscal year having the Description of Service Code values for University Extension payments. |
| FCP_TST_TAX_GRS | NUMBER(9,2) | UNDER RESEARCH | |
| FCP_TST_TOT_GRS | NUMBER(9,2) | UNDER RESEARCH | |
| FYTD_FWT_GROSS | FEDERAL WITHHOLDING TAX GROSS - FYTD | NUMBER(9,2) | The accumulated gross earnings paid during the fiscal year that are subject to federal taxation or reporting. |
| FYTD_RET_GROSS | RETIREMENT GROSS - FISCAL YTD | NUMBER(9,2) | The total gross earning paid during the current fiscal year that are considered covered compensation for retirement purposes. |
| HOLD_PAYSTAT_01 | HOLD HOURS ON PAY STATUS - JANUARY | NUMBER(9,2) | The number of hours reported on pay status for the month of January as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_02 | HOLD HOURS ON PAY STATUS - FEBRUARY | NUMBER(9,2) | The number of hours reported on pay status for the month of February as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_03 | HOLD HOURS ON PAY STATUS - MARCH | NUMBER(9,2) | The number of hours reported on pay status for the month of March as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_04 | HOLD HOURS ON PAY STATUS - APRIL | NUMBER(9,2) | The number of hours reported on pay status for the month of April as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_05 | HOLD HOURS ON PAY STATUS - MAY | NUMBER(9,2) | The number of hours reported on pay status for the month of May as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_06 | HOLD HOURS ON PAY STATUS - JUNE | NUMBER(9,2) | The number of hours reported on pay status for the month of June as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_07 | HOLD HOURS ON PAY STATUS - JULY | NUMBER(9,2) | The number of hours reported on pay status for the month of July as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_08 | HOLD HOURS ON PAY STATUS - AUGUST | NUMBER(9,2) | The number of hours reported on pay status for the month of August as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_09 | HOLD HOURS ON PAY STATUS - SEPTEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of September as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_10 | HOLD HOURS ON PAY STATUS - OCTOBER | NUMBER(9,2) | The number of hours reported on pay status for the month of October as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_11 | HOLD HOURS ON PAY STATUS - NOVEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of November as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HOLD_PAYSTAT_12 | HOLD HOURS ON PAY STATUS - DECEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of December as of the end of the last monthly processing cycle. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc. are excluded. |
| HRS_BEN_ELIG_TOT | HOURS TOWARD BENEFITS ELIGIBILITY - TOTAL | NUMBER(9,2) | The number of hours that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_CUR | HOURS TOWARD BENEFITS ELIGIBILITY - CURRENT MONTH | NUMBER(9,2) | The number of hours reported in the current month that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_01 | HOURS TOWARD BENEFITS ELIGIBILITY - JANUARY | NUMBER(9,2) | The number of hours reported in January that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_02 | HOURS TOWARD BENEFITS ELIGIBILITY - FEBRUARY | NUMBER(9,2) | The number of hours reported in February that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_03 | HOURS TOWARD BENEFITS ELIGIBILITY - MARCH | NUMBER(9,2) | The number of hours reported in March that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_04 | HOURS TOWARD BENEFITS ELIGIBILITY - APRIL | NUMBER(9,2) | The number of hours reported in April that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_05 | HOURS TOWARD BENEFITS ELIGIBILITY - MAY | NUMBER(9,2) | The number of hours reported in May that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_06 | HOURS TOWARD BENEFITS ELIGIBILITY - JUNE | NUMBER(9,2) | The number of hours reported in June that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_07 | HOURS TOWARD BENEFITS ELIGIBILITY - JULY | NUMBER(9,2) | The number of hours reported in July that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_08 | HOURS TOWARD BENEFITS ELIGIBILITY - AUGUST | NUMBER(9,2) | The number of hours reported in August that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_09 | HOURS TOWARD BENEFITS ELIGIBILITY - SEPTEMBER | NUMBER(9,2) | The number of hours reported in September that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_10 | HOURS TOWARD BENEFITS ELIGIBILITY - OCTOBER | NUMBER(9,2) | The number of hours reported in OCTOBER that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_11 | HOURS TOWARD BENEFITS ELIGIBILITY - NOVEMBER | NUMBER(9,2) | The number of hours reported in November that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_BEN_ELIG_12 | HOURS TOWARD BENEFITS ELIGIBILITY - DECEMBER | NUMBER(9,2) | The number of hours reported in December that qualify toward eligibility for retirement and benefits. This excludes overtime,differrntial, hours worked as casual restricted, per diem, etc. |
| HRS_CAR_ELIG_TOT | HOURS TOWARD CAREER STATUS ELIGIBILITY - TOTAL | NUMBER(9,2) | The number of hours that qualify toward eligibility for career status as of the beginning of the current process month. |
| HRS_CAR_ELIG_CUR | HOURS TOWARD CAREER STATUS ELIGIBILITY - CURRENT MONTH | NUMBER(9,2) | The total number of hours reported in the current month that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_01 | HOURS TOWARD CAREER STATUS ELIGIBILITY - JANUARY | NUMBER(9,2) | The number of hours reported in January that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_02 | HOURS TOWARD CAREER STATUS ELIGIBILITY - FEBRUARY | NUMBER(9,2) | The number of hours reported in February that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_03 | HOURS TOWARD CAREER STATUS ELIGIBILITY - MARCH | NUMBER(9,2) | The number of hours reported in March that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_04 | HOURS TOWARD CAREER STATUS ELIGIBILITY - APRIL | NUMBER(9,2) | The number of hours reported in April that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_05 | HOURS TOWARD CAREER STATUS ELIGIBILITY - MAY | NUMBER(9,2) | The number of hours reported in May that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_06 | HOURS TOWARD CAREER STATUS ELIGIBILITY - JUNE | NUMBER(9,2) | The number of hours reported in June that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_07 | HOURS TOWARD CAREER STATUS ELIGIBILITY - JULY | NUMBER(9,2) | The number of hours reported in July that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_08 | HOURS TOWARD CAREER STATUS ELIGIBILITY - AUGUST | NUMBER(9,2) | The number of hours reported in August that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_09 | HOURS TOWARD CAREER STATUS ELIGIBILITY - SEPTEMBER | NUMBER(9,2) | The number of hours reported in September that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_10 | HOURS TOWARD CAREER STATUS ELIGIBILITY - OCTOBER | NUMBER(9,2) | The number of hours reported in October that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_11 | HOURS TOWARD CAREER STATUS ELIGIBILITY - NOVEMBER | NUMBER(9,2) | The number of hours reported in November that qualify toward eligibility for career status. |
| HRS_CAR_ELIG_12 | HOURS TOWARD CAREER STATUS ELIGIBILITY - DECEMBER | NUMBER(9,2) | The number of hours reported in December that qualify toward eligibility for career status. |
| LAST_GTN_ACT | MONTH OF LAST GTN ROUTINE 15 | NUMBER(9,2) | The code indicating the payroll processing month in which Special Calculation Routine Number 15 was last involved for a payroll activity record. |
| LAST_PAY_DATE | LAST PAY DATE | DATE | The date of the last payroll compute activity for the individual. |
| LEG_CON_ACT_MONTH | MONTH OF LAST LEGAL ONTRIBUTION/DEDUCTION | NUMBER(2,0) | Code indicating the payrollprocessing month in which a Legal benefit contribution/deduction was taken on a payroll activity record. It is used to grigger a full contribution on the first pay period of the month for which the employee has activity. |
| MED_CON_ACT_MONHT | MONTH OF LAST MEDICAL CONTRIBUTION/DEDUCTION | NUMBER(2,0) | Code indicating the payroll processing month in which a Medical benefit contribution/deduction was taken on a payroll activity record. It is used to trigger a full contribution on the first pay period of the month for which the employee has activity |
| MIN_RCD_FLAG | MINIMUM RECORD FLAG | VARCHAR2(1) | The code indicating whether there is sufficient information to establish an employees pay record. The minimum data fields required are Name-Employee, Date of Birth, Citizenship Status Code, Social Security Number, DAte of Employment, UC Student Status Code, FICA Eligibility Code, and Address-Permanent(Line One, City, State, Zip). Fields must contain non-blank or non-zero data. (values are 1=no, minimum data requirement has not been met; 0=yes, minimum data requirement has been met or exceeded) |
| PARK_RED_TAKEN | PARKING REDUCTION TAKEN | NUMBER(5,2) | The amount of reduction taken in the current pay month against the allowed parking reduction limit. |
| PAYSTAT_CURR_MO | HOURS ON PAY STATUS - CURRENT MONTH | NUMBER(9,2) | The number of hours reported on pay status for the current month. This excludes overtime, differential etc. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. |
| PAYSTAT_JAN | HOURS ON PAY STATUS - JANUARY | NUMBER(9,2) | The number of hours reported on pay status for the month of January. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_FEB | HOURS ON PAY STATUS - FEBRUARY | NUMBER(9,2) | The number of hours reported on pay status for the month of February. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_MAR | HOURS ON PAY STATUS - MARCH | NUMBER(9,2) | The number of hours reported on pay status for the month of March. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_APR | HOURS ON PAY STATUS - APRIL | NUMBER(9,2) | The number of hours reported on pay status for the month of April. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_MAY | HOURS ON PAY STATUS - MAY | NUMBER(9,2) | The number of hours reported on pay status for the month of May. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_JUN | HOURS ON PAY STATUS - JUNE | NUMBER(9,2) | The number of hours reported on pay status for the month of June. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_JUL | HOURS ON PAY STATUS - JULY | NUMBER(9,2) | The number of hours reported on pay status for the month of July. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_AUG | HOURS ON PAY STATUS - AUGUST | NUMBER(9,2) | The number of hours reported on pay status for the month of August. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_SEP | HOURS ON PAY STATUS - SEPTEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of September. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_OCT | HOURS ON PAY STATUS - OCTOBER | NUMBER(9,2) | The number of hours reported on pay status for the month of October. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_NOV | HOURS ON PAY STATUS - NOVEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of November. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| PAYSTAT_DEC | HOURS ON PAY STATUS - DECEMBER | NUMBER(9,2) | The number of hours reported on pay status for the month of December. Hours includes all hours defined by the Description of Service table as counting towards hours on pay status. Overtime, differential, etc., are excluded. |
| 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 (values are BW-biweekly, MO=monthly current, MA=monthly arrears, SM=semi-monthly) |
| QTD_CETA_GROSS | CETA GROSS - QTD | NUMBER(9,2) | UNDER RESEARCH |
| QTD_FICA_GROSS | FICA GROSS - QTD | NUMBER(9,2) | UNDER RESEARCH |
| QTD_FWT_GROSS | FEDERAL WITHHOLDING TAX GROSS - QTD | NUMBER(9,2) | The total gross earnings paid during the current calendar quarter which are subject to federal taxation or reporting. |
| QTD_MED_GROSS | MEDICARE GROSS - QTD | NUMBER(9,2) | The total gross earnings paid during the current calendar quarter which are subject to employee and employer. |
| QTD_SWT_GROSS | STATE WITHHOLDING TAX GROSS - QTD | NUMBER(9,2) | The total gross earnings paid during the calendar quarter which are subject to State of California taxation and reporting. |
| QTD_UI_GROSS | UNEMPLOYMENT INSURANCE GROSS - QTD | NUMBER(9,2) | The total gross earnings paid during the current calendar quarter which are subject to Unemployment Insurance benefit contributions. |
| RED_GROSS_CURRMO | REDUCTION AMOUNT-CURRENT MONTH | NUMBER(9,2) | The portion of the current month pay period retirement gross which was exempted from employee retirement contributions by the retirement rebate |
| RED_GROSS_PRIOR1 | REDUCTION AMOUNT-ONE MONTH | NUMBER(9,2) | The portion of the retirement gross ending one month ago which was exempted from employee retirement contributions by the retirement rebate |
| RED_GROSS_PRIOR2 | REDUCTION AMOUNT-TWO MONTH | NUMBER(9,2) | The portion of the retirement gross ending two months ago which was exempted from employee retirement contributions by the retirement rebate |
| RED_GROSS_PRIOR3 | REDUCTION AMOUNT-THREE MONTH | NUMBER(9,2) | The portion of the retirement gross ending three months ago which was exempted from employee retirement contributions by the retirement rebate. |
| RED_GROSS_PRIOR4 | REDUCTION AMOUNT-FOUR MONTH | NUMBER(9,2) | The portion of the retirement gross ending four months ago which was exempted from employee retirement contributions by the retirement rebate. |
| RET_GROSS_CURRMO | RETIREMENT GROSS RATE-CURRENT MONTH | NUMBER(9,2) | The total gross earnings for the current pay period which are subject to employee retirement contributions under one of the University's retirement plans. |
| RET_GROSS_PRIOR1 | RETIREMENT GROSS RATE-ONE MONTH OLD | NUMBER(9,2) | The total gross earnings for the pay period ending one month ago which were subject to employee retirement contributions under one of the University's retirement plans. |
| RET_GROSS_PRIOR2 | RETIREMENT GROSS RATE-TWO MONTH OLD | NUMBER(9,2) | The total gross earnings for the pay period ending two months ago which were subject to employee retirement contributions under one of the University's retirement plans. |
| RET_GROSS_PRIOR3 | RETIREMENT GROSS RATE-THREE MONTH OLD | NUMBER(9,2) | The total gross earnings for the pay period ending three months ago which were subject to employee retirement contributions under one of the University's retirement plans. |
| RET_GROSS_PRIOR4 | RETIREMENT GROSS RATE-FOUR MONTH OLD | NUMBER(9,2) | The total gross earnings for the pay period ending four months ago which were subject to employee retirement contributions under one of the University's retirement plans. |
| RET_RATE_CURRMO | RETIREMENT GROSS-CURRENT MONTH | NUMBER(9,2) | The rate used to calculate the employee's retirement contributions for the current month. The rate is expressed as a percentage, but without the percent sign (i.e. 3.5 = 3.5%, 10 = 10%). |
| RET_RATE_PRIOR1 | RETIREMENT GORSS-ONE MONTH OLD | NUMBER(9,2) | The rate used to calculate the employee's retirement contributions from one month ago. The rate is expressed as a percentage, but without the percent sign (i.e. 3.5 = 3.5%, 10 = 10%). |
| RET_RATE_PRIOR2 | RETIREMENT GORSS-TWO MONTH OLD | NUMBER(9,2) | The rate used to calculate the employee's retirement contributions from two months ago. The rate is expressed as a percentage, but without the percent sign (i.e. 3.5 = 3.5%, 10 = 10%). |
| RET_RATE_PRIOR3 | RETIREMENT GORSS-THREE MONTH OLD | NUMBER(9,2) | The rate used to calculate the employee's retirement contributions from three months ago. The rate is expressed as a percentage, but without the percent sign (i.e. 3.5 = 3.5%, 10 = 10%). |
| RET_RATE_PRIOR4 | RETIREMENT GORSS-FOUR MONTH OLD | NUMBER(9,2) | The rate used to calculate the employee's retirement contributions from four months ago. The rate is expressed as a percentage, but without the percent sign (i.e. 3.5 = 3.5%, 10 = 10%). |
| TRAN_RED_TAKEN | TRANSIT REDUCTION TAKEN | NUMBER(5,2) | The amount of reduction taken in the current pay month against the allowed transit reduction limit. |
| VIS_CON_ACT_MONTH | MONTH OF LAST VISION CONTRIBUTION/DEDUCTION | NUMBER(2,0) | Code indicating the payroll processing month in which a Vision benefit contribution/deduction was taken on a payroll activity record. It is used to trigger a full contriubtion on the first pay period of the month for which the employee has activity. |
| YTD_ALT_TT_GROSS | TAX TREATY GROSS YTD - ALTERNATE | NUMBER(9,2) | Thetotal gross earning paid during the calendar year on a second type of income claimed as exampt from federal tax under the provisions of a tax treaty. |
| YTD_CETA_GROSS | CETA GROSS - YTD | NUMBER(9,2) | UNDER RESEARCH |
| YTD_DPI_GROSS | YTD DOMESTIC PARTNER IMPUTED INCOME | NUMBER(9,2) | The YTD gross amount to imputed income resulting from coverage of domestic partners, and their children and/or grandchildren. |
| YTD_ESL_GROSS | EXTENDED SICK LEAVE GROSS YTD | NUMBER(9,2) | The total amount paid to an employee within the calendar year for gross extended sick leave. |
| YTD_EXCL_MOVE_EXP | EXCLUDABLE MOVING EXPENSE REIMBURSEMENTS | NUMBER(9,2) | The accumulated amount of excludable moving expense reimbursements made to an employee during the calendar year. |
| YTD_FICA_GROSS | FICA GROSS YTD | NUMBER(9,2) | The total gross earning paid during the calendar year which are subject to employee and employer Old Age and Survivors Disability Insurance (OASDI) contribution. |
| YTD_FWT_GROSS | FEDERAL WITHHOLDING TAX GROSS - YTD | number(9,2) | The total gross earning paid during the calendar year which are not subject to federal taxation and reporting. |
| YTD_MED_GROSS | MEDICARE GROSS - YTD | NUMBER(9,2) | The total gross earning paid during the calendar year which are not subject to employee and employer Medicare contribution. |
| YTD_NDIP_GROSS | INTEREST GROSS - YTD | NUMBER(9,2) | The total gross interest paid during the calendar year. |
| YTD_NONTAX_GROSS | FEDERAL NON-TAXABLE GROSS - YTD | NUMBER(9,2) | The total gross earning paid during the calendar year wich are not subject to federal withholding tax and reporting. |
| YTD_OSWT_GROSS_1 | OTHER STATE WITHHOLDING TAX STATE CODE 1 | NUMBER(9,2) | The total gross earnings paid during the calendar year that are subject to state taxation and reporting in the state identified by Other State Withholding Tax State Code 1. |
| YTD_OSWT_GROSS_2 | OTHER STATE WITHHOLDING TAX STATE CODE 2 | NUMBER(9,2) | The total gross earnings paid during the calendar year that are subject to state taxation and reporting in the state identified by Other State Withholding Tax State Code 2. |
| YTD_OSWT_GROSS_3 | OTHER STATE WITHHOLDING TAX STATE CODE 3 | NUMBER(9,2) | The total gross earnings paid during the calendar year that are subject to state taxation and reporting in the state identified by Other State Withholding Tax State Code 3. |
| YTD_OSWT_NAME_1 | OTHER STATE WITHHOLDING TAX STATE CODE 1 | VARCHAR2(2) | The code indicating the state other than California associated with Other State Withholding Tax Gross YTD 1. |
| YTD_OSWT_NAME_2 | OTHER STATE WITHHOLDING TAX STATE CODE 1 | VARCHAR2(2) | The code indicating the state other than California associated with Other State Withholding Tax Gross YTD 2. |
| YTD_OSWT_NAME_3 | OTHER STATE WITHHOLDING TAX STATE CODE 1 | VARCHAR2(2) | The code indicating the state other than California associated with Other State Withholding Tax Gross YTD 3. |
| YTD_OTHER_INCOME | OTHER INCOME | NUMBER(9,2) | Any non-wage income, paid through the Accounts Payable System or through the University's disability insurance carrier, which is reportable for tax purposes. |
| YTD_RET_GROSS | RETIREMENT GROSS - YTD | NUMBER(9,2) | The total gross earnings for the current year which are subject to employee retirement contribution under one of the University's retirement plans. |
| YTD_SFHBR_GROSS | SAFE HARBOR GROSS - YTD | NUMBER(9,2) | The total gross earnings paid during the current calendar year that are eligible for Safe Harbor employee contribution. |
| YTD_SWT_GROSS | STATE WITHHOLDING TAX GROSS - YTD | NUMBER(9,2) | The total gross earnings paid during the calendar year which are subject to State of California taxation and reporting. |
| YTD_TAX_FRINGE | NON-CASH FRINGE BENEFITS - YTD | NUMBER(9,2) | The sum of the non-cash fringe benefits that are reportable under Internal Revenue Service Regulation. |
| YTD_TOTAL_GROSS | TOTAL GROSS - YTD | NUMBER(9,2) | The total gross earning paid during the calendar year. |
| YTD_TT_GROSS | TAX TREATY GROSS YTD | NUMBER(9,2) | The total gross earning paid during the calendar year on one type of income claimed as exempt from federal tax under the provisions of a tax treaty. |
| YTD_UI_GROSS | UNEMPLOYMENT INSURANCE GROSS - YTD | NUMBER(9,2) | The total gross earnings paid during the current calendar year which are subject to Unemployment Insurance benefit contributions. |
| YTD_WCR_REFUND | WORKERS' COMPENSATION REFUND - YTD | NUMBER(9,2) | The total workers' compensation refund for the employee during the calendar year. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: July 26, 2001