| Data element |
Definition |
| ACTION_ID
Indexed - no
Format - number
May be null? no |
The unique identifier on each action. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system. |
| CREATE_DT
Indexed - no
Format - date
May be null? no
|
The date the record was created. |
| CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record. |
LOA_BENEFIT_ID
Indexed - yes (primary key)
Format - number(12)
May be null - yes |
A unique identifier of each LOA benefit funding record.
|
|
LOA_BENEFIT_LEVEL
Indexed - no
Format - number(12)
May be null? no
|
A numeric code identifying the LOA benefit funding level.Use this to join to the FIS_LOA_BENEFIT_LEVEL_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the description of the benefit funding level (e.g., Full, None, Paid by Employee).
|
LOA_BENEFIT_PAID_3RD_PTY_DESCR
Indexed - no
Format - varchar2(250)
May be null? yes |
Additional information pertaining to the LOA benefit funding record. |
