California-Specific Legacy Custom Field Migration to Database Extensions
Contents
Field set information is provided for each California-specific custom field migration file released. For detailed information on California-specific database extensions, please refer to the Data Dictionary.
Field Set: State CA CC v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
CC | CA_Repeated_Course | S_CA_CC_X | Repeated_Course |
Field Set: State CA Courses v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
COURSES | CA_ContentCode | S_CA_CRS_X | ContentCode |
COURSES | CA_CourseLevel | S_CA_CRS_X | CourseLevel |
COURSES | CA_CourseType | S_CA_CRS_X | CourseType |
COURSES | CA_CTECapstone | S_CA_CRS_X | CTECapstone |
COURSES | CA_CTEProvider | S_CA_CRS_X | CTEProvider |
COURSES | CA_CTETechPrep | S_CA_CRS_X | CTETechPrep |
COURSES | CA_DistanceLearning | S_CA_CRS_X | DistanceLearning |
COURSES | CA_EdServiceCode | S_CA_CRS_X | EdServiceCode |
COURSES | CA_FundingSource | S_CA_CRS_X | FundingSource |
COURSES | CA_IndependentStudy | S_CA_CRS_X | IndependentStudy |
COURSES | CA_InstStrategy | S_CA_CRS_X | InstStrategy |
COURSES | CA_LangInstruction | S_CA_CRS_X | LangInstruction |
COURSES | CA_NCLBCoreCourse | S_CA_CRS_X | NCLBCoreCourse |
COURSES | CA_NS_Instructional_Lvl | S_CA_CRS_X | NS_Instructional_Lvl |
COURSES | CA_TranscriptCourseName | S_CA_CRS_X | TranscriptCourseName |
COURSES | CA_UCCSU_Area | S_CA_CRS_X | UCCSU_Area |
COURSES | State_ExcludeFromReporting | S_CA_CRS_X | State_ExcludeFromReporting |
Field Set: State CA ReEnrollments v2
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
| REENROLLMENTS | InterdistrictTransfer | S_CA_REN_X | InterdistrictTransfer |
| REENROLLMENTS | CA_EnrollmentStatus | S_CA_REN_X | EnrollmentStatus |
| REENROLLMENTS | CA_GradeLevelOverride | S_CA_REN_X | GradeLevelOverride |
| REENROLLMENTS | CA_NPS_CDS_SchoolCode | S_CA_REN_X | NPS_CDS_SchoolCode |
| REENROLLMENTS | CA_ExcludeFromADA | S_CA_REN_X | ExcludeFromADA |
| REENROLLMENTS | CA_ReceiverSchool | S_CA_REN_X | ReceiverSchool |
| REENROLLMENTS | CA_SchoolCompletionStatus | S_CA_REN_X | SchoolCompletionStatus |
| REENROLLMENTS | CA_SchoolEntryDate | S_CA_REN_X | SchoolEntryDate |
| REENROLLMENTS | CA_SpEdGradeLevel | S_CA_REN_X | SpEdGradeLevel |
| REENROLLMENTS | state_excludeenrollment | S_CA_REN_X | State_ExcludeEnrollment |
Field Set: State CA Schools v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SCHOOLS | CA_AddendumComments | S_CA_SCH_X | AddendumComments |
SCHOOLS | CA_Admin_Email | S_CA_SCH_X | AdminEmail |
SCHOOLS | CA_Admin_First_Name | S_CA_SCH_X | AdminFirstName |
SCHOOLS | CA_Admin_Last_Name | S_CA_SCH_X | AdminLastName |
SCHOOLS | CA_Admin_Phone | S_CA_SCH_X | AdminPhone |
SCHOOLS | CA_CalendarType | S_CA_SCH_X | CalendarType |
SCHOOLS | CA_CalpadsStoreCodes | S_CA_SCH_X | ExcludedStoreCodesFromEOY |
SCHOOLS | CA_CharterSchool | S_CA_SCH_X | CharterSchoolFlag |
SCHOOLS | CA_CharterSchoolNumber | S_CA_SCH_X | CharterSchoolNumber |
SCHOOLS | CA_ClassInternet | S_CA_SCH_X | ClassroomInternetAccessCount |
SCHOOLS | CA_CompInstruc | S_CA_SCH_X | ComputersForInstructionCount |
SCHOOLS | CA_CSIS_SchoolNum | S_CA_SCH_X | StateSchoolNumber |
SCHOOLS | CA_ExcludeFromEoy1 | S_CA_SCH_X | ExcludeFromEOY1 |
SCHOOLS | CA_ExplanationZeroTruants | S_CA_SCH_X | ExplanationForZeroTruants |
SCHOOLS | CA_InstSettings | S_CA_SCH_X | InstructionalSettingsCount |
SCHOOLS | CA_OneYearCourseUnits | S_CA_SCH_X | CarnegieUnitsPerOneYearCourse |
SCHOOLS | CA_Perkins_EconDisadvantaged | S_CA_SCH_X | PerkinsEconDisadvantagedFlag |
SCHOOLS | CA_School_ATP_Code | S_CA_SCH_X | SchoolATPCode |
SCHOOLS | CA_SchoolLogoName | S_CA_SCH_X | SchoolLogoName |
SCHOOLS | CA_SchoolProgramType | S_CA_SCH_X | SchoolProgramType |
SCHOOLS | CA_SchoolType | S_CA_SCH_X | SchoolType |
SCHOOLS | CA_SessionType | S_CA_SCH_X | SessionType |
SCHOOLS | CA_SessionType_minus_1yr | S_CA_SCH_X | SessionTypeMinus1Year |
SCHOOLS | CA_SessionType_minus_2yr | S_CA_SCH_X | SessionTypeMinus2Year |
SCHOOLS | CA_SessionType_minus_3yr | S_CA_SCH_X | SessionTypeMinus3Year |
SCHOOLS | CA_Tech_Email | S_CA_SCH_X | TechEmail |
SCHOOLS | CA_Tech_First_Name | S_CA_SCH_X | TechFirstName |
SCHOOLS | CA_Tech_Last_Name | S_CA_SCH_X | TechLastName |
SCHOOLS | CA_Tech_Phone | S_CA_SCH_X | TechPhone |
SCHOOLS | CA_UC_Direct_Auth_Key | S_CA_SCH_X | UCDirectAuthenticationKey |
Field Set: State CA Schools v2
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SCHOOLS | CA_KindergartenProgram | S_CA_SCH_X | KindergartenProgram |
SCHOOLS | CA_TransKindergartenProgram | S_CA_SCH_X | TransKindergartenProgram |
Field Set: State CA Sections v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SECTIONS | CA_AcademicTerm | S_CA_SEC_X | AcademicTerm |
SECTIONS | CA_CensusTeacherId | S_CA_SEC_X | CensusTeacherId |
SECTIONS | CA_CTECapstone | S_CA_SEC_X | CTECapstone |
SECTIONS | CA_CTEProvider | S_CA_SEC_X | CTEProvider |
SECTIONS | CA_DistanceLearning | S_CA_SEC_X | DistanceLearning |
SECTIONS | CA_EdServiceCode | S_CA_SEC_X | EdServiceCode |
SECTIONS | CA_FundingSource | S_CA_SEC_X | FundingSource |
SECTIONS | CA_HQTCompentency | S_CA_SEC_X | HQTCompentency |
SECTIONS | CA_IndependentStudy | S_CA_SEC_X | IndependentStudy |
SECTIONS | CA_InstStrategy | S_CA_SEC_X | InstStrategy |
SECTIONS | CA_LangInstruction | S_CA_SEC_X | LangInstruction |
SECTIONS | CA_MultHQTCompentency | S_CA_SEC_X | MultHQTCompentency |
SECTIONS | CA_MultipleTeacherID | S_CA_SEC_X | MultipleTeacherID |
SECTIONS | CA_MultipleTeacherStatus | S_CA_SEC_X | MultipleTeacherStatus |
SECTIONS | CA_NS_Instructional_Lvl | S_CA_SEC_X | NS_Instructional_Lvl |
Field Set: State CA Students v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
STUDENTS | CA_AKAFirst | S_CA_STU_X | AKAFirst |
STUDENTS | CA_AKAMiddle | S_CA_STU_X | AKAMiddle |
STUDENTS | CA_AKASurname | S_CA_STU_X | AKASurname |
STUDENTS | CA_BirthCountry | S_CA_STU_X | BirthCountry |
STUDENTS | CA_BirthPlace_City | S_CA_STU_X | BirthPlace_City |
STUDENTS | CA_BirthPlace_StateProvince | S_CA_STU_X | BirthPlace_StateProvince |
STUDENTS | CA_FirstUSASchooling | S_CA_STU_X | FirstUSASchooling |
STUDENTS | CA_NameSuffix | S_CA_STU_X | NameSuffix |
STUDENTS | CA_PrimaryLanguage | S_CA_STU_X | PrimaryLanguage |
Field Set: State CA Students v2
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
STUDENTS | CA_Address2 | S_CA_STU_X | Address2 |
| STUDENTS | CA_After3rdBD | S_CA_STU_X | After3rdBD |
| STUDENTS | CA_AltAssess | S_CA_STU_X | AltAssess |
| STUDENTS | CA_CasemisNote | S_CA_STU_X | CasemisNote |
| STUDENTS | CA_CELDT_TestPurpose | S_CA_STU_X | CELDT_TestPurpose |
| STUDENTS | CA_CensusMakeupInd | S_CA_STU_X | CensusMakeupInd |
| STUDENTS | CA_CMA_CSTTest | S_CA_STU_X | CMA_CSTTest |
| STUDENTS | CA_CMA_ELA | S_CA_STU_X | CMA_ELA |
| STUDENTS | CA_CMA_Math | S_CA_STU_X | CMA_Math |
| STUDENTS | CA_CMA_Science | S_CA_STU_X | CMA_Science |
| STUDENTS | CA_CompEmployment | S_CA_STU_X | CompEmployment |
| STUDENTS | CA_Counselor | S_CA_STU_X | Counselor |
| STUDENTS | CA_CountyOfResidence | S_CA_STU_X | CountyOfResidence |
| STUDENTS | CA_DateELAStatus | S_CA_STU_X | ELAStatusDate |
| STUDENTS | CA_DateEnroll | S_CA_STU_X | ELEnrollDate |
| STUDENTS | CA_DateRFEP | S_CA_STU_X | RFEPDate |
STUDENTS | CA_DiplomaType | S_CA_STU_X | DiplomaType |
| STUDENTS | CA_DistrictOfServices | S_CA_STU_X | DistrictOfServices |
| STUDENTS | CA_EarlyIntervening | S_CA_STU_X | EarlyIntervening |
| STUDENTS | CA_EL | S_CA_STU_X | ELProgram |
| STUDENTS | CA_ELAStatus | S_CA_STU_X | ELAStatus |
| STUDENTS | CA_ELCParentAuth | S_CA_STU_X | ELCParentAuth |
| STUDENTS | CA_ELCSubmit | S_CA_STU_X | ELCSubmit |
| STUDENTS | CA_ELlt12mos | S_CA_STU_X | ELlt12mos |
| STUDENTS | CA_ELProfELA | S_CA_STU_X | ELProfELA |
| STUDENTS | CA_EnrollmentStatus | S_CA_STU_X | EnrollmentStatus |
| STUDENTS | CA_ExcludeFromADA | S_CA_STU_X | ExcludeFromADA |
| STUDENTS | CA_Expected_GradDate | S_CA_STU_X | ExpectedGradDate |
| STUDENTS | CA_FedSetting | S_CA_STU_X | FedSetting |
| STUDENTS | CA_FR_Code | S_CA_STU_X | FR_Code |
| STUDENTS | CA_G1Relationship | S_CA_STU_X | G1Relationship |
| STUDENTS | CA_G2Relationship | S_CA_STU_X | G2Relationship |
| STUDENTS | CA_GATE | S_CA_STU_X | GATE |
| STUDENTS | CA_GradeLevelOverride | S_CA_STU_X | GradeLevelOverride |
| STUDENTS | CA_GradProgram | S_CA_STU_X | GradProgram |
| STUDENTS | CA_GraduationPlan | S_CA_STU_X | GraduationPlan |
| STUDENTS | CA_GraduationStatus | S_CA_STU_X | GraduationStatus |
| STUDENTS | CA_GroupCode | S_CA_STU_X | GroupCode |
| STUDENTS | CA_GroupName | S_CA_STU_X | GroupName |
| STUDENTS | CA_Gt60Days | S_CA_STU_X | Gt60DaysReasonCode |
| STUDENTS | CA_guardian2_fn | S_CA_STU_X | Guardian2_FirstName |
| STUDENTS | CA_guardian2_ln | S_CA_STU_X | Guardian2_LastName |
| STUDENTS | CA_HSEEExpEng | S_CA_STU_X | HSEEExpEng |
| STUDENTS | CA_HSEEExpMath | S_CA_STU_X | HSEEExpMath |
| STUDENTS | CA_IEPType | S_CA_STU_X | IEPType |
| STUDENTS | CA_ImmigrantFunding | S_CA_STU_X | ImmigrantFunding |
| STUDENTS | CA_InfFedSetting | S_CA_STU_X | InfFedSetting |
| STUDENTS | CA_InfInitEvaluationDate | S_CA_STU_X | InfInitEvaluationDate |
| STUDENTS | CA_InfParentConsentDate | S_CA_STU_X | InfParentConsentDate |
| STUDENTS | CA_InfRefAge2Date | S_CA_STU_X | InfRefAge2Date |
| STUDENTS | CA_InfReferredBy | S_CA_STU_X | InfReferredByCode |
| STUDENTS | CA_InfSetting | S_CA_STU_X | InfSetting |
| STUDENTS | CA_InitEvaluationDate | S_CA_STU_X | InitEvaluationDate |
| STUDENTS | CA_InterdistrictTransfer | S_CA_STU_X | InterdistrictTransfer |
| STUDENTS | CA_LastIEPDate | S_CA_STU_X | LastIEPDate |
| STUDENTS | CA_LatestEvalDate | S_CA_STU_X | LatestEvalDate |
| STUDENTS | CA_MigrantEd | S_CA_STU_X | MigrantEd |
| STUDENTS | CA_MultChWave | S_CA_STU_X | MultChoiceWave |
| STUDENTS | CA_NonPublicIEP | S_CA_STU_X | NonPublicIEP |
| STUDENTS | CA_NPS_CDS_SchoolCode | S_CA_STU_X | NPS_CDS_SchoolCode |
| STUDENTS | CA_Opportunity | S_CA_STU_X | Opportunity |
| STUDENTS | CA_ParentConsentDate | S_CA_STU_X | ParentConsentDate |
| STUDENTS | CA_ParentCorrespLang | S_CA_STU_X | ParentCorrespLang |
| STUDENTS | CA_ParentEd | S_CA_STU_X | ParentEd |
| STUDENTS | CA_ParInput | S_CA_STU_X | ParentInput |
| STUDENTS | CA_Post2ndProgram | S_CA_STU_X | Post2ndProgram |
| STUDENTS | CA_PostGrade12 | S_CA_STU_X | PostGrade12 |
| STUDENTS | CA_PreFedSetting | S_CA_STU_X | PreFedSetting |
| STUDENTS | CA_PreIDData1 | S_CA_STU_X | PreIDData1 |
| STUDENTS | CA_PreIDData2 | S_CA_STU_X | PreIDData2 |
| STUDENTS | CA_PreviousSelpa | S_CA_STU_X | PreviousSelpa |
| STUDENTS | CA_PrimaryGuardian | S_CA_STU_X | PrimaryGuardian |
| STUDENTS | CA_PrimaryResidence | S_CA_STU_X | PrimaryResidence |
| STUDENTS | CA_PrimaryDisability | S_CA_STU_X | PrimaryDisability |
| STUDENTS | CA_PTCPCahsee | S_CA_STU_X | PTCPCahsee |
| STUDENTS | CA_PTCPEla | S_CA_STU_X | PTCPEla |
| STUDENTS | CA_PTCPHistory | S_CA_STU_X | PTCPHistory |
| STUDENTS | CA_PTCPMath | S_CA_STU_X | PTCPMath |
| STUDENTS | CA_PTCPScience | S_CA_STU_X | PTCPScience |
| STUDENTS | CA_PTCPWriting | S_CA_STU_X | PTCPWriting |
| STUDENTS | CA_ReceiverSchool | S_CA_STU_X | ReceiverSchool |
| STUDENTS | CA_RefAge2Date | S_CA_STU_X | RefAge2Date |
| STUDENTS | CA_ReferredBy | S_CA_STU_X | ReferredByCode |
| STUDENTS | CA_RegClassPercent | S_CA_STU_X | RegClassPercent |
| STUDENTS | CA_ResStatus | S_CA_STU_X | ResStatus |
| STUDENTS | CA_SchoolCompletionStatus | S_CA_STU_X | SchoolCompletionStatus |
| STUDENTS | CA_SecondaryGuardian | S_CA_STU_X | SecondaryGuardian |
| STUDENTS | CA_SoleLow | S_CA_STU_X | SoleLow |
| STUDENTS | CA_SpEd504 | S_CA_STU_X | SpEd504 |
| STUDENTS | CA_SpEdGradeLevel | S_CA_STU_X | SpEdGradeLevel |
| STUDENTS | CA_SpTrans | S_CA_STU_X | SpTrans |
| STUDENTS | CA_STS | S_CA_STU_X | STS |
| STUDENTS | CA_TitleI_Targeted | S_CA_STU_X | TitleI_Targeted |
| STUDENTS | CA_TranReg1 | S_CA_STU_X | TranReg1 |
| STUDENTS | CA_TranReg2 | S_CA_STU_X | TranReg2 |
| STUDENTS | CA_TranReg3 | S_CA_STU_X | TranReg3 |
| STUDENTS | CA_TranReg4 | S_CA_STU_X | TranReg4 |
| STUDENTS | CA_TranReg5 | S_CA_STU_X | TranReg5 |
| STUDENTS | CA_TranReg6 | S_CA_STU_X | TranReg6 |
| STUDENTS | CA_TranReg7 | S_CA_STU_X | TranReg7 |
| STUDENTS | CA_TranReg8 | S_CA_STU_X | TranReg8 |
| STUDENTS | CA_TranscriptNotes | S_CA_STU_X | TranscriptNotes |
| STUDENTS | CA_UC_CSU | S_CA_STU_X | UC_CSU_Override |
| STUDENTS | CA_UC_CSU_Elig | S_CA_STU_X | UC_CSU_Elig |
| STUDENTS | CA_Use_UC_CSU_Override | S_CA_STU_X | UC_CSU_Use_Override |
| STUDENTS | CA_WritWave | S_CA_STU_X | WritingWave |
| STUDENTS | CA_state_excludeenrollment | S_CA_STU_X | State_ExcludeEnrollment |
Field Set: State CA Students v3
This field set was included with State Reporting Installer 18.2.0 released on February 22, 2018.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
STUDENTS | CA_SpEntryDate | S_CA_STU_X | SpEntryDate |
Field Set: State CA Users v1
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
TEACHERS | CA_ClassDesig | S_CA_USR_X | JobClassification |
| TEACHERS | CA_ELInstructor | S_CA_USR_X | ELInstructor |
| TEACHERS | CA_FormerFirstName | S_CA_USR_X | FormerFirstName |
| TEACHERS | CA_FormerLastName | S_CA_USR_X | FormerLastName |
| TEACHERS | CA_FormerMiddleName | S_CA_USR_X | FormerMiddleName |
| TEACHERS | CA_HighestDegree | S_CA_USR_X | HighestDegree |
| TEACHERS | CA_InstructionLanguage | S_CA_USR_X | InstructionLanguage |
| TEACHERS | CA_Parttime | S_CA_USR_X | PartTime |
| TEACHERS | CA_PositionStatus | S_CA_USR_X | PositionStatus |
| TEACHERS | CA_SEID | S_CA_USR_X | SEID |
| TEACHERS | CA_YearsInDistrict | S_CA_USR_X | YearsInDistrict |
| TEACHERS | CA_YearsOfService | S_CA_USR_X | YearsOfService |
Field Set: State CA Courses CRDC
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
COURSES | CRDC_APSubjectArea | S_CRS_CRDC_X | APSubjectArea |
COURSES | CRDC_CourseTypeAdvMath_YN | S_CRS_CRDC_X | CourseTypeAdvMath_YN |
COURSES | CRDC_CourseTypeAlgebraI_YN | S_CRS_CRDC_X | CourseTypeAlgebraI_YN |
COURSES | CRDC_CourseTypeAlgebraII_YN | S_CRS_CRDC_X | CourseTypeAlgebraII_YN |
COURSES | CRDC_CourseTypeBiology_YN | S_CRS_CRDC_X | CourseTypeBiology_YN |
COURSES | CRDC_CourseTypeCalculus_YN | S_CRS_CRDC_X | CourseTypeCalculus_YN |
COURSES | CRDC_CourseTypeChemistry_YN | S_CRS_CRDC_X | CourseTypeChemistry_YN |
COURSES | CRDC_CourseTypeGeometry_YN | S_CRS_CRDC_X | CourseTypeGeometry_YN |
COURSES | CRDC_CourseTypePhysics_YN | S_CRS_CRDC_X | CourseTypePhysics_YN |
Field Set: State CA Schools CRDC
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SCHOOLS | CRDC_AllMagnetOnly_YN | S_SCH_CRDC_X | AllMagnetOnly_YN |
SCHOOLS | CRDC_AlternativeSchoolAcademic_TF | S_SCH_CRDC_X | AlternativeSchoolAcademic_TF |
SCHOOLS | CRDC_AlternativeSchoolDiscipline_TF | S_SCH_CRDC_X | AlternativeSchoolDiscipline_TF |
SCHOOLS | CRDC_AlternativeSchool_YN | S_SCH_CRDC_X | AlternativeSchool_YN |
SCHOOLS | CRDC_APSelfParticipate_YN | S_SCH_CRDC_X | APSelfParticipate_YN |
SCHOOLS | CRDC_CharterSchool_YN | S_SCH_CRDC_X | CharterSchool_YN |
SCHOOLS | CRDC_ForDisabilities_YN | S_SCH_CRDC_X | ForDisabilities_YN |
SCHOOLS | CRDC_InterschAthletics_YN | S_SCH_CRDC_X | InterschAthletics_YN |
SCHOOLS | CRDC_InterschParticipantsF | S_SCH_CRDC_X | InterschParticipantsF |
SCHOOLS | CRDC_InterschParticipantsM | S_SCH_CRDC_X | InterschParticipantsM |
SCHOOLS | CRDC_InterschSportsF | S_SCH_CRDC_X | InterschSportsF |
SCHOOLS | CRDC_InterschSportsM | S_SCH_CRDC_X | InterschSportsM |
SCHOOLS | CRDC_InterschTeamsF | S_SCH_CRDC_X | InterschTeamsF |
SCHOOLS | CRDC_InterschTeamsM | S_SCH_CRDC_X | InterschTeamsM |
SCHOOLS | CRDC_MagentSchoolOrProgram_YN | S_SCH_CRDC_X | MagnetSchoolOrProgram_YN |
SCHOOLS | CRDC_ProvidesUngraded_YN | S_SCH_CRDC_X | ProvidesUngraded_YN |
Field Set: State CA Sections CRDC
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SECTIONS | CRDC_SingleSexCode | S_SEC_CRDC_X | SingleSexCode |
SECTIONS | CRDC_SubjectCat | S_SEC_CRDC_X | SubjectCat |
Field Set: State CA Students CRDC
This field set was included with State Reporting Installer 16.2.2 released on February 26, 2016.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
| STUDENTS | CRDC_ACT_YN | S_STU_CRDC_X | ACT_YN |
| STUDENTS | CRDC_APExam | S_STU_CRDC_X | APExam |
| STUDENTS | CRDC_APExamPassed | S_STU_CRDC_X | APExamPassed |
| STUDENTS | CRDC_GEDPrepProgram_YN | S_STU_CRDC_X | GEDPrepProgram_YN |
| STUDENTS | CRDC_GEDPrepProgramCred_YN | S_STU_CRDC_X | GEDPrepProgramCred_YN |
| STUDENTS | CRDC_IBDiplomaProgram_YN | S_STU_CRDC_X | IBDiplomaProgram_YN |
| STUDENTS | CRDC_SAT_YN | S_STU_CRDC_X | SAT_YN |
Field Set: State CA SchoolStaff v1
This field set was included with State Reporting Installer 17.4.0 released on April 28, 2017.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SCHOOLSTAFF | FTE | S_CA_SSF_X | FTE |
Field Set: State CA Users v2
This field set was included with State Reporting Installer 17.4.0 released on April 28, 2017.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
TEACHERS | CA_DateOfHire | S_CA_USR_X | EmploymentStartDate |
| TEACHERS | CA_EndDate | S_CA_USR_X | EmploymentEndDate |
| TEACHERS | State_ExcludeFromReporting | S_CA_USR_X | State_ExcludeFromReporting |
Field Set: State CA Schools v3
This field set was included with State Reporting Installer 17.4.0 released on April 28, 2017.
| Core Table | Legacy Custom Field | Database Extension Table | Database Extension Field |
|---|---|---|---|
SCHOOLS | CA_CalpadsStoreCodes | S_CA_SCH_X | CalpadsStoreCodesOmit |
| SCHOOLS | CA_StoreCodesIgnore | S_CA_SCH_X | TranscriptStoreCodesIgnore |