Penn Computing

University of Pennsylvania
Penn Computing << go backback
HCM_ACAD_APPOINTMENT_DETAIL Table    Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

HCM_ACAD_APPOINTMENT_DETAIL Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




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.

 
HCM_ACAD_APPOINTMENT_DETAIL Table    Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania