Skip to main content
Skip table of contents

S_NM_STU_GroupFact_C (ver 17.6.0)

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

SchoolId

17.6.0

Number(11,0)

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

ForeignKey

17.6.0

Number(11,0)

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

ForeignKey_Alpha

17.6.0

Varchar2(31)

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

GroupEntryDate

17.6.0

Date

Date of entry into group. Migrated from [VirtualTablesData2.User_Defined_Date].

GroupExitDate

17.6.0

Date

Date of exit from group. Migrated from [VirtualTablesData2.User_Defined_Date2].

GroupCode

17.6.0

Varchar2(10)

Indicates which group this record is related to. Migrated from [VirtualTablesData2.User_Defined_Text].

GroupStatus

17.6.0

Varchar2(20)

Group status. Migrated from [VirtualTablesData2.User_Defined_Text2].

JavaScript errors detected

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

If this problem persists, please contact our support.