SFA_ATB_ST_AET(SQL Table) |
Index Back |
---|---|
ATB State RecState Table for Ability to Benefit Select AE process, SFA_ATB. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
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 |
9 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |