S_AB_STU_ConEnrollments_C (ver 17.9.2)
This is a child table of the Students table. The data is populated from the VirtualTablesData table. Only records related to ConcurrentEnrollments are stored in this table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Id | 17.9.2 | Number(10,0) | Primary Key. |
StudentsDcid | 17.9.2 | Number(10,0) | Foreign Key. |
Unique_Id | 17.9.2 | Number(11,0) | Alternate Primary Key. Migrated from [VirtualTablesData.Unique_Id]. |
| SchoolId | 17.9.2 | Number(11,0) | Identifies school this record is related to. Migrated from [VirtualTablesData.SchoolId]. |
| ForeignKey | 17.9.2 | Number(11,0) | Alternate Foreign Key. Migrated from [VirtualTablesData.ForeignKey]. |
| ForeignKey_Alpha | 17.9.2 | Varchar2(31) | Unused but needed for migration. Migrated from [VirtualTablesData.ForeignKey_Alpha]. |
| EntryDate | 17.9.2 | Date | Entry Date. Migrated from [VirtualTablesData.User_Defined_Date]. |
| ExitDate | 17.9.2 | Date | Exit Date. Migrated from [VirtualTablesData.User_Defined_Date2]. |
| Grade_Level | 17.9.2 | Number(25,10) | Grade Level. Migrated from [VirtualTablesData.User_Defined_Numeric]. |
| EntryCode | 17.9.2 | Varchar2(3) | Entry Code. Migrated from [VirtualTablesData.User_Defined_Text]. |
| ExitCode | 17.9.2 | Varchar2(5) | Exit Code. Migrated from [VirtualTablesData.User_Defined_Text2]. |
| ResidentBoard | 17.9.2 | Varchar2(4) | Resident Board. Migrated from [VirtualTablesData.AB_Resident_Board]. |
| GrantsProgram1 | 17.9.2 | Varchar2(3) | Grants Program (1). Migrated from [VirtualTablesData.AB_Grants_Program_1]. |
| GrantsProgram2 | 17.9.2 | Varchar2(3) | Grants Program (2). Migrated from [VirtualTablesData.AB_Grants_Program_2]. |
| GrantsProgram3 | 17.9.2 | Varchar2(3) | Grants Program (3). Migrated from [VirtualTablesData.AB_Grants_Program_3]. |
| SpclEduStu1 | 17.9.2 | Varchar2(2) | Special Education Student (1). Migrated from [VirtualTablesData.AB_Spcl_Edu_Stu_1]. |
| SpclEduStu2 | 17.9.2 | Varchar2(2) | Special Education Student (2). Migrated from [VirtualTablesData.AB_Spcl_Edu_Stu_2]. |
| EnrlType1 | 17.9.2 | Varchar2(3) | Enrollment Type (1). Migrated from [VirtualTablesData.AB_Enrl_Type_1]. |
| EnrlType2 | 17.9.2 | Varchar2(3) | Enrollment Type (2). Migrated from [VirtualTablesData.AB_Enrl_Type_2]. |
| EnrlType3 | 17.9.2 | Varchar2(3) | Enrollment Type (3). Migrated from [VirtualTablesData.AB_Enrl_Type_3]. |
| RegistrationType | 17.9.2 | Varchar2(1) | Registration Type. Migrated from [VirtualTablesData.AB_Regi_Type]. |
| FrenchHours | 17.9.2 | Number(11,0) | French Instruction Hours. Migrated from [VirtualTablesData.AB_Fren_Hrs_Cal]. |
| FNMI | 17.9.2 | Varchar2(3) | First Nation/Metis Inuit (FNMI). Migrated from [VirtualTablesData.AB_FNMI]. |
| EnrlChgRsn | 17.9.2 | Varchar2(50) | Enrollment Change Reason. Migrated from [VirtualTablesData.AB_Enrl_ChgRsn]. |
| EnrlChgComments | 17.9.2 | Varchar2(250) | Enrollment Change Comments. Migrated from [VirtualTablesData.AB_Enrl_ChgComments]. |
| SchProvidedProgPercentage | 18.11.0 | Number(11,0) | School Provided Program Percentage. |
| PROGRAMMINGTYPE | 22.7.1 | VARCHAR2(100 CHAR) | The Programming Type of the registration. |
| PROGRAMMINGTIMEFRAME | 22.7.1 | VARCHAR2(100 CHAR) | The Programming Timeframe of the registration. |
| EXITDATETYPE | 22.7.1 | VARCHAR2(100 CHAR) | The exit date Type of the registration. |