EMPLOYEE_ENCUMBRANCE Table
Note: This table is no longer updated, following the retirement of the mainframe Personnel/Payroll system and the implementation Workday@Penn in July 2019.
Explanation
Contains data on the amounts currently or previously encumbered for the salary
for each employee for each account. Encumbered funds have been set aside but
have not yet been spent for a specific planned approved expenditure (in this
case, salaries). These funds cannot be used for any other purpose, unless the
encumbrance is removed. The data is provided by a weekly extract from the Salary
Management system. In most cases, there is one row per employee per account
number per encumbrance per period.
Common Uses
To determine the amount currently or previously encumbered for salary expenses,
broken down by employee.
Primary Key |
Indexed Data Elements |
Related Tables |
ENCUMBRANCE_SEQUENCE_NUMBER
LAST_EXTRACT_DATE
POSTED_COA_ACCOUNT
SSN
|
ACCOUNTING_PERIOD
BATCH_ID
ENCUMBRANCE_ACCOUNT
ENCUMBRANCE_END_FISCAL_YEAR
ENCUMBRANCE_END_YEAR
ENCUMBRANCE_SEQUENCE_NUMBER
ENCUMBRANCE_START_FISCAL_YEAR
ENCUMBRANCE_START_YEAR
FISCAL_MONTH_SEQ
FISCAL_YEAR
HOME_DEPT
HOME_DEPT_ORG
HOME_SCHOOL
HOME_SCHOOL_CTR
JOB_CLASS
JOB_DEPT
JOB_DEPT_ORG
JOB_LINK_ID
JOB_SCHOOL
JOB_SCHOOL_CTR
LAST_EXTRACT_DATE
PENN_ID
POSTED_COA_ACCOUNT
POSTED_COA_CENTER_REF
POSTED_COA_CNAC
POSTED_COA_FUND
POSTED_COA_OBJECT
POSTED_COA_ORG
POSTED_COA_PROGRAM
RESPONSIBLE_ORG
SSN
UNIV_POSITION_NUMBER
|
CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_PERSON (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_ADDRESS (DWADMIN)
EMPLOYEE_DISTRIBUTION (DWADMIN)
EMPLOYEE_ENCUMBRANCE_CURRENT (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
EMPLOYEE_JOB (DWADMIN)
EMPLOYEE_PAYMENT (DWADMIN)
EMPLOYEE_PAYMENT_SUMMARY (DWADMIN)
FUND_CODES (DWADMIN)
JOB_CLASS (DWADMIN)
JOB_CLASS_GENERAL (DWADMIN)
OBJECT_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PAR_EARNINGS (DWADMIN)
PAR_MAIN (DWADMIN)
PROGRAM_CODES (DWADMIN)
|
Cautions
- To preserve encumbrance history in the Data Warehouse, each period's data
is appended to the existing table, rather than replacing it, although only
the latest encumbrance for a given period is stored. Encumbrances for weekly
paid employees, therefore, will appear to decrease through the accounting
period. This also makes footing to Salary Management reports for a period
rather complicated, as Salary Management stores the "current" encumbrance
balance only. The Data Warehouse is updated with payments and encumbrance
data directly following Salary Management, which may actually be a couple
days in advance of BEN Financials. To pull matching data from BEN Financials,
Salary Management and the Data Warehouse at the end of a period you'll need
to run your system reports and Warehouse queries between the Tuesday after
payroll runs, producing the last weekly check for the month, and before the
Monday of the following week. By that last Tuesday, monthly payroll has already
been run, so those actuals and updated encumbrances will be correct. This
limits the risk of retrieving data from Salary Management or the Warehouse
for the last weekly pay of the month which may, in fact, be posted to the
next BEN Financials Accounting Period. (For example, for AUG-99, reports would
have to have been run between August 27 and August 30th.)
- Keep in mind that encumbrances and payments for executive paid individuals
(JOB_CLASS.Personnel_Class 'EX' or EMPLOYEE_JOB.Appt_Employee_Type '6') are
not available in the Data Warehouse. These payments are stored in sum with all
others from the same account combination (by period) in the General Ledger
collection (and in BEN Financials) however, so cross-footing those account
combinations between Data Warehouse collections or system reports may be difficult.
- You can access an EMPLOYEE_ENCUMBRANCE record only if you are authorized
to access data for the employee's home school or organization, the job organization,
or the encumbrance account CNAC, ORG or Responsible_Org. Access to SSN is further restricted to specifically authorized individuals.
- The EMPLOYEE_ENCUMBRANCE Table contains both current and past encumbrances.
To access current encumbrances only, use the EMPLOYEE_ENCUMBRANCE_CURRENT
table.
- As a result of the University's Classification Redesign Project, a new job
classification system for staff positions was developed in 1998. Job classes
in the online Payroll system and the Data Warehouse were converted to this
new system over April 8 - 9, 1998. Some classes were reused, however; only
the attributes now used for those classes are available. Faculty classes were
unaffected by this conversion.
- Use of 9-digit Encumbrance_Account numbers was phased out at the end of
June 1998, when the Payroll system became fully compliant with the present
General Ledger accounting structure. This column should be null for all records
from fiscal year 1999 onward, and Posted_COA_Account should be used instead.
- Use of 5-character Payroll department codes and 2-character Payroll school
codes was phased out at the end of June 1998, when the Payroll system became
fully compliant with the present General Ledger accounting structure. These
columns should be null for all records from fiscal year 1999 onward; in these
records, refer to Dept_Org and School_Ctr columns instead.
- In the event that an employee holds two different jobs of the same Job_Class
paid by the same account, the Salary Management system does not track specifically
which encumbrances were made for which job. The Warehouse uses the following
logic to determine the position associated with an encumbrance (the position
is represented by the Job_Link_ID):
- If there is only one job, that job's Job Link ID appears on the encumbrance
row.
- If there's only one job with matching job class and appointment begin
/ end dates which fit the end date of the encumbrance accounting period,
that job's Job Link ID appears on the encumbrance row.
- The first distribution (lowest job sequence / distribution sequence number)
with (a) matching job class, (b) distribution start / stop dates and (c)
matching distribution account which fit the end date of the encumbrance
accounting period.
- If there are no jobs which fit the payment using the above three criteria,
the encumbrance is assigned to the primary appointment.
- The EMPLOYEE_ENCUMBRANCE table can be found in the DWADMIN schema, as DWADMIN.EMPLOYEE_ENCUMBRANCE_V.
Questions about this page? Email us at da-staff@isc.upenn.edu
|