| Data element |
Definition |
| Attendance_Period Indexed - no
Format - Varchar2(12)
May be Null? Y | Short description of the period of time in which the student took the transferred courses. Source field: SHRTRAM_ATTN_PERIOD. |
| Count_In_Gpa_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the grade for the equivalent record should be included in the Penn GPA, for the Level of the course. SHRTRCE_COUNT_IN_GPA_IND |
| Ext_Articulated_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Transfer articulation indicator. Null denotes course not articulated, N denotes that course has no institution equivalent, Y denotes course has been articulated. Source field: SHRTRCR_ART_IND. |
| Ext_Credit_Grade Indexed - no
Format - Varchar2(6)
May be Null? Y | Grade received at the external institution. Source field: SHRTRCR_TRANS_GRADE. |
| Ext_Credit_Hours Indexed - no
Format - Number
May be Null? Y | Credit hours of the course taken at the external institution. Source field: SHRTRCR_TRANS_CREDIT_HOURS. |
| Ext_Crse_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Name of the course taken at the external institution. Source field: STRTRCR_TRANS_COURSE_NAME. |
| Ext_Crse_Num Indexed - no
Format - Varchar2(60)
May be Null? Y | Number of the course taken at the external institution. Source field: SHRTRCR_TRANS_COURSE_NUMBERS. |
| Ext_Crse_Title Indexed - no
Format - Varchar2(30)
May be Null? Y | Title of the course taken at the external institution. Source Field: SHRTRCR_TCRSE_TITLE. |
| Ext_Group Indexed - no
Format - Varchar2(2)
May be Null? Y | Source field: SHRTRCR_GROUP |
| Ext_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | Student Level of the course taken at the external institution. Source field: SHRTRCR_LEVL_CODE. |
| Ext_Program Indexed - no
Format - Varchar2(12)
May be Null? Y | Academic program related to the course taken at the external institution. Source field: SHRTRCR_PROGRAM. |
| Ext_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Academic term of the external institution. Source field: SHRTRCR_TERM_CODE. |
| Institution_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the school, college or university the student attended, where they did the coursework that is being granted equivalency to Penn credit. When the credit is Advance Placement credit, the Institution Code will be 'EQIVAP'; when the credit is International Baccalaureate credit, the Institution Code will be 'EQIVIB'.
Source field: SHRTRIT_SBGI_CODE. Source validation table: STVSBGI. Data warehouse validation table: v_institution. |
| Institution_Desc Indexed - no
Format - Varchar2(150)
May be Null? Y | Descriptive name for the institution. Source field: STVSBGI_DESC. For the custom Penn Long Description of the institution, see UP_ST_UP_S_BANNER_LONG_DESC.LONG_DESC for table STVSBGI. |
| Penn_Equiv_Credit_Hours Indexed - no
Format - Number
May be Null? Y | Penn credit assigned to the equivalent record, stored in native Penn units. Derived from SHRTRCE_CREDIT_HOURS. |
| Penn_Equiv_Credit_Hours_Bu Indexed - no
Format - Number
May be Null? Y | Penn credit assigned to the equivalent record, stored in Banner Units. Source field: SHRTRCE_CREDIT_HOURS |
| Penn_Equiv_Crse_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Penn course number assigned to the equivalent record. Source field: SHRTRCE_CRSE_NUMB |
| Penn_Equiv_Crse_Subj Indexed - no
Format - Varchar2(30)
May be Null? Y | Penn subject area assigned to the equivalent record. Source field: SHRTRCE_SUBJ_CODE |
| Penn_Equiv_Crse_Title Indexed - no
Format - Varchar2(30)
May be Null? Y | Penn course title assigned to the equivalent record. Source field: SHRTRCE_CRSE_TITLE |
| Penn_Equiv_Grade Indexed - no
Format - Varchar2(6)
May be Null? Y | Penn grade or mark assigned to the equivalent record. Source field: SHRTRCE_GRDE_CODE. |
| Penn_Equiv_Grade_Mode Indexed - no
Format - Varchar2(1)
May be Null? Y | Penn grade mode for the grade assigned to the equivalent record. Source field: SHRTRCE_GMOD_CODE |
| Penn_Equiv_Level Indexed - no
Format - Varchar2(4)
May be Null? Y | Penn Level of the course assigned to the equivalent record. SHRTRCE_LEVL_CODE |
| Penn_Equiv_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Penn academic term assigned to the equivalent record. Source field: SHRTRCE_TERM_CODE_EFF |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn identify management system unique identifier. Source field: SPRIDEN_ID |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number from source. Source field: SHRTRCE_PIDM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this test record was updated in the source. |
| Repeat_Course_Rule Indexed - no
Format - Varchar2(1)
May be Null? Y | When an equivalent record is a repeat of a course, this indicates if a course is to be Included, Excluded or Averaged. Source field: SHRTRCE_REPEAT_COURSE |
| Shrtram_Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the SHRTRAM record was updated. |
| Shrtrce_Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the SHRTRCE record was updated. |
| Shrtrcr_Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the SHRTRCR record was updated. |
| Shrtrit_Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the SHRTRIT record was updated. |
| St_Transfer_Credit_Pk Indexed - yes
Format - Varchar2(100)
May be Null? N | Internal primary key, based on pidm, and the sequence numbers of each of the underlying source tables. |
| Term_Code_Entered Indexed - no
Format - Varchar2(24)
May be Null? Y | Identifies the academic term to which the attendance period at the external institution applies. Source field: SHRTRAM_TERM_CODE_ENTERED. |
| Tram_Seqno Indexed - no
Format - Number
May be Null? Y | Sequence number of the Attendance Period by Transfer Institution Repeating Table. Source field: SHRTRAM_SEQ_NO |
| Trce_Seqno Indexed - no
Format - Number
May be Null? Y | Sequence number of the Transfer Course Equivalent Repeating Table. Source field: SHRTRCE_SEQ_NO |
| Trcr_Seqno Indexed - no
Format - Number
May be Null? Y | Sequence number of the Transfer Course Detail Repeating Table. Source field: SHRTRCR_SEQ_NO |
| Trit_Seqno Indexed - no
Format - Number
May be Null? Y | Sequence number of the Transfer Institution Repeating Record. Source field: SHRTRIT_SEQ_NO |
