| Data element |
Definition |
ACAD_APPT_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The end date of the academic appointment. |
ACAD_APPT_END_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fiscal year of the end of the academic appointment. |
ACAD_APPT_END_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The calendar year of the end of the academic appointment. |
ACAD_APPT_REASON
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The reason for the creation of the academic appointment record. |
ACAD_APPT_REASON_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the reason for the creation of the academic appointment record. |
ACAD_APPT_START_DATE
Format DATE
Indexed? No
May be Null? Yes |
The start date of the academic appointment. |
ACAD_APPT_START_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fiscal year of the start of the academic appointment. |
ACAD_APPT_START_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The calendar year of the start of the academic appointment. |
ACAD_TRACK_TYPE_CATEGORY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The broader categorization of the track type for the appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
ACAD_TRACK_TYPE_CATEGORY_ID
Format VARCHAR2(200)
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_APPT_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The title pertaining to the specific appointment. The title may be the same as or a modification of the text of the academic rank. |
ACADEMIC_RANK
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name of the academic rank for the appointment. |
ACADEMIC_RANK_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system ID of the academic rank for the appointment. |
ACADEMIC_REVIEW_DATE
Format DATE
Indexed? No
May be Null? Yes |
The latest date by which a faculty member shall be reviewed for purposes of a timely tenure decision. |
ACADEMIC_TRACK_TYPE
Format VARCHAR2(200)
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. |
ACADEMIC_TRACK_TYPE_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID 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. |
ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system ID of the Academic Unit for the appointment. |
ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The name of the Academic Unit for the appointment. |
ACADEMIC_UNIT_PENN_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Penn Cost Center (4-digit ORG code) associated with the Academic Unit for the appointment. |
ACADEMIC_UNIT_SUBTYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The type classification of the Academic Unit for the appointment. |
APPOINTMENT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The unique system identifier for the appointment. |
APPOINTMENT_IDENTIFIER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name for the classification of the appointment as primary or other among other appointments for the individual. |
APPOINTMENT_IDENTIFIER_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID for the classification of the appointment as primary or other among other appointments for the individual. |
JOB_PROFILE_FOR_APPT_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier of the job profile associated with the academic appointment. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code. This field is only populated for workers with a position linked to the appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
JOB_PROFILE_FOR_APPT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the of the job profile associated with the academic appointment. This field is only populated for workers with a position linked to the appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
JOB_PROFILE_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier of the job profile associated with the academic appointment. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code. This field is only populated for workers with a position linked to the appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
JOB_PROFILE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the of the job profile associated with the academic appointment. This field is only populated for workers with a position linked to the appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
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. |
NAMED_PROFESSORSHIP
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The description of the Named Professorship associated with the academic appointment. |
NAMED_PROFESSORSHIP_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the Named Professorship associated with the academic appointment. |
NEW_RANK_LEVEL
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the academic appointment marks the attainment a new rank for the person. |
PENN_ID
Format VARCHAR2(200)
Indexed? Yes
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
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique system identifier for the position related to the academic appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
PRI_PENN_AU_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
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_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the worker's primary position. |
PRI_PENN_SCH_CTR
Format VARCHAR2(200)
Indexed? Yes
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. |
PRIMARY_ACAD_APPT_IND
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For individuals with multiple current appointments, a flag indicating if the appointment is (1) the person's primary academic appointment or not (0). |
PROBATIONARY_END_DATE_EXT
Format DATE
Indexed? No
May be Null? Yes |
The end date of the tenure probationary period. |
RELATED_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the Supervisory ORG associated with the Academic Unit for the appointment. |
RELATED_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the Supervisory ORG associated with the Academic Unit for the appointment. |
ROSTER_PERCENT
Format NUMBER
Indexed? No
May be Null? Yes |
An indication of percentage effort for the appointment, initially derived from FTE percent on the related position (if one is related, for workers). |
TENURE_AWARD_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which tenure was awarded. |
TENURE_HOME_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit where the person was awarded tenure. |
TENURE_HOME_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the Academic Unit where the person was awarded tenure. |
TENURE_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The tenure status pertaining to the person in the appointment. |
TENURE_STATUS_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the tenure status pertaining to the person in the appointment. |
TOP_ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the Academic Unit for the appointment. |
TOP_ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the Academic Unit for the 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_START_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date in which the person started in the academic track. |
WORKDAY_AFFILIATE_ID
Format VARCHAR2(200)
Indexed? Yes
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_EMPLOYEE_ID
Format VARCHAR2(200)
Indexed? Yes
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. |
