SEL_GROUP_TBL

(SQL Table)
 Index Back

Selection Group Table

Contains the selection groups that students can belong to. These groups are used to determine which fee/waivers apply to a particular student.

  • Related Language Record: SEL_GROUP_LNG

  • Parent Record Of GROUP_CLST_TBL GROUP_FEE_TBL GRP_WAIVER_TBL SEL_GROUP_CRITR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SEL_GROUP_TBL.DESCR

    7 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description

    Default Value: SEL_GROUP_TBL.DESCR

    8 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    9 TUIT_CALC_GROUP Character(1) VARCHAR2(1) NOT NULL Tuition Calculation Group

    Y/N Table Edit

    Default Value: Y

    10 FA_CALC_GROUP Character(1) VARCHAR2(1) NOT NULL Fin Aid Calculation Group

    Y/N Table Edit

    Default Value: N

    11 TRANS_FEE_CD Character(8) VARCHAR2(8) NOT NULL Transaction Fee Code

    Prompt Table: TRANS_FE_CD_TBL

    12 PRO_RATA_ADJ Character(8) VARCHAR2(8) NOT NULL Pro-rata

    Prompt Table: ADJ_CODE_TRM_VW

    13 PRO_RATA_SRVC_IND Character(3) VARCHAR2(3) NOT NULL Pro-rata Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    14 PRO_RATA_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL Pro-rata Service Ind Reason

    Prompt Table: PRO_SRVC_RSN_VW

    15 ACCREDIT_AGNCY_ADJ Character(8) VARCHAR2(8) NOT NULL Accrediting Agency

    Prompt Table: ADJ_CODE_TRM_VW

    16 ACCR_AGEN_SRVC_IND Character(3) VARCHAR2(3) NOT NULL Agency Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    17 ACCR_AGEN_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL Agency Service Ind Reason

    Prompt Table: ACC_SRVC_RSN_VW

    18 STATE_ADJ Character(8) VARCHAR2(8) NOT NULL State

    Prompt Table: ADJ_CODE_TRM_VW

    19 STATE_SRVC_IND Character(3) VARCHAR2(3) NOT NULL State Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    20 STATE_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL State Service Indicator Reason

    Prompt Table: STA_SRVC_RSN_VW

    21 FED_REFUND_ADJ Character(8) VARCHAR2(8) NOT NULL Federal Refund

    Prompt Table: ADJ_CODE_TRM_VW

    22 FEDERAL_SRVC_IND Character(3) VARCHAR2(3) NOT NULL Federal Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    23 FEDERAL_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL Federal Service Ind Reason

    Prompt Table: FED_SRVC_RSN_VW

    24 INSTITUTION_ADJ Character(8) VARCHAR2(8) NOT NULL Institution

    Prompt Table: ADJ_CODE_TRM_VW

    25 INSTITUTN_SRVC_IND Character(3) VARCHAR2(3) NOT NULL Institutn Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    26 INSTITUTN_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL Institution Service Ind Reason

    Prompt Table: INS_SRVC_RSN_VW

    27 NSFA_INST_ADJ Character(8) VARCHAR2(8) NOT NULL Non-SFA Institution

    Prompt Table: ADJ_CODE_TRM_VW

    28 NSF_INST_SRVC_IND Character(3) VARCHAR2(3) NOT NULL NSF Inst Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    29 NSF_INST_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL NSFA Inst Service Ind Reason

    Prompt Table: NIN_SRVC_RSN_VW

    30 NSFA_1ST_INST_ADJ Character(8) VARCHAR2(8) NOT NULL Non-SFA 1st Time Institution

    Prompt Table: ADJ_CODE_TRM_VW

    31 NSF_1_INS_SRVC_IND Character(3) VARCHAR2(3) NOT NULL 1st Inst Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    32 NSF_1_INS_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL 1st Inst Service Ind Reason

    Prompt Table: N1I_SRVC_RSN_VW

    33 NSFA_1ST_CAR_ADJ Character(8) VARCHAR2(8) NOT NULL Non-SFA 1st Time Career

    Prompt Table: ADJ_CODE_TRM_VW

    34 NSF_1_CAR_SRVC_IND Character(3) VARCHAR2(3) NOT NULL 1st Car Service Indicator CD

    Prompt Table: SRV_IND_CD_SCTY

    35 NSF_1_CAR_SRVC_RSN Character(5) VARCHAR2(5) NOT NULL 1st Car Service Ind Reason

    Prompt Table: N1C_SRVC_RSN_VW

    36 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

    Prompt Table: SRV_IND_CD_SCTY

    37 SRVC_IND_REASON Character(5) VARCHAR2(5) NOT NULL Service Indicator Reason

    Prompt Table: SRVC_IN_RSN_TBL

    38 LOCK_IN_FLG Character(1) VARCHAR2(1) NOT NULL Lock In Flag

    Y/N Table Edit

    Default Value: N

    39 SSF_HECS_CODE Character(6) VARCHAR2(6) NOT NULL HECS Fee Code

    Prompt Table: SSF_HECS_CD_TBL

    40 SSF_USE_PAST_INST Character(1) VARCHAR2(1) NOT NULL Assess Past Installments

    Y/N Table Edit

    Default Value: N

    41 SSF_ADJ_BILL_INST Character(1) VARCHAR2(1) NOT NULL Adjust Billed Installments

    Y/N Table Edit

    Default Value: N