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

COMP_ATTACHMENT Table

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

Explanation
Contains information about files that have been attachment to PennWorks records (e.g., Additional Pay requests).

Common Uses
To determine the file name and related attributes about attachments to PennWorks records.

COMP_ATTACHMENT_ID

COMP_ATTACHMENT_GROUP_ID

COMP_PAY_PERSON (DWCOMP)
COMP_PAY_REQUEST (DWCOMP)

Cautions

• This table contains information about files attached to PennWorks records. While the attachment files themselves are not stored in the Warehouse, you may use this table to determine the name of attachment files, and when the associated records were created and last updated.

• The COMP_ATTACHMENT table can be found in the DWCOMP schema.

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