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 |