SFA_ATB_BIND

(SQL View)
 Index Back

Pop Select ATB Bind

Bind record for ATB Population Selection Context. It's a view to PS_STUDENT_AID.

SELECT DISTINCT A.EMPLID , A.INSTITUTION , A.AID_YEAR , ' ' , ' ' , ' ' , ' ' , %DateNull FROM PS_STUDENT_AID A

# 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
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
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
8 SFA_ATB_COMP_DT Date(10) DATE Ability to Benefit Completion Date