Penn Computing

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

HCM_POSITION Table - Data Element Index

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




Data element Definition

ANNUAL_WORK_PERIOD

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The descriptive text indicating the annual work cycle for the position.

ANNUAL_WORK_PERIOD_END_DATE

Format DATE

Indexed? No

May be Null? Yes

The end date of the annual work cycle for the position.

ANNUAL_WORK_PERIOD_START_DATE

Format DATE

Indexed? No

May be Null? Yes

The start date of the annual work cycle for the position.

BUSINESS_TITLE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The business title for the position.

COMPANY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The system name representing the Company for the position.

COMPANY_NAME

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The descriptive name representing the Company for the position.

CURR_POSITION_FILLED_EFF_DATE

Format DATE

Indexed? No

May be Null? Yes

The most recent date on which the worker occupied the position.

DEFAULT_WEEKLY_HOURS

Format NUMBER

Indexed? No

May be Null? Yes

The standard hours for the position.

DISBURSEMENT_PLAN_PD_END_DATE

Format DATE

Indexed? No

May be Null? Yes

The end date of the disbursement plan period for the position.

DISBURSEMENT_PLAN_PD_ST_DATE

Format DATE

Indexed? No

May be Null? Yes

The start date of the disbursement plan period for the position.

DISBURSEMENT_PLAN_PERIOD

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The descriptive text indicating the disbursement plan period for the position.

EARLIEST_HIRE_DATE

Format DATE

Indexed? No

May be Null? Yes

The worker's first date of hire into the position.

END_EMPLOYMENT_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which employment will end for a fixed term position.

EXEMPT_POSITION_FLAG

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

Indicates whether the position is considered exempt. Under Federal law, employees are either exempt (Y) or nonexempt (N) from the Fair Labor Standards Act (FLSA) wage and hour regulations. Monthly-paid staff are exempt, and weekly-paid staff are non-exempt.

FTE_PERCENT

Format NUMBER

Indexed? No

May be Null? Yes

The ratio of a worker's scheduled weekly hours divided by the default weekly hours. This drives benefits eligibility.

HOURLY_RATE

Format NUMBER

Indexed? No

May be Null? Yes

The hourly rate for the position.

JOB_PROFILE_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The system identifier of the job profile for the position. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code.

JOB_PROFILE_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The name of the job profile for the position.

LAST_BASE_PAY_INCREASE_AMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

The amount of the last increase to the base pay amount.

LAST_COMPENSATION_CHANGE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The text describing the activity of the last compensation change.

LAST_COMPENSATION_CHANGE_DATE

Format DATE

Indexed? No

May be Null? Yes

The date the compensation for the position was last changed.

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.

MANAGER_PENN_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The Penn ID of the manager for the position.

MANAGER_WORKDAY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The Workday ID of the manager for the position.

OCCUPANT_FROM_DATE

Format DATE

Indexed? No

May be Null? Yes

The date from which the worker occupied the position.

OCCUPANT_FROM_FISCAL_YEAR

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The fiscal year from which the worker occupied the position.

OCCUPANT_FROM_YEAR

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The calendar year from which the worker occupied the position.

PAY_GROUP

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The pay group (e.g., academic, monthly, weekly) assigned to the position. Workers may not concurrently hold positions with different pay groups.

PAY_RATE_TYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The pay status (hourly or salaried) for the position.

PENN_CREF

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The default Chart of Accounts Center Reference code segment value (CREF) used in costing allocations for the position.

PENN_FUND

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The default Chart of Accounts Fund code segment value used in costing allocations for the position.

PENN_PROGRAM

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The default Chart of Accounts Program code segment value used in costing allocations for the position.

POSITION_EMPLOYEE_TYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The employee type assigned to the position (e.g. academic, staff, student).

POSITION_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The unique system identifier for the position.

POSITION_PENN_COST_CENTER

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 4-digit number for the Penn Cost Center associated with the position.

POSITION_SCHOOL_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 position.

POSITION_STATUS

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The status of the position.

POSITION_TITLE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The title for the position.

POSITION_VACATED_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the worker left the position.

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_POSITION_FLAG

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

For individuals with multiple current positions, a Y/N flag indicating the primary position.

PRIOR_INCUMBENT_EMPLOYEE_ID

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Workday ID of the prior incumbent of the position.

PRIOR_INCUMBENT_PENN_ID

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Penn ID of the prior incumbent of the position.

SUPERVISORY_ORG_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The system name representing the Supervisory Organization for the position.

SUPERVISORY_ORG_NAME

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The descriptive name representing the Supervisory Organization for the position.

TIME_TYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

A descriptive indicator of the time status for the position. This is not in any way or calculated based on the FTE_Percent.

TOTAL_BASE_AMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

The total base salary amount for the position.

WORKDAY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The unique ID for the worker in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID.

WORKER_PENN_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 8-digit identification number assigned to the worker 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.

 
HCM_POSITION 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