Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference atnd-letter
Tables atnd-letter references
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