Carl Perkins Grant-Link File Layout

1

Course Number

Scheduling > Courses > Course Sections > Master Schedule: Course (schd_ms. Course where CTE = 'Y' in validation table catb_cbeds_subj.)

Using the Master Schedule CA Course Page. State Course Code

2

Course Title

Scheduling > Courses > Course Sections > Master Schedule: Description (schd_ms.description)

3

Grade received in Course

Mark Reporting > Entry & Reports > Student > Transcript Summary: Marks where the Mark type matches the prompted mark type (mr_stu_marks.mark_value where mark_type = prompted mark types)

Use prompted mark types.

4

CBEDS Course Number

Scheduling > Courses > Course Sections > CA Course: CBEDS Subject Area field (catb_cbeds_subj.state_code_equiv using where code = schd_ms. Course)

This field on the master schedule CA Course Page. State Course Code.

5

Student ID

Registration > Entry & Reports > Student Demographic > Registration: Student ID (reg.student_id)

6

Last Name

Registration > Entry & Reports > Student Demographic > Registration: Last Name field (reg.last_name)

7

First Name

Registration > Entry & Reports > Student Demographic > Registration: First Name field (reg.first_name)

8

Gender

Registration > Entry & Reports > Student Demographic > Registration: Gender field (reg.gender)

9

Grade

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade field for last Entry/Withdrawal vector (reg_entry_with.grade)

Last grade of the year

10

Ethnic Code

Registration > Entry & Reports > Student Demographic > Personal: Hispanic/Latino Ethnicity or Race field (If reg_personal.hispanic = 'Y' then this value is 500 else get the value from reg_personal.ethnic_code)

11

Mailing Address

Registration > Entry & Reports > Student Demographic > Contacts: Address fields (Get reg_contact. street_number, reg_contact. Street, reg_contact. prefix, reg_contact. street_name, reg_contact. street_suffix, reg_contact. street_type, reg_contact. apartment, reg_contact. complex, reg_contact. Development
where
reg_stu_contact. contact_id = reg_contact. contact_id and reg_stu_contact. contact_type = Prompted Address type(G/P))

12

City

Registration > Entry & Reports > Student Demographic > Contacts: City field (reg_contact.city)

13

State

Registration > Entry & Reports > Student Demographic > Contacts: State field (reg_contact.state)

14

Zip Code

Registration > Entry & Reports > Student Demographic > Contacts: Zip Code field (reg_contact.zip)

15

Home Phone

Registration > Entry & Reports > Student Demographic > Contacts: Phone Number field (reg_contact_phone.phone where
reg_stu_contact. contact_id = reg_contact_phone. contact_id and reg_stu_contact. contact_type = Prompted Address type(G/P))

16

LEP/Limited English Proficient

Registration > Entry & Reports > Student District Defined > CA Demographics: English Proficiency field (Get the Program_value where Reg_v_programs.state_code_equiv = 'ca120_prof' using as of date. If the student's program_value has the code of EO then the output would be Y otherwise N)

Y or N

17

Free & Reduce

Registration > Entry & Reports > Student Demographic > Personal: Meal Status field (based on the prompt date check the student is in the Program where Reg_v_programs.state_code_equiv = 'MEALSTATUS'. If the student is in the program output would be Y else N.)

Y or N

18

Special Ed

Registration > Entry & Reports > Student Demographic > Programs: CA144 – Special Education program, Special Education program line (Based on the prompt date check the student is in the Program where Reg_v_programs.state_code_equiv = 'CA144_PROG''. If the student is in the program output would be Y else N.)

Y or N

19

Migrant

Registration > Entry & Reports > Student Demographic > Personal: Migrant field (Based on the prompt date check the student is in the Program where Reg_v_programs.state_code_equiv = 'CA135_PROG'. If the student is in the program output would be Y else N.)

Y or N.

20

Single Parent

Registration > Entry & Reports > Student Demographic > Programs: CTE Information program (Based on the prompt date check the student is in the Program where Reg_v_programs.state_code_equiv = 'SINGLE'(New Program). If the student is in the program output would be Y else N.)

Y or N

21

Displaced Homemakers

Registration > Entry & Reports > Student Demographic > Programs: CTE Information program (Based on the prompt date check the student is in the Program where Reg_v_programs.state_code_equiv = 'DISPHOM'(New Program), If the student is in the program output would be Y else N.)

Y or N

22

CAHSEE ELA Scale Score

Test Scores > All > Student > Test History by Student: Highest CAHSEE ELA Scale Score for student (Get the highest score of LTDB_STU_SUBTEST.score based on the prompt test definition across years.)

23

CAHSEE Math Scale Score

Test Scores > All > Student > Test History by Student: Highest CAHSEE Math Scale Score for student (Get the highest score of LTDB_STU_SUBTEST.score based on the prompt test definition across years.)

24

SSID

Registration > Entry & Reports > Student Demographic > Personal: State Reporting ID field (reg_personal.state_report_id)

25

Birth Date

Registration > Entry & Reports > Student Demographic > Registration: Birth Date field (reg.birthdate)