Field Set: StateNM Virtual ServicesFact
This field set was included with State Reporting Installer 17.6.0 released on June 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
NM_Service_Fact | Unique_ID | S_NM_STU_Service_Fact_C | Unique_ID |
NM_Service_Fact | SchoolID | S_NM_STU_Service_Fact_C | SchoolID |
NM_Service_Fact | ForeignKey | S_NM_STU_Service_Fact_C | ForeignKey |
NM_Service_Fact | ForeignKey_Alpha | S_NM_STU_Service_Fact_C | ForeignKey_Alpha |
NM_Service_Fact | user_defined_text | S_NM_STU_Service_Fact_C | ServiceCode |
NM_Service_Fact | user_defined_text2 | S_NM_STU_Service_Fact_C | PlacementType |
NM_Service_Fact | NM_ServiceFrequency | S_NM_STU_Service_Fact_C | ServiceFrequency |
NM_Service_Fact | NM_ServiceCycle | S_NM_STU_Service_Fact_C | ServiceCycle |
NM_Service_Fact | NM_IntegratedServiceStatus | S_NM_STU_Service_Fact_C | IntegratedServiceStatus |
NM_Service_Fact | NM_StaffSSN | S_NM_STU_Service_Fact_C | StaffSSN |
NM_Service_Fact | NM_ServiceProviderName | S_NM_STU_Service_Fact_C | ServiceProviderName |
NM_Service_Fact | user_defined_date | S_NM_STU_Service_Fact_C | EntryDate |
NM_Service_Fact | user_defined_date2 | S_NM_STU_Service_Fact_C | ExitDate |
NM_Service_Fact | user_defined_integer | S_NM_STU_Service_Fact_C | YearId |
NM_Service_Fact | NM_CompDate | S_NM_STU_Service_Fact_C | CompDate |