Discipline File Layout

Primary Disability Code

2

Y

Y

563 - 564

reg_programs.program_value where state_code_equiv=
ORSPEPD

or_disp_down. stu_prima_disab

Discipline Action Date

8

Y

Y

565 - 572

disc_off_action.start_date

or_disp_down. action_date

Discipline Action Type Code

1

Y

N

573 - 573

Disc_off_action.action_code using the state code equiv

For every student who is truant for >=8 counts an incident record needs to be inserted with action_code hardcoded as 4.

or_disp_down. action_code

District Discipline Incident Identifier

10

Y

N

574 - 583

Disc_offender.incident_id

ID will have to be generated for action_code = 4 {Truancy)

 ID can be T+Student_id+ Count of Occurrence

or_disp_down. Incident_id

Primary Offense Type Code

4

Y

Y

584 - 587

Disc_off_code.offense_code using the state code equiv

or_disp_down. Prima_offense

Secondary Offense Type Code

4

Y

Y

588 - 591

Disc_off_code.offense_code using state code equiv

or_disp_down. Second_offense

Tertiary Offense Type Code

4

Y

Y

592 - 595

Disc_off_code.offense_code using state code equiv

or_disp_down. Terti_offense

Primary Weapon Type Code

4

Y

Y

596 - 599

Disc_off_weapon.weapon_code using state code equiv

or_disp_down. Prima_weapon

Secondary Weapon Type Code

4

Y

Y

600 - 603

Disc_off_weapon.weapon_code using state code equiv

or_disp_down. Second_weapon

Tertiary Weapon Type Code

4

Y

Y

604 - 607

Disc_off_weapon.weapon_code using state code equiv

or_disp_down. Terti_weapon

Discipline Modifier Code

1

Y

Y

608 - 608

reg_programs.program_value where state_code_equiv=
ORDISMOD using disctb_reason.state_code_equiv

or_disp_down. Disp_modifier

Discipline Days

5

Y

Y

609 - 612

If tracking occurrences, disc_off_action.actual_duration and schd_duration.

If not tracking occurrences, disc_off_action.actual_duration.

or_disp_down. Disp_days

Interim Educational Services Flag

1

N

N

613 - 613

disc_act_user.field_value where screen_number=500 and field_number=1

Always Y for Action Codes 2 and 5

or_disp_down. Interim_srvcs_flag

Violent Criminal Offense Arrest Flag

1

N

N

614 - 614

If disc_offender.police_action contains value from reg_user-district.field_value where screen_number=700 and field_number=8 then Y

or_disp_down.
under_arrest

Discipline (Dspln) Filler

50

N

N

616 - 664