| 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: STVSITE_ACTIVITY_DATE. |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | |
| 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. |
| Site_City Indexed - no
Format - Varchar2(50)
May be Null? Y | City of the site address. Source field: STVSITE_CITY. |
| Site_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Code for the Site, or location, of the student in a term or program. At Penn, study abroad programs are identified by Site Codes. Source field: STVSITE_CODE. |
| Site_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Descriptive text title of the Site code. Source field: STVSITE_DESC. |
| Site_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the site code. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| Site_House_Num Indexed - no
Format - Varchar2(10)
May be Null? Y | House number of the site street address. Source field: STVSITE_HOUSE_NUMBER. |
| Site_Nation Indexed - no
Format - Varchar2(10)
May be Null? Y | Country code of the site address. Source field: STVSITE_NATN_CODE. See also STVNATN. |
| Site_State Indexed - no
Format - Varchar2(50)
May be Null? Y | State code of the site address. This field is not validated against the source State validation table; can contain a state or province from a non-US country. Source field: STVSITE_STATE. |
| Site_Zip Indexed - no
Format - Varchar2(30)
May be Null? Y | Postal code of the site address. Source field: STVSITE_ZIPC. |
| Street_Addr1 Indexed - no
Format - Varchar2(75)
May be Null? Y | Line 1 of the site street address. Source field: STVSITE_STREET_ADDR1. |
| Street_Addr2 Indexed - no
Format - Varchar2(75)
May be Null? Y | Line 2 of the site street address. Source field: STVSITE_STREET_ADDR2. |
| Street_Addr3 Indexed - no
Format - Varchar2(75)
May be Null? Y | Line 3 of the site street address. Source field: STVSITE_STREET_ADDR3. |
| Street_Addr4 Indexed - no
Format - Varchar2(75)
May be Null? Y | Line 4 of the site street address. Source field: STVSITE_STREET_ADDR4. |
| V_Site_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key |
