Definition of table stu-behave-event

Student Behaviour Events , Table Dump Name stu-bevt

Alphabetical Field Summary

behave-action-id: (INTG) Behavioral Action ID associate with this event

behave-event-seq: (INTG) [DEFINE KEY]

behave-follow-up-id: (INTG) Follow up to this behavior event

behave-seq: (INTG) Related behavior incident seq#

bldg-id: (INTG) This is not always the same as stu-year.bldg-id (multi-bldg

cre-date: (DATE) Date record was created

cre-time: (CHAR) Time this record was created at

cre-user-name: (CHAR) Name of user who created the record

description: (CHAR) Description of the incident/event

event-date: (DATE) Date of this event

event-time: (CHAR) Time of this event

extern-guid: (CHAR) External Global Unique ID for this record

parent-contact-made: (LOGC) Has the parent been contacted about this behavioral event

parent-contact-required: (LOGC) Yes if this even requires parental contact

parent-contacted-at: (CHAR) Time parent was contacted

parent-contacted-date: (DATE) Date parent was contact on

personnel-id: (INTG) ID of the person reviewing and/or recording this event

precipitating-acts: (INTG) Number of related behavior problems leading up to this actio

school-year-id: (INTG) School year for this record

stu-contact-seq: (INTG) Internally assigned contact sequence #

stu-seq: (INTG) Student Seq# for this behavior entry

upd-date: (DATE) Date record was last updated

upd-time: (CHAR) Time this record was last updated at

upd-user-name: (CHAR) Name of user record was updated by

Alphabetical Index Summary

event-by-action: school-year-id, bldg-id, behave-action-id, stu-seq, behave-seq, behave-event-seq

event-by-date: school-year-id, stu-seq, behave-seq, event-date, event-time, behave-event-seq

event-by-person: school-year-id, personnel-id, stu-seq, behave-seq, behave-event-seq

extern-guid: extern-guid

stu-behave-event: (UNIQUE, PRIMARY) school-year-id, stu-seq, behave-seq, behave-event-seq

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ste.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-ste.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-ste.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-ste.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-ste.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-ste.p (SOURCE NOT AVAILABLE)

Tables stu-behave-event references

behave-action - Behaviour Actions

behave-follow-up - (no description available)

building - One record for each building, for each scheduling version, f

grading-setup - Grading setup controls building level setup/policy issues wi

personnel - Schools District personnel

school-year - School year file

stu-assign - (no description available)

stu-base - Student Base record

stu-behave - Student behaviour records

stu-contact - Student Contacts file

stu-request-master - Student Request Master Controls

stu-year - One record for each year a student exists in the district

user-bldg - User Restricted to building list

user-personnel - User Personnel level restrictions

Detailed Alphabetical Field Listing
behave-action-id Data type: INTEGER
Format: zzzzzzzzzz9
Help: Behavioral Action ID associate with this event
Attributes: Index Component

behave-event-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: [DEFINE KEY]
Help: Behavioral Event Seq#
Attributes: Index Component

behave-follow-up-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Follow up to this behavior event

behave-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Related behavior incident seq#
Attributes: Index Component

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: This is not always the same as stu-year.bldg-id (multi-bldg
Help: Building this behaviorial incident occurened in
Attributes: Index Component

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date record was created

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

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

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

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

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

extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component

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

parent-contact-required Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this even requires parental contact

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

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

personnel-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: ID of the person reviewing and/or recording this event
Attributes: Index Component

precipitating-acts Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of related behavior problems leading up to this actio

school-year-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: School year for this record
Attributes: Index Component

stu-contact-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned contact sequence #
Help: Contact Sequence of parent contacted

stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Student Seq# for this behavior entry
Attributes: Index Component

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date record was last updated

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

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

Created on 05/07/2012 by DBHTML V1.2