Data element |
Definition |
ACA_UNIT_PENN_COST_CENTER_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The Penn Cost Center (4-digit ORG code) associated with the Academic Unit for the current appointment. |
ACA_UNIT_PENN_COST_CENTER_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The Penn Cost Center (4-digit ORG code) associated with the Academic Unit for the proposed appointment. |
ACAD_APPT_END_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The end date of the current academic appointment. |
ACAD_APPT_END_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The end date of the proposed academic appointment. |
ACAD_APPT_START_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The start date of the current academic appointment. |
ACAD_APPT_START_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The start date of the proposed academic appointment. |
ACADEMIC_APPT_TITLE_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The title pertaining to the specific current appointment. The title may be the same as or a modification of the text of the academic rank. |
ACADEMIC_APPT_TITLE_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The title pertaining to the specific proposed appointment. The title may be the same as or a modification of the text of the academic rank. |
ACADEMIC_RANK_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name of the academic rank for the current appointment. |
ACADEMIC_RANK_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name of the academic rank for the proposed appointment. |
ACADEMIC_REVIEW_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The latest date (for the current appointment) by which a faculty member shall be reviewed for purposes of a timely tenure decision. |
ACADEMIC_REVIEW_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The latest date (for the proposed appointment) by which a faculty member shall be reviewed for purposes of a timely tenure decision. |
ACADEMIC_TRACK_TYPE_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name of the track type for the current appointment. The appointment track is defined based on the type and behavior of the appointment. It yields eligibility information (e.g. tenure, promotion, and sabbatical) and specific ranks are tied to a track type. Track types include Tenure, Clinician-Educator, Research, etc. |
ACADEMIC_TRACK_TYPE_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name of the track type for the proposed appointment. The appointment track is defined based on the type and behavior of the appointment. It yields eligibility information (e.g. tenure, promotion, and sabbatical) and specific ranks are tied to a track type. Track types include Tenure, Clinician-Educator, Research, etc. |
ACADEMIC_UNIT_ID_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit for the current appointment. |
ACADEMIC_UNIT_ID_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit for the proposed appointment. |
APPOINTMENT_DESC
Format VARCHAR2(2000)
Indexed? No
May be Null? Yes |
The system ID of the broader categorization of the track type for the appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
APPOINTMENT_EVENT_STATUS
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The status of the Workday business process event related to this appointment record. |
APPOINTMENT_ID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The unique system identifier for the appointment. |
APPOINTMENT_IDENTIFIER_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name for the classification of the current appointment as primary or other among other appointments for the individual. |
APPOINTMENT_IDENTIFIER_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name for the classification of the proposed appointment as primary or other among other appointments for the individual. |
APPOINTMENT_TRACK_DESC
Format VARCHAR2(2000)
Indexed? No
May be Null? Yes |
The system ID of the broader categorization of the track type for the appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
ACADEMIC_TRACK_ID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The system ID of the academic rank for the appointment. |
ACADEMIC_TRACK_WID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The internal system ID of the academic rank for the appointment. |
ACADEMIC_TRACK_TYPE
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The descriptive name of the track type for the appointment. The appointment track is defined based on the type and behavior of the appointment. It yields eligibility information (e.g. tenure, promotion, and sabbatical) and specific ranks are tied to a track type. Track types include Tenure, Clinician-Educator, Research, etc. |
APPT_EVENT_DATE_COMPLETED
Format DATE
Indexed? No
May be Null? Yes |
The date on which the Workday business process event related to this appointment record was completed. |
APPT_EVENT_DATE_INITIATED
Format DATE
Indexed? No
May be Null? Yes |
The date on which the Workday business process event related to this appointment record was initiated. |
APPT_EVENT_EFFECTIVE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The effective date of the Workday business process event related to this appointment record. |
APPT_IDENTIFIER_CURR_IS_PRI
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
For individuals with multiple current appointments, a flag indicating if the current appointment is (1) the person's primary academic appointment or not (0). |
APPT_IDENTIFIER_PRO_IS_PRI
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
For individuals with multiple current appointments, a flag indicating if the proposed appointment will be (1) the person's primary academic appointment or not (0). |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
PENN_ID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse. |
POSITION_ID_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The unique system identifier for the position related to the current academic appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
POSITION_ID_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The unique system identifier for the position related to the proposed academic appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
PRI_PENN_ACA_UNIT_COST_CENTER
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the Academic Unit of the person's primary appointment. |
PRI_PENN_SCH_CTR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The 2-digit number used to identify the school or center for the Penn Cost Center associated with the worker's primary position. |
PROBATIONARY_END_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The end date of the tenure probationary period for the current appointment. |
PROBATIONARY_END_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The end date of the tenure probationary period for the proposed appointment. |
PROFESSORSHIP_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The description of the Named Professorship associated with the current academic appointment. |
PROFESSORSHIP_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The description of the Named Professorship associated with the proposed academic appointment. |
ROSTER_PERCENT_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
An indication of percentage effort for the current appointment, initially derived from FTE percent on the related position (if one is related, for workers). |
ROSTER_PERCENT_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
An indication of percentage effort for the proposed appointment, initially derived from FTE percent on the related position (if one is related, for workers). |
TENURE_AWARD_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The date on which tenure was awarded (for the current appointment). |
TENURE_AWARD_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The date on which tenure was awarded (for the proposed appointment). |
TENURE_HOME_ID_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit where the person was awarded tenure (for the current appointment). |
TENURE_HOME_ID_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit where the person was awarded tenure (for the proposed appointment). |
TENURE_STATUS_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The tenure status pertaining to the person in the current appointment. |
TENURE_STATUS_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The tenure status pertaining to the person in the proposed appointment. |
TRACK_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The last date on which the person will be in the academic track. |
TRACK_LAST_FUNCTIONAL_UPDATE
Format DATE
Indexed? No
May be Null? Yes |
The last functional update in Workday related to the appointment track. |
TRACK_START_DATE_CURR
Format DATE
Indexed? No
May be Null? Yes |
The date in which the person started in the academic track (for the current appointment). |
TRACK_START_DATE_PRO
Format DATE
Indexed? No
May be Null? Yes |
The date in which the person started in the academic track (for the proposed appointment). |
TRACK_TYPE_CATEGORY_CURR
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The broader categorization of the track type for the current appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
TRACK_TYPE_CATEGORY_PRO
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The broader categorization of the track type for the proposed appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
WORKDAY_AFFILIATE_ID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The unique ID for an academic affiliate in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |
WORKDAY_BUSINESS_PROC_CATEGORY
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The category of the Workday business process related to this appointment record. |
WORKDAY_BUSINESS_PROC_NAME
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The name of the Workday business process related to this appointment record. |
WORKDAY_BUSINESS_PROC_REASON
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The reason for the creation of the academic appointment record. |
WORKDAY_EMPLOYEE_ID
Format VARCHAR2(800)
Indexed? No
May be Null? Yes |
The unique ID for a worker in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |