SAE_BULK_TRANS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SAE_BULK_TRAN |
Character(250) | VARCHAR2(250) NOT NULL | Transaction ID |
| 2 | SAE_TARGET_ID |
Character(50) | VARCHAR2(50) NOT NULL |
SAIP Target ID
Prompt Table: SAE_BULK_TRGTS |
| 3 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | SAE_TRAN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Status
02=Cancelled 03=Announced 04=Announce Failed 05=Ignored 06=Completed 07=Requested |
| 5 | SAE_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type
1=Push 2=Pull 3=Batch |
| 6 | SAE_LIS_CODE_MAJOR | Character(4) | VARCHAR2(4) NOT NULL |
Code Major
FAIL=failure PROC=processing SUCC=success UNSU=unsupported |
| 7 | SAE_LIS_SEVERITY | Character(4) | VARCHAR2(4) NOT NULL |
Severity
EROR=error STAT=status WARN=warning |
| 8 | SAE_LIS_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Status Description |
| 9 | SAE_ERR_DESC | Character(100) | VARCHAR2(100) NOT NULL | Error Description |
| 10 | SAE_EVENT_DT | DateTime(26) | TIMESTAMP | Event Driven Timestamp |