BCT_PURGE_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BCT_PURGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Setup field to indicate what status of BCT records (BCT_STATUS) the purge process will work with.
2=Complete 6=Confirmed |
| 4 | BCT_HISTORY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
History Options
0=No history will be maintained 1=History for all Transactions 2=History only for Errors |
| 5 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 6 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 7 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 8 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 9 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least |
| 10 | DAYS_SINCELASTACT | Number(3,0) | SMALLINT NOT NULL | Days Since Last Activity |
| 11 | COMMIT_BATCH | Number(6,0) | INTEGER NOT NULL | Commit Batch |
| 12 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 13 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |
| 14 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 15 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 16 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |