• ACCOUNTING_PERIOD
• ANTICIPATED_FUNDS
• ANTICIPATED_FUNDS_LFY
• ANTICIPATED_FUNDS_LM
• ANTICIPATED_FUNDS_LY
• AVERAGE_SALARY
• AVERAGE_SALARY_LFY
• AVERAGE_SALARY_LM
• AVERAGE_SALARY_LY
• DESIGNATED_FUNDS
• DESIGNATED_FUNDS_LFY
• DESIGNATED_FUNDS_LM
• DESIGNATED_FUNDS_LY
• EMPLOYEE_SALARY
• EMPLOYEE_SALARY_LFY
• EMPLOYEE_SALARY_LM
• EMPLOYEE_SALARY_LY
• EXTERNAL_FUNDS
• EXTERNAL_FUNDS_LFY
• EXTERNAL_FUNDS_LM
• EXTERNAL_FUNDS_LY
• FISCAL_YEAR
• FUNDS_SALARY_DIFF
• FUNDS_SALARY_DIFF_LFY
• FUNDS_SALARY_DIFF_LM
• FUNDS_SALARY_DIFF_LY
• GENERAL_OPERATING_FUNDS
• GENERAL_OPERATING_FUNDS_LFY
• GENERAL_OPERATING_FUNDS_LM
• GENERAL_OPERATING_FUNDS_LY
• JOB_DEPT_ORG
• JOB_SCHOOL_CTR

• PERCENT_FULL_TIME
• PERCENT_FULL_TIME_LFY
• PERCENT_FULL_TIME_LM
• PERCENT_FULL_TIME_LY
• PERSONAL_CLASS
• POSITION_COMPARE_PK
• POSITION_COUNT
• POSITION_COUNT_LFY
• POSITION_COUNT_LM
• POSITION_COUNT_LY
• POSITION_STATUS
• SALARY_COMMITMENT
• SALARY_COMMITMENT_LFY
• SALARY_COMMITMENT_LM
• SALARY_COMMITMENT_LY
• SERVICE_CENTER_FUNDS
• SERVICE_CENTER_FUNDS_LFY
• SERVICE_CENTER_FUNDS_LM
• SERVICE_CENTER_FUNDS_LY
• SPONSORED_PROGRAM_FUNDS
• SPONSORED_PROGRAM_FUNDS_LFY
• SPONSORED_PROGRAM_FUNDS_LM
• SPONSORED_PROGRAM_FUNDS_LY
• TOTAL_FUNDS
• TOTAL_FUNDS_LFY
• TOTAL_FUNDS_LM
• TOTAL_FUNDS_LY
• TOTAL_OPERATING_FUNDS
• TOTAL_OPERATING_FUNDS_LFY
• TOTAL_OPERATING_FUNDS_LM
• TOTAL_OPERATING_FUNDS_LY

The Accounting Period stated in MON-YY format. MON is the calendar month (stored in upper case), and YY is the calendar year. Note that the beginning and ending dates of an ACCOUNTING_PERIOD are not the same as the first and last day of the calendar month.

Example: JUL-97 (July 1997, which occurs in fiscal year 1998).

The sum of payments and remaining encumbrances for the accounting period from fund 000001. Derived from the Salary Management system.

The sum of payments and remaining encumbrances for the as of the end of the previous fiscal year from fund 000001. Derived from the Salary Management system.

The sum of payments and remaining encumbrances for the previous accounting period from fund 000001. Derived from the Salary Management system.

The sum of payments and remaining encumbrances for the same period in the previous year from fund 000001. Derived from the Salary Management system.

The average salary for a Position Status or Personnel Class. Average salary is derived from the Employee Salary and is calculated as Salary divided by Position Count.

The average salary for a Position Status or Personnel Class as of the end of the previous fiscal year. Average salary is derived from the Employee Salary and is calculated as Salary divided by Position Count.

The average salary for a Position Status or Personnel Class for the previous accounting period. Average salary is derived from the Employee Salary and is calculated as Salary divided by Position Count.

The average salary for a Position Status or Personnel Class for the same period in the previous year. Average salary is derived from the Employee Salary and is calculated as Salary divided by Position Count.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the accounting period from fund numbers that begin with 4 (endowment funds), 6 (gift funds), and to the extent that they exist, fund numbers that begin with 1, 2, 3, 7, 8, or 9. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances as of the end of the previous fiscal year from fund numbers that begin with 4 (endowment funds), 6 (gift funds), and to the extent that they exist, fund numbers that begin with 1, 2, 3, 7, 8, or 9. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the previous accounting period from fund numbers that begin with 4 (endowment funds), 6 (gift funds), and to the extent that they exist, fund numbers that begin with 1, 2, 3, 7, 8, or 9. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the same period in the previous year from fund numbers that begin with 4 (endowment funds), 6 (gift funds), and to the extent that they exist, fund numbers that begin with 1, 2, 3, 7, 8, or 9. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

For Monthly Paid and Weekly (type 2, as designated in Payroll) employees: Salary is derived from the Annual Salary field in the Employee Job record in the Payroll/Personnell system.

For other Weekly Paid employees (type 3), salary is computed using the rate and hours in the Employee Job record. Assumptions: Weekly Paid are assumed to work a 35-hour week, 52 weeks a year (salary will be determined by the first condition an employee meets)

• If hours and rate are both = 0, then salary = 0
• If hours = 0, but percent full time is greater than 0, then salary = rate * 35 * percent full-time * 52
• If hours are greater than zero but less than 35, then salary = rate * hours * 52

Salary is computed for Non-filled Positions as follows:

If the position was previously filled, the previous incumbent's salary is used, as computed above. If the position has never been filled, the average of active, primary appointments with the same job class is computed and used. If a reasonable average is unavailable, the annualized salary using the midpoint for the job class (maximum minus minimum, divided by 2, with adjustments for Weekly Paid employees) is computed and used. If a reasonable midpoint is unavailable, the average of active, primary appointments with the same Personnel Class (Administrative/Professional, Support Staff of Unionized Staff) is computed and used.

Indexed - no
Format - number(11,2)
May be null - yes

Employee Salary as of the end of the previous fiscal year.

Indexed - no
Format - number(11,2)
May be null - yes

Employee Salary for the previous accounting period.

Indexed - no
Format - number(11,2)
May be null - yes

Employee Salary for the same period in the previous year.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the accounting period from non-university commitments (ie. anything with an object code of 1251, 1252, 1253, 1254, 1521, 1522, 1524; or anything from a "9-fund" with an object code between 5000 and 5199). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances as of the end of the previous fiscal year from non-university commitments (ie. anything with an object code of 1251, 1252, 1253, 1254, 1521, 1522, 1524; or anything from a "9-fund" with an object code between 5000 and 5199). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances from the previous accounting period from non-university commitments (ie. anything with an object code of 1251, 1252, 1253, 1254, 1521, 1522, 1524; or anything from a "9-fund" with an object code between 5000 and 5199). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances from same period in the previous year from non-university commitments (ie. anything with an object code of 1251, 1252, 1253, 1254, 1521, 1522, 1524; or anything from a "9-fund" with an object code between 5000 and 5199). Derived from the Salary Management system.

Indexed - yes
Format - char(4)
May be null - yes

The financial year. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.

Example: 1998 (fiscal year that began July 1, 1997, and ended June 30, 1998)

Indexed - no
Format - number(11,2)
May be null - yes

The difference between Total Funds and Total Salary Commitment. (Total Salary is subtracted from Total Funds.)

Indexed - no
Format - number(11,2)
May be null - yes

The difference between Total Funds and Total Salary Commitment as of the end of the previous fiscal year. (Total Salary is subtracted from Total Funds.)

Indexed - no
Format - number(11,2)
May be null - yes

The difference between Total Funds and Total Salary Commitment for the previous month. (Total Salary is subtracted from Total Funds.)

Indexed - no
Format - number(11,2)
May be null - yes

The difference between Total Funds and Total Salary Commitment for the same period in the previous year. (Total Salary is subtracted from Total Funds.)

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the accounting period from General Operating Funds -- those fund numbers that begin with 0, except funds 000001 and 000011. (e.g. general university funds). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances as of the end of the previous fiscal year from General Operating Funds -- those fund numbers that begin with 0, except funds 000001 and 000011. (e.g. general university funds). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the previous accounting period from General Operating Funds -- those fund numbers that begin with 0, except funds 000001 and 000011. (e.g. general university funds). Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the same period in the previous year from General Operating Funds -- those fund numbers that begin with 0, except funds 000001 and 000011. (e.g. general university funds). Derived from the Salary Management system.

Indexed - yes
Format - char(4)
May be null - yes

The 4-digit number identifying the Organization having primary responsibility for this job appointment. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:

Refer to the ORG_CODES table for values.

Indexed - yes
Format - char(2)
May be null - yes

A 2-digit number used to identify the school or center having primary responsibility for this job appointment. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)

Values:

Refer to the CNAC_CODES table, for values where 

Home_School_Ctr||'0' = CNAC_Code. 

Indexed - no
Format - number(9,2)
May be null - yes

The percentage of full-time work completed by the employee for the job during a pay period. The value is estimated by the department, as a percentage of the standard number of hours in the work week for the Job_Class.

Example: For an employee holding a job with 40 standard work hours per week, who works 20 hours a week: 50 (50%)

Indexed - no
Format - number(9,2)
May be null - yes

The percentage of full-time work completed by the employee for the job during a pay period, for the last period in the last fiscal year.

Indexed - no
Format - number(9,2)
May be null - yes

The percentage of full-time work completed by the employee for the job during a pay period, for the previous accounting period.

Indexed - no
Format - number(9,2)
May be null - yes

The percentage of full-time work completed by the employee for the job during a pay period, for the same period in the previous year.

Indexed - yes
Format - char (1)
May be null - yes

The class to which a position is assigned as a function of employee type and or job grade. Includes only those classes subject to the HR-1 process (the form used to request a position posting from Human Resources). Executive, Faculty (unless they hold an Administrative posting as well), Non-Employees, and Student Workers are excluded. Payments-to-date and projected encumbrances are reported for all Personnel Classes with the exception of Temporary staff. For Temporary staff, only payments are included. [Note: "Type" of employee, below, is derived from the EMP TYPE in the Personnel/Payroll system.]

Administrative/Professional: Type 1 employees with

 Job Grade not equal to FAC (Faculty)

Support Staff: Meeting any of the following criteria:

   -Type 2 employees, first position having

    Job Grade between 021 and 032 or any Job Grade A-H

   -Type 2 or 3 employees with a Job Grade equal to

    LIM (would otherwise be categorized as Temporary;

    includes Limited Service Clerk, Limited Service

    Positive, Limited Service Exception and Theatre

    Tech)

   -Job Class = 515550 - Regular Part-time

    (would otherwise be classified as Temporary)

   -Job Class = 515515 - Regular Part-time

    (would otherwise be classified as Temporary)

Unionized Staff: Job Grade = U

Temporary Staff: Only payments-to-date reported, no

 projected encumbrances

   -Job Grade = TEM

   -Employee Type = 3, Job Grade not = U

   -Job Class = 855150 - Occasional workers

Indexed - no
Format - number(9)
May be null - no

The unique identifier for a row in the POSITION_COMPARISON_SUMMARY table.

Indexed - no
Format - number(7)
May be null - yes

Indexed - no
Format - number(7)
May be null - yes

as of the end of the previous fiscal year

Indexed - no
Format - number(7)
May be null - yes

for the previous accounting period

Indexed - no
Format - number(7)
May be null - yes

for the same period in the previous year

Indexed - yes
Format - char (1)
May be null - yes

A position is a post of employment offered by an organization within the University for a given job classification. A position can have a status of Approved, Discontinued, Filled, or Vacated. Be aware that Position Status is distinct from and unrelated to job classification, and that reclassification of a job will not affect position status. Promotion or transfer of a current employee to another position, however, would affect the status of both new and old positions. Position Status is derived from the Payroll/Personnel system.

Approved: A position has been created online and has 

been approved to be filled. Only persons with the

proper authority can approve a position.

For Schools, Position Status automatically returns

to Approved rather than Vacated when the

employee leaves the position.



Discontinued: The position cannot be refilled.

Only persons with the appropriate authority

can discontinue a position.



Filled: A School or Center has assigned an employee

to a position on the Job screen in the

Payroll/Personnel system. Includes employees on

leave of absence.



Vacated: A position exists but is currently unfilled.

This is the default for Administrative Centers. For

Schools, Position Status automatically

returns to Approved rather than Vacated when

the employee leaves the position.

Indexed - no
Format - number(11,2)
May be null - yes

The portion of the annualized salary that is payable this fiscal year. Salary Commitment compensates for instances when a person leaves before the end of the fiscal year, or begins after the start of the fiscal year, or when a position is filled by more than one person at different times during the course of the year. If a position is filled more than once in the course of the year, all distinct instances of "filled" status will be taken into account when summing the salary commitment. Dollar amounts represent a combination of payments made to date plus remaining encumbrances for the fiscal year. Historical data is based on actual payments to employees rather than projected Payroll distributions and takes start and end date into account.

The computation process for Salary Commitment is as follows:

1. All positions for the fiscal year are scanned, 

   and the following information is extracted for each 

   filled entry:




- Annualized salary, as computed in Employee_Salary.

- Fiscal year begin date, or position assignment 

  start date, whichever comes last.

- Fiscal year end date, or position assignment end 

  date, whichever comes first.



  Position Assignment End Date is adjusted to avoid 

  overlap. If someone leaves a position, the Position 

  Assignment End Date may still contain the original 

  value; if so, for the purposes of calculation, it is 

  changed to reflect the date when the position was 

  vacated.  If someone is replaced in a position, the

  original incumbent's end date must be less than or 

  equal to the new incumbent's start date.  The 

  calculation does not account for position sharing.




2.  After the salary is annualized, it is divided by

    365 and multiplied by the number of position 

	assignment days to obtain Salary Commitment.

Indexed - no
Format - number(11,2)
May be null - yes

The portion of the annualized salary that is payable this fiscal year, as of the end of the previous fiscal year.

Indexed - no
Format - number(11,2)
May be null - yes

The portion of the annualized salary that is payable this fiscal year, for the previous accounting period.

Indexed - no
Format - number(11,2)
May be null - yes

The portion of the annualized salary that is payable this fiscal year, for the same accounting period in the previous year.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the accounting period from fund 000011. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances as of the end of the previous fiscal year from fund 000011. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the previous period from fund 000011. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the same period in the previous year from fund 000011. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the accounting period from Sponsored Program Funds, where the fund number begins with 5. Usually, these are grant or contract funds that are awarded for a specific purpose and that are often government related. Examples are Wharton SBDC and Administrative/Professional staff who are paid from this fund number. Often calendar year based, so two funds may be applied for a fiscal year. Encumbrances are only calculated for the duration of the grant or contract. Derived from the Salary Management system.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances as of the end of the previous fiscal year from Sponsored Program Funds, where the fund number begins with 5.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the previous accounting period from Sponsored Program Funds, where the fund number begins with 5.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of payments and remaining encumbrances for the same period in the previous year from Sponsored Program Funds, where the fund number begins with 5.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of Total Operating, Designated, Sponsored Program, and External Funds.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of Total Operating, Designated, Sponsored Program, and External Funds as of the end of the previous fiscal year.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of Total Operating, Designated, Sponsored Program, and External Funds for the previous accounting period.

Indexed - no
Format - number(11,2)
May be null - yes

The sum of Total Operating, Designated, Sponsored Program, and External Funds for the same period in the previous year.

Indexed - no
Format - number(11,2)
May be null - yes

Sum of General Operating, Anticipated and Service Center Funds Designated Funds.

Indexed - no
Format - number(11,2)
May be null - yes

Sum of General Operating, Anticipated and Service Center Funds Designated Funds as of the end of the previous fiscal year.

Indexed - no
Format - number(11,2)
May be null - yes

Sum of General Operating, Anticipated and Service Center Funds Designated Funds for the previous accounting period.

Indexed - no
Format - number(11,2)
May be null - yes

Sum of General Operating, Anticipated and Service Center Funds Designated Funds for the same period in the previous year.