Definition of table atnd-letter
One entry per attendance letter , Table Dump Name atnd-let

Alphabetical Field Summary

  • atnd-class-id: (INTG) Attendance class used to figure counts for letter eligibilit
  • bldg-id: (INTG) Building this letter belongs to
  • calc-for-schd-group-id: (INTG) Apply this letter only to courses in this schd group
  • calculate-letter: (LOGC) Has letter been selected for calculations?
  • consolidate-courses: (LOGC) Yes to consolidate multiple eligible courses on one letter
  • counts-based-on-year: (LOGC) Are attendance counts/occurance based on entire year to date
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • description: (CHAR) Description of this attendance letter
  • enable-tardy-factoring: (LOGC) Yes to enable tardy to occurance factoring
  • extern-guid: (CHAR) External Global Unique ID for this record
  • file-copies-to-print: (INTG) Number of additional file copies to print of letter, 0 for n
  • lag-days: (INTG) Number of days after posting to wait before using attendance
  • last-letter-num: (INTG) Last assigned letter #
  • letter-based-on: (CHAR) Letter is based on Course, Daily, CrsAsDly or CrsAsTot
  • letter-enabled: (LOGC) Is letter enabled for generation and printing?
  • letter-for-first-course-only: (LOGC) Yes if letter should only be issued for 1st course eligible
  • letter-high-count: (DECM) Maximum Number of occurances to be eligible for this letter
  • letter-id: (INTG) Internally assigned letter identifier
  • letter-low-count: (DECM) Minimum number of occurances to be eligible for this letter
  • letter-name: (CHAR) Short Name for this letter
  • letter-needs-verification: (LOGC) Do you want to track parental verification of this letter?
  • letter-template-file: (CHAR) Template file used for printing letter
  • master-letter-id: (INTG) ID of atnd-letter this code is tied to
  • period-occurance-count: (INTG) Number of selected periods in a day to equal 1 occurance
  • primary-key: (INTG) Unique, Primary key for record
  • print-all-courses: (LOGC) Yes to cause all courses to print, No to print only selected
  • reset-for-each-schd-period: (LOGC) Yes if counts for letter each schd period seperatly
  • schd-group-id: (INTG) Scheduling group to use when counts are not based on year
  • schd-version-id: (INTG) Schedule Version we are associated with
  • school-year-id: (INTG) School year for this record
  • tardy-atnd-class-id: (INTG) Atnd Class ID for tardy code counting
  • tardy-factor: (INTG) # of tardies to equal one occurance for letter eligibility
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by
  • use-daily-fte: (LOGC) Yes to count daily atnd using Daily FTE, No for simple count
  • use-mailing-classes: (LOGC) Yes to send letters to all selected mailing classes

    Alphabetical Index Summary

  • atnd-letter: (UNIQUE, PRIMARY) school-year-id, bldg-id, schd-version-id, letter-id
  • description: school-year-id, bldg-id, schd-version-id, description, letter-id
  • extern-guid: extern-guid
  • letter-name: school-year-id, bldg-id, schd-version-id, letter-name, letter-id

    Alphabetical Trigger Summary

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

    Other tables who reference atnd-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
  • 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.

    Tables atnd-letter references

  • atnd-class - Attendance Code Classes
  • building - One record for each building, for each scheduling version, f
  • email-info - (no description available)
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • schd-group - Scheduling Group
  • school-year - School year file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • user-bldg - User Restricted to building list


    Detailed Alphabetical Field Listing
    atnd-class-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Attendance class used to figure counts for letter eligibilit

    bldg-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Building this letter belongs to
    Attributes: Index Component

    calc-for-schd-group-id Data type: INTEGER
    Format: 9999999999999999999
    Help: Apply this letter only to courses in this schd group

    calculate-letter Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Has letter been selected for calculations?

    consolidate-courses Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to consolidate multiple eligible courses on one letter

    counts-based-on-year Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Are attendance counts/occurance based on entire year to date

    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 record was created

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

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this attendance letter
    Attributes: Index Component

    enable-tardy-factoring Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable tardy to occurance factoring

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

    file-copies-to-print Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Number of additional file copies to print of letter, 0 for n

    lag-days Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Help: Number of days after posting to wait before using attendance

    last-letter-num Data type: INTEGER
    Format: zzzzzzzzz9 (Initial Value: 0)
    Help: Last assigned letter #

    letter-based-on Data type: CHARACTER
    Format: x(8) (Initial Value: Course)
    Help: Letter is based on Course, Daily, CrsAsDly or CrsAsTot

    letter-enabled Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is letter enabled for generation and printing?

    letter-for-first-course-only Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if letter should only be issued for 1st course eligible

    letter-high-count Data type: DECIMAL (Decimals: 3)
    Format: zz9.999 (Initial Value: 999.999)
    Help: Maximum Number of occurances to be eligible for this letter

    letter-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Internally assigned letter identifier
    Attributes: Index Component

    letter-low-count Data type: DECIMAL (Decimals: 3)
    Format: zz9.999 (Initial Value: 1.000)
    Help: Minimum number of occurances to be eligible for this letter

    letter-name Data type: CHARACTER
    Format: x(8)
    Help: Short Name for this letter
    Attributes: Index Component

    letter-needs-verification Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Do you want to track parental verification of this letter?

    letter-template-file Data type: CHARACTER
    Format: x(40)
    Help: Template file used for printing letter

    master-letter-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: ID of atnd-letter this code is tied to

    period-occurance-count Data type: INTEGER
    Format: zz9 (Initial Value: 3)
    Help: Number of selected periods in a day to equal 1 occurance

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

    print-all-courses Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to cause all courses to print, No to print only selected

    reset-for-each-schd-period Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if counts for letter each schd period seperatly

    schd-group-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Scheduling group to use when counts are not based on year

    schd-version-id Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Schedule Version we are associated with
    Attributes: Index Component

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

    tardy-atnd-class-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Atnd Class ID for tardy code counting

    tardy-factor Data type: INTEGER
    Format: zz9 (Initial Value: 3)
    Help: # of tardies to equal one occurance for letter eligibility

    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: Record last updated at

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

    use-daily-fte Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to count daily atnd using Daily FTE, No for simple count

    use-mailing-classes Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to send letters to all selected mailing classes

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