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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top