SAE_BULK_TRN_VW(SQL View) |
Index Back |
|---|
| SELECT SAE_BULK_TRAN , SAE_TARGET_ID , PRCSINSTANCE , SAE_TRAN_STATUS , SAE_TRAN_TYPE , SAE_LIS_CODE_MAJOR , SAE_LIS_SEVERITY , SAE_LIS_DESCR , SAE_ERR_DESC , SAE_EVENT_DT , CASE WHEN SAE_ERR_DESC = ' ' THEN SAE_LIS_CODE_MAJOR ELSE 'CNER' END FROM %Table(SAE_BULK_TRANS) |
| # | 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 |
| 11 | SAE_ANN_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Announce Status
CNER=Connection Error FAIL=failure PROC=processing SUCC=success UNSU=unsupported |