Skip to main content
Skip table of contents

S_NM_STU_SpedEvents_C (ver 17.6.0)

This is a child table of the Students table. The data is populated from the VirtualTablesData3 table. Only records related to SpedEvents 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 [VirtualTablesData3.Unique_Id].

SchoolId

17.6.0

Number(11,0)

Identifies school this record is related to. Migrated from [VirtualTablesData3.SchoolId].

ForeignKey

17.6.0

Number(11,0)

Alternate Foreign Key. Migrated from [VirtualTablesData3.ForeignKey].

ForeignKey_Alpha

17.6.0

Varchar2(31)

Unused but needed for migration. Migrated from [VirtualTablesData3.ForeignKey_Alpha].

EventDate

17.6.0

Date

The actual date of the event. Migrated from [VirtualTablesData3.User_Defined_Date].

EventType

17.6.0

Number(11,0)

Event type code. Migrated from [VirtualTablesData3.User_Defined_Integer].

EventReason

17.6.0

Varchar2(4)

Event reason code. Migrated from [VirtualTablesData3.User_Defined_Text].

SpedNonComplianceReason

17.6.0

Varchar2(4)

Non-compliance reason code. Migrated from [VirtualTablesData3.User_Defined_Text2].

SubToSTARSCode

17.6.0

Varchar2(6)

Indicates the STARS reporting segment. Migrated from [VirtualTablesData3.NM_SubmittedToSTARS_Code].

SubToSTARSDate

17.6.0

Date

The date corresponding to the STARS reporting segment. Migrated from [VirtualTablesData3.NM_SubmittedToSTARS_Date].

YearID

24.4.2.0

Number(11,0)

Force this record to publish

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.