GPCH_ATTACH_VW

(SQL View)
Index Back

Attachment View

GPCH Attachment View

SELECT GPCH_FILE_ID ,GPCH_FILE_CATEGORY ,URL_ID ,ATTACHSYSFILENAME ,ATTACHUSERFILE FROM PS_GPCH_ATTACH_REF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPCH_FILE_ID Character(128) VARCHAR2(128) NOT NULL GPCH File ID Field
2 GPCH_FILE_CATEGORY Character(30) VARCHAR2(30) NOT NULL File Group of the Attachment File
3 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
4 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File