| Data element |
Definition |
| ACCRUAL_ELIGIBLE
Indexed - no
Format - varchar2(1)
May be null? yes |
This field is not in use.
|
| ACTION_ID
Indexed - no
Format - number
May be null? yes
|
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 creation date of the record.
|
|
CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record.
|
CREDIT_ACCRUED
Indexed - no
Format - number
May be null? yes |
The number of credits accrued, as a result of the leave of absence (LOA) credit record. |
CREDIT_ADJUSTMENT_COMMENTS
Indexed - no
Format - varchar2(250)
May be null? yes |
Comments associated with a LOA credit adjustment. |
CREDIT_BORROWED
Indexed - no
Format - number
May be null? yes |
The number of credits borrowed, as a result of the leave of absence (LOA) credit record. |
CREDIT_USED
Indexed - no
Format - number
May be null? yes |
The number of credits used, as a result of the leave of absence (LOA) credit record. |
| DATE_OF_RECORD Indexed - no
Format - date
May be null? yes |
The date of record for the LOA credit adjustment. |
| EVENT_TYPE_CD
Indexed - no
Format - number
May be null? yes |
A numeric code indicating the type of leave of action (LOA). .Use this to join to the FIS_LOA_EVENT_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description.
Records with Event_Type_Cd = '3' are used to represent the balance at the effective start date of the LOA, and they should not be used to determine total credits accrued. |
| FASDA_ID
Indexed - no
Format - number
May be null? no
|
A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting. |
| LAST_UPD
Indexed - no
Format - timestamp(6)
May be null? no
|
The date/time when the LOA credit record was last updated. |
| LOA_CREDIT_ID
Indexed - yes (primary key)
Format - number
May be null? no
|
A unique identifier of each LOA credit record. |
| UPD_DT
Indexed - no
Format - date
May be null? no
|
The date the LOA credit record was last updated. |
| UPD_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who last updated the record. |
