Penn Computing

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

HCM_ACAD_APPOINTMENT Table - Data Element Index

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




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.

 
HCM_ACAD_APPOINTMENT 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