HYP_SALARY Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

HYP_SALARY Table

Explanation
Contains salary budget and forecast information from Hyperion Planning (PennPln1, PennPln2 and PennPln3 applications, as well as the CPUP Planning application).

Common Uses
Displaying indivudal budget or forecast salary detail, by person or Home ORG.

ACCOUNT
ACCOUNTING_PERIOD
PENN_ID
SCENARIO
VERSION

ACCOUNT
ACCOUNTING_PERIOD
BUDGET_CHECK
CNAC
CREF
FISCAL_MONTH_SEQ
FISCAL_YEAR
FUND
OBJECT
ORG
PENN_ID
PERIOD
PROGRAM
RESP_ORG
SCENARIO
VERSION
YEAR

EMPLOYEE
EMPLOYEE_GENERAL
CENTER_REF_CODES
CNAC_CODES
OBJECT_CODES
ORG_CODES
PROGRAM_CODES

Cautions

• You can access HYP_SALARY data for an only if you authorized to access data for the employee's home school or organization, or the account Org or Responsible_Org.
• If you are using Business Objects Desktop Intelligence, you can find this data in the "Planning Salary Detail" class in the RSALMGT universe.
• The HYP_SALARY table is stored in the DWHYP schema in the Data Warehouse..

HYP_SALARY Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home