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

COMP_PERSON_ROLE_JOINT_ORG Table

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

Explanation
Contains records associating role and organizations for organizations designated as Partner ORG(s) in joint appointments.

Common Uses
To determine organizations designated as Partner ORGs in Penn Integrates Knowledge (PIK) or joint appointments.

COMP_PERSON_ROLE_JOINT_ORG_ID

COMP_PERSON_ROLE_ID
HOME_CENTER
HOME_ORG
PENN_ID
ROLE_CENTER
ROLE_ORG

COMP_PERSON (DWCOMP)
COMP_PERSON_ROLE(DWCOMP)
ORG_CODES (DWADMIN)

Cautions

• At the time of this writing (October 2009), Partner/Joint organizations may only apply to faculty PIK or joint appointments, or to student work-study positions. For PIK/joint faculty appointments, the Partner ORG is designated by the administering organization. For student work-study positions, the Student Employment Office will automatically receive Partner ORG (view-only) access to the student’s record.

• As long as an ORG is designated as a Joint ORG for a role, users with access to that organization in PennWorks and the Salary Management collection will be able to view all biographic/demographic, role and distribution data for the employee, even if the organization is not the Home ORG.

• Historical snapshots of job information are available in the COMP_PERSON_ROLE_JNT_ORG_SNAP table, beginning with the NOV-09 period.

• You can access a COMP_PERSON_ROLE_JOINT_ORG row only if you are authorized to access data for the employee's home center or organization, the role center or organization, or a joint center or organization.

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