| 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_SALARY_FUNDING_OTHER_DESCR
Indexed - no
Format - varchar2(250)
May be null - yes |
Additional information pertaining to the LOA benefit funding record.
|
LOA_SALARY_FUNDING_PCT
Indexed - no
Format - integer
May be null - yes |
The percentage of salary funding for the record. Percentages are represented in whole numbers. |
LOA_SALARY_FUNDING_TYPE
Indexed - no
Format - number(12)
May be null - no |
A numeric code identifying the type of LOA salary funding.Use this to join to the FIS_LOA_SAL_FUND_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the description of the salary funding type (e.g., Department, Grants, Leave Budget). |
|
LOA_SALARY_ID
Indexed - yes (primary key)
Format - number(12)
May be null? no
|
A unique identifier of each LOA salary funding record.
|
LOA_SALARY_LEVEL
Indexed - no
Format - number(12)
May be null? yes |
A numeric code identifying the LOA salary funding level.Use this to join to the FIS_LOA_SALARY_LEVEL_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the description of the salary funding level (e.g., Full, None, Partial). |
