RUN_CNTL_CONSL

(SQL Table)
Index Back

Fin Aid Award Notification

RUN_CNTL_AK contains fields that are used as input parameters for the various Letter Generation. Input data is retrieved from this record when a report is requested from the Process Scheduler.

# 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 CONSL_SELECTION Character(1) VARCHAR2(1) NOT NULL Selection Criteria
A=All Stdnts in Verification
N=Unconsolidated
6 SFA_VER_TCONSL_TYP Character(1) VARCHAR2(1) NOT NULL Tax Consolidation Type
1=Federal
2=Institutional