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 |