S_NM_STU_ProgramQualif_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 ProgramQualif 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) | Contains data from field named NM_ProgramCode. Indicates the program type this record is related to. Migrated from [VirtualTablesData2.ForeignKey_Alpha]. |
QualificationType | 17.6.0 | Varchar2(4) | Qualification type. Migrated from [VirtualTablesData2.NM_QualificationType]. |
QualificationInfoCode | 17.6.0 | Varchar2(4) | Qualification info code id. Migrated from [VirtualTablesData2.User_Defined_Text]. |
ProgramQualifEndDate | 17.6.0 | Date | The last date the student qualified for this service. Migrated from [VirtualTablesData2.User_Defined_Date2]. |
QualificationDate | 17.6.0 | Varchar2(6) | Qualification date. Migrated from [VirtualTablesData2.User_Defined_Text2]. |
ProgramQualifStartDate | 17.6.0 | Date | The date the student became qualified for this service. Migrated from [VirtualTablesData2.User_Defined_Date]. |