Guidelines for Submitting Public In-District/BOCES High Cost Worksheets Electronically
11/29/19
The file worksheet, described in the attached file layout, must be used for all data transfer with SED concerning high cost worksheets supporting costs for special education services provided by the student's home school district or a BOCES. No particular worksheet will require the use of all the data fields. Below you will find a list of the data fields necessary for SED to process high cost worksheets for in-district and BOCES 10-month placements.
Record Information:
- HCPUB-STAC-ID - Required. Student's STAC ID. This is the six digit unique identification number for all children on the STAC system.
- HCPUB-YR-SCH - Required. School Year of Enrollment. Two consecutive two digit years. For example, the 1996-97 school year would be represented by 9697.
- HCPUB-NUM-REC - Required. Record Number. This two digit field uniquely identifies the child’s service.
Student Information:
- HKIDS-LAST-NAME - Required. Student's Last Name. Last names with imbedded spaces or special characters will be rejected. For example, send O’RILEY as ORILEY. Send VAN SCHAIK as VANSCHAIK. Send JONES-SMITH as JONESSMITH. Do not include any suffixes such as JR. or III.
- HKIDS-FIRST-NAME - Required. Student's First Name. First names with imbedded spaces or special characters will be rejected. For example, send BILLY BOB as BILLYBOB.
- HKIDS-MID-INIT - Optional. Student's Middle Initial. If entered, must be an alpha character.
- HKIDS-DT-BIRTH - Required. Child's date of birth in Century (ie. 20), year, month, day order.
- HKIDS-SEX - Optional. Student's Gender. "M" or "F".
- HKIDS-RAC-ETH - Optional. Student's Race/Ethnicity
- HKIDS-STUDENT-ID - Optional. Student's Outside ID (if applicable)
Value | Description |
---|---|
I | American Indian or Alaskan Native |
A | Asian or Pacific Islander |
B | Black or African American |
H | Hispanic or Latino |
C | White |
U | Two or more Races |
Placement Information:
- HPLAC-LEA-CODE - Required. CSE District's 12-digit SED Code
- HSERV-CD-PROV - Required. Education Provider's 12-digit SED Code
- HSERV-CD-PROG - Required. This is the education program code. This code along with the Agency (Education Provider) code and STAC code define the program. This code can be obtained from the Agency Provider Information link below.
- HSERV-CD-STAC - Required. This is the education program code. This code along with the Agency (Education Provider) code and STAC code define the program. This code can be obtained from the Agency Provider Information link below.
- HSERV-RATE-ANN - Optional. 10-Month Annualized Cost. Must be a numeric right justified field with the 2 rightmost digits being the decimal places. Decimal places are required - enter 00 if there are no cents. The decimal point is implied - DO NOT include a decimal point in this field.
- HSERV-DT-BEGIN - Required. Begin date of service in CC, YY, MM, DD order.
- HSERV-DT-END - Required. End date of Service in CC, YY, MM, DD order.
Section I. BOCES:
- HCPUB-RATE-ANN-B - Optional. BOCES 10-Month Annualized Cost (from Year-End Final Cost Report)
Section II-A. InDistrict Classroom - Full Day Self-Contained Special Education Classroom:
- HCPUB-NUM-STUD - Optional. IEP Ratio: Number of Students
- HCPUB-NUM-TCHR - Optional. IEP Ratio: Number of Teachers
- HCPUB-NUM-PARA - Optional. IEP Ratio: Number of Classroom Paraprofessionals
- HCPUB-NUM-SE-STU - Optional. Actual Students in Class
- HCPUB-T-SAL-COST - Optional. Special Ed Teachers: Classroom Salaries
- HCPUB-T-BEN-COST - Optional. Special Ed Teachers: Classroom Fringe Benefits
- HCPUB-A-SAL-COST - Optional. Classroom Aides/T.A.s: Classroom Salaries
- HCPUB-A-BEN-COST - Optional. Classroom Aides/T.A.s: Classroom Fringe Benefits
Section II-B. InDistrict Classroom - Period-Based Special Education Placements
Row 1:
- HCPUB-PLAC-TYP1 - Optional. Placement Type
Value Description CTM CO-TEACH MATH CTE CO-TEACH ENGLISH LA COTS CO-TEACH SCIENCE CTSS CO-TEACH SOCIAL STUDIES CTO CO-TEACH OTHER SC SPECIAL CLASS APE Adaptive Phys Ed CTS Consultant Teacher Services RR Resource Room - HCPUB-TSAL-COST1 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST1 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-1 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE7 - Optional. Group Size
- HCPUB-N-PERIOD1 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-1 - Optional. Session Length (Mins)
- HCPUB-FREQ1 - Optional. Frequency
Value Description 180 Daily Cycle 40 Weekly Cycle 30 6-Day Cycle 45 4-Day Cycle
Row 2:
- HCPUB-PLAC-TYP2 - Optional. Placement Type. Accepts same values as HCPUB-PLAC-TYP1.
- HCPUB-TSAL-COST2 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST2 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-2 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE8 - Optional. Group Size
- HCPUB-N-PERIOD2 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-2 - Optional. Session Length (Mins)
- HCPUB-FREQ2 - Optional. Frequency. Accepts same values as HCPUB-FREQ1.
Row 3:
- HCPUB-PLAC-TYP3 - Optional. Placement Type. Accepts same values as HCPUB-PLAC-TYP1.
- HCPUB-TSAL-COST3 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST3 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-3 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE9 - Optional. Group Size
- HCPUB-N-PERIOD3 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-3 - Optional. Session Length (Mins)
- HCPUB-FREQ3 - Optional. Frequency. Accepts same values as HCPUB-FREQ1.
Row 4:
- HCPUB-PLAC-TYP4 - Optional. Placement Type. Accepts same values as HCPUB-PLAC-TYP1.
- HCPUB-TSAL-COST4 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST4 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-4 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE10 - Optional. Group Size
- HCPUB-N-PERIOD4 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-4 - Optional. Session Length (Mins)
- HCPUB-FREQ4 - Optional. Frequency. Accepts same values as HCPUB-FREQ1.
Row 5:
- HCPUB-PLAC-TYP5 - Optional. Placement Type. Accepts same values as HCPUB-PLAC-TYP1.
- HCPUB-TSAL-COST5 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST5 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-5 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE11 - Optional. Group Size
- HCPUB-N-PERIOD5 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-5 - Optional. Session Length (Mins)
- HCPUB-FREQ5 - Optional. Frequency. Accepts same values as HCPUB-FREQ1.
Row 6:
- HCPUB-PLAC-TYP6 - Optional. Placement Type. Accepts same values as HCPUB-PLAC-TYP1.
- HCPUB-TSAL-COST6 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Salaries
- HCPUB-TFRI-COST6 - Optional. Spec. Ed Teachers/Classrooms Aides: Total Fringe
- HCPUB-PER-DAY-6 - Optional. Teacher Work Day (Exclude Lunch) Length in Mins
- HCPUB-GRP-SIZE12 - Optional. Group Size
- HCPUB-N-PERIOD6 - Optional. Sessions Per Cycle
- HCPUB-PER-LEN-6 - Optional. Session Length (Mins)
- HCPUB-FREQ6 - Optional. Frequency. Accepts same values as HCPUB-FREQ1.
Additional Costs:
- HCPUB-CR-O-COST - Optional. Additional Special Education Classroom Costs
Section III. Child-Specific 1:1 Aide/Shared Aide/Nurse/Interpreter
Row 1:
- HCPUB-TYP-AIDE - Optional. Type of 1:1
Value Description A Aide/Teaching Asst L LPN R RN I Interpreter - HCPUB-SAL-COST1 - Optional. Annual Salary
- HCPUB-FRING-CST1 - Optional. Annual Fringe
- HCPUB-NUM-SERV1 - Optional. # of Students Served
Row 2:
- HCPUB-TYP-AIDE2 - Optional. Type of 1:1. Accepts same values as HCPUB-TYP-AIDE.
- HCPUB-SAL-COST2 - Optional. Annual Salary
- HCPUB-FRING-CST2 - Optional. Annual Fringe
- HCPUB-NUM-SERV2 - Optional. # of Students Served
Section IV. Related/Other Services
Row 1:
- HCPUB-TYP-SERV1 - Optional. Service Type
Value Description ABA ABA/Behavior Intervention APED Adaptive Phys Ed AUD Audiological/Hearing Therapy CTS Consultant Teacher Services CSL Counseling Services JC Job Coaching MUS Music Therapy NT Notetaker NURS Skilled Nursing OT Occupational Therapy OM Orientation and Mobility PNT Parent Training PT Physical Therapy PSY Psychological Therapy SOC Social Work ICT Spec Ed - Integ Co-teaching RESR Spec Ed - Add'l/Resource Room SLT Speech/Language Therapy TS Transition Services TDF Teacher for the Deaf VISU Visually Impaired Services OTH Other -- Explain in Comments - HCPUB-PTYP-SERV1 - Optional. Provider Type
Value Description B BOCES Extra D District O Other Provider - HCPUB-LEN-SESS1 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S1 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE - Optional. Group Size
- HCPUB-NUM-SESS - Optional. Actual Sessions
Row 2:
- HCPUB-TYP-SERV2 - Optional. Service Type. Accepts same values as HCPUB-TYP-SERV1.
- HCPUB-PTYP-SERV2 - Optional. Provider Type. Accepts same values as HCPUB-PTYP-SERV1.
- HCPUB-LEN-SESS2 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S2 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE2 - Optional. Group Size
- HCPUB-NUM-SESS2 - Optional. Actual Sessions
Row 3:
- HCPUB-TYP-SERV3 - Optional. Service Type. Accepts same values as HCPUB-TYP-SERV1.
- HCPUB-PTYP-SERV3 - Optional. Provider Type. Accepts same values as HCPUB-PTYP-SERV1.
- HCPUB-LEN-SESS3 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S3 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE3 - Optional. Group Size
- HCPUB-NUM-SESS3 - Optional. Actual Sessions
Row 4:
- HCPUB-TYP-SERV4 - Optional. Service Type. Accepts same values as HCPUB-TYP-SERV1.
- HCPUB-PTYP-SERV4 - Optional. Provider Type. Accepts same values as HCPUB-PTYP-SERV1.
- HCPUB-LEN-SESS4 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S4 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE4 - Optional. Group Size
- HCPUB-NUM-SESS4 - Optional. Actual Sessions
Row 5:
- HCPUB-TYP-SERV5 - Optional. Service Type. Accepts same values as HCPUB-TYP-SERV1.
- HCPUB-PTYP-SERV5 - Optional. Provider Type. Accepts same values as HCPUB-PTYP-SERV1.
- HCPUB-LEN-SESS5 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S5 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE5 - Optional. Group Size
- HCPUB-NUM-SESS5 - Optional. Actual Sessions
Row 6:
- HCPUB-TYP-SERV6 - Optional. Service Type. Accepts same values as HCPUB-TYP-SERV1.
- HCPUB-PTYP-SERV6 - Optional. Provider Type. Accepts same values as HCPUB-PTYP-SERV1.
- HCPUB-LEN-SESS6 - Optional. Length of Sessions (Mins)
- HCPUB-T-COST-S6 - Optional. Total Cost Per Session
- HCPUB-GRP-SIZE6 - Optional. Group Size
- HCPUB-NUM-SESS6 - Optional. Actual Sessions
Additional Services:
- HCPUB-B-O-COST - Optional. Additional Related Services: BOCES Extra
- HCPUB-D-O-COST - Optional. Additional Related Services: District
- HCPUB-OP-O-COST - Optional. Additional Related Services: Other Provider
Section V. Other Child Specific Costs:
- HCPUB-COST-CATE - Optional. Cost Category
Value Description AT ASSISTIVE TECHNOLOGY ST SPECIAL TECHNOLOGY CO CONSULT -- Explain in Comments OT OTHER -- Explain in Comments - HCPUB-ADD-INFO - Optional. Additional Information
- HCPUB-OTH-CH-CST - Optional. Total Other Child Specific Costs
Comments:
- HCPUB-COMMENT1 - Optional. Comments: Row 1
- HCPUB-COMMENT2 - Optional. Comments: Row 2
- HCPUB-NAM-CNTCT - Required. District Contact information: Contact Name
- HCPUB-ADR-EMAIL - Required. District Contact information: E-mail Address
- HCPUB-PHONE - Required. District Contact information: Phone#
Processing Information:
- SRV-TR-USERID - Required. This eight character field must be a valid EFRT Usercode. The corresponding HPLAC-LEA-CODE on this record must match the LEA Code that the STAC Unit has recorded for this EFRT Usercode.
Last Updated:
August 23, 2022