| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the record was entered or updated in the source. Source field: STVSBGI_ACTIVITY_DATE |
| Custom_Id Indexed - yes
Format - Number
May be Null? Y | Custom ID. Source field: UP_ST_UP_S_BANNER_LONG_DESC.ID |
| Institution_Code Indexed - yes
Format - Varchar2(6)
May be Null? Y | Code for the high school, college, university, or other academic institution. Source field: STVSBGI_CODE. |
| Institution_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Descriptive text title of the Institution code. Source field: STBSBGI_DESC. |
| Institution_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the institution code. Source: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| Institution_Source Indexed - no
Format - Varchar2(1)
May be Null? Y | Source field: STVSBGI_SRCE_IND |
| Institution_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | Source field: STVSBGI_TYPE_IND |
| Inst_Addr_City Indexed - no
Format - Varchar2(50)
May be Null? Y | The city of the source institutions address. Source field: SOBSBGI_CITY. |
| Inst_Addr_Cy Indexed - no
Format - Varchar2(5)
May be Null? Y | The US county code of the source institutions address. May be null, as county information is not generally collected. Source field: SOBSBGI_CNTY_CODE. |
| Inst_Addr_Line1 Indexed - no
Format - Varchar2(75)
May be Null? Y | The first line of the source institutions address. Source field: SOBSBGI_STREET_LINE1 |
| Inst_Addr_Line2 Indexed - no
Format - Varchar2(75)
May be Null? Y | The second line of the source institutions address. Source field: SOBSBGI_STREET_LINE2 |
| Inst_Addr_Line3 Indexed - no
Format - Varchar2(75)
May be Null? Y | The third line of the source institutions address. Source field: SOBSBGI_STREET_LINE3 |
| Inst_Addr_Line4 Indexed - no
Format - Varchar2(75)
May be Null? Y | The fourth line of the source institutions address. Source field: SOBSBGI_STREET_LINE4 |
| Inst_Addr_Nation Indexed - no
Format - Varchar2(5)
May be Null? Y | The country (nation) code of the source institutions address. Source field: SOBSBGI_NATN_CODE. |
| Inst_Addr_State Indexed - no
Format - Varchar2(3)
May be Null? Y | The state code of the source instituions address. Source field: SOBSBGI_STAT_CODE. |
| Inst_Addr_Zip Indexed - no
Format - Varchar2(60)
May be Null? Y | The postal code of the source institutions address. Source field: SOBSBGI_ZIP |
| Long_Desc_End_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The latest term the long description for the code is in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.END_TERM |
| Long_Desc_Start_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The earliest term the long description for the code was in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.START_TERM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date this table in the warehouse was last refreshed. |
| V_Institution_Pk Indexed - yes
Format - Varchar2(70)
May be Null? N | Internal warehouse primary key; Concatenation of the Institution_code, long_desc_start_term, and the custom_id. |
