Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_THESIS_DISS_COMMITTEE Table . Pennant Student Records Home . Data Warehouse Home

ST_THESIS_DISS_COMMITTEE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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

ST_THESIS_DISS_COMMITTEE Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania