S_CA_CALPADS_SERV_REC_S (ver 23.4.3.0)
This table S_CA_CALPADS_SERV_REC_S is a Standalone table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AcademicYearId | 23.4.3.0 | Varchar2(9) | Academic Year ID |
LocalRecordId | 23.4.3.0 | Varchar2(255) | Local Record ID |
| LocalSPEDStuId | 23.4.3.0 | Varchar2(16) | Local Special Education Student ID |
| LocalStuId | 23.4.3.0 | Varchar2(15) | Local Student ID |
| NonPubAgencyIdentifier | 23.4.3.0 | Varchar2(9) | Nonpublic Agency Identifier (NPA) |
| PlanEffStartDate | 23.4.3.0 | Varchar2(8) | Plan Effective Start Date |
RecordType | 23.4.3.0 | Varchar2(4) | Record Type |
| RecUpdateStatus | 23.4.3.0 | Varchar2(1) | Record Update Status |
ReportingLEA | 23.4.3.0 | Varchar2(7) | Reporting LEA |
| ReportingSELPA | 23.4.3.0 | Varchar2(4) | Reporting SELPA |
| ServiceDuration | 23.4.3.0 | Varchar2(4) | Service Duration |
| ServiceFreqCode | 23.4.3.0 | Varchar2(2) | Service Frequency Code |
| SPEDAccountabilityDistrict | 23.4.3.0 | Varchar2(7) | District of Special Education Accountability |
| SPEDLocationCode | 23.4.3.0 | Varchar2(3) | Special Education Service Location Code |
| SPEDProviderCode | 23.4.3.0 | Varchar2(3) | Special Education Service Provider Code |
| SPEDServiceCode | 23.4.3.0 | Varchar2(3) | Special Education Service Code |
| SSID | 23.4.3.0 | Varchar2(10) | SSID |
| SubmissionType | 23.4.3.0 | Varchar2(1) | Submission Type |
TransactionType | 23.4.3.0 | Varchar2(1) | Transaction Type |