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 on PowerSchool Community.
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 |