S_CA_STU_CALPADSPrograms_C (ver 17.9.0)
This is a child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [StudentProgram.unique_ID]. |
AutoEndOpen_Tmp | 17.9.0 | Number(11,0) | Auto End Open Temp (for PS internal use only). Migrated from [StudentProgram.user_defined_integer]. |
DistSPEDAccountability | 17.9.0 | Varchar2(7) | District Special Ed Accountability. Migrated from [StudentProgram.CA_dist_sp_edu_acnty]. |
DwellingType | 17.9.0 | Varchar2(3) | Dwelling Type. Migrated from [StudentProgram.CA_dwelling_type]. |
EndDate | 17.9.0 | Date | End Date. Migrated from [StudentProgram.user_defined_date2]. |
ExitCode | 17.9.0 | Varchar2(2) | Exit Code. Migrated from [StudentProgram.CA_exitCode]. |
ForeignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [StudentProgram.foreignKey]. |
ForeignKey_Alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [StudentProgram.foreignKey_alpha]. |
FosterClientID | 17.9.0 | Varchar2(10) | Foster Client ID. Migrated from [StudentProgram.CA_FosterClientID]. |
MigrantId | 17.9.0 | Varchar2(11) | Migrant ID. Migrated from [StudentProgram.CA_MigrantId]. |
NewProgID_Tmp | 17.9.0 | Number(25,10) | New Program ID Temp (for PS internal use only). Migrated from [StudentProgram.user_defined_numeric]. |
PartnershipAcademyID | 17.9.0 | Varchar2(5) | Partnership Academy ID. Migrated from [StudentProgram.CA_partner_acad_Id]. |
PrimaryDisabilityCode | 17.9.0 | Varchar2(3) | Primary Disability Code. Migrated from [StudentProgram.CA_pri_disability_code]. |
ProgramCode | 17.9.0 | Varchar2(3) | Program Code. Migrated from [StudentProgram.user_defined_text]. |
| ProgramComment | 18.1.0 | Varchar2(500) | Program Comment. |
ProgramMembershipCode | 17.9.0 | Varchar2(1) | Program Membership Code. Migrated from [StudentProgram.user_defined_text2]. |
RunawayYouth | 17.9.0 | Varchar2(1) | Runaway Youth Flag. Migrated from [StudentProgram.CA_RunawayYouth]. |
SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [StudentProgram.schoolID]. |
SecondaryDisabilityCode | 17.9.0 | Varchar2(3) | Secondary Disability Code. Migrated from [StudentProgram.CA_sec_disability_code]. |
StartDate | 17.9.0 | Date | Start Date. Migrated from [StudentProgram.user_defined_date]. |
| SubDist_Prog_Assign_ID | 20.12.1.0 | Number(11,0) | The sub district number. |
UnaccYouth | 17.9.0 | Varchar2(1) | Unaccompanied Youth Flag. Migrated from [StudentProgram.CA_UnaccYouth]. |