SFA_RUN_ISR_CRW(SQL Table) |
Index Back |
---|---|
Proc Run Control Fin Aid RptsThis record is used for ISIR Crystal Reports. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
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 | FIN_AID_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Fin Aid Type
A=Athletic B=Bursary F=Fellowship G=Grant L=Loan S=Scholarship V=Waiver W=Work/Study |
6 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
7 | REPORTING_DATE | Date(10) | DATE | Pell Reporting Date |
8 | IWD_AWARD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Award Year |
9 | IWD_TRANS_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Source Site Cd
Prompt Table: %EDITTABLE3 |