PROCESS_INSTANCEPrompt Table: INSTITUTION_TBL
B=Insert/Update
U=Update Only
Default Value: U
1=All
2=Unprocessed
3=Suspended Only
SFA_CNSLEXT_AET(SQL Table) |
Index Back |
|---|---|
Publish AE Cache RecordFor Exit Counseling processing |
| # | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 5 | SFA_CR_AY_SEL_OPT | Character(1) | VARCHAR2(1) NOT NULL | Select Within Aid Year |
| 6 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 7 | SFA_CR_LOAD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Update/Insert Option
B=Insert/Update U=Update Only Default Value: U |
| 8 | SFA_CR_SELECT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Selection Option
1=All 2=Unprocessed 3=Suspended Only |
| 9 | SFA_CR_GPLUS_OPT | Character(1) | VARCHAR2(1) NOT NULL | Process Grad PLUS |
| 10 | SCCFP_MAP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Mapping ID - the unique key that identifies the file mapping |
| 11 | SFA_CR_SCHOOL_ID | Character(8) | VARCHAR2(8) NOT NULL | Common School ID/OPEID |
| 12 | SFA_ACTIVE_OPEID | Character(1) | VARCHAR2(1) NOT NULL | Active |