POEC_DEL_AET(SQL Table) |
Index Back |
|---|---|
Purge ASN HistoryState record for Purge ASN History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | ASN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
ASR Processing Status
E=Error N=New P=Processed R=Ready V=Validated X=Canceled |
| 7 | ASN_RECEIVED_DT | Date(10) | DATE | ASR Trans Receipt Date |
| 8 | DATE_TO | Date(10) | DATE | Date To |
| 9 | POEC_BU_SQL | Character(254) | VARCHAR2(254) NOT NULL | POEC Business Unit SQL |
| 10 | POEC_ASN_STATUS_SQ | Character(100) | VARCHAR2(100) NOT NULL | ASN Status Receive |
| 11 | POEC_DATFRM_TO_SQL | Character(100) | VARCHAR2(100) NOT NULL | Receive date from to |
| 12 | POEC_EMPTY_BU | Character(1) | VARCHAR2(1) NOT NULL |
Purge blank BU Rows
Y/N Table Edit |