The benefit information for each employee includes dental, life insurance, medical,
vision, legal, accidental death and dismemberment, and employee paid disability. The
coverage level, effective date and waiting period. information for each benefit program
are included. The data originates from the Employee Data Base (EDB) and. one record exists
per employee regardless of their benefit coverage.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ADD_COVEFFDATE | ACCIDENTAL DEATH/DISMEMBERMENT COVERAGE EFFECTIVE DATE | DATE | The effective date of coverage of accidental death and dismemberment (AD and D) insurance. |
| ADD_COVERAGE | ACCIDENTAL DEATH/DISMEMBERMENT COVERAGE FLAG | VARCHAR2(1) | The code indicating the type of accidental death and dismemberment (AD and D) coverage selected by the individual. (values are S=self coverage, F=family coverage-employee, spouse, and any eligible dependent children, or M=modified family plan, if both husband and wife are eligible employees of the university, only one may elect to cover their dependent children, at a modified family rate. A single parent may elect to cover his or her dependent children only, at a modified rate.) |
| ADD_DEENROLL | ACCIDENTAL DEATH DISMEMBERMENT DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from accidental death and dismemberment insurance. (values are X=data base maintenance required or BLANK=no action required) |
| ADD_EARNEFFDATE | ACCIDENTAL DEATH DISMEMBERMENT EFFECTIVE DATE | DATE | The effective date of coverage of accidental death and dismemberment (AD and D) insurance. |
| ADD_PRINC_SUM | ACCIDENTAL DEATH DISMEMBERMENT SUM | VARCHAR2(3) | The amount of accidental death and dismemberment (AD and D) insurance coverage selected by the individual. |
| AGE_JAN1 | AGE AS OF JANUARY 1ST | NUMBER(5) | The age of the individual as of January 1 of the current calendar year. |
| CAL_CAS_DED_IND | CALIFORNIA CASUALTY DEDUCTION | VARCHAR2(1) | The code indicating whether an employee record is to be processed for auto/homeowner deduction. (values are N=do not process, BLANK or Y=process) |
| COV_COMP_LIMIT_CD | COVERAGE COMPENSATION LIMIT | VARCHAR2(1) | The code indicating whether an employee is grandfathered under the compensation limit of $235,840 in effect prior to July 1994 or is subject to the new index limit effective on July 1, 1994. (values are G=grandfathered, N=not grandfathered, or BLANK=not subject to limit because of membership in retirement plan other than UCRP) |
| DCP_PLAN_CODE | DEFINE CONTRIBUTION PLAN | VARCHAR2(1) | The code indicating the defined contribution plan fund option selected by the employee. (values are A=multi-asset fund, B=bond fund, E=equity fund, F=fidelity investments fund, G=insurance company contract fund, M=money market fund, or S=savings fund) |
| DENTAL_ALT_CURRMO | DENTAL ALT CURRENT MONTH FLAG | VARCHAR2(1) | Reserved for future use. |
| DENTAL_ALT_HIST | DENTAL ALT MONTH HISTORY | VARCHAR2(1) | Reserved for future use. |
| DENTAL_ALT_MTH1 | DENTAL ALT MONTH 1 FLAG | VARCHAR2(1) | Reserved for future use. |
| DENTAL_ALT_MTH2 | DENTAL ALT MONTH 2 FLAG | VARCHAR2(1) | Reserved for future use. |
| DENTAL_ALT_MTH3 | DENTAL ALT MONTH 3 FLAG | VARCHAR2(1) | Reserved for future use. |
| DENTAL_ALT_MTH4 | DENTAL ALT MONTH 4 FLAG | VARCHAR2(1) | Reserved for future use. |
| DENTAL_COVEFFDATE | DENTAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current dental insurance carrier, becomes effective for the employee. |
| DENTAL_COVERAGE | DENTAL PLAN COVERAGE | VARCHAR2(3) | The code indicating the level of dental plan coverage selected by the individual. (values are U=one party, UU=two party, or UUU=family) |
| DENTAL_DEENROLL | DENTAL COVERAGE DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from dental insurance. (values are X=data base maintenance required, or BLANK=no action required) |
| DENTAL_EFFDATE | DENTAL COVERAGE EFFECTIVE PLAN | DATE | The date on which the associated coverage level, with the current dental. insurance carrier, becomes effective for the employee. |
| DENTAL_OPTOUT | DENTAL COVERAGE OPT OUT FLAG | VARCHAR2(1) | The code indicating the reason why automatic enrollment in the dental insurance program is not to take place. (values are X=opted not to participate, C=cancelled, D=deenrolled, or BLANK=no action to be taken) |
| DENTAL_PLAN | DENTAL PLAN CODE | VARCHAR2(2) | The code indicating the dental plan selected by the individual. (values are D1=Delta dental service or D3=PMI) |
| DEN_PROVIDER_ID | DENTAL COVERAGE PROVIDER ID | VARCHAR2(26) | OBSOLETE |
| DEPLIFE_COVEFFDATE | DEPENDENT LIFE COVERAGE EFFECTIVE DATE | DATE | The effective date of coverage for dependent life insurance. |
| DEP_LIFE_DEENROLL | DEPENDENT LIFE DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to effect the individuals de-enrollment from dependent life insurance coverage. |
| DEP_LIFE_EFFDATE | DEPENDENT LIFE EFFECTIVE DATE | DATE | The effective date of coverage for employee paid life insurance. |
| DEP_LIFE_IND | DEPENDENT LIFE INSURANCE FLAG | VARCHAR2(1) | The code indicating the dependent life insurance plan the individual has selected. (values are Y=basic plan-flat, S=expanded plan-spouse only, B=expanded plan-spouse and children, C=expanded plan-children only, or BLANK=no dependent life insurance plan) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| EMP_DENTL_COVEFFDT | EMPLOYEE DENTAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current dental insurance carrier becomes effective for the employee. |
| EMP_HLTH_COVEFFDT | EMPLOYEE MEDICAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current medical insurance carrier, becomes effective for the employee. |
| EMP_LEGAL_COVEFFDT | EMPLOYEE LEGAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current legal insurance carrier, becomes effective for the employee. |
| EMP_VIS_COVEFFDT | EMPLOYEE VISION COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current optical insurance carrier, becomes effective for the employee. |
| EPD_COVRGE_DATE | EMPLOYEE PAID DISABILITY COVERAGE DATE | DATE | The effective date of coverage for employee paid disability (EPD). |
| EPD_DEENROLL | EMPLOYEE PAID DISABILITY DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment in employee paid disability (EPD) insurance. (values are X=data base maintenance required, or BLANK=no action necessary) |
| EPD_SALARY_BASE | EMPLOYEE PAID DISABILITY SALARY BASE | NUMBER(5) | The full-time pay rate of covered compensation, used in the computation of employee paid disability (EPD) premiums. |
| EPD_WAIT_PERIOD | EMPLOYEE PAID DISABILITY WAITING PERIOD | VARCHAR2(3) | The number of calendar days which must elapse after a disability is incurred before an individual employee paid disability (EPD) insurance benefit can begin. (values are 007=7 day waiting, 030=30 day waiting; or 180=180 day waiting) |
| EXEC_BEN_ELIG | EXECUTIVE BENEFITS ELIGIBILITY | VARCHAR2(1) | The code indicating how a special benefits contribution (EDB 2021) is to be applied (0=Not eligible, 4=Apply total amount of contribution to tax-deferred. saving fund, 5=Apply total amount of contribution to tax-deferred equity fund, 6=Apply total amount of contribution to tax-deferred bond fund, 7=Apply total amount of contribution to tax-deferred guaranteed insurance contract fund, 8=Apply total amount of contribution to tax-deferred money market fund, or 9=Reserve for future) |
| EXEC_LIFECHANGE | EXECUTIVE LIFE CHANGE FLAG | VARCHAR2(1) | The code indicating the change to be made to the individuals executive life insurance indicator. |
| EXEC_LIFECHGDATE | EXECUTIVE LIFE CHANGE DATE | DATE | The date indicating the month and year in which the change associated with the executive life insurance change code becomes effective. |
| EXEC_LIFEFLAG | EXECUTIVE LIFE INSURANCE FLAG | VARCHAR2(1) | The code indicating eligibility, participation, and level of coverage in the executive life insurance program. (values are 0=not eligible, 2=eligible-ex annual salary, participating, or X=eligible, but not participating) |
| EXEC_LIFEINCOME | EXECUTIVE LIFE INCOME AMOUNT | NUMBER(9,2) | The amount of imputed taxable income accrued year-to-date by participation in the executive life insurance program. |
| EXEC_LIFESALARY | EXECUTIVE LIFE INSURANCE SALARY BASE | NUMBER(5) | The salary base for the executive life insurance program, expressed in thousands of dollars. |
| EXEC_LIFE_EFFDATE | EXECUTIVE LIFE INSURANCE EFFECTIVE DATE | DATE | The effective date of coverage for the executive life insurance plan. |
| EXEC_SPP_FLAG | EXECUTIVE SEVERANCE PLAN | VARCHAR2(1) | The code indicating the eligibility for and level of participation (salary grade) in the executive severance pay program. |
| EXEC_SPP_PCT | EXECUTIVE SEVERANCE PERCENT | NUMBER(4,2) | OBSOLETE |
| HLTH_COVEFFDATE | MEDICAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current medical insurance carrier, becomes effective. |
| HLTH_COVERCODE | MEDICAL COVERAGE LEVEL CODE | VARCHAR2(3) | The code indicating single, two party, or family medical plan coverage and indicating whether the insured are covered by Medicare. (A three character code consisting of U and M and BLANK. The first character represents the individual. The second character represents the second party. The third character represents the family coverage. A U indicates uninsured by Medicare, an M indicates insured by Medicare, and a BLANK indicates no coverage.) |
| HLTH_DEENROLL | MEDICAL COVERAGE DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from medical insurance. (values are X=database maintenance require or BLANK=no action required) |
| HLTH_EARNEFFDATE | MEDICAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current medical insurance carrier, becomes effective. |
| HLTH_OPTOUT | MEDICAL COVER OPT OUT FLAG | VARCHAR2(1) | The code indicating the reason why automatic enrollment in the core medical insurance program is not to take place. (values are X=opted not to participate, C=cancelled, D=deenrolled, or BLANK=no action to be taken) |
| HLTH_PLAN | MEDICAL HEALTH PLAN CODE | VARCHAR2(2) | The code indicating the medical insurance plan in which the individual is enrolled. (See BEN_CODE in the DVTBEN table for data translation) |
| INS_REDUCT_IND | INSURANCE REDUCTION FLAG | VARCHAR2(1) | The code indicating the insurance tax savings plan option selected by the individual. (values are Y or BLANK=full participation, N=no participation, or H=participation except for medical insurance premium) |
| LEGAL_COVEFFDATE | LEGAL COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current legal insurance carrier, becomes effective for the employee. |
| LEGAL_COVERAGE | LEGAL COVERAGE LEVEL CODE | VARCHAR2(3) | The code indicating the level of legal plan coverage selected by the individual. (values are U=one party, UU=two party or UUU=family) |
| LEGAL_DEENROLL | LEGAL DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from legal insurance. (values are X=data base maintenance required or BLANK=no action required) |
| LEGAL_EARNEFFDATE | LEGAL EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current legal insurance carrier, becomes effective for the employee. |
| LEGAL_PLAN | LEGAL PLAN CODE | VARCHAR2(2) | The code indicating the legal plan selected by the individual. (value is J1= prudential legal services). |
| LIFEINS_PLAN | LIFE INSURNCE PLAN | VARCHAR2(1) | The code indicating the amount of life insurance coverage selected by the individual. (values are 1=1X base salary, 2=2X base salary, 3=3X base salary, 4=4X base salary, or F=flat coverage) |
| LIFE_COVEFFDATE | LIFE INSURANCE COVERAGE EFFECTIVE DATE | DATE | The effective date of coverage for employee paid life insurance |
| LIFE_DEENROLL | LIFE INSURANCE DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from life insurance. (values are X=data base maintenance required, or BLANK=no action required) |
| LIFE_EFFDATE | LIFE INSURANCE EFFECTIVE DATE | DATE | The effective date of coverage for employee paid life insurance. |
| LIFE_SALARY_BASE | LIFE INSURANCE SALARY BASE AMOUNT | NUMBER(5) | The salary base used to determine employee-paid life insurance coverage, expressed in thousands of dollars. The annual full-time salary amount is rounded to the next highest thousand and the three right-most zeroes are truncated. |
| LIFE_UCPAIDAMT | LIFE UC PAID AMOUNT | VARCHAR2(3) | The amount of employer paid life insurance coverage. The annual salary amount (with certain adjustments) is rounded to the next highest thousand and the three right-most digits are truncated. e.g. 18,750 is rounded to 19,000 and entered as 019. The life insurance amount is always blank if retirement system code has a value of BLANK (no retirement plan) or N (not eligible) or H (safe harbor plan). |
| LIFE_UCPD_EFFDATE | LIFE UC PAID EFFECTIVE DATE | DATE | The effective date of coverage for the UC paid life insurance plan. |
| LTD_DEENROLL | LONG TERM DISABILITY DEENROLL FLAG | VARCHAR2(1) | OBSOLETE |
| LTD_EARNEFFDATE | LONG TERM DISABILITY EFFECTIVE DATE | DATE | OBSOLETE |
| LTD_SALBASE | LONG TERM DISABILITY SALARY BASE | NUMBER(5) | OBSOLETE |
| MED_PROVIDER_ID | MEDICAL COVERAGE PROVIDER ID | VARCHAR2(26) | OBSOLETE |
| NDI_CODE | DISABILITY INSURANCE CODE | VARCHAR2(1) | The code indicating the UC paid temporary disability (UCTD) coverage for an individual. (values are A=covered or BLANK) |
| NDI_COVEFFDATE | DISABILITY INSURANCE COVERAGE EFFECTIVE DATE | DATE | The effective date of coverage for the UC paid temporary disability insurance plan. |
| PLN_403B_CHGD_DATE | 403B PLAN CHANGE DATE | DATE | The date of the last change in either the total percentage or the total flat dollar amount of all voluntary contributions to 403B plans. |
| RET_ELIG_CODE | RETIREMENT ELIGIBILITY CODE | VARCHAR2(1) | The code indicating the retirement plan to which the individual belongs. |
| SEC_HLTH_COVERAGE | SECONDARY MEDICAL COVERAGE LEVEL | VARCHAR2(3) | OBSOLETE |
| SEC_HLTH_DATE | SECONDARY MEDICAL COVERAGE EFFECTIVE DATE | DATE | OBSOLETE |
| SEC_HLTH_PLAN | SECONDARY MEDICAL HEALTH PLAN | VARCHAR2(2) | OBSOLETE |
| STD_DEENROLL | SHORT TERM DISABILITY DEENROLL FLAG | VARCHAR2(1) | OBSOLETE |
| STD_EARNEFFDATE | SHORT TERM DISABILITY EFFECTIVE DATE | DATE | OBSOLETE |
| STD_SALBASE | SHORT TERM DISABILITY SALARY BASE | NUMBER(5) | OBSOLETE |
| STD_WAITPERIOD | SHORT TERM DISABILITY WAIT PERIOD | VARCHAR2(3) | OBSOLETE |
| UCRS_ELIGDATE | UCRS ELIGIBILITY DATE | DATE | The code indicating how the special benefits contribution is to be applied. |
| VIS_ALT_CURRMO | VISION ALT CURRENT MONTH FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_ALT_HIST | VISION ALT HISTORY FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_ALT_MTH1 | VISION ALT MONTH 1 FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_ALT_MTH2 | VISION ALT MONTH 2 FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_ALT_MTH3 | VISION ALT MONTH 3 FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_ALT_MTH4 | VISION ALT MONTH 4 FLAG | VARCHAR2(1) | Reserved for future use. |
| VIS_COVEFFDATE | VISION COVERAGE EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current optical insurance carrier, becomes effective for the employee. |
| VIS_COVERAGE | VISION COVERAGE LEVEL | VARCHAR2(3) | The code indicating the level of optical plan coverage selected by the individual (values are U=one party, UU=two party, or UUU=family) |
| VIS_DEENROLL | VISION DEENROLL FLAG | VARCHAR2(1) | The code indicating that data base maintenance is required to reflect the individuals de-enrollment from optical insurance. (values are X=data base maintenance required, or BLANK=no action required) |
| VIS_EARNEFFDATE | VISION EFFECTIVE DATE | DATE | The date on which the associated coverage level, with the current optical insurance carrier, becomes effective for the employee. |
| VIS_OPTOUT | VISION OPT OUT FLAG | VARCHAR2(1) | The code indicating the reason why automatic enrollment in the optical insurance program is not to take place. (values are X=opted not to participate, D=deenrolled, or BLANK=no action to be taken) |
| VIS_PLAN | VISION PLAN CODE | VARCHAR2(2) | The code indicating the optical insurance plan selected by the individual. (value is VI=Vision care) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: June 8, 2000