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
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 |
|---|---|---|---|
|
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 |