Field Set: State AB Virtual Concurrent Enrollments
This field set was included with State Reporting Installer 17.9.2 released on October 18, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| VirtualTablesData | unique_ID | S_AB_STU_ConEnrollments_C | unique_ID |
| VirtualTablesData | schoolID | S_AB_STU_ConEnrollments_C | schoolID |
| VirtualTablesData | foreignKey | S_AB_STU_ConEnrollments_C | foreignKey |
| VirtualTablesData | foreignKey_alpha | S_AB_STU_ConEnrollments_C | foreignKey_alpha |
| VirtualTablesData | user_defined_date | S_AB_STU_ConEnrollments_C | entryDate |
| VirtualTablesData | user_defined_date2 | S_AB_STU_ConEnrollments_C | exitDate |
| VirtualTablesData | user_defined_numeric | S_AB_STU_ConEnrollments_C | grade_level |
| VirtualTablesData | user_defined_text | S_AB_STU_ConEnrollments_C | entryCode |
| VirtualTablesData | user_defined_text2 | S_AB_STU_ConEnrollments_C | exitCode |
| VirtualTablesData | AB_Resident_Board | S_AB_STU_ConEnrollments_C | ResidentBoard |
| VirtualTablesData | AB_Grants_Program1 | S_AB_STU_ConEnrollments_C | GrantsProgram1 |
| VirtualTablesData | AB_Grants_Program2 | S_AB_STU_ConEnrollments_C | GrantsProgram2 |
| VirtualTablesData | AB_Grants_Program3 | S_AB_STU_ConEnrollments_C | GrantsProgram3 |
| VirtualTablesData | AB_Spcl_Edu_Stu_1 | S_AB_STU_ConEnrollments_C | SpclEduStu1 |
| VirtualTablesData | AB_Spcl_Edu_Stu_2 | S_AB_STU_ConEnrollments_C | SpclEduStu2 |
| VirtualTablesData | AB_Enrl_Type_1 | S_AB_STU_ConEnrollments_C | EnrlType1 |
| VirtualTablesData | AB_Enrl_Type_2 | S_AB_STU_ConEnrollments_C | EnrlType2 |
| VirtualTablesData | AB_Enrl_Type_3 | S_AB_STU_ConEnrollments_C | EnrlType3 |
| VirtualTablesData | AB_Regi_Type | S_AB_STU_ConEnrollments_C | RegistrationType |
| VirtualTablesData | AB_Fren_Hrs_Cal | S_AB_STU_ConEnrollments_C | FrenchHours |
| VirtualTablesData | AB_FNMI | S_AB_STU_ConEnrollments_C | FNMI |
| VirtualTablesData | AB_Enrl_ChgRsn | S_AB_STU_ConEnrollments_C | EnrlChgRsn |
| VirtualTablesData | AB_Enrl_ChgComments | S_AB_STU_ConEnrollments_C | EnrlChgComents |