Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  Query the warehouse
What you need
Access request forms
Password change
Query tool software
Training options
Tips
  
  Related information
About the warehouse
Data Administration
Security
Support services
Warehouse updates
  
  Data collections
advancement
assets
brs
faculty
general ledger
position inventory
research
salary management
space@penn
student
tuition distribution
cross-collection

Salary Management Collection Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

BUDGET_BASE
Table   Elements

BUDGET_DISTRIBUTION
Table   Elements

COUNTRY_CODE
Table   Elements

EMPLOYEE
Table   Elements

EMPLOYEE_ADDRESS
Table   Elements

EMPLOYEE_BENEFITS
Table   Elements

EMPLOYEE_DISTRIBUTION
Table   Elements

EMPLOYEE_ENCUMBRANCE
Table   Elements

EMPLOYEE_ENCUMBRANCE_CURRENT
Table   Elements

EMPLOYEE_GENERAL
Table   Elements

EMPLOYEE_JOB
Table   Elements

EMPLOYEE_PAYMENT
Table   Elements

EMPLOYEE_PAYMENT_SUMMARY
Table   Elements


Snapshot versions of select tables are also available.

JOB_CLASS
Table   Elements

JOB_CLASS_GENERAL
Table   Elements

MAIL_CODE
Table   Elements

PAR_DOLLAR_GTN_ADJUSTMENTS
Table   Elements

PAR_EARNINGS
Table   Elements

PAR_GROSS_TO_NET
Table   Elements

PAR_HOUR_ADJUSTMENTS
Table   Elements

PAR_MAIN
Table   Elements

PAR_TAX_ACH_BENEFITS
Table   Elements

PAYROLL_CHANGE_LOG
Table   Elements

PAYROLL_DATA_ELEMENT
Table   Elements

PAYROLL_EARNINGS
Table   Elements

PAYROLL_GROSS_TO_NET
Table   Elements

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania