S_NM_STU_ProgramFact_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 ProgramFact 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_ProgramIntensity. Program intensity - only select when program code is BEP. Migrated from [VirtualTablesData.ForeignKey_Alpha]. |
PgmStartDate | 17.6.0 | Date | Original PGM start date - only for programs of code CEIS, 3Y, 4Y, or FACE. Migrated from [VirtualTablesData.User_Defined_Date]. |
BeginningDate | 17.6.0 | Date | The date the student started the program. Migrated from [VirtualTablesData.User_Defined_Date2]. |
EndingDate | 17.6.0 | Varchar2(10) | The date the student exited the program. Migrated from [VirtualTablesData.User_Defined_Text2]. |
ParticipationInfoCode | 17.6.0 | Varchar2(5) | Participation info code. Migrated from [VirtualTablesData.User_Defined_Text]. |
ProgramCode | 17.6.0 | Varchar2(8) | Indicates the program type this record is related to. Migrated from [VirtualTablesData.NM_ProgramCode]. |
ProgramComment | 17.6.0 | Varchar2(60) | Program comment. Migrated from [VirtualTablesData.NM_ProgramComment]. |
ELTPProgFreq | 19.8.1.0 | Number(11,0) | To collect Program Frequency |
ELTPProgDur | 19.8.1.0 | Number(11,0) | To collect Program Duration |
ELTPProgSesCode | 19.8.1.0 | Varchar2(1) | To collect Program Session Code |
ProgramIntensity | 22.2.2.0 | Number(11,0) | To Collect Program Intensity |