| 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_Proposed Indexed - no
Format - Date
May be Null? Y | The action date associated with the initiating of the proposal. |
| Date_Sent_To_Sis Indexed - no
Format - Date
May be Null? Y | The most recent date the approved data changes from this proposal were sent to the SIS (legacy SIS is SRS - Student Records System.) |
| 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 Indexed - no
Format - Varchar2(800)
May be Null? Y | The latest recorded action taken in the source system. |
| Latest_Action_Date Indexed - no
Format - Date
May be Null? Y | The date of the Latest Action, if available. |
| Latest_Action_Role Indexed - no
Format - Varchar2(800)
May be Null? Y | The Curriculum Management role of the office or person who entered the Latest Action, if available. |
| Latest_Action_User Indexed - no
Format - Varchar2(800)
May be Null? Y | The Penn_ID of the person who entered the Latest Action, if applicable. |
| Legacy_Committee_Term Indexed - no
Format - Varchar2(20)
May be Null? Y | The Committee Term, in legacy system (SRS) format. |
| Legacy_Last_Effective_Term Indexed - no
Format - Varchar2(20)
May be Null? Y | The Last Effective Term, in legacy system (SRS) format. |
| Legacy_Start_Term Indexed - no
Format - Varchar2(20)
May be Null? Y | The Start Term in legacy system (SRS) format. |
| Next_Queue Indexed - no
Format - Varchar2(800)
May be Null? Y | The Curriculum Management system role of the office or entity that is next in the workflow to take action on the proposal. Proposals remain in a queue until action is taken and they are promoted to the next step in the workflow. |
| Proposal_Id Indexed - yes
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(4000)
May be Null? Y | The Pennkey of the person who initially requested the proposal. |
| Requestor_Penn_Id Indexed - no
Format - Char
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 proposal, if approved, is to take effect. |
| Status Indexed - no
Format - Varchar2(800)
May be Null? Y | An internal Data Warehouse field that indicates where the proposal is in the approval process. Values are:
in_progress -- still working its way through the Curriculum Management workflow.
deferred -- decision not made; deferred till later. Proposal no longer in workflow.
denied -- proposal was not approved; no longer in workflow.
ready -- proposal was approved and is ready to sync to the SIS (legacy SIS is SRS).
sent -- temporary status indicating record was sent to the SIS.
error_on_send -- temporary status indicating there was a problem with the sync.
complete -- record was sent to the SIS and synched back to the Curriculum Managment system.
|
| 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
|
