SFA_ATB_STDNT

(SQL Table)
 Index Back

Student Ability To Benefit

Contains ability to benefit information about the student.

  • Parent record: SFA_COD_ATTSCHL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    3 SFA_SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL 3 byte Sequence Number field for Financial Aid use.
    4 SFA_ATB_CD Character(2) VARCHAR2(2) NOT NULL Ability To Benefit Code
    01=01: Complete before 7/1/2012
    02=02: College before 7/1/2012
    03=03: State Process
    04=04: Home Schooled
    05=05: Other
    06=06: High School Diploma
    07=07: General Ed Development
    08=08: State-Authorized exam/cert
    09=09: Acad Transc min 2 YR Prog
    10=10: Excelled in High School
    11=11: Complete 7/1/12 - 6/30/15
    12=12: Complete after 7/1/2012
    13=13: College 7/1/12 - 6/30/15
    14=14: College after 7/1/2012
    15=15: CPT Program
    5 SFA_ATB_TST_ADM_CD Character(2) VARCHAR2(2) NOT NULL Ability to Benefit Test Adminitrator Code
    01=01: Testing Center
    02=02: Test Administrator
    6 SFA_ATB_TST_CD Character(2) VARCHAR2(2) NOT NULL Ability To Benefit Test Code
    01=01: ASSET Program
    02=02: Career Program Assessment
    03=03: COMBO English Lang Skills
    04=04: Compass Subtests
    05=05: COMP Placement Tests
    06=06: Descriptive LANG Skills
    07=07: ESL Placement Test
    08=08: Wonderic Basic Skills Test
    09=09: WorkKeys Program
    10=10: Test of Adult Basic ED
    11=11: Spanish Assessment
    12=12: WBST - Spanish
    13=13: TSI Assessment
    7 SFA_ATB_STATE_CD Character(2) VARCHAR2(2) NOT NULL Ability to Benefit State Code

    Prompt Table: SFA_ISIRSTATEVW

    8 SFA_ATB_COMP_DT Date(10) DATE Ability to Benefit Completion Date
    9 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    10 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    11 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    12 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    13 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    14 COMMENTS Long Character CLOB Comment