SFA_SS_SETUP

(SQL Table)
 Index Back

Shopping Sheet Setup

General Shoping Sheet Setup

  • Related Language Record: SFA_SS_SETUPLNG

  • Parent Record Of SFA_SHS_ONF_MAP SFA_SS_SETUPAW2 SFA_SS_SETUPAWD SFA_SS_SETUPCOA

    • # 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_SS_GROUP Character(10) VARCHAR2(10) NOT NULL Group
    4 SFA_SS_GROUP_DESCR Character(30) VARCHAR2(30) NOT NULL Group Description
    5 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: AID_YEAR_CAREER

    6 SFA_AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    B=Both Academic& Non Std
    N=Non Standard

    Default Value: A

    7 SFA_SS_INST_TITLE Character(60) VARCHAR2(60) NOT NULL Institution Name
    8 SFA_SS_INST_INIT Character(10) VARCHAR2(10) NOT NULL Institution Initial
    9 SFA_SS_INST_LOGO Character(30) VARCHAR2(30) NOT NULL Institution Logo
    10 SFA_SS_HL_LABEL Character(30) VARCHAR2(30) NOT NULL Self Service Link Label
    11 SFA_SS_INST_NAME Character(40) VARCHAR2(40) NOT NULL Institution Name
    12 SFA_SS_OFFICE_NAME Character(40) VARCHAR2(40) NOT NULL Office Name
    13 SFA_SS_ADDRESS1 Character(40) VARCHAR2(40) NOT NULL Address
    14 SFA_SS_CITY_ST_ZIP Character(40) VARCHAR2(40) NOT NULL City, State Zip
    15 SFA_SS_PHONE Character(30) VARCHAR2(30) NOT NULL Phone Number
    16 SFA_SS_EMAIL Character(40) VARCHAR2(40) NOT NULL E-mail Address
    17 SFA_SS_INST_GROUP Character(2) VARCHAR2(2) NOT NULL Institution Group
    1=Primarily bachelor's degree
    2=Primarily associate's degree
    3=Primarily certificate
    4=Primarily graduate degree
    5=Primarily non-degree

    Prompt Table: SFA_SS_XLAT_VW

    18 SFA_SS_COHORT_YEAR Character(4) VARCHAR2(4) NOT NULL Cohort Year
    19 SFA_SS_COLLECT_YR Character(4) VARCHAR2(4) NOT NULL Collection Year
    20 SFA_SS_GRAD_DATA Character(1) VARCHAR2(1) NOT NULL No Graduation Rate Data
    21 SFA_SS_GRAD_RATE Signed Number(6,1) DECIMAL(4,1) NOT NULL Graduation Rate
    22 SFA_SS_GRADRATE_LV Character(1) VARCHAR2(1) NOT NULL Graduation Rate Level
    1=Low
    2=Medium
    3=High
    23 SFA_SS_DEFAULTDATA Character(1) VARCHAR2(1) NOT NULL No Loan Default Data
    24 SFA_SS_DFTRATE_SCH Number(5,1) DECIMAL(4,1) NOT NULL Institution Loan Default Rate
    25 SFA_SS_DFTRATE_NAT Number(5,1) DECIMAL(4,1) NOT NULL National Loan Default Rate
    26 SFA_SS_BORROW_DATA Character(1) VARCHAR2(1) NOT NULL No Median Borrowing Data
    27 SFA_SS_AVG_BOR_AMT Number(6,0) INTEGER NOT NULL Average Borrowed Amount
    28 SFA_SS_AVG_BOR_PMT Number(4,0) SMALLINT NOT NULL Average Monthly Payment
    29 SFA_SS_EFC_OPT Character(1) VARCHAR2(1) NOT NULL EFC Option
    0=Federal
    1=Institutional

    Default Value: 0

    30 SFA_SS_PELL_OPT Character(1) VARCHAR2(1) NOT NULL Federal Pell Grant
    0=No
    1=Yes

    Default Value: 1

    31 SFA_SS_PERKIN_OPT Character(1) VARCHAR2(1) NOT NULL Federal Perkins Loan
    0=No
    1=Yes

    Default Value: 1

    32 SFA_SS_SUBLOAN_OPT Character(1) VARCHAR2(1) NOT NULL Federal Subsidized Loan
    0=No
    1=Yes

    Default Value: 1

    33 SFA_SHS_PPLUS_OPT Character(1) VARCHAR2(1) NOT NULL Federal Parent PLUS Loan
    0=No
    1=Yes

    Default Value: 1

    34 SFA_SS_WS_OPT Character(1) VARCHAR2(1) NOT NULL Work-Study
    0=No
    1=Yes

    Default Value: 1

    35 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    36 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

    37 SFA_MSG_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number

    Prompt Table: SFA_MSG_SET_VW

    38 SFA_MSG_NBR Number(5,0) INTEGER NOT NULL Message Number

    Prompt Table: SFA_MSG_CAT_VW

    39 SFA_SS_DISP_NOAWD Character(1) VARCHAR2(1) NOT NULL Allow display with no awards

    Y/N Table Edit

    40 SFA_SS_DO_NOT_COPY Character(1) VARCHAR2(1) NOT NULL Do Not Copy

    Y/N Table Edit

    41 SFA_SS_HRSA_OPT Character(1) VARCHAR2(1) NOT NULL HRSA Loans
    0=No
    1=Yes

    Default Value: 1

    42 SFA_SS_INC_SAG_OPT Character(1) VARCHAR2(1) NOT NULL Income Share Agreement
    0=No
    1=Yes

    Default Value: 1

    43 SFA_SS_DIS_STU_OPT Character(1) VARCHAR2(1) NOT NULL Scholarships for Disadvantage
    0=No
    1=Yes

    Default Value: 1

    44 SFA_SS_ASSIT_OPT Character(1) VARCHAR2(1) NOT NULL Assistantships
    0=No
    1=Yes

    Default Value: 1

    45 SFA_SHS_TEMPLT_OPT Character(1) VARCHAR2(1) NOT NULL CFP Template
    G=Graduate
    U=Undergraduate

    Default Value: U

    46 SFA_SS_TEMPLT_COLR Character(10) VARCHAR2(10) NOT NULL Default ED Template Color
    47 SFA_SHS_DNBTN_OPT Character(1) VARCHAR2(1) NOT NULL Hide Download Button

    Y/N Table Edit

    Default Value: N

    48 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    49 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    50 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    51 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time