Definition of table email-info
No table description available , Table Dump Name email-in

Alphabetical Field Summary

  • 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
  • drop-bldg: (LOGC) Yes to send email to building contact for a drop
  • drop-grade: (LOGC) Yes to send email to the grade contact for a withdrawl
  • drop-house: (LOGC) Yes to send email to house contact for a withdrawl
  • drop-site: (LOGC) Yes to send email to the site contact for a drop
  • enroll-bldg: (LOGC) Yes to send email to the building contact for an enrollment
  • enroll-grade: (LOGC) Yes to send email to the grade contact for an enrollment
  • enroll-house: (LOGC) Yes to send email to the house contact for enrollment
  • enroll-site: (LOGC) Yes to send email to the profile addresses for an enrollment
  • primary-key: (INTG) Unique, Primary key for record
  • send-drop: (CHAR) (no description available)
  • send-enroll: (CHAR) (no description available)
  • 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

    Alphabetical Index Summary

  • primary-key: (UNIQUE, PRIMARY) primary-key

    Alphabetical Trigger Summary

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

    Other tables who reference email-info

  • atnd-calendar-day - Building Attendance calendar
  • atnd-calendar-group - Attendance calendar group
  • atnd-class - Attendance Code Classes
  • atnd-class-link - Links between the attendance codes and class files
  • atnd-code - Attendance Code definitions
  • atnd-eligibility - Attendance Eligibility Codes
  • atnd-letter - One entry per attendance letter
  • atnd-letter-mailing - One record per selected mailing class for this letter
  • atnd-letter-relation - Attendance letter relationships. There is an entry for any l
  • behave-action - Behaviour Actions
  • behave-class - Behaviour class codes allow various behave-codes to be colle
  • behave-class-link - This file is used to link each behave-class to it's associat
  • behave-code - Behviour Codes
  • behave-follow-up - (no description available)
  • behave-incident - Behavior Incidents, if the distict is tracking them
  • behave-location - (no description available)
  • behave-variance - Table to describe variances between official and actual days
  • behave-victim - (no description available)
  • building - One record for each building, for each scheduling version, f
  • counseling-code - (no description available)
  • course-catalog - Course Catalog
  • course-group - Course Groups
  • course-group-alternate - Alternate course for a course group
  • course-level - Course Level header file. This has little content and mostly
  • course-stats - Course Request statistics
  • course-study-area - Course Study Area
  • credential-area-course - (no description available)
  • credential-area-study -
  • daily-atnd-post-log - Log file of postings on a date/room basis
  • department - Department Classifications
  • distance-learning - Distance learning codes
  • form-bldg - Form definitions, on a per building level
  • grad-requirement-name - Graduation Requirements Names
  • grad-requirement-study - Graduation Requirement Study Area Controls
  • grade-catalog - Grades Catalog
  • grading-comment - Grading Comments. These are comments that teachers can assig
  • grading-mark - List of possible marks (not grades) for this building
  • grading-period - Grading period file holds a list of grading periods for a gi
  • grading-period-honor - Honor rolls enabled for a given grading period
  • grading-period-mark - List of marks enabled for this grading period
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • honor-roll - Honor roll setup/defitions
  • honor-roll-comment - Comment codes required or forbidden from this honor roll
  • honor-roll-exclude - Honor rolls you can't already have if you want to get this o
  • honor-roll-grade - List of required or forbidden grades for this honor roll
  • honor-roll-group - List of course gourps that are required or forbidden from th
  • house - Houses for buildings
  • imported-item -
  • instruction-setting - Instruction settings for students and courses
  • interleave-code - Scheduler Interleave codes
  • master-schd - Master Schedule records One entry per course, per section fo
  • master-schd-conflict - One entry per master schd record that conflicts with a cours
  • master-schd-meets - Course meets entry. There may be many of these for each c
  • master-schd-post-log - Log file of postings on a per-section basis
  • master-schd-stats - Master Schedule Statistics
  • period-catalog - Period Name catalog
  • personnel - Schools District personnel
  • personnel-bldg - Personnel/Building Linkage file
  • personnel-class - Personnel CLassifications (teacher, vice-principle, etc)
  • population-served - Population served by a course
  • progress-comment - Progress Report Comments
  • progress-period - Progress reporting periods
  • role-code - The role code associated with a course
  • room-catalog - Rooms catalog, within a building
  • scan-form-dataset - Scan form datasets. Many forms are simple and only have one
  • scan-form-line - Scan Form Line info
  • scan-form-sheet - Scan Form Sheets
  • schd-group - Scheduling Group
  • schd-period - These define the minimum period a course can be scheduled fo
  • schd-status - Student Schedule Status Code
  • schd-version - Master Schedule Versions
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • status-code - Student Status Codes
  • stu-assign - (no description available)
  • stu-assign-totals - (no description available)
  • stu-atnd-letter - One entry per letter a student receives
  • stu-atnd-letter-event - Events that comprise a student attendance letter
  • stu-atnd-letter-item - This has one entry for each 'item' that appears on a letter.
  • stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records
  • stu-counseling - (no description available)
  • stu-grade-comment - Student Grade comments
  • stu-grade-mark - One entry for each mark a student received for the associate
  • stu-history - Student Activity History
  • stu-makeup-event - (no description available)
  • stu-makeup-summary - (no description available)
  • stu-rank-gpa - Ranking and GPA data for a grading-period for a student
  • stu-rank-gpa-by-mark - Ranking and GPA by period mark
  • stu-request-master - Student Request Master Controls
  • stu-site - Site Specific Student data file
  • stu-transcript-mark - Student transcript marks
  • stu-transcript-year - Student Transcript Year record. One per student, per transcr
  • stu-year - One record for each year a student exists in the district
  • study-area - Study Areas for courses
  • test-record-layout - (no description available)
  • transcript-grade - List of grades/buildings that are considered for transcripts
  • user-access - User Access/Permissions file
  • user-bldg - User Restricted to building list
  • user-department - User Department Level Restrictions
  • user-grade - User Grade level restriction
  • user-personnel - User Personnel level restrictions

    Tables email-info references

  • spm-prof - SPM Profile/Base record. Only 1 per system!

    Detailed Alphabetical Field Listing
    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

    drop-bldg Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Yes to send email to building contact for a drop

    drop-grade Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Yes to send email to the grade contact for a withdrawl

    drop-house Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Yes to send email to house contact for a withdrawl

    drop-site Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Yes to send email to the site contact for a drop

    enroll-bldg Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to send email to the building contact for an enrollment

    enroll-grade Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes to send email to the grade contact for an enrollment

    enroll-house Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes to send email to the house contact for enrollment

    enroll-site Data type: LOGICAL
    Format: Yes/No (Initial Value: N)
    Help: Yes to send email to the profile addresses for an enrollment

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

    send-drop Data type: CHARACTER
    Format: x(12)

    send-enroll Data type: CHARACTER
    Format: x(12)

    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

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