PROCESS_INSTANCEA=Agency
T=Treasury
E=Fair Value Missing
F=Fail
P=Pass
N=No
Y=Yes
GTAS_EDITS_AET(SQL Table) |
Index Back |
|---|---|
GTAS Run EditsGTAS Run Edits |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 6 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | REPORT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
| 9 | TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 10 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 11 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 12 | EDIT_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Edit Category
A=Agency T=Treasury |
| 13 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 14 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |
| 15 | PASS_FAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pass / Fail
E=Fair Value Missing F=Fail P=Pass |
| 16 | FILEREFPATH | Character(128) | VARCHAR2(128) NOT NULL | File Reference Path |
| 17 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 18 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |