| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date any part of this record was updated in the source. Source field: SHRCOMM_ACTIVITY_DATE. |
| Committee_Type Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the type of committee. Source field: SHRCOMM_COMT_CODE. Source validation table: STVCOMT. Warehouse validation table: v_committee_type |
| Committee_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the Committee type code. Source field: STVCOMT_DESC Warehouse validation table: v_committee_type |
| Member_Dept Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the department that the committee member is associated with. Source field: SHRCOMM_DEPT_CODE. Source validation table: STVDEPT. Warehouse validation table: v_department |
| Member_Division Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the division that the committee member is associated with. Source field: SHRCOMM_COLL_CODE. Source validation table: STVCOLL. Warehouse validation table: v_division. |
| Member_First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | First name of the committee member. Source field: SPRIDEN_FIRST_NAME. |
| Member_From_Date Indexed - no
Format - Date
May be Null? Y | The start date of the member's participation on this committee. Source field: SHRCOMM_FROM_DATE. |
| Member_Function Indexed - no
Format - Varchar2(2)
May be Null? Y | The committee member's function on the committee. Source field: SHRCOMM_COMF_CODE. Source validation table: STVCOMF. Warehouse validation table: v_committee_function |
| Member_Function_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description for the Member's function in the Committee. Source field: SVTCOMF_DESC. Warehouse validation table: v_committee_function |
| Member_Last_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Last name of the committee member. Source field: SPRIDEN_LAST_NAME. |
| Member_Middle_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Middle name of the committee member. Source field: SPRIDEN_MI. |
| Member_Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | The committee member's Penn_ID. Source field: SPRIDEN_ID |
| Member_Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identification number for the committee member. Source field: SHRCOMM_PIDM_MEMBER. |
| Member_School Indexed - no
Format - Varchar2(3)
May be Null? Y | Code for the school that the committee member is associated with. Source field: SHRCOMM_DICD_CODE. Source validation table: GTVDICD. Warehouse validation table: v_school. |
| Member_Status Indexed - no
Format - Varchar2(2)
May be Null? Y | The committee member's status on the committee. Source field: SHRCOMM_COMS_CODE. Source validation table: STVCOMS. |
| Member_Status_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description for the Member's status in the Committee. Source field: SVTCOMS_DESC. Source validation table: STVCOMS. |
| Member_To_Date Indexed - no
Format - Date
May be Null? Y | The end date of the member's participation on this committee. Source field: SHRCOMM_TO_DATE. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identification number for the student. Source field: SHRCOMM_PIDM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date the table was refreshed in the warehouse |
| St_Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID |
| St_Thesis_Diss_Committee_Pk Indexed - yes
Format - Varchar2(32)
May be Null? N | internal warehouse primary key: based on PIDM, COMT_CODE, PIDM_MEMBER, and FROM_DATE |
