| 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.
|
