SFA_ATB_TRGT(SQL Table) |
Index Back |
---|---|
PopSelect ATB TargetTarget record for ATB Population Selection Context |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
5 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
6 | 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 |
7 | 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 |
8 | 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 |
9 | SFA_ATB_STATE_CD | Character(2) | VARCHAR2(2) NOT NULL | Ability to Benefit State Code |
10 | SFA_ATB_COMP_DT | Date(10) | DATE | Ability to Benefit Completion Date |