S_NM_STU_Service_Fact_C (ver 17.6.0)
This is a child table of the Students table. The data is populated from the VirtualTablesData table. Only records related to NM_Service_Fact are stored in this table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Id | 17.6.0 | Number(10,0) | Primary Key. |
StudentsDcid | 17.6.0 | Number(10,0) | Foreign Key. |
Unique_Id | 17.6.0 | Number(11,0) | Alternate Primary Key. Migrated from [VirtualTablesData.Unique_Id]. |
SchoolId | 17.6.0 | Number(11,0) | Identifies school this record is related to. Migrated from [VirtualTablesData.SchoolId]. |
ForeignKey | 17.6.0 | Number(11,0) | Alternate Foreign Key. Migrated from [VirtualTablesData.ForeignKey]. |
ForeignKey_Alpha | 17.6.0 | Varchar2(31) | Contains data from field named NM_ServiceSize. Indicates service size. Migrated from [VirtualTablesData.ForeignKey_Alpha]. |
ServiceCode | 17.6.0 | Varchar2(10) | Indicates service type this record is related to. Migrated from [VirtualTablesData.User_Defined_Text]. |
PlacementType | 17.6.0 | Varchar2(5) | Placement type. Migrated from [VirtualTablesData.User_Defined_Text2]. |
ServiceFrequency | 17.6.0 | Number(25,10) | Service frequency. Migrated from [VirtualTablesData.NM_ServiceFrequency]. |
ServiceCycle | 17.6.0 | Varchar2(5) | Service cycle. Migrated from [VirtualTablesData.NM_ServiceCycle]. |
IntegratedServiceStatus | 17.6.0 | Varchar2(5) | Integrated service status. Migrated from [VirtualTablesData.NM_IntegratedServiceStatus]. |
StaffSSN | 17.6.0 | Varchar2(11) | Social security number of relevant staff member. Migrated from [VirtualTablesData.NM_StaffSSN]. |
ServiceProviderName | 17.6.0 | Varchar2(100) | Service provider name. Migrated from [VirtualTablesData.NM_ServiceProviderName]. |
EntryDate | 17.6.0 | Date | Date student entered service. Migrated from [VirtualTablesData.User_Defined_Date]. |
ExitDate | 17.6.0 | Date | Date student exited service. Migrated from [VirtualTablesData.User_Defined_Date2]. |
YearId | 17.6.0 | Number(11,0) | Indicates to which school year this record applies. Migrated from [VirtualTablesData.User_Defined_Integer]. |
CompDate | 17.6.0 | Date | Compliance date. Migrated from [VirtualTablesData.NM_CompDate]. |
ServiceDuration | 18.8.0 | Number(11,0) | Number of minutes a student receives services on a weekly basis |