SFA_EXITCNSL_RC

(SQL Table)
 Index Back

Counseling Update Run Control

Exit Loan Counseling Run Control Record

  • Parent record: PRCSRUNCNTL

    • # 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 SFA_CR_AY_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Select Within Aid Year

    Y/N Table Edit

    Default Value: N

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    6 SFA_CR_LOAD_OPT Character(1) VARCHAR2(1) NOT NULL Update/Insert Option
    B=Insert/Update
    U=Update Only

    Default Value: B

    7 SFA_CR_SELECT_OPT Character(1) VARCHAR2(1) NOT NULL Selection Option
    1=All
    2=Unprocessed
    3=Suspended Only

    Default Value: 1

    8 SFA_CR_GPLUS_OPT Character(1) VARCHAR2(1) NOT NULL Process Grad PLUS

    Y/N Table Edit

    9 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping

    Prompt Table: SFA_FPMAPDFN_VW

    10 SFA_CR_SCHOOL_ID Character(8) VARCHAR2(8) NOT NULL Common School ID/OPEID

    Prompt Table: SFA_OPEID_XF_VW

    11 SFA_ACTIVE_OPEID Character(1) VARCHAR2(1) NOT NULL Active

    Y/N Table Edit

    Default Value: N