Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_ATTACHMENT Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_ATTACHMENT Table

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.

Primary Key Indexed Data Elements Related Tables
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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania