programName | The formal name of the program of instruction, training, services, or benefits available. |
| If S_SC_STU_CATE_X.CATE_ConcntrInd1 or S_SC_STU_CATE_X.CATE_CompleterInd1 is NOT NULL then programName='CTE Program 1',
If S_SC_STU_CATE_X.CATE_ConcntrInd2 or S_SC_STU_CATE_X.CATE_CompleterInd2 is NOT NULL then programName='CTE Program 2';
If s_sc_stu_wbl_x.wbl_expodeccr is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expodeccr is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expodeccr is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expodeccr is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode1 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode1 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode1 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode2 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode2 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode2 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode2 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode3 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode3 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode3 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode3 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode4 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode4 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode4 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode4 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode5 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode5 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode5 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode5 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode6 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode6 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode6 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode6 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode7 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode7 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode7 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode7 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode8 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode8 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode8 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode8 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode9 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode9 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode9 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode9 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If s_sc_stu_wbl_x.wbl_expode10 is ‘C’ then programname = ‘C-Cooperative Education,
If s_sc_stu_wbl_x.wbl_expode10 is ‘I’ then programname = ‘I-Internship’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘R’ programname = ‘R-Registered Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘Y’ then programname = ‘Y-Youth Apprenticeship’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘B’ then programname = ‘B-CTE Internship Credit Bearing Course’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘F’ then programname = ‘F-School-Based Enterprise,
If s_sc_stu_wbl_x.wbl_expode10 is ‘L’ then programname = ‘L-Service Learning’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘M’ then programname = ‘M-Mentoring’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘S’ then programname = ‘S-Shadowing: On-Site’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘U’ then programname = ‘U-Structured Field Study’,
If s_sc_stu_wbl_x.wbl_expode10 is ‘V’ then programname = ‘V-Shadowing: Virtual’;
If [S_SC_STU_X]Title1MathInd or [S_SC_STU_X]Title1ReadInd or [S_SC_STU_X]Title1AsstTypeCode or [S_SC_STU_X]Title1AsstTypeCode is not null then studentTitleIPartAProgramAssociations If [S_SC_STU_X]InstrSetting is not null then Special Education If [S_SC_STU_X]night_residence is not null then Homeless Program If [S_SC_STU_X]Engl_Prof,1,1) not in ('8','9') then ESOL | R |
programTypeDescriptor | The type of program. | String | CTE: If S_SC_STU_CATE_X.CATE_ConcntrInd1 or S_SC_STU_CATE_X.CATE_CompleterInd1 is NOT NULL then programTypeDescriptor='CTE Program 1',
If S_SC_STU_CATE_X.CATE_ConcntrInd2 or S_SC_STU_CATE_X.CATE_CompleterInd2 is NOT NULL then programTypeDescriptor='CTE Program 2'; Special Program:
if SpEnrollments.ProgramID NOT NULL then ProgramTypeDescriptor = ‘Special Program’;
If s_sc_stu_wbl_x.wbl_expcodeccr is NOT NULL then programTypeDescriptor ='WBL CR Experience';
If s_sc_stu_wbl_x.wbl_expcode1 is NOT NULL then programTypeDescriptor='WBL 1',
If s_sc_stu_wbl_x.wbl_expcode2 is NOT NULL then programTypeDescriptor='WBL 2',
If s_sc_stu_wbl_x.wbl_expcode3 is NOT NULL then programTypeDescriptor='WBL 3',
If s_sc_stu_wbl_x.wbl_expcode4 is NOT NULL then programTypeDescriptor='WBL4',
If s_sc_stu_wbl_x.wbl_expcode5 is NOT NULL then programTypeDescriptor='WBL5',
If s_sc_stu_wbl_x.wbl_expcode6 is NOT NULL then programTypeDescriptor='WBL6',
If s_sc_stu_wbl_x.wbl_expcode7 is NOT NULL then programTypeDescriptor='WBL7',
If s_sc_stu_wbl_x.wbl_expcode8 is NOT NULL then programTypeDescriptor='WBL8',
If s_sc_stu_wbl_x.wbl_expcode9 is NOT NULL then programTypeDescriptor='WBL9',
If s_sc_stu_wbl_x.wbl_expcode10 is NOT NULL then programTypeDescriptor='WBL10'; Special Education: If [S_SC_STU_X]InstrSetting,1,2='SE' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='SR' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='SP' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='RS' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='RP' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='PR' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='PS' then ProgramTypeDescriptor = 'Special Education Enrollment'
If [S_SC_STU_X]InstrSetting,1,2='504' then ProgramTypeDescriptor = 'Special Education Enrollment' TitleIPartA: If [S_SC_STU_X]Title1MathInd = 'Y' then ProgramTypeDescriptor = 'Mathematics Instructional Services' If [S_SC_STU_X]Title1ReadInd='Y' then ProgramTypeDescriptor ='Reading/Language Instructional Services' If [S_SC_STU_X]Title1AsstTypeCode = 'T' then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = "Was not served" If [S_SC_STU_X]Title1AsstTypeCode = 'T' then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = "Was not served" Homeless Program: If [S_SC_STU_X]night_residence is not null then Homeless Program ESOL: If [S_SC_STU_X]Engl_Prof,1,1) not in ('8','9') | R |