| Data element |
Definition |
| Id Indexed - yes
Format - Number
May be Null? N | Primary key to this warehouse table. System-generated. Internal; does not come from the source. |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was refreshed in the Data Warehouse. |
| Reader_Name Indexed - no
Format - Varchar2(800)
May be Null? Y | The name of the reader who reviews proposals. Note this name comes from Curriculum Management, where it is stored. Penn staff members who have name changes may not have those changes reflected in this table, unless the change is made in Curriculum Management. |
| Reader_Pennkey Indexed - no
Format - Varchar2(800)
May be Null? Y | Pennkey of the Reader. Note this information comes from Curriculum Management, using the pennkey of the person logged on as the reader. |
| Reader_School Indexed - no
Format - Varchar2(8)
May be Null? N | Code for the School associated with the reader.
Valid values are found in the cm_subject_dept_school table. |
| Retired Indexed - no
Format - Varchar2(800)
May be Null? Y | Flag indicated whether this reader is not longer active. Retired records will have a 'Y' in this column. |
