Penn Computing

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

COMP_ATTACHMENT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ATTACHMENT_NAME

Indexed - no
Format - varchar2 (300)
May be null? yes
A description (e.g., file name) of the attachment.
 
COMP_ATTACHMENT_GROUP_ID

Indexed - yes
Format - number (22)
May be null? yes
Uniquely identifies the group of attachments, if any, to which the particular attachment record belongs.
COMP_ATTACHMENT_ID

Indexed - yes
Format - number (22)
May be null? no
Uniquely identifies a record in the COMP_ATTACHMENT table.
CREATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who created the record in the PennWorks Additional Pay module.
 
CREATION_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was created in the PennWorks Additional Pay module.
 
EXTRACT_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the COMP_ATTACHMENT record was loaded to the Data Warehouse.
 

LAST_UPDATE_DATE

Indexed - no
Format - date (7)
May be null? yes

The date on which the record was last updated in the PennWorks Additional Pay module.

LAST_UPDATE_TIMESTAMP

Indexed - no
Format - timestamp (6)
May be null? yes


The timestamp on which the record was last updated in the PennWorks Additional Pay module.
 
LAST_UPDATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who last updated the record in the PennWorks Additional Pay module.
 

COMP_ATTACHMENT Table   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