| Data element |
Definition |
ADDITIONAL_INFORMATION
Format VARCHAR2(500)
Indexed? No
May be Null? Yes |
Additonal information associated with the one-time payment. |
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? Yes
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. |
COMPLETED_ON_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the one-time payment request was completed in Workday. |
COSTING_COA_CNAC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Chart of Accounts Center Net Asset code (CNAC) segment value used in the one-time payment request. |
COSTING_COA_CREF
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Chart of Accounts Center Reference (CREF) code segment value used in the one-time payment request. |
COSTING_COA_FUND
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Chart of Accounts Fund code segment value used in the one-time payment request. |
COSTING_COA_ORG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Chart of Accounts Organization (ORG) code segment value used in the request. |
COSTING_COA_PROGRAM
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Chart of Accounts Program code segment value used in the one-time payment request. |
COSTING_COA_RESP_ORG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fund responsible organization for the Fund code segment value used in the one-time payment request. |
COVERAGE_END_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The end date of the period to which the one-time payment applies. |
COVERAGE_END_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fiscal year of the coverage end date. |
COVERAGE_START_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The start date of the period to which the one-time payment applies. |
COVERAGE_START_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fiscal year of the coverage start date. |
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. |
OTP_EARNING_CODE
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The earning code associated with the payment record.
Workday Earnings Codes are similar, but may not be identical to, legacy Payroll earnings type values.
Refer to this spreadsheet for mapping from the Workday earnings codes to the legacy values. |
OTP_EARNING_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The description of the earning code associated with the payment record. |
OTP_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 |
OTP_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 |
OTP_SEND_TO_PAYROLL
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates that the one-time payment has been sent to payroll for processing '1' or not sent '0'. |
PAYMENT_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The one-time payment amount. There may be more than one record per employee per payment, depending upon the Earning Code, Compensation Element, and account segments. |
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_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. |
SCHEDULED_PAYMENT_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The scheduled date of of the one-time payment. The scheduled date of of the one-time payment. Payments are not issued unless the OTP_Send_to_Payroll indicator is set appropriately (value of ‘1’). |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
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. |
