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

COMP_INCREASE_ROLE_TEMPLATE Table

Note: This table is no longer updated, following the retirement of PennWorks and the implementation Workday@Penn in July 2019.

Explanation
Contains data about employees and their roles as defined in PennWorks, to be used in preparatory stages of the annual Salary Increase Program. There is one record per employee/role with the role organization and start/end dates and salary rates currently defined for the role appointment.

Common Uses
To view, during the Salary Increase Program, current information for currently held roles, along with placeholder columns for planning dates and rates to take effect at the conclusion of the Salary Increase Program.

COMP_PERSON_ROLE_ID

HOME_CENTER
HOME_ORG
PENN_ID
ROLE_CENTER
ROLE_ORG

COMP_DISTRIBUTION (DWCOMP)
COMP_EMPLOYEE_GROUP_LIST (DWCOMP)
COMP_PERSON (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)

Cautions

• COMP_INCREASE_ROLE_TEMPLATE should be used only in the course of the Salary Increase Program, to view or export current role information before the conclusion of the program. This table does not hold planned salary rates or dates. For more complete information about roles held by an employee, refer to the COMP_PERSON_ROLE table.

• This table includes only rows for active (non-terminated) employees' roles where the current Role_State is Final.

• You can access a COMP_INCREASE_ROLE_TEMPLATE row only if you are authorized to view Salary Increase Program data in the Warehouse, and you are also authorized to access data for the employee's home center or organization, the role center or organization, or a current joint organization for the employee.

• The COMP_INCREASE_ROLE_TEMPLATE Table can be found in the DWCOMP schema.

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