Student Program Table
For general information about Virtual Tables, such as how to view Virtual Table records, see Virtual Tables.
Virtual table name: StudentProgram
Note: This table is also used for Lunch Program records.
Data Element | Importing: [Table]Field | DDE: [Table]Field | Required for Import |
|---|---|---|---|
Education Program Code | [StudentProgram]CA_prog_code | [VirtualTablesData2]user_defined_text (also seen as CA_prog_code) | Yes |
Primary Disability Code | [StudentProgram]CA_pri_disability_code | [VirtualTablesData2]CA_pri_disability_code (also seen as CA_pri_disability_code) | Yes, if the Education Program Code is 144. |
Education Program Membership Code | [StudentProgram]CA_prog_mem_code | [VirtualTablesData2]user_defined_text2 (also seen as CA_prog_mem_code) | Yes |
Education Program Membership Start Date | [StudentProgram]CA_prog_mem_Start_Date | [VirtualTablesData2]user_defined_date (also seen as CA_prog_mem_ Start_Date) | Yes |
Education Program Membership End Date | [StudentProgram]CA_prog_mem_End_Date | [VirtualTablesData2]user_defined_date2 (also seen as CA_prog_mem_ End_Date) | Yes, if the program participation has ended. |
California Partnership Academy ID | [StudentProgram]CA_partner_acad_ID | [VirtualTablesData2]CA_partner_acad_ID | Yes, if the Education Program Code is 113. |
District of Special Education Accountability | [StudentProgram]CA_dist_sp_edu_acnty | [VirtualTablesData2]CA_dist_sp_edu_acnty | No |
Special Education Exit Code | [StudentProgram]CA_exitCode | [VirtualTablesData2]CA_exitCode | No |
Student Foster Client ID | [StudentProgram]CA_FosterClientID | [VirtualTablesData2]CA_FosterClientID | No |
Dwelling Type | [StudentProgram]CA_dwelling_type | [VirtualTablesData2]CA_dwelling_type | No |
Unaccompanied Youth | [StudentProgram]CA_UnaccYouth | [VirtualTablesData2]CA_UnaccYouth | No |
Runaway Youth | [StudentProgram]CA_RunawayYouth | [VirtualTablesData2]CA_RunawayYouth | No |
Migrant Student ID | [StudentProgram]CA_MigrantId | [VirtualTablesData2]CA_MigrantId | Yes, if the Education Program Code is 135. |
School ID | [StudentProgram]schoolID | [VirtualTablesData2]schoolID | Yes |
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. | [StudentProgram]foreignKey | [VirtualTablesData2]foreignKey | Yes |