| Data element |
Definition |
ACCOUNTING_DATE
Format DATE
Indexed? No
May be Null? Yes |
The accounting date pertaining to the payment record. |
ACCOUNTING_PERIOD
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The financial Accounting Period in which the payment accounting date falls. |
CHECK_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
Date on which the payment is available to the employee, or the effective date of an adjustment. |
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. |
EARNING_DESC
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The description of the earning code associated with the payment record. |
FISCAL_MONTH_SEQ
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The month (or accounting period) of the fiscal year. Note that leading zeroes are used for months 01-09 (July through March). |
FISCAL_SORT_SEQ
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The fiscal year and month pertaining to the accounting period in format YYYYMM. |
FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The financial year within which the Accounting_Period falls |
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. |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from the BEN Payroll Reallocation system and loaded to the Data Warehouse. |
LEGACY_EARNING_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The earning code associated with the reallocated legacy 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. |
LEGACY_ISN
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Legacy Integration Sequence Number |
LEGACY_JOB_CLASS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The 6-digit code indicating the job for which the reallocated legacy payment was made. Key to the job classification table where the job attributes arelisted. Refer to Job_Title in the JOB_CLASS or JOB_CLASS_GENERAL tables to find the title which currently corresponds to the Job_Class. As a resultof the University's Classification Redesign Project, a new job classificationsystem for staff positions was developed in 1998. Job classes in the onlinePayroll system and the Data Warehouse were converted to this new systemover April 8 - 9, 1998. For jobs that were reclassified, records beforethis date will contain the old class, and records after this date will reflect the new scheme. Some classes were reused, however (and only the attributes now used for those classes are available). Faculty classes were unaffectedby this conversion.
Example: 226010 (Associate Professor C-E)
Values:
Refer to the DWADMIN.JOB_CLASS table for values.
|
OFFCYCLE_PAYMENT_REASON
Format VARCHAR2(255)
Indexed? No
May be Null? Yes |
Indicated the reason for the offcycle payment. |
OFFCYCLE_PAYMENT_TYPE
Format VARCHAR2(255)
Indexed? No
May be Null? Yes |
Indicates the Payment Type for offcycle payments. |
PAY_FREQUENCY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The frequency pertaining to the compensation for 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_PERIOD_END_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The pay period end date pertaining to the payment record.
|
PAYMENT_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The amount of the Earnings_Code paid from the Posted_COA_Account to the employee for the job on the Check_Date; or the amount of the reallocation. Credits to an account will appear as negative amounts. There may be more than one record per employee per account per period, depending upon Earnings_Type. |
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. |
POSITION_LINK_ID
Format NUMBER
Indexed? Yes
May be Null? Yes |
The unique sequence number that identifies the position (in the HCM_POSITION_HISTORY table) for which the payment was made. This sequence number is found in the HISTORY_SEQUENCE field on the POSITION_HISTORY table. The corresponding position history record is that where the payment's position ID matches the position history position ID and the payment's pay period end date falls between the position history SCD start and end dates. |
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? No
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. |
POSTED_COA_ACCOUNT
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 26-digit account number from the present General Ledger accounting structure (in use at Penn since July 1, 1996) indicating the source of the payment to the employee. |
POSTED_COA_BC
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The budgetary control character that represents the level at which funds availability checking occurs. Posted_COA_BC is the third segment of the Posted_COA_Account. |
POSTED_COA_CENTER_REF
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Center Reference Code. A 4-character identifier uniquely defined by each School or Center. Posted_COA_Center_Ref is used to record information that is important to a school or center but is inappropriate for any other segment of the Posted_COA_Account. The value of the Posted_COA_Center_Ref is unique within a school or center. Posted_COA_Center_Ref is the seventh and last segment of the Posted_COA_Account. |
POSTED_COA_CNAC
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 3-character Center Net Asset Class. The first two positions of the Posted_COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). Posted_COA_CNAC is the first segment of the Posted_COA_Account. |
POSTED_COA_FUND
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 6-character fund code. A fund is the unique identifier for a specific set of financial resources that needs tracking or management. Posted_COA_Fund is the fourth segment of the Posted_COA_Account. |
POSTED_COA_OBJECT
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-character Object Code that identifies the asset, liability, revenue, or expense. Posted_COA_Object is the fifth segment of the Posted_COA_Account. |
POSTED_COA_ORG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-character code indicating the Organization. An Organization is a subdivision of the University created for management purposes. An Organization belongs to only one responsibility center, and its Organization code is unique. That is, no two Organizations will have the same values for Posted_COA_Org. Posted_COA_Org is the second segment of the Posted_COA_Account. |
POSTED_COA_PROGRAM
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-character code indicating the program. This is an activity or work process commonly defined across the University for tracking a program's activity across Schools and Centers (or across organizations within a school or center). Posted_COA_Program is the sixth segment of the Posted_COA_Account. |
POSTED_COA_RESP_ORG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-character code for the organization responsible for managing the Posted_COA_Fund. Many organizations may use the same fund, but only one organization -- the Responsible_Org -- is accountable for managing the fund. Those who are authorized to access records for the Responsible_Org for the fund may access all records for the fund, regardless of the value of the Posted_COA_Org in the Posted_COA_Account for the record. |
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. |
PRI_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Supervisory Organization for the person's primary position. This field is only populated for workers with a current position. |
REALLOCAT_ORIG_PAY_SUBLED_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For payments that have been reallocated, the unique identifier of the original payment record. |
REALLOCAT_PAY_SUBLED_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For reallocation records, the unique identifier of the reallocation record. |
REALLOCATION_JUSTIFICATION
Format VARCHAR2(2000)
Indexed? No
May be Null? Yes |
For reallocation records, a URL pointing to the reallocation justification documentation for this reallocation.
Note: You must have access to the Payroll Reallocation application in order to view the justification documentation. |
REALLOCATION_REASON
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For reallocation records, the reason for the reallocation. |
REALLOCATION_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For reallocation records, the status of the reallocation. |
REALLOCATION_STATUS_DATE
Format DATE
Indexed? No
May be Null? Yes |
For reallocation records, the date on which the reallocation occurred. |
UPDATED_ON
Format DATE
Indexed? No
May be Null? Yes |
The date on which the payment record was updated. |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique ID for a worker or affiliate in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |
WORKER_PAYMENT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique identifier of a row in the HCM_WORKER_PAYMENT table. |
WORKER_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates the Worker Type (Employee or Contingent Worker) for the person. |
