| Data element |
Definition |
| Change_Type Indexed - no
Format - Varchar2(800)
May be Null? Y | Indicates the type of change being requested in the proposal. Values are "new", "edit" or "delete."" |
| Committee_Term Indexed - no
Format - Varchar2(800)
May be Null? Y | The term in which the responsible committee/committees will review the proposal. |
| Date_Approved Indexed - no
Format - Date
May be Null? Y | The date the proposal was entered in the Curriculum Management source system. |
| Date_Proposed Indexed - no
Format - Date
May be Null? Y | The action date associated with the initiating of the proposal. |
| Effective_Catalog Indexed - no
Format - Varchar2(800)
May be Null? Y | The academic catalog in which the approved proposal will take effect. Catalogs run according to Academic Year. |
| Last_Effective_Term Indexed - no
Format - Varchar2(800)
May be Null? Y | For proposals that are putting an end-date a course or program, this is the last term in which that course or program can be used. |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date the record was last refreshed in the Data Warehouse. |
| Latest_Action_Date Indexed - no
Format - Date
May be Null? Y | The date of the latest action entered for this proposal in the Curriculum Management system, if available. |
| Most_Recently_Approved_YN Indexed - no
Format - Varchar2(4)
May be Null? Y | Flag indicating whether this record is the most recently approved version of this proposal. |
| Proposal_History_Id Indexed - yes
Format - Number
May be Null? N | Internal Data Warehouse id number for this table. |
| Proposal_Id Indexed - no
Format - Number
May be Null? N | Internal Data Warehouse identification number for the proposal. Used to join this table to other tables in the Curriculum Management data collection. |
| Proposer_Pennkey Indexed - no
Format - Varchar2(80)
May be Null? Y | If the Requestor initiated the proposal on behalf of another person, this is the Pennkey of that person. |
| Proposer_Penn_Id Indexed - no
Format - Varchar2(32)
May be Null? Y | If the Requestor initiated the proposal on behalf of another person, this is the Penn_ID of that person. |
| Requestor_Pennkey Indexed - no
Format - Varchar2(800)
May be Null? Y | The Pennkey of the person who initially requested the proposal. |
| Requestor_Penn_Id Indexed - no
Format - Varchar2(32)
May be Null? Y | The Penn_ID of the person who initially requested the proposal. |
| Start_Term Indexed - no
Format - Varchar2(800)
May be Null? Y | The first term this approved proposal took effect. |
| Type Indexed - no
Format - Varchar2(800)
May be Null? Y | Indicates whether the proposal is for a change to one of the following:
course
assign a foundational approach with a course
assign a sector with a course
program
|
