For general information about Virtual Tables, such as how to view Virtual Table records, see Virtual Tables.
Virtual table name: CALPADS_StudentServices
Note: Student Program records must be imported before Student Program Service records.
|
Data Element |
Importing: [Table]Field |
DDE: [Table]Field |
Required for Import |
|---|---|---|---|
|
Education Program Membership Start Date |
[CALPADS_StudentServices]StartDate |
[VirtualTablesData]user_defined_date (also seen as StartDate) |
Yes |
|
Education Program Membership End Date |
[CALPADS_StudentServices]EndDate |
[VirtualTablesData]user_defined_date2 (also seen as EndDate) |
Yes, if the program service has ended. |
|
Education Service Code |
[CALPADS_StudentServices]serviceCode |
[VirtualTablesData]user_defined_integer (also seen as serviceCode) |
Yes |
|
School ID |
[CALPADS_StudentServices]schoolID |
[VirtualTablesData]schoolID |
Yes |
|
Program ID Note: Export student program records to locate the internal ID of the program record, stored in the unique_ID field. |
[CALPADS_StudentServices]foreignKey |
[VirtualTablesData]foreignKey |
Yes |