| Data element |
Definition |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | Aid year for record being tracked. |
| Date_Recorded Indexed - no
Format - Date (7)
May be Null? Y | The date when this value was recorded in the FA_VALUE_SNAP table. |
| Field_Char_Value Indexed - no
Format - Varchar2 (1600)
May be Null? Y | If the value is in characater form, the value will be located in this field. |
| Field_Name Indexed - yes
Format - Varchar2 (240)
May be Null? Y | Field or value being tracked. |
| Field_Numb_Value Indexed - no
Format - Number (22)
May be Null? Y | If the value is numeric, the value will be located in this field. |
| Penn_Id Indexed - yes
Format - Varchar2 (36)
May be Null? Y | Student or Penn ID listed for the record. |
| Period Indexed - yes
Format - Varchar2 (60)
May be Null? Y | Period for record being tracked. Some values are tracked by aid year while others are tracked by period. |
| Pidm Indexed - no
Format - Number (22)
May be Null? Y | Internal database ID for student listed. |
| Table_Name Indexed - yes
Format - Varchar2 (240)
May be Null? Y | The table name or materialized view where value is stored. |
