GPGB_CO_FILEREF(SQL Table) |
Index Back |
---|---|
Court Orders files recordRecord for Court Order file references |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | GPGB_CO_ORD_REF | Character(25) | VARCHAR2(25) NOT NULL | GPUK Court Order Reference |
3 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
4 | GPGB_NOTES | Character(254) | VARCHAR2(254) NOT NULL | Use field to hold notes for GP UK. |
5 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
7 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |