Lunch Program

SchoolName

Name of the school in which the student is enrolled.

[Schools]Name

NVL(sch.name, 'LEA Office') — defaults to "LEA Office" when school name is null

Yes

Student_Number

The student number assigned by the district.

[Students]Student_Number

Direct column value from the students table.

Yes

LastFirst

The full name of the student (Last, First format).

[Students]LastFirst

Serves as a hyperlink to student record via <idColumn>StudentDCID</idColumn>

Yes

State_StudentNumber

State-assigned student identifier (STN).

[Students]State_StudentNumber

Direct column value from the students table.

Yes

ProgramName

The name of the program in which the student is participating.

Lunch Program - is published if students are assigned one of the lunch status codes mentioned above.

Economic Disadvantage - is published if Student has EconomicDisadvantage = Yes or No on the student record but has a program end date within the school year.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramName'. Filtered by composite key prefix 'FR%' (Free/Reduced) or 'ED%' (Economic Disadvantage)

Yes

ProgramTypeCode

The code that identifies the type of program.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramTypeCodeValue'

Yes

OtherCode

The additional program classification code.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'OtherCodeValue'

Yes

ProgramStatus

The current status of the student's program participation.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramStatusValue'

Yes

ProgramPlacementDate

The date on which the student was placed into the program.

Note:

• If there's no specific placement date recorded, the date the student enrolled in the school is used.

• For students who graduated early, special dates from their re-enrollment records used.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'StudentParticipationAsOfDate'

Yes

ProgramPlacementReason

The reason for which the student was placed in the program.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramPlacementReason'

Yes

ProgramExitDate

The date on which the student exited the program.

The exit date comes from the lunch history record.

• If there's no exit date, the system uses the student's exit date from the school minus one day.

• For early graduates, the system uses special exit dates from their re-enrollment records.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramExitDate'

Yes

ProgramExitReason

The reason for exiting the program.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'ProgramExitReasonValue'

Yes

FreeAndReducedStatus

Free and Reduced lunch eligibility status.

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'FreeAndReducedStatus'

Yes

CertifiedLunchProgram

Indicates if the student is in a certified lunch program.

Note: If the student has "Certified Free" (FDC) or "Certified Reduced" (RDC), it is marked as "Yes" for certified.

All other types are marked as "No".

[CST_PubPublishSupKeyVal]SupportingValue

Pivoted value where SUPPORTINGNAME = 'CertifiedLunchProgramValue'

Yes

LastPublishDate

The date/time when the record was last published.

[CST_PubPublishED]LastPublishDate

Formatted as TO_CHAR(pub.LastPublishDate, 'DD-MON-YYYY HH:MI PM')

Yes

PublishingID

The internally published record identifier.

[CST_PubPublish]ID

pub.ID from CST_PUBPUBLISHED

Yes

ResourceID

The external reference ID for the published resource.

[CST_PubPublish]ExternalRefId

pub.ExternalRefId — external system reference

Yes