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