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
Learning Management
OIP
Position Inventory
Research-PennERA Proposals
Salary Management
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

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