| Data element |
Definition |
| Banner_Pidm Indexed - yes
Format - Number
May be Null? N | Internal unique ID of the student |
| Grade_Hold_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whetther or not this type of hold prevents a student from receiving their grades
Values: Y or null |
| Graduation_Hold_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whetther or not this type of hold prevents a student from graduating
Values: Y or null |
| Hold_Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the hold was updated |
| Hold_Applied_User Indexed - no
Format - Varchar2(120)
May be Null? Y | ID of the user who applied the hold - may be a system process of an individual user |
| Hold_Code Indexed - yes
Format - Varchar2(8)
May be Null? N | A code indicating the type of hold. See also Hold_Description. |
| Hold_Data_Origin_Code Indexed - no
Format - Varchar2(120)
May be Null? Y | Indicates the original source of the hold information.
Values:
Banner
LEGACY
|
| Hold_Description Indexed - no
Format - Varchar2(120)
May be Null? Y | Description of the type of hold. See also Hold_Code. |
| Hold_From_Date Indexed - yes
Format - Date
May be Null? N | Effective date of the hold |
| Hold_Originator_Code Indexed - no
Format - Varchar2(16)
May be Null? Y |
For holds where the origin is "LEGACY" this is a code will indicate whether the hold is coming from the bursar system (BURS) or has been sent to collections (CLCT). |
| Hold_Reason Indexed - no
Format - Varchar2(120)
May be Null? Y | Reason for the hold - displays on student's record so not always meaningful |
| Hold_Release_Indicator Indexed - yes
Format - Varchar2(4)
May be Null? N | Whether or not the hold has been released |
| Hold_To_Date Indexed - no
Format - Date
May be Null? Y | Date the hold expires |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Penn_Id Indexed - no
Format - Varchar2(10)
May be Null? Y | PennID of the student |
| Registration_Hold_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whether or not this type of hold prevents a student from registering for classes
Values: Y or null |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Transcript_Hold_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whetther or not this type of hold prevents a student transcript from being issued
Values: Y or null |
