Student CTE Table
For general information about Virtual Tables, such as how to view Virtual Table records, see Virtual Tables.
Virtual table name: StudentCTE
Data Element | Importing: [Table]Field | DDE: [Table]Field | Required for Import |
|---|---|---|---|
School ID | [StudentCTE]SchoolID | VirtualTablesData3]SchoolID | Yes |
Academic Year | [StudentCTE]AcademicYear Format: CCYY-CCYY | [VirtualTablesData3]user_defined_text (also seen as AcademicYear) | Yes |
Pathway Code | [StudentCTE]PathwayCode | [VirtualTablesData3]user_defined_integer (also seen as PathwayCode) | Yes |
Pathway Completer | [StudentCTE]Completer Import 1 for Yes, blank for No | [VirtualTablesData3]user_defined_text2 (also seen as Completer) | No |
Student ID Note: This is the internal student ID, stored in [Students]ID. The ID can also be found on the bottom/center of the Teacher Comments student page. | [StudentCTE]foreignKey | [VirtualTablesData2]foreignKey | Yes |