Definition of table Behavior_Incident
Student Behavior , Table Dump Name res-0001

Alphabetical Field Summary

  • action-code: (CHAR) Name of this behavioural action
  • action-code-description: (CHAR) Description of this behavior action
  • action-contact-authorized-to-car: (LOGC) Yes if contact is allowed to care for student
  • action-contact-code: (CHAR) Name of contact code
  • action-contact-head-of-house: (LOGC) Is this contact the head of the students household?
  • action-contact-home-phone: (CHAR) Home/Evening Phone number for this contact
  • action-contact-lives-with-studen: (LOGC) Yes if this contact lives with the student
  • action-contact-made: (LOGC) Has the parent been contacted about this behavioural event
  • action-contact-name: (CHAR) Name of contact, last name first
  • action-contact-type: (CHAR) Type of contact (Name, Address, Phone or Complete)
  • action-contact-work-phone: (CHAR) Work/Day Phone number for this contact
  • action-contacted-at: (CHAR) Time parent was contacted
  • action-contacted-date: (DATE) Date parent was contact on
  • action-counselled-by: (CHAR) Name of this person (last name first)
  • action-cre-date: (DATE) Date record was created
  • action-cre-time: (CHAR) Time this record was created at
  • action-cre-user-name: (CHAR) Name of user who created the record
  • action-date: (DATE) Date of this event
  • action-description: (CHAR) Description of the incident/event
  • action-time: (CHAR) Time of this event
  • action-upd-date: (DATE) Date record was last updated
  • action-upd-time: (CHAR) Time this record was last updated at
  • action-upd-user-name: (CHAR) Name of user record was updated by
  • birth-date: (DATE) Students Birthdate
  • bldg-code: (CHAR) Short name for this building
  • counselor: (CHAR) Name of this person (last name first)
  • current-year: (LOGC) (no description available)
  • days-actual: (DECM) # of days actually determined for remidiation
  • days-official: (DECM) # of days officially recommended for remidiation
  • days-variance-code: (CHAR) Variance Code
  • dw-valid-from: (DATE) (no description available)
  • dw-valid-to: (DATE) (no description available)
  • dw-version: (INTG) (no description available)
  • enrolled: (LOGC) Yes if this status code means the student is enrolled
  • ethnic-code: (CHAR) Ethnic code name
  • event-bldg-code: (CHAR) Short name for this building
  • event-code: (CHAR) Name of this behavioural code
  • event-code-description: (CHAR) Description of this behavior code
  • event-contact-authorized-to-care: (LOGC) Yes if contact is allowed to care for student
  • event-contact-code: (CHAR) Name of contact code
  • event-contact-head-of-house: (LOGC) Is this contact the head of the students household?
  • event-contact-home-phone: (CHAR) Home/Evening Phone number for this contact
  • event-contact-lives-with-student: (LOGC) Yes if this contact lives with the student
  • event-contact-made: (LOGC) Has the parent been contacted about this behavioural event
  • event-contact-name: (CHAR) Name of contact, last name first
  • event-contact-type: (CHAR) Type of contact (Name, Address, Phone or Complete)
  • event-contact-work-phone: (CHAR) Work/Day Phone number for this contact
  • event-contacted-at: (CHAR) Time parent was contacted
  • event-contacted-date: (DATE) Date parent was contact on
  • event-cre-date: (DATE) Date record was created
  • event-cre-time: (CHAR) Time this record was created at
  • event-cre-user-name: (CHAR) Name of user who created the record
  • event-date: (DATE) Date this event occured on
  • event-description: (CHAR) Description of the incident/event
  • event-occured-in-school: (LOGC) Did the event occur on school grounds in school hours?
  • event-referred-by: (CHAR) Name of this person (last name first)
  • event-time: (CHAR) Time the event occured at
  • event-upd-date: (DATE) Date record was last updated
  • event-upd-time: (CHAR) Time this record was last updated at
  • event-upd-user-name: (CHAR) Name of user record was updated by
  • gender: (LOGC) Gender or student, Male or Female
  • grade: (CHAR) Name of this Grade (i.e. K, 1, 10, 12, etc)
  • home-room: (CHAR) Room # or name
  • house-code: (CHAR) Short name for this house
  • house-description: (CHAR) Description of the house
  • incident-cost: (DECM) Cost, if any, associated with this incident
  • incident-id: (INTG) Incident # for this incident
  • promotion-path-name: (CHAR) Name of this promotion path
  • school-year-name: (CHAR) Name for school year (i.e. 1993/94, etc)
  • sped-code: (CHAR) Name of student special education code
  • sped-fte: (DECM) Special Education FTE of student
  • state-ethnic-code: (CHAR) State Assigned ethnic code
  • status-code: (CHAR) Name of student status code
  • stu-fte: (DECM) Student's FTE equivilency
  • stu-id: (CHAR) Students assigned ID #
  • stu-name: (CHAR) Name of student, Last name first
  • stu-ssn: (CHAR) Students SSN (if available)
  • year-of-grad: (INTG) Expected year of graduation for a student in this grade

    Alphabetical Index Summary

  • action-code: (PRIMARY) action-code
  • action-contact-name: action-contact-name
  • action-counselled-by: action-counselled-by
  • action-date: action-date
  • action-time: action-time
  • bldg-code: bldg-code
  • counselor: counselor
  • ethnic-code: ethnic-code
  • event-bldg-code: event-bldg-code
  • event-code: event-code
  • event-contact-name: event-contact-name
  • event-date: event-date
  • event-referred-by: event-referred-by
  • event-time: event-time
  • grade: grade
  • home-room: home-room
  • house-code: house-code
  • house-description: house-description
  • incident-id: incident-id
  • promotion-path-name: promotion-path-name
  • school-year-name: school-year-name
  • sped-code: sped-code
  • status-code: status-code
  • stu-id: stu-id
  • stu-name: stu-name
  • stu-ssn: stu-ssn
  • year-of-grad: year-of-grad

    Tables Behavior_Incident references

  • Contact - Student Contacts
  • Course_Request - Course Request Record
  • Daily_Attendance - Daily Attendance
  • GPA_Rank - Student GPAs
  • Honor_Roll - Student Awarded Honor Rolls
  • Medical_Record - Medical Notes
  • Note - Student Notes
  • Report_Card - Report Card Data
  • Scheduled_Course - Scheduled Student Course
  • Student - Basic Student Data
  • Transcript_Course - Transcript Course
  • Transcript_Year - Student Transcript Year data

    Detailed Alphabetical Field Listing
    action-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this behavioural action
    Attributes: Index Component

    action-code-description Data type: CHARACTER
    Format: x(28)
    Description: Description of this behavior action

    action-contact-authorized-to-car Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if contact is allowed to care for student

    action-contact-code Data type: CHARACTER
    Format: x(8)
    Description: Name of contact code

    action-contact-head-of-house Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this contact the head of the students household?

    action-contact-home-phone Data type: CHARACTER
    Format: (xxx) xxx-xxxx ~xxxxx
    Description: Home/Evening Phone number for this contact

    action-contact-lives-with-studen Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this contact lives with the student

    action-contact-made Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Has the parent been contacted about this behavioural event

    action-contact-name Data type: CHARACTER
    Format: x(30)
    Description: Name of contact, last name first
    Attributes: Index Component

    action-contact-type Data type: CHARACTER
    Format: x(8)
    Description: Type of contact (Name, Address, Phone or Complete)

    action-contact-work-phone Data type: CHARACTER
    Format: (xxx) xxx-xxxx ~xxxxx
    Description: Work/Day Phone number for this contact

    action-contacted-at Data type: CHARACTER
    Format: x(8)
    Description: Time parent was contacted

    action-contacted-date Data type: DATE
    Format: 99/99/9999
    Description: Date parent was contact on

    action-counselled-by Data type: CHARACTER
    Format: x(32)
    Description: Name of this person (last name first)
    Attributes: Index Component

    action-cre-date Data type: DATE
    Format: 99/99/9999
    Description: Date record was created

    action-cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time this record was created at

    action-cre-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who created the record

    action-date Data type: DATE
    Format: 99/99/9999
    Description: Date of this event
    Attributes: Index Component

    action-description Data type: CHARACTER
    Format: x(68)
    Description: Description of the incident/event

    action-time Data type: CHARACTER
    Format: x(8)
    Description: Time of this event
    Attributes: Index Component

    action-upd-date Data type: DATE
    Format: 99/99/9999
    Description: Date record was last updated

    action-upd-time Data type: CHARACTER
    Format: x(8)
    Description: Time this record was last updated at

    action-upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

    birth-date Data type: DATE
    Format: 99/99/9999
    Description: Students Birthdate

    bldg-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this building
    Attributes: Index Component

    counselor Data type: CHARACTER
    Format: x(32)
    Description: Name of this person (last name first)
    Attributes: Index Component

    current-year Data type: LOGICAL
    Format: yes/no (Initial Value: no)

    days-actual Data type: DECIMAL (Decimals: 2)
    Format: z9.999 (Initial Value: 0)
    Description: # of days actually determined for remidiation

    days-official Data type: DECIMAL (Decimals: 2)
    Format: z9.999 (Initial Value: 0)
    Description: # of days officially recommended for remidiation

    days-variance-code Data type: CHARACTER
    Format: x(8)
    Description: Variance Code

    dw-valid-from Data type: DATE
    Format: 99/99/9999

    dw-valid-to Data type: DATE
    Format: 99/99/9999

    dw-version Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: 0)

    enrolled Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this status code means the student is enrolled

    ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: Ethnic code name
    Attributes: Index Component

    event-bldg-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this building
    Attributes: Index Component

    event-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this behavioural code
    Attributes: Index Component

    event-code-description Data type: CHARACTER
    Format: x(28)
    Description: Description of this behavior code

    event-contact-authorized-to-care Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if contact is allowed to care for student

    event-contact-code Data type: CHARACTER
    Format: x(8)
    Description: Name of contact code

    event-contact-head-of-house Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this contact the head of the students household?

    event-contact-home-phone Data type: CHARACTER
    Format: (xxx) xxx-xxxx ~xxxxx
    Description: Home/Evening Phone number for this contact

    event-contact-lives-with-student Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this contact lives with the student

    event-contact-made Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Has the parent been contacted about this behavioural event

    event-contact-name Data type: CHARACTER
    Format: x(30)
    Description: Name of contact, last name first
    Attributes: Index Component

    event-contact-type Data type: CHARACTER
    Format: x(8)
    Description: Type of contact (Name, Address, Phone or Complete)

    event-contact-work-phone Data type: CHARACTER
    Format: (xxx) xxx-xxxx ~xxxxx
    Description: Work/Day Phone number for this contact

    event-contacted-at Data type: CHARACTER
    Format: x(8)
    Description: Time parent was contacted

    event-contacted-date Data type: DATE
    Format: 99/99/9999
    Description: Date parent was contact on

    event-cre-date Data type: DATE
    Format: 99/99/9999
    Description: Date record was created

    event-cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time this record was created at

    event-cre-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who created the record

    event-date Data type: DATE
    Format: 99/99/9999
    Description: Date this event occured on
    Attributes: Index Component

    event-description Data type: CHARACTER
    Format: x(68)
    Description: Description of the incident/event

    event-occured-in-school Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Did the event occur on school grounds in school hours?

    event-referred-by Data type: CHARACTER
    Format: x(32)
    Description: Name of this person (last name first)
    Attributes: Index Component

    event-time Data type: CHARACTER
    Format: x(8)
    Description: Time the event occured at
    Attributes: Index Component

    event-upd-date Data type: DATE
    Format: 99/99/9999
    Description: Date record was last updated

    event-upd-time Data type: CHARACTER
    Format: x(8)
    Description: Time this record was last updated at

    event-upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

    gender Data type: LOGICAL
    Format: Male/Female (Initial Value: no)
    Description: Gender or student, Male or Female

    grade Data type: CHARACTER
    Format: x(3)
    Description: Name of this Grade (i.e. K, 1, 10, 12, etc)
    Attributes: Index Component

    home-room Data type: CHARACTER
    Format: x(6)
    Description: Room # or name
    Attributes: Index Component

    house-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this house
    Attributes: Index Component

    house-description Data type: CHARACTER
    Format: x(28)
    Description: Description of the house
    Attributes: Index Component

    incident-cost Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Cost, if any, associated with this incident

    incident-id Data type: INTEGER
    Format: zzzzzz9 (Initial Value: 0)
    Description: Incident # for this incident
    Attributes: Index Component

    promotion-path-name Data type: CHARACTER
    Format: x(8)
    Description: Name of this promotion path
    Attributes: Index Component

    school-year-name Data type: CHARACTER
    Format: x(9)
    Description: Name for school year (i.e. 1993/94, etc)
    Attributes: Index Component

    sped-code Data type: CHARACTER
    Format: x(8)
    Description: Name of student special education code
    Attributes: Index Component

    sped-fte Data type: DECIMAL (Decimals: 2)
    Format: 9.999 (Initial Value: 0)
    Description: Special Education FTE of student

    state-ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: State Assigned ethnic code

    status-code Data type: CHARACTER
    Format: x(8)
    Description: Name of student status code
    Attributes: Index Component

    stu-fte Data type: DECIMAL (Decimals: 3)
    Format: 9.999 (Initial Value: 0)
    Description: Student's FTE equivilency

    stu-id Data type: CHARACTER
    Format: x(9)
    Description: Students assigned ID #
    Attributes: Index Component

    stu-name Data type: CHARACTER
    Format: x(32)
    Description: Name of student, Last name first
    Attributes: Index Component

    stu-ssn Data type: CHARACTER
    Format: xxx-xx-xxxx
    Description: Students SSN (if available)
    Attributes: Index Component

    year-of-grad Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Expected year of graduation for a student in this grade
    Attributes: Index Component

    Created on 02/08/2008 by DBHTML V1.2