SFA_RUN_EASTAGE(SQL Table) |
Index Back |
|---|---|
SFA Run External Award StagingSFA_RUN_EASTAGE holds run control parameters to run the external award staging process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 5 | SFA_EA_FILE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
External award file type (single vs. list).
L=File List S=Single File Default Value: S |
| 6 | FILE_INBOUND | Character(127) | VARCHAR2(127) NOT NULL | Inbound File |
| 7 | SCCFP_MAP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Mapping ID - the unique key that identifies the file mapping
Prompt Table: SFA_EA_SCCFPMAP |
| 8 | SFA_EA_FILECONTROL | Character(1) | VARCHAR2(1) NOT NULL |
External award file integrity control flag.
Y/N Table Edit Default Value: N |
| 9 | SFA_EA_AWRD_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Externa Award load action.
B=Offer/Accept O=Offer Default Value: B |