| Data element |
Definition |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | the latest date this record was refreshed in the Data Warehouse. |
| Latest_Pagekey Indexed - no
Format - Varchar2(800)
May be Null? Y | The internal identifying number for the Courseleaf source database. Note that in the source database, pagekeys are dynamic and can change as often as daily. The Latest_Pagekey in the warehouse is the pagekey that was on the record in the source when the record was extracted as of the Last_Refresh_Date. |
| Path_Id_Number Indexed - no
Format - Varchar2(800)
May be Null? Y | The internal identifying number for Courseleaf web pages, used to find a specific record in the online application. The Path_ID number is part of the path statement (url) for a record in that application.
Example: in the url "https://next.catalog.upenn.edu/courseadmin/2295/index.html", "2295" is the Path_ID_Number |
| Path_Key Indexed - no
Format - Varchar2(800)
May be Null? Y | A text string that is part of the path statement (url) for a record in the online Courseleaf application. Note that Path_ID_Number is part of the Path_Key.
Example: in the url "https://next.catalog.upenn.edu/courseadmin/2295/index.html", "/courseadmin/2295/index.html" is the Path_Key |
| Path_Type Indexed - no
Format - Varchar2(800)
May be Null? Y | Used to identify the type of proposal. Values are:
courseadmin
foundationalapproachesadmin
programadmin
sectoradmin |
| 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. |
