SOCS_AUTH_KEY_ESPGPES_YEARGPES_MONTHFILE_NAMEA=Attached
G=Generated
L=Loaded
B=XML of Bases
D=Request of a Draft
R=Response
GPES_CRT_LQ_DOC(SQL Table) |
Index Back |
|---|---|
CRT Liquidation DocAttachment Document for Creta Reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOCS_AUTH_KEY_ESP |
Character(8) | VARCHAR2(8) NOT NULL | Authorization Key |
| 2 | GPES_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 3 | GPES_MONTH |
Number(2,0) | SMALLINT NOT NULL | Month |
| 4 | FILE_NAME |
Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | TIME_STAMP_ESP | DateTime(26) | TIMESTAMP | Time Stamp |
| 7 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 8 | GPES_CRT_DOC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Liquidation Doc Status:
- Generated. G
- Attached. A
- Loaded. L
A=Attached G=Generated L=Loaded |
| 9 | GPES_CRT_DOC_TMPLT | Character(1) | VARCHAR2(1) NOT NULL |
Liquidation Doc Template Type
- D Request of a Draft
- B XML of Bases
- R Response
B=XML of Bases D=Request of a Draft R=Response |
| 10 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 11 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |