SFA_ATB_ST_SRCH

(SQL View)
 Index Back

Ability to Benefit Search

This search record provides a list of all student who have been entered on the Student Ability to Benefit page. The list box will also provide identifying information from the Personal_Data table.

SELECT DISTINCT B.OPRCLASS , A.EMPLID , A.INSTITUTION , A.SFA_ATB_CD , A.SFA_ATB_TST_ADM_CD , A.SFA_ATB_TST_CD , B.NID_COUNTRY , B.NATIONAL_ID_TYPE , B.NID_DESCRSHORT , B.NATIONAL_ID , B.NATIONAL_ID_MSK , B.BIRTHDATE , B.BIRTHDATE_MSK , B.NAME , B.CAMPUS_ID , B.SEX , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME_DISPLAY FROM PS_SFA_ATB_STDNT A , PS_PEOPLE_SRCH B WHERE A.EMPLID = B.EMPLID AND A.SFA_SEQ_NBR_3 = ( SELECT MAX(C1.SFA_SEQ_NBR_3) FROM PS_SFA_ATB_STDNT C1 WHERE C1.EMPLID = A.EMPLID AND C1.INSTITUTION = A.INSTITUTION )

  • Parent record: STUDENT_AID

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

    Prompt Table: PEOPLE_SRCH

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    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 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
    8 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Prompt Table: HCR_NID_TYP_I

    9 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
    10 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    11 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
    12 BIRTHDATE Date(10) DATE Date of Birth
    13 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
    14 NAME Character(50) VARCHAR2(50) NOT NULL Name
    15 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
    16 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    17 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    18 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country