Skip to main content
Skip table of contents

S_CA_CALPADS_SPED_REC_S (ver 20.10.2.0)

This table S_CA_CALPADS_SPED_REC_S is a Standalone table.

Column Name

Version

Data Type

Description

AcademicYearId

20.10.2.0

Varchar2(9)

AcademicYearId

AcademicYearIdSSID

20.10.2.0

Varchar2(10)

SSID

AgencyRepIEPPartCode20.10.2.0Varchar2(2)AgencyRepIEPPartCode
DisabilityCode120.10.2.0Varchar2(3)DisabilityCode1
DisabilityCode220.10.2.0Varchar2(3)DisabilityCode2
EduPlanAmmendDate20.10.2.0Varchar2(8)EduPlanAmmendDate
EduPlanTypeCode20.10.2.0Varchar2(3)EduPlanTypeCode
Filler120.10.2.0Varchar2(1)Filler1
Filler120.10.2.0Varchar2(1)Filler1
GenEduPartPctRangeCode20.10.2.0Varchar2(1)GenEduPartPctRangeCode
IEPPostSecGoalInd20.10.2.0Varchar2(1)IEPPostSecGoalInd
InfantRegEligInd20.10.2.0Varchar2(1)InfantRegEligInd

LocalRecordID

20.10.2.0

Varchar2(255)

LocalRecordID

LocalSPEDStudID20.10.2.0Varchar2(16)LocalSPEDStudID
LocalStudentId20.10.2.0Varchar2(15)LocalStudentId
MeetingDelayCode20.10.2.0Varchar2(2)MeetingDelayCode
ParentConsentDate20.10.2.0Varchar2(8)ParentConsentDate
ParentInvFacilitationCode20.10.2.0Varchar2(2)ParentInvFacilitationCode
PostSecGoalsAnualInd20.10.2.0Varchar2(1)PostSecGoalsAnualInd
PostSecGoalsTransAsmtInd20.10.2.0Varchar2(1)PostSecGoalsTransAsmtInd
PreSchProgSettLocCode20.10.2.0Varchar2(1)PreSchProgSettLocCode
PrimaryResidenceCode20.10.2.0Varchar2(3)PrimaryResidenceCode
RaceCode120.10.2.0Varchar2(3)RaceCode1
RaceCode220.10.2.0Varchar2(3)RaceCode2
RaceCode320.10.2.0Varchar2(3)RaceCode3
RaceCode420.10.2.0Varchar2(3)RaceCode4
RaceCode520.10.2.0Varchar2(3)RaceCode5

RecordType

20.10.2.0.0

Varchar2(4)

RecordType

RecUpdateStatus20.10.2.0Varchar2(1)RecUpdateStatus
ReferringPartyCode20.10.2.0Varchar2(2)ReferringPartyCode

ReportingLEA

20.10.2.0

Varchar2(7)

ReportingLEA

ReportingSELPA20.10.2.0Varchar2(4)ReportingSELPA

SchoolOfAttendance

20.10.2.0

Varchar2(7)

SchoolOfAttendance

SchoolOfAttendanceNPS

20.10.2.0

Varchar2(7)

SchoolOfAttendanceNPS

SpecialTransInd20.10.2.0Varchar2(1)SpecialTransInd
SPEDAccountabilityDistrict20.10.2.0Varchar2(7)PEDAccountabilityDistrict
SPEDEntryDate20.10.2.0Varchar2(8)SPEDEntryDate
SPEDMeetingAmmendId20.10.2.0Varchar2(28)SPEDMeetingAmmendId
SPEDMeetingDate20.10.2.0Varchar2(8)SPEDMeetingDate
SPEDMeetingType20.10.2.0Varchar2(2)SPEDMeetingType
SPEDPrgTypeCode20.10.2.0Varchar2(3)SPEDPrgTypeCode
SPEDProgExitdate20.10.2.0Varchar2(8)SPEDProgExitdate
SPEDProgExitReasonCode20.10.2.0Varchar2(1)SPEDProgExitReasonCode
SPEDProgSettCode20.10.2.0Varchar2(3)SPEDProgSettCode
SPEDReferralDate20.10.2.0Varchar2(8)SPEDReferralDate
StuBirthDate20.10.2.0Varchar2(8)StuBirthDate
StuEthMissingInd20.10.2.0Varchar2(1)StuEthMissingInd
StuGender20.10.2.0Varchar2(1)StuGender
StuHisEthInd20.10.2.0Varchar2(1)StuHisEthInd
StuIEPPartInd20.10.2.0Varchar2(1)StuIEPPartInd
StuLegalFirstName20.10.2.0Varchar2(30)StuLegalFirstName
StuLegalLastName20.10.2.0Varchar2(50)StuLegalLastName
StuRaceMissingInd20.10.2.0Varchar2(1)StuRaceMissingInd
SubmissionType20.10.2.0Varchar2(1)SubmissionType
SupportServiceInd20.10.2.0Varchar2(1)SupportServiceInd
TenOrMoreWeeklyInd20.10.2.0Varchar2(1)TenOrMoreWeeklyInd

TransactionType

20.10.2.0

Varchar2(1)

TransactionType

TransServiceGoalsIEPInd20.10.2.0Varchar2(1)TransServiceGoalsIEPInd
TransServiceIEPInd20.10.2.0Varchar2(1)TransServiceIEPInd



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.