FA_BATCH_RUNCTL

(SQL Table)
 Index Back

Run Control For Batch Process

This Table contains the run control values for the batch COBOL progam 'FAPIMCL7'. Said program reads a table populated by the ISIR load job 'FAISIR97', which contains a list of students that the institution requests an IM calculation to be performed. The results of this calculation are stored for that student, on the Student_AID table. 9/4/97 Added field PELL_SEND_ADDR_YN & use by FAEPPD98.SQR 9/5/97 Backed-out PELL_SEND_ADDR_YN field and Peoplecode changes made 9/3/97...too many problems.

  • Parent Record Of RUNCTL_VERIF_VW RUN_CNTL_VERIF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: AID_YEAR_TBL

    4 SCC_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update switch
    N=No
    Y=Yes

    Default Value: Y

    5 COMMIT_LEVEL Number(5,0) INTEGER NOT NULL Commit Level
    6 SELECT_OFFERED Character(1) VARCHAR2(1) NOT NULL Select Awards in Offered Stat

    Y/N Table Edit

    Default Value: N

    7 BYPASS_FUND_CK Character(1) VARCHAR2(1) NOT NULL Bypass Fund Balance Check

    Y/N Table Edit

    Default Value: N

    8 TIV_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL Pell ID Reporting

    Prompt Table: PELL_PMT_OPTION

    9 REPORTING_DATE Date(10) DATE Pell Reporting Date

    Default Value: %date

    10 PELL_SEND_ADDR Character(1) VARCHAR2(1) NOT NULL Added for FAEPPD98.SQR

    Y/N Table Edit

    Default Value: N

    11 SFA_CALC_TYPE Character(2) VARCHAR2(2) NOT NULL Calculation Rule
    F=Federal
    FA=Flat Amount
    FM=Formula
    P=Profile
    PB=Percentage of Base
    RU=Rate * Units
    12 MAX_NBR_SEVERE_ERR Number(3,0) SMALLINT NOT NULL Max Number of Severe Errors
    13 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL