VCHR_STG_LOG_VW(SQL View) |
Index Back |
|---|
| SELECT A.BATCH_ID , A.OPRID , A.TIME_DEL , A.VCHR_SRC_TEXT , A.COUNT_DEL , A.COMMENT1 FROM %Table(VCHR_STG_LOG) A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BATCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | TIME_DEL | DateTime(26) | TIMESTAMP | Delete Time |
| 4 | VCHR_SRC_TEXT | Character(30) | VARCHAR2(30) NOT NULL | Voucher Source |
| 5 | COUNT_DEL | Signed Number(9,0) | DECIMAL(8) NOT NULL | Count |
| 6 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |