SFA_SLC_HEBSS

(SQL Table)
 Index Back

HEBSS Data

SLC Higher Education Bursay & Scholarship Scheme Data Table

  • Parent record: SFA_SLC_STUDENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
    5 SFA_SLC_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    6 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
    7 SFA_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name
    8 SFA_SLC_ISSUE_DT Date(10) DATE Issue Date
    9 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
    10 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
    11 SFA_SLC_ADDR_LINE1 Character(240) VARCHAR2(240) NOT NULL Address Line 1
    12 SFA_SLC_ADDR_LINE2 Character(240) VARCHAR2(240) NOT NULL Address Line 2
    13 SFA_SLC_ADDR_LINE3 Character(240) VARCHAR2(240) NOT NULL Address Line 3
    14 SFA_SLC_CITY Character(60) VARCHAR2(60) NOT NULL City
    15 SFA_SLC_COUNTY Character(60) VARCHAR2(60) NOT NULL County
    16 SFA_SLC_POST_CD Character(8) VARCHAR2(8) NOT NULL Post Code
    17 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
    18 SFA_SLC_SEX Character(1) VARCHAR2(1) NOT NULL Sex
    F=Female
    M=Male
    19 SFA_SLC_DOMICILE Character(30) VARCHAR2(30) NOT NULL Domicile
    20 SFA_SLC_ART_ID Character(11) VARCHAR2(11) NOT NULL ART ID
    21 SFA_SLC_SSN Character(13) VARCHAR2(13) NOT NULL Student Support Nbr
    22 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number
    23 SFA_SLC_CRSE_TYPE Character(11) VARCHAR2(11) NOT NULL Course Type
    24 SFA_SLC_NBR_SPNSRS Number(1,0) SMALLINT NOT NULL Number of Sponsors
    25 SFA_SLC_NMTO_IND Character(1) VARCHAR2(1) NOT NULL Non-Means Test

    Y/N Table Edit

    26 SFA_SLC_CCG_IND Character(1) VARCHAR2(1) NOT NULL Childcare Grant

    Y/N Table Edit

    27 SFA_SLC_ADG_IND Character(1) VARCHAR2(1) NOT NULL Adult Dependent Support

    Y/N Table Edit

    28 SFA_SLC_HSHLD_INC Signed Number(20,3) DECIMAL(18,3) NOT NULL Household Income
    29 SFA_SLC_HH_INC_FLG Character(1) VARCHAR2(1) NOT NULL Value is blank

    Y/N Table Edit

    Default Value: N

    30 SFA_SLC_EARNER_INC Signed Number(20,3) DECIMAL(18,3) NOT NULL Principle Earner Income
    31 SFA_SLC_ELIG_SUPP Character(12) VARCHAR2(12) NOT NULL Student Support Eligibility
    32 SFA_SLC_EDIV_VERIF Character(1) VARCHAR2(1) NOT NULL Evidence Verified

    Y/N Table Edit

    33 SFA_SLC_NHS_INC_I Character(1) VARCHAR2(1) NOT NULL Income Assessed Funding

    Y/N Table Edit

    34 SFA_SLC_NHS_NINC_I Character(1) VARCHAR2(1) NOT NULL Non-Income Assessed Funding

    Y/N Table Edit

    35 SFA_SLC_COMMNCE_YR Character(4) VARCHAR2(4) NOT NULL Commencing Year of Study
    36 SFA_SLC_CRSE_DESCR Character(120) VARCHAR2(120) NOT NULL Course Name
    37 SFA_SLC_COURSE_DT Date(10) DATE Course Start Date
    38 SFA_SLC_UCAS_CRSCD Character(6) VARCHAR2(6) NOT NULL UCAS Course Code
    39 SFA_SLC_COURSE_CD Character(15) VARCHAR2(15) NOT NULL SLC Course Code
    40 SFA_SLC_CRSE_QUAL Character(8) VARCHAR2(8) NOT NULL Qualification
    41 SFA_SLC_CAMPUS_CD Character(1) VARCHAR2(1) NOT NULL Campus Code
    42 SFA_SLC_MTHD_ATTND Character(240) VARCHAR2(240) NOT NULL Method of Attendance
    43 SFA_SLC_BANK_DTL Character(1) VARCHAR2(1) NOT NULL Bank Details Held

    Y/N Table Edit

    44 SFA_SLC_AUTOAWDAMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Automated Award Total
    45 SFA_SLC_MAN_AWDAMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Manual Award Total
    46 SFA_SLC_OVR_AWDAMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Overall Award Total
    47 SFA_SLC_NEW_STDNT Character(1) VARCHAR2(1) NOT NULL New Student

    Y/N Table Edit

    48 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    49 SFA_SLC_APPACAD_YR Character(7) VARCHAR2(7) NOT NULL Application Academic Year
    50 SFA_SLC_COHRT_YR Character(20) VARCHAR2(20) NOT NULL Cohort Year
    51 SFA_SLC_EVID_REQ Character(3) VARCHAR2(3) NOT NULL Evidence Requirement Type
    CI=Current Year Income
    N=Full Evidence
    P=Provisional
    SC=Self Certified
    SFA=Single Financial Assessment
    52 SFA_SLC_MAINT_GR Character(1) VARCHAR2(1) NOT NULL Maintenance Grant

    Y/N Table Edit

    53 SFA_SLC_SPECSUP_GR Character(1) VARCHAR2(1) NOT NULL Special Support Grant

    Y/N Table Edit

    54 SFA_SLC_PREV_APPD Character(1) VARCHAR2(1) NOT NULL Previously Approved

    Y/N Table Edit

    55 SFA_SLC_FEE_WVRAPR Number(18,2) DECIMAL(17,2) NOT NULL Fee Waiver Approved
    56 SFA_SLC_FEE_WVRPRC Number(18,2) DECIMAL(17,2) NOT NULL Fee Waiver Processed
    57 SFA_SLC_CARE_LEAVE Character(1) VARCHAR2(1) NOT NULL Care Leaver

    Y/N Table Edit

    58 SFA_SLC_WITHDRAWN Character(1) VARCHAR2(1) NOT NULL Withdrawn

    Y/N Table Edit

    59 SFA_SLC_TRANSFER Character(1) VARCHAR2(1) NOT NULL Transferred

    Y/N Table Edit

    60 SFA_SLC_CANCELLED Character(1) VARCHAR2(1) NOT NULL Cancelled Application

    Y/N Table Edit

    61 SFA_SLC_DELETED Character(1) VARCHAR2(1) NOT NULL Deleted Application

    Y/N Table Edit

    62 SFA_SLC_INDEPNDT Character(1) VARCHAR2(1) NOT NULL Independent Status

    Y/N Table Edit

    63 SFA_SLC_APP_STATUS Character(30) VARCHAR2(30) NOT NULL Application Status
    64 SFA_SLC_SPECSUP_EL Character(1) VARCHAR2(1) NOT NULL Special Support Element

    Y/N Table Edit

    65 SFA_SLC_CREDIT_VAL Number(4,0) SMALLINT NOT NULL Credit Value
    66 SFA_SLC_INTENSITY Number(4,0) SMALLINT NOT NULL Intensity
    67 SFA_SLC_CRSE_YEAR Number(2,0) SMALLINT NOT NULL Course Year