BAS_BARUN_AET(SQL Table) |
Index Back |
|---|---|
Real Time Indexing Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SCHED_ID | Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 4 | REPROCESS_IND | Character(1) | VARCHAR2(1) NOT NULL |
Reprocess Indicator
A=Assign Benefit Pgm E=Elect Options N=None P=Prepare Options S=Schedule |
| 5 | PARTIC_LIST_IND | Character(1) | VARCHAR2(1) NOT NULL | List indicator for participants |
| 6 | PARTIC_NEW_IND | Character(1) | VARCHAR2(1) NOT NULL | Schedule New Participants |
| 7 | PROCESS_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
BAS Processing Phase
A=Assigning Benefit Program C=Processing Completed O=Processing Options P=Passive Event Processing R=Ready for Processing S=Scheduling Events |
| 8 | PROCESS_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process Indicator
A=Assign Benefit Program E=Elect Options N=Normal Processing P=Prepare Options R=Re-Enter V=Void |
| 9 | FINALIZE_ENROLL | Character(1) | VARCHAR2(1) NOT NULL | Finalize/Apply Defaults |
| 10 | PASSIVE_EVENT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Passive Events Processing
N=Do Not Process O=Trigger Passive Events Only Y=Process |
| 11 | BAS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ben Admin Type
E=Event Maintenance O=Open Enrollment S=Snapshot |