The assigned and derived benefits coverage eligibility codes indicate coverage levels
such as career benefits eligible or eligible for core benefits only. The data originates
from the Employee Data Base (EDB) and one records exists per employee regardless of
coverage.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| APR_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - APRIL | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of April. (values are M=medical, L=core life, B=both or BLANK=none) |
| AUG_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - AUGUST | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of August. (values are M=medical, L=core life, B=both or BLANK=none) |
| BELI_AVGHRSWEEK | BELI AVERAGE WORK HOURS PER WEEK | NUMBER(9,2) | The estimated average number of hours worked per week during includable months either for the most recent twelve month period or for the period since the individuals benefits eligibility date. |
| BELI_CHANGEDATE | BELI CODE CHANGE DATE | DATE | The date which identifies the year and month of the processing cycle in which the individuals benefits eligibility level indicator-assigned was last changed. |
| BELI_CONFLICTDATE | BELI CODE CONFLICT DATE | DATE | The date indicating the month and year in which a current discrepancy between the system-derived benefits eligibility level indicator and the assigned benefits eligibility level indicator was first identified. |
| BELI_DATE | BENEFIT ELIGIBILITY LEVEL INDICATOR DATE | DATE | The date indicating the year and month of the earliest possible begin date for the period used in calculating the average hours per week. |
| BELI_DERIVED_IND | DERIVED BELI INDICATOR | VARCHAR2(1) | The code indicating the system-derived estimate of the set of benefits for which the individual is eligible.(values are 1=career benefits eligibility, 2=limited career benefits eligibility - not a member of a retirement system and appt is for 12 months or more, 3=limited career benefits eligibility - not a member of a retirement system and appt is for less than 12 months, 4=eligible for core benefits only - avg hrs worked per week meets minimum requirements, 5=no benefits eligibility - avg hrs worked per week does not meet minimum requirements, 6=no benefits eligibility - appts are either casual/restricted or in titles restricted to students, 7=no benefits eligibility - appts are per diem, 8=no benefits eligibility - BYA appts, 9=no benefits eligibility - WOS appts, ?=no value assigned) |
| BELI_EFF_DATE | BELI EFFECTIVE DATE | DATE | The date on which the employees current assigned benefits eligibility level indicator. |
| BELI_IND | BENEFIT ELIGIBILITY LEVEL INDICATOR | VARCHAR2(1) | The code indicating the set of benefits for which the individual is eligible. (see list of values under BELI_DERIVED_IND) |
| CURR_BEN_COVERAGE | CURRENT BENEFIT COVERAGE FLAG | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the current month. (values are M=medical, L=core life, B=both core life and medical, or BLANK=none) |
| DEC_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - DECEMBER | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of December. (values are M=medical, L=core life, B=both or BLANK=none) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| FEB_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - FEBRUARY | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of February. (values are M=medical, L=core life, B=both or BLANK=none) |
| JAN_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - JANUARY | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of January. (values are M=medical, L=core life, B=both or BLANK=none) |
| JUL_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - JULY | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of July. (values are M=medical, L=core life, B=both or BLANK=none) |
| JUN_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - JUNE | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of June (values are M=medical, L=core life, B=both or BLANK=none) |
| LOA_APR_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE APRIL EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of April. (values are L=On leave of absence) |
| LOA_AUG_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE AUGUST EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of August. (values are L=On leave of absence) |
| LOA_CURR_AVGEXCLUD | LEAVE OF ABSENCE CURRENT EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual is on leave of absence at any time during the current month. (values are L=On leave of absence) |
| LOA_DEC_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE DECEMBER EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of December. (values are L=On leave of absence) |
| LOA_FEB_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE FEBRUARY EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of February. (values are L=On leave of absence) |
| LOA_JAN_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE JANUARY EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of January. (values are L=On leave of absence) |
| LOA_JUL_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE JULY EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of July. (values are L=On leave of absence) |
| LOA_JUN_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE JUNE EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of June. (values are L=On leave of absence) |
| LOA_MAR_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE MARCH EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of March. (values are L=On leave of absence) |
| LOA_MAY_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE MAY EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of May. (values are L=On leave of absence) |
| LOA_NOV_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE NOVEMBER EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of November. (values are L=On leave of absence) |
| LOA_OCT_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE OCTOBER EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of October. (values are L=On leave of absence) |
| LOA_SEP_AVGEXCLUD | LEAVE OF ABSENCE AVERAGE SEPTEMBER EXCLUDE FLAG | VARCHAR2(1) | The code indicating whether an individual was on leave of absence during the most recent month of September. (values are L=On leave of absence) |
| MAR_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - MARCH | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of March. (values are M=medical, L=core life, B=both or BLANK=none) |
| MAY_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - MAY | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of May. (values are M=medical, L=core life, B=both or BLANK=none) |
| NOV_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - NOVEMBER | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of November. (values are M=medical, L=core life, B=both or BLANK=none) |
| OCT_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - OCTOBER | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of October. (values are M=medical, L=core life, B=both or BLANK=none) |
| PRI_STAT_QUAL_CODE | PRIMARY STATUS QUALIFY CODE | VARCHAR2(2) | The code indicating a condition which causes the value of an individuals assigned benefits eligibility level indicator to appear to be out of compliance. (values are 10=appointee with ending date for funding purposes only, 20=averaged appointment percent employee (academic), 30=extended sick leave recipient, 40=employee rehabilitation (formally approved), 50=split student/non-student appointee inelibible for benefits, 60=seasonal employee, 70=phased retiree, 80="grandfathered" employee, 90=sabbatical/leave for professional renewal or BLANK=none) |
| PRI_STAT_QUAL_DATE | PRIMARY STATUS QUALIFY DATE | DATE | The date indicating the effective month, day, and year of the primary beli status qualification code. |
| SEC_STAT_QUAL_CODE | SECONDARY STATUS QUALIFY CODE | VARCHAR2(2) | The code indicating a second condition which causes the value of an individuals assigned benefits eligibility level indicator to appear to be out of compliance. (see list of code values under PRI_STAT_QUAL_CODE) |
| SEC_STAT_QUAL_DATE | SECONDARY STATUS QUALIFY DATE | DATE | The date indicating the effective month, day and year of the current secondary beli status qualification code. |
| SEP_BEN_COV_IND | BENEFIT COVERAGE INDICATOR - SEPTEMBER | VARCHAR2(1) | The code indicating the individuals core benefits coverage for the month of September (values are M=medical, L=core life, B=both or BLANK=none) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: November 19, 1999