OPRIDRUN_CNTL_IDTAS_GWASEQNBRA=Agency
T=Treasury
E=Fair Value Missing
F=Fail
P=Pass
GTAS_EDITS_DTL(SQL Table) |
Index Back |
|---|---|
GTAS Edits Details Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | TAS_GWA |
Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 4 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | EDIT_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Edit Category
A=Agency T=Treasury |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 8 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |
| 9 | PASS_FAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pass / Fail
E=Fair Value Missing F=Fail P=Pass |
| 10 | FILEREFPATH | Character(128) | VARCHAR2(128) NOT NULL | File Reference Path |