EX_AUDIT_DCAA_H(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 4 | AUDIT_STAMP |
DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 5 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | TRANSACTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Transaction ID |
| 7 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 8 | LOG_DCAA_REASON |
Character(1) | VARCHAR2(1) NOT NULL |
Log DCAA Entry Reason
A=Changes during approval B=Changed and Late C=Changes after cutt-off time D=Deleting Time Report E=Entry by authorized Reporter L=Late Entry by emplid or AuthRp |
| 9 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |