Student Program Services Table
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 |