Penn Computing

Penn Computing

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

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
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

COMP_ATTACHMENT
Table   Elements

COMP_CHANGE_LOG
Table   Elements

COMP_DISTRIBUTION
Table   Elements

COMP_DISTRIBUTION_EXT
Table   Elements

COMP_INCREASE_BATCH
Table   Elements

COMP_INCREASE_FACCOMP_TEMPLATE
Table   Elements

COMP_INCREASE_JUSTIFICATION
Table   Elements

COMP_INCREASE_PAY_ADJUSTMENTS
Table   Elements

COMP_INCREASE_ROLE
Table   Elements

COMP_INCREASE_ROLE_TEMPLATE
Table   Elements

COMP_PAY_DISTRIBUTION
Table   Elements

COMP_PAY_PERSON
Table   Elements

COMP_PAY_PERSON_DEPENDENT
Table   Elements

COMP_PAY_REQUEST
Table   Elements

COMP_PAY_ROUTING_HISTORY
Table   Elements

COMP_PAY_STAGING
Table   Elements

COMP_PERSON
Table   Elements

COMP_PERSON_ADDRESS
Table   Elements

COMP_PERSON_ROLE
Table   Elements

COMP_PERSON_ROLE_JOINT_ORG
Table   Elements

COMP_PERSON_SALARY
Table   Elements

COMP_PERSON_SALARY_SUMMARY
Table   Elements

COMP_ROLE_JOB_CLASS_XREF
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

EMPLOYEE_TAX
Table   Elements

HYP_SALARY
Table   Elements

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_ACTION_CODES
Table   Elements

PAYROLL_CHANGE_LOG
Table   Elements

PAYROLL_DATA_ELEMENT
Table   Elements

PAYROLL_EARNINGS
Table   Elements

PAYROLL_GROSS_TO_NET
Table   Elements

Snapshot versions of select tables are also available.

 

PennWorks lookup tables (used to decode elements in the Salary Managment collection):
COMP_ACTION_TYPE_LOOKUP COMP_MARITAL_STATUS_LIST
COMP_ACADEMIC_CATEGORY_LOOKUP COMP_MILITARY_LIST
COMP_AFFILIATION_LIST COMP_PAY_ALLOWANCE_TYPE_LIST
COMP_CATEGORY_LOOKUP COMP_PAY_AWARD_TYPE_LIST
COMP_COUNTRY_LIST COMP_PAY_EXTRA_SERVICES_LIST
COMP_CITIZENSHIP_LOOKUP COMP_PAY_STATUS_LOOKUP
COMP_EMPLOYEE_GROUP_LIST COMP_PAY_TYPE_LOOKUP
COMP_EMPLOYEE_TYPE_LIST COMP_PUB_MAIL_CODE_LIST
COMP_EXT_DIST_SOURCE_LIST COMP_ROLE_DIST_STATE_LOOKUP
COMP_FACULTY_CLASS_LOOKUP COMP_ROLE_LOOKUP
COMP_GENDER_LIST COMP_SALARY_TYPE_LOOKUP
COMP_INCREASE_BATCH_BARG_UNIT COMP_SEPARATION_REASON_LIST
COMP_INCREASE_BATCH_TYPE_LIST COMP_STATE_LIST
COMP_JOB_FAMILY_LIST COMP_TERM_LOOKUP
COMP_JOB_GRADE_LIST COMP_UNION_LIST
COMP_JUSTIFICATION_LIST COMP_VISA_LIST
COMP_LEAVE_REASON_LIST  

Related GL reference tables included in the RSALMGT universe:

CENTER_REF_CODES
Table   Element
CNAC_CODES
Table   Element
FUND_CODES
Table   Element
OBJECT_CODES
Table   Element
ORG_CODES
Table   Element
PROGRAM_CODES
Table   Element

 

 

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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