Field Set: State CA Virtual StudentProgram
This field set was included with State Reporting Installer 17.9.0 released on September 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
StudentProgram | Unique_id | S_CA_STU_CALPADSPrograms_C | Unique_id |
StudentProgram | SchoolID | S_CA_STU_CALPADSPrograms_C | SchoolID |
StudentProgram | ForeignKey | S_CA_STU_CALPADSPrograms_C | ForeignKey |
StudentProgram | ForeignKey_Alpha | S_CA_STU_CALPADSPrograms_C | ForeignKey_Alpha |
StudentProgram | User_Defined_Date | S_CA_STU_CALPADSPrograms_C | StartDate |
StudentProgram | User_Defined_Date2 | S_CA_STU_CALPADSPrograms_C | EndDate |
StudentProgram | User_Defined_Text | S_CA_STU_CALPADSPrograms_C | ProgramCode |
StudentProgram | User_Defined_Text2 | S_CA_STU_CALPADSPrograms_C | ProgramMembershipCode |
StudentProgram | User_Defined_Integer | S_CA_STU_CALPADSPrograms_C | AutoEndOpen_Tmp |
StudentProgram | User_Defined_Numeric | S_CA_STU_CALPADSPrograms_C | NewProgID_Tmp |
StudentProgram | CA_Partner_Acad_ID | S_CA_STU_CALPADSPrograms_C | PartnershipAcademyID |
StudentProgram | CA_Pri_Disability_Code | S_CA_STU_CALPADSPrograms_C | PrimaryDisabilityCode |
StudentProgram | CA_Dist_Sp_Edu_Acnty | S_CA_STU_CALPADSPrograms_C | DistSPEDAccountability |
StudentProgram | CA_MigrantID | S_CA_STU_CALPADSPrograms_C | MigrantId |
StudentProgram | CA_Sec_Disability_Code | S_CA_STU_CALPADSPrograms_C | SecondaryDisabilityCode |
StudentProgram | CA_ExitCode | S_CA_STU_CALPADSPrograms_C | ExitCode |
StudentProgram | CA_FosterClientID | S_CA_STU_CALPADSPrograms_C | FosterClientID |
StudentProgram | CA_Dwelling_Type | S_CA_STU_CALPADSPrograms_C | DwellingType |
StudentProgram | CA_UnaccYouth | S_CA_STU_CALPADSPrograms_C | UnaccYouth |
StudentProgram | CA_RunawayYouth | S_CA_STU_CALPADSPrograms_C | RunawayYouth |
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
CALPADS_StudentServices | Unique_ID | S_CA_CALPADS_StudentServices_C | Unique_ID |
CALPADS_StudentServices | SchoolID | S_CA_CALPADS_StudentServices_C | SchoolID |
CALPADS_StudentServices | ForeignKey | S_CA_CALPADS_StudentServices_C | ForeignKey |
CALPADS_StudentServices | ForeignKey_Alpha | S_CA_CALPADS_StudentServices_C | ForeignKey_Alpha |
CALPADS_StudentServices | User_Defined_Date | S_CA_CALPADS_StudentServices_C | StartDate |
CALPADS_StudentServices | User_Defined_Date2 | S_CA_CALPADS_StudentServices_C | EndDate |
CALPADS_StudentServices | User_Defined_Integer | S_CA_CALPADS_StudentServices_C | ServiceCode |
CALPADS_StudentServices | User_Defined_Numeric | S_CA_CALPADS_StudentServices_C | AutoEndOpen_Tmp |