S_CA_STU_SPEDPrgServices_C (ver 17.9.0)
This table is a child table of STUDENTS, storing CASEMIS services associated with CALPADS 144 programs.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [CASEMIS_StudentServices.unique_ID]. |
AutoEnded_Tmp | 17.9.0 | Number(25,10) | Auto Ended Temp (for PS internal use only). Migrated from [CASEMIS_StudentServices.user_defined_numeric]. |
ContactName | 17.9.0 | Varchar2(40) | Contact Name. Migrated from [CASEMIS_StudentServices.contactName]. |
Duration | 17.9.0 | Number(25,10) | Duration. Migrated from [CASEMIS_StudentServices.duration]. |
EndDate | 17.9.0 | Date | End Date. Migrated from [CASEMIS_StudentServices.user_defined_date2]. |
ForeignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [CASEMIS_StudentServices.foreignKey]. |
ForeignKey_Alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [CASEMIS_StudentServices.foreignKey_alpha]. |
FrequencyCode | 17.9.0 | Varchar2(2) | Frequency Code. Migrated from [CASEMIS_StudentServices.frequencyCode]. |
| Group Size | 19.1.0 | Varchar2(25) | Identifies the group size. |
LocationCode | 17.9.0 | Varchar2(3) | Location Code. Migrated from [CASEMIS_StudentServices.user_defined_text2]. |
| NonPublicAgeInd | 20.9.3.0 | Varchar2(9) | Nonpublic Agency Identifier(NPA) |
Notes | 17.9.0 | Varchar2(255) | Notes. Migrated from [CASEMIS_StudentServices.notes]. |
ProviderCode | 17.9.0 | Varchar2(3) | Provider Code. Migrated from [CASEMIS_StudentServices.user_defined_text]. |
SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [CASEMIS_StudentServices.schoolID]. |
ServiceCode | 17.9.0 | Number(11,0) | Service Code. Migrated from [CASEMIS_StudentServices.user_defined_integer]. |
StartDate | 17.9.0 | Date | Start Date. Migrated from [CASEMIS_StudentServices.user_defined_date]. |
TimeMultiplier | 17.9.0 | Number(11,0) | Time Multiplier. Migrated from [CASEMIS_StudentServices.timeMultiplier]. |