AUDIT_OPRIDAUDIT_STAMPRECNAMETRANSACTION_IDVERSION_NUMLOG_DCAA_REASONA=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
EX_AUDIT_DCAA(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 2 | AUDIT_STAMP |
DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | TRANSACTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Transaction ID |
| 5 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 6 | 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 |
| 7 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |