Definition of table stu-counseling
No table description available , Table Dump Name stu-coun

Alphabetical Field Summary

  • comments: (CHAR) Comments about this visit
  • contact-date: (DATE) Date parent was contacted
  • contact-time: (CHAR) Time the parent was contacted
  • counseling-code-id: (INTG) Counseling Code this visit references
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created at
  • cre-user-name: (CHAR) User name of user who creatd this record
  • incident-id: (INTG) Behavior Incident Number for this visit, if appropriate
  • parent-contacted: (LOGC) Yes when parent has been contacted about this visit
  • personnel-id: (INTG) ID of the person reporting and/or recording this incident
  • primary-key: (INTG) Unique, Primary key for record
  • school-year-id: (INTG) School year for this record
  • stu-contact-seq: (INTG) Internally assigned contact sequence #
  • stu-seq: (INTG) Internally assigned Student Sequence #
  • upd-date: (DATE) Date this records was last updated on
  • upd-time: (CHAR) Time the record was last updated at
  • upd-user-name: (CHAR) Name of user who last updated this record
  • visit-date: (DATE) Date of this visit
  • visit-description: (CHAR) Description of this visit
  • visit-time: (CHAR) Time of this visit

    Alphabetical Index Summary

  • by-personnel: school-year-id, personnel-id, contact-date
  • by-school-year: (PRIMARY) school-year-id, stu-seq, contact-date, contact-time
  • by-student: stu-seq, school-year-id, counseling-code-id

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-scb.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-scb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-scb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-scb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-scb.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-scb.p (SOURCE NOT AVAILABLE)

    Tables stu-counseling references

  • behave-incident - Behavior Incidents, if the distict is tracking them
  • counseling-code - (no description available)
  • email-info - (no description available)
  • personnel - Schools District personnel
  • school-year - School year file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • stu-assign - (no description available)
  • stu-base - Student Base record
  • 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-personnel - User Personnel level restrictions

    Detailed Alphabetical Field Listing
    comments Data type: CHARACTER
    Format: x(68)
    Help: Comments about this visit

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

    contact-time Data type: CHARACTER
    Format: x(10)
    Help: Time the parent was contacted
    Attributes: Index Component

    counseling-code-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Help: Counseling Code this visit references
    Attributes: Index Component

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

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

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: User name of user who creatd this record

    incident-id Data type: INTEGER
    Format: zzzzzz9 (Initial Value: 0)
    Help: Behavior Incident Number for this visit, if appropriate

    parent-contacted Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes when parent has been contacted about this visit

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

    primary-key Data type: INTEGER
    Format: zzzzzzzzzzzz
    Help: Unique, Primary key for record

    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
    Description: Internally assigned Student Sequence #
    Attributes: Index Component

    upd-date Data type: DATE
    Format: 99/99/9999
    Help: Date this records was last updated on

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

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who last updated this record

    visit-date Data type: DATE
    Format: 99/99/9999
    Help: Date of this visit

    visit-description Data type: CHARACTER
    Format: x(255)
    Help: Description of this visit

    visit-time Data type: CHARACTER
    Format: x(10)
    Help: Time of this visit

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