Wyoming-specific Virtual Table Migrations
Fieldset information is provided below for each Wyoming-specific virtual table migration file released. For detailed information on Wyoming-specific database extensions, refer to the Wyoming State Reporting Data Dictionary.
State WY Virtual ConcurrentEnrollments
This field set was included with State Reporting Installer 17.8.0 released on August 25, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| Students | unique_ID | S_WY_STU_ConcurrentEnroll_C | Unique_ID |
| Students | schoolID | S_WY_STU_ConcurrentEnroll_C | SchoolID |
| Students | foreignKey | S_WY_STU_ConcurrentEnroll_C | ForeignKey |
| Students | foreignKey_alpha | S_WY_STU_ConcurrentEnroll_C | ForeignKey_Alpha |
| Students | user_defined_date | S_WY_STU_ConcurrentEnroll_C | SchoolEntryDate |
| Students | user_defined_date2 | S_WY_STU_ConcurrentEnroll_C | SchoolExitDate |
| Students | user_defined_numeric | S_WY_STU_ConcurrentEnroll_C | ConSchoolID |
| Students | user_defined_text | S_WY_STU_ConcurrentEnroll_C | SchoolEntryCode |
| Students | user_defined_text2 | S_WY_STU_ConcurrentEnroll_C | SchoolExitCode |
| Students | WY_MembershipType | S_WY_STU_ConcurrentEnroll_C | MembershipType |
State WY Virtual CRDCFinalGradeStoreCodes v1
This field set was included with State Reporting Installer 17.8.0 released on August 25, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| CRDCFinalGradeStoreCodes | unique_ID | S_FinalGradeStoreCodes_CRDC_S | Unique_ID |
| CRDCFinalGradeStoreCodes | schoolID | S_FinalGradeStoreCodes_CRDC_S | SchoolID |
| CRDCFinalGradeStoreCodes | foreignKey | S_FinalGradeStoreCodes_CRDC_S | ForeignKey |
| CRDCFinalGradeStoreCodes | foreignKey_alpha | S_FinalGradeStoreCodes_CRDC_S | ForeignKey_Alpha |
| CRDCFinalGradeStoreCodes | user_defined_integer | S_FinalGradeStoreCodes_CRDC_S | TermID |
| CRDCFinalGradeStoreCodes | user_defined_numeric | S_FinalGradeStoreCodes_CRDC_S | YearID |
| CRDCFinalGradeStoreCodes | user_defined_text | S_FinalGradeStoreCodes_CRDC_S | StoreCodeList |
State WY Virtual Home Language
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| WY_HomeLanguage | unique_ID | S_WY_HomeLanguage | Unique_ID |
| WY_HomeLanguage | schoolID | S_WY_HomeLanguage | School_ID |
| WY_HomeLanguage | foreignKey | S_WY_HomeLanguage | ForeignKey |
| WY_HomeLanguage | foreignKey_alpha | S_WY_HomeLanguage | ForeignKey_alpha |
| WY_HomeLanguage | user_defined_text | S_WY_HomeLanguage | HomeLangCode |
| WY_HomeLanguage | user_defined_text2 | S_WY_HomeLanguage | HomeLangDesc |