PROCESS_INSTANCEPrompt Table: INSTITUTION_TBL
B=Insert/Update
U=Update Only
Default Value: U
Y/N Table Edit
Default Value: N
1=All
2=Unprocessed
3=Suspended Only
1=Both
2=Entrance
3=Exit
SFA_CNSL_UPDAET(SQL Table) |
Index Back |
|---|---|
Publish AE Cache Record |
| # | 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_GPLUS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Process Grad PLUS
Y/N Table Edit Default Value: N |
| 9 | SFA_CR_SELECT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Selection Option
1=All 2=Unprocessed 3=Suspended Only |
| 10 | SFA_CR_SCHOOL_ID | Character(8) | VARCHAR2(8) NOT NULL | Common School ID/OPEID |
| 11 | SFA_ACTIVE_OPEID | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 12 | SFA_LN_CNSL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Counseling Option
1=Both 2=Entrance 3=Exit |
| 13 | SFA_LC_AY_SEL_OPT | Character(1) | VARCHAR2(1) NOT NULL | Use latest awarded Aid Year |