SFA_SLC_SETUP

(SQL Table)
 Index Back

SLC Setup Options Table

Student Loan Company (SLC) Setup Options Table

  • Parent record: AID_YEAR_TBL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
    4 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
    5 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Default Value: FINA

    Prompt Table: ADM_FUNCTN_TBL

    6 SFA_SLC_BANK_COMM Character(8) VARCHAR2(8) NOT NULL Bank Details Comm Key

    Prompt Table: COMM_SPDKEY_TBL

    7 SFA_SLC_SSAR_CHKL Character(6) VARCHAR2(6) NOT NULL Create SSAR Checklist

    Prompt Table: CS_CHKLST_VW

    8 SFA_SLC_PKGST_OPT1 Character(1) VARCHAR2(1) NOT NULL Make Ready for Packaging

    Y/N Table Edit

    Default Value: N

    9 SFA_SLC_P_ATT_OPT Character(1) VARCHAR2(1) NOT NULL Use Physical Attendance Flag

    Y/N Table Edit

    Default Value: N

    10 SFA_SLC_SSAC_CHKL Character(6) VARCHAR2(6) NOT NULL Use SSAC Checklist

    Prompt Table: CS_CHKLST_VW

    11 SFA_SLC_CHKL_OPT1 Character(1) VARCHAR2(1) NOT NULL Complete SSAR Checklist

    Y/N Table Edit

    Default Value: N

    12 SFA_SLC_PKGST_OPT2 Character(1) VARCHAR2(1) NOT NULL Make Ready for Packaging

    Y/N Table Edit

    Default Value: N

    13 SFA_SLC_ATTEND_EQ Character(12) VARCHAR2(12) NOT NULL Attendance Equation

    Prompt Table: EQTN_NAME_VW

    14 SFA_SLC_CRSE_CD_EQ Character(12) VARCHAR2(12) NOT NULL Course Code Equation

    Prompt Table: EQTN_NAME_VW

    15 SFA_SLC_CRSE_YR_EQ Character(12) VARCHAR2(12) NOT NULL Course Year Equation

    Prompt Table: EQTN_NAME_VW

    16 SFA_SLC_CRSEFEE_EQ Character(12) VARCHAR2(12) NOT NULL Course Fee Equation

    Prompt Table: EQTN_NAME_VW

    17 SFA_SLC_TUITLIB_EQ Character(12) VARCHAR2(12) NOT NULL Tuition Liability Equation

    Prompt Table: EQTN_NAME_VW

    18 SFA_SLC_AT_FEE_EQ Character(12) VARCHAR2(12) NOT NULL At Fee Equation

    Prompt Table: EQTN_NAME_VW

    19 SFA_SLC_CRSEFEEGRP Character(10) VARCHAR2(10) NOT NULL Course Fee Group

    Prompt Table: ITEM_GROUP_TBL

    20 SFA_SLC_TLOAN_GRP Character(10) VARCHAR2(10) NOT NULL Tuition Fee Loan Group

    Prompt Table: ITEM_GROUP_TBL

    21 SFA_SLC_TGRANT_GRP Character(10) VARCHAR2(10) NOT NULL Tuition Fee Grant Group

    Prompt Table: ITEM_GROUP_TBL

    22 SFA_SLC_FILE_TYPE2 Character(3) VARCHAR2(3) NOT NULL HEBSS File Type
    FA=Full Administration
    IO=Information Only