SC_Reported_Records Virtual Table

This table contains a combination of student's enrollments and EFA/EIA records that are selected to report for that collection.

Data Element	Importing: [Table]Field	DDE: [Table]Field
Created By	[SC_Reported_Records]created_By	[VirtualTablesData3]created _By
Created On	[SC_Reported_Records]created_On	[VirtualTablesData3]created _On
Enroll Entry	[SC_Reported_Records]user_defined_date	[VirtualTablesData3]user_defined_date
Enroll Exit	[SC_Reported_Records]enroll_defined_date2	[VirtualTablesData3]enroll_defined_date2
Enroll Grade Level	[SC_Reported_Records]user_defined_integer	[VirtualTablesData3]user_defined_integer
Enroll School	[SC_Reported_Records]user_defined_text	[VirtualTablesData3]user_defined_text
Entry Code	[SC_Reported_Records]entry_code	[VirtualTablesData3]custom
Exit Code	[SC_Reported_Records]exit_code	[VirtualTablesData3]custom
Last Modified	[SC_Reported_Records]last_Modified	[VirtualTablesData3]last_Modified
Modified By	[SC_Reported_Records]Modified_By	[VirtualTablesData3]Modified_By
Record Type	[SC_Reported_Records]foreignKey_alpha	[VirtualTablesData3]foreignKey_alpha
Record Codes	[SC_Reported_Records]record_codes	[VirtualTablesData3]custom
Record ID	[SC_Reported_Records]User_defined_text2	[VirtualTablesData3]User_defined_text2
Record Start	[SC_Reported_Records]record_start	[VirtualTablesData3]custom
Record Stop	[SC_Reported_Records]record_stop	[VirtualTablesData3]custom
School ID Report	[SC_Reported_Records]schoolID_report	[VirtualTablesData3]custom
Student ID ([Students]ID value)	[SC_Reported_Records]foreignKey	[VirtualTablesData3]foreignKey
Student Name	[SC_Reported_Records]student_name	[VirtualTablesData3] custom
User ID	[SC_Reported_Records]user_defined_numeric	[VirtualTablesData3]user_defined_numeric