| Data element |
Definition |
ACCOUNTING_DATE
Format DATE
Indexed? No
May be Null? Yes |
The accounting date pertaining to the encumbrance record. |
ACCOUNTING_PERIOD
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The financial Accounting Period in which the encumbrance accounting date falls. |
BATCH_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The identifier for the BEN Financials batch job under which the encumbrance was posted. |
ENCUMBRANCE_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The amount of the employee's salary encumbered for the Posted_COA_Account from the Encumbrance_Start_Date through the Encumbrance_End_Date inclusive. The Encumbrance_Amount represents funds that have been encumbered but have not yet been spent for a specific approved planned expenditure (in this case, salaries). These funds cannot be used for any other purpose, unless the encumbrance is removed. Only the latest encumbrance is stored for a given Accounting_Period, so, for weekly employees, the amount will likely appear to decrease through the period as the encumbrance is relieved. |
ENCUMBRANCE_DATE_CREATED
Format DATE
Indexed? No
May be Null? Yes |
The date on which the encumbrance was created. |
ENCUMBRANCE_END_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The date on which the salary encumbrance ends for this employee for this Posted_COA_Account for this Accounting_Period. |
ENCUMBRANCE_END_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The financial year within which the Encumbrance_End_Date falls. |
ENCUMBRANCE_END_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The calendar year within which the Encumbrance_End_Date falls. |
ENCUMBRANCE_HEADER_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The unique identifier of the encumbrance journal header. |
ENCUMBRANCE_START_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The date on which the salary encumbrance begins for this employee for this Posted_COA_Account for this Accounting_Period. |
ENCUMBRANCE_START_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The financial year within which the Encumbrance_Start_Date falls. |
ENCUMBRANCE_START_YEAR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The calendar year within which the Encumbrance_Start_Date falls. |
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? No
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. |
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? No
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? No
May be Null? Yes |
The pay period end date pertaining to the encumbrance record.
|
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 encumbrance was made. This sequence number is found in the HISTORY_SEQUENCE field on the POSITION_HISTORY table. The corresponding position history is that where the encumbrance's position ID matches the position history position ID and the encumbrance's encumbrance end date falls between the position history SCD start and end dates. |
POSITION_PENN_COST_CENTER
Format VARCHAR2(200)
Indexed? No
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? No
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 account for which the employee's salary is encumbered from the Encumbrance_Start_Date through the Encumbrance_End_Date |
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. |
UPDATED_ON
Format DATE
Indexed? No
May be Null? Yes |
|
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
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_ENCUMBRANCE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique identifier of a row in the HCM_WORKER_ENCUMBRANCE table. |
