BENEFITS COSTSHARE DETAIL Table
Data about retirees and benefits subscribers who page a percentage of their full medical cost
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
BENEFITS_COSTSHARE_TYPE_KEY |
Field used to join BENEFITS_COSTSHARE_DETAIL and BENEFITS_COSTSHARE_TYPE tables. Should not be used in reports. |
VARCHAR2 |
30 |
COST_SHARE_COMMENT |
Free-form comment associated with cost sharing percent, entered by the Benefits Office. |
VARCHAR2 |
100 |
COST_SHARE_PERCENT |
The cost sharing percent. |
NUMBER |
22 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
RECORD_VALID_FROM_DATE |
The date a commitment record is started. Usually the date the commitment was opened. If, however, changes were made to an open commitment this date may reflect the beginning of the altered commitment. |
DATE |
8 |
RECORD_VALID_TO_DATE |
The last day (inclusive) when the record values are vaoid. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |