GPCH_FILE_IDGPCH_ATTACH_VW(SQL View) |
Index Back |
|---|---|
Attachment ViewGPCH 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 |