RUNCTL_FA911

(SQL Table)
Index Back

IM App Load Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: AID_YEAR_TBL

5 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Type
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan
6 BEGIN_DT Date(10) DATE NOT NULL Begin Date
7 END_DT Date(10) DATE NOT NULL end date