| Data element |
Definition |
COMP_ACT_END_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fiscal year of the end of the compensation plan for the position. |
COMP_ACTUAL_END_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The end date of the compensation plan for the position. |
COMP_ACTUAL_END_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The calendar year of the end of the compensation plan for the position. |
COMP_EFF_START_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fiscal year of the start of the compensation plan for the position. |
COMP_EFFECTIVE_START_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The effective start date of the compensation plan for the position. |
COMP_EFFECTIVE_START_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The calendar year of the start of the compensation plan for the position. |
COMPENSATION_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The amount of compensation, for the particular compensation plan and element, for the position. |
COMPENSATION_ELEMENT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name of the smallest unit of compensation for specific position. Compensation elements, such as base pay, comprise compensation plans. |
COMPENSATION_ELEMENT_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system ID of the smallest unit of compensation for specific position. Compensation elements, such as base pay, comprise compensation plans. |
COMPENSATION_FREQUENCY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The frequency pertaining to the compensation for the position. |
COMPENSATION_GRADE_DESC
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name of the compensation grade assigned to the position. |
COMPENSATION_GRADE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system ID of the compensation grade assigned to the position. |
COMPENSATION_PERCENT
Format NUMBER
Indexed? No
May be Null? Yes |
The percentage of the compensation, for the particular compensation plan and element, for the position. |
COMPENSATION_PLAN_DESC
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name of a compensation plan associated with the position. A compensation plan is a component of pay used to assign monetary amounts to a worker's pay. For example, in addition to salary there are allowances, such as a car allowance, or a cell phone allowance. Some compensation plans, for example, an award, are discretionary. An employee is not paid from these compensation plans in every paycheck. By contrast, other plans, like a salary plan, are included in every paycheck |
COMPENSATION_PLAN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system ID of a compensation plan associated with the position. A compensation plan is a component of pay used to assign monetary amounts to a worker's pay. For example, in addition to salary there are allowances, such as a car allowance, or a cell phone allowance. Some compensation plans, for example, an award, are discretionary. An employee is not paid from these compensation plans in every paycheck. By contrast, other plans, like a salary plan, are included in every paycheck |
COMPENSATION_PLAN_TYPE
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The type (Allowance, Hourly, Salary) grouping for a compensation plan associated with the 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. |
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. |
POSITION_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
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? No
May be Null? Yes |
The status of the position. |
POSITION_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Supervisory Organization for the position. |
POSITION_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name representing the Supervisory Organization for 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. |
TOTAL_BASE_PAY
Format NUMBER
Indexed? No
May be Null? Yes |
The total base salary amount for the position. |
TOTAL_PAY
Format NUMBER
Indexed? No
May be Null? Yes |
The total pay amount (for all compensation plans) 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. |
