Skip to main content
Skip table of contents

BSCE Student Program (studentProgramAssociation)

This view captures details about BSCE program records in which a student participates or receives services as published in the StudentProgramAssociation resource within the Student Program category. The layout includes the Program Name, Entry Date, Exit Date, State Student Number, and Publishing ID.

studentProgramAssociations

This association represents the program(s) that a student participates in or is served by. Program associations reported in this resource include:

Primary PowerSchool Source Data

  • [Prefs]

  • [Students]

  • [S_NM_STU_X]

  • [S_NM_STU_ProgramsFact_C]

Selection Criteria

Records are published if the following criteria are met:

General:

  • The student was previously published in the Student & Student Enrollments dashboard category.

  • StudentUniqueId must be populated in PowerSchool.

  • Student must not be a “no-show” (their entry date and exit date are the same date value).

  • The student must not be excluded from state reporting.

  • The school must not be excluded from state reporting.

Auto Generated Records:

Field Description

[Table]Field

Page

Notes

Eligible for bus service to Vocational Education (BSCE)

[S_NM_SCH_X]EligibleBusSvcVocEd_YN

Start Page, Select Student, State / Province NM, Misc

Start Page, Select Student, State / Province NM, Programs Fact

Student rode bus on 80D Date.

Student rode bus on 120D Date

[S_NM_SCH_X]RodeBus80D

[S_NM_SCH_X]RodeBus120D

Start Page, Select Student, State / Province NM, Misc

Start Page, Select Student, State / Province NM, Programs Fact

December (80 Day) **

February (120 Day) *

[Prefs]Value where [Prefs]Name = NM_80D_Date

[Prefs]Value where [Prefs]Name = NM_120D_Date

Start Page, District Setup, STARS Reporting Dates

Must be the current year reporting period date.

For 80D, the date must be 12/1/YYYY

Location Code

[S_NM_STU_X]LocationCode

Start Page, Select Student, State / Province NM, Misc

Start Page, Select Student, State / Province NM, Programs Fact

This field must NOT be populated.

Child Table Records [S_NM_STU_ProgramsFact_C]:

  • The record must be active at some point during the current reporting year.

Resource Output

  • A record is published for each student and each school enrollment the program record was active for.

  • The StudentProgramAssociation resource is dependent on the prior publishing of the following resources: Student.

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).

Data Element

Description

Data Type

Auto Generated Records:

[Table]Field

Child Table Records:

[Table]Field

Req'd

educationOrganizationReference

educationOrganizationId

The school associated with this student. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+[School Number - 3 digit]

String

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number:

[Schools]Alternate_School_Number if the value greater is than zero, else the [Schools]School_Number

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number:

[Schools]Alternate_School_Number if the value greater is than zero, else the [Schools]School_Number

R

programReference

R

/educationOrganizationId

The LEA associated with this student and program. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+000

String

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

The last 3 digits will be 000

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

The last 3 digits will be 000

R

/programTypeDescriptor

The type of program.

String

Always BSCE

[S_NM_STU_ProgramsFact_C]ProgramCode

R

/programName

The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.

String

Always

Bus Services' Vocational Ed/Concurrent Enrollment

Based on the [S_NM_STU_ProgramsFact_C]ProgramCode value:

Bus Services' Vocational Ed/Concurrent Enrollment

R

studentReference

 /studentUniqueId

The student associated with the program.

String

[Students]State_StudentNumber

[Students]State_StudentNumber

R

/beginDate

The month, day, and year on which the student started the program.

Note:

For an 80D record, this date must be the 80D reporting date.

For an 120D record, this date must be the 120D reporting date.

Datetime

[Prefs]Value where [Prefs]Name = NM_80D_Date

[Prefs]Value where [Prefs]Name = NM_120D_Date

[S_NM_STU_ProgramsFact_C]BeginningDate

R

/endDate

The month, day, and year on which the student exited the program or stopped receiving services.

Note:

For an 80D record, this date must be the 80D reporting date.

For an 120D record, this date must be the 120D reporting date.

Datetime

[Prefs]Value where [Prefs]Name = NM_80D_Date

[Prefs]Value where [Prefs]Name = NM_120D_Date

[S_NM_STU_ProgramsFact_C]EndingDate

CR

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.