BENEFITS COSTSHARE TYPE Table
A dimension table holding fields specificying benefits cost sharing conditions, as well as billing specifics
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSOCIATED_PERSON_TYPE |
XXX |
VARCHAR2 |
50 |
ASSOCIATED_PERSON_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
BENEFITS_COSTSHARE_TYPE_KEY |
Field used to join BENEFITS_COSTSHARE_DETAIL and BENEFITS_COSTSHARE_TYPE tables. Should not be used in reports. |
VARCHAR2 |
30 |
IS_CURRENT_YEAR_RECORD |
A yes/no flag: "Y" if current year record, else "N". |
VARCHAR2 |
1 |
IS_ELIG_NON_PROFIT |
If an employee works in a qualifying non-MIT non profit position, this time worked may be counted towards MIT service. Eligible retirees must have a cost share percentage of 50%. |
VARCHAR2 |
1 |
IS_GRANDFATHERED |
A yes/no flag: "Y" if grandfathered, else "N". Employees eligible for retiree health insurance benefits on July 1, 1995 if, on that date, they were at least age 55 and had at least 10 years of service or were at least age 65. Under these grandfathered eligibility rules, if they or their spouse/partner are under age 65, the cost is the same as the cost to active MIT employees. If they or their spouse/partner are age 65 or over, MIT pays the full cost of Blue Cross and Blue Shield's MEDEX Supplement and subsidizes the other Medicare supplement plans up to the cost of MEDEX. |
VARCHAR2 |
1 |
IS_HOME_BILLED |
A yes/no flag refering to the A/R method of billing for retirees and subscribers who do not receive a pension through SAP. "Y" means yes. |
VARCHAR2 |
1 |
IS_LATEST_RECORD |
A yes/no flag: "Y" if latest record, else "N". |
VARCHAR2 |
1 |
IS_NEXT_YEAR_RECORD |
A yes/no flag: "Y" if next year record, else "N". |
VARCHAR2 |
1 |
MEDICAL_RATE_TYPE |
Description of the type of medical plan cost sharing, e.g., "Full cost", "No cost" etc. |
VARCHAR2 |
50 |
MEDICAL_RATE_TYPE_CODE |
Code identifying the type of medical plan cost sharing |
VARCHAR2 |
1 |
SUBSCRIBER_TYPE |
XXX |
VARCHAR2 |
50 |
SUBSCRIBER_TYPE_CODE |
XXX |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |