| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The date the record was most recently updated in the source. Source field: GORVISA_ACTIVITY_DATE. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system's identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal indentification number. Source field: GORVISA_PIDM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date the record was mostly recently refreshed in the warehouse. |
| Seq_Num Indexed - no
Format - Number
May be Null? Y | Internal sequence number. Source field: GORVISA_SEQ_NO. |
| St_Visa_Pk Indexed - yes
Format - Varchar2(27)
May be Null? N | Internal primary key, based on PIDM, VISA_TYPE and SEQ_NUM |
| Visa_Type Indexed - no
Format - Varchar2(2)
May be Null? Y | The type of visa that was issued to the student. Source field: GORVISA_VTYP_CODE. Source validation table: GTVVTYP. Warehouse validation table: V_VISA_TYPE. |
