Definition of table stu-atnd-letter
One entry per letter a student receives
, Table Dump Name stu-alet
Alphabetical Field Summary
atnd-from: (DATE) First day of attendance counted toward this letter
atnd-to: (DATE) Last day attendance counted toward this letter
bldg-id: (INTG) Building this letter is for
comments: (CHAR) Comments for or about this letter
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
extern-guid: (CHAR) External Global Unique ID for this record
letter-date: (DATE) Date letter has been generated for/as-of
letter-id: (INTG) Internally assigned letter identifier
letter-num: (INTG) Letter tracking number
letter-print-date: (DATE) Date (if any) letter was printed on
letter-printed: (LOGC) Has the letter been printed yet?
letter-seq: (INTG) Letter sequence identifier
letter-verified: (LOGC) Has the letter been verified?
letter-verified-date: (DATE) Date letter was verified on
primary-key: (INTG) Unique, Primary key for record
schd-version-id: (INTG) Schedule Version we are associated with
school-year-id: (INTG) School year for this record
stu-seq: (INTG) Internally assigned Student Sequence #
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
verified-contact-seq: (INTG) Contact who verified the letter
Alphabetical Index Summary
extern-guid: extern-guid
letters-by-date: school-year-id, bldg-id, schd-version-id, letter-date, letter-id, letter-seq
letters-by-letter: school-year-id, bldg-id, schd-version-id, letter-id, stu-seq, letter-seq
letters-by-num: school-year-id, bldg-id, schd-version-id, letter-num, letter-id, letter-seq
letters-to-print: school-year-id, bldg-id, schd-version-id, letter-printed, letter-id, letter-seq
stu-atnd-letter: (UNIQUE, PRIMARY) school-year-id, stu-seq, letter-seq
stu-letters: school-year-id, stu-seq, letter-date, letter-num, letter-seq
verified-letters: school-year-id, bldg-id, schd-version-id, letter-verified, letter-id, letter-num, letter-seq
Alphabetical Trigger Summary
CREATE: Overridable, Procedure is tr-c-slt.p (SOURCE NOT AVAILABLE)
DELETE: Overridable, Procedure is tr-d-slt.p (SOURCE NOT AVAILABLE)
REPLICATION-CREATE: Procedure is rp-c-slt.p (SOURCE NOT AVAILABLE)
REPLICATION-DELETE: Procedure is rp-d-slt.p (SOURCE NOT AVAILABLE)
REPLICATION-WRITE: Procedure is rp-u-slt.p (SOURCE NOT AVAILABLE)
WRITE: Overridable, Procedure is tr-u-slt.p (SOURCE NOT AVAILABLE)
Other tables who reference stu-atnd-letter
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 stu-atnd-letter references
atnd-letter - One entry per attendance letter
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
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-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
Detailed Alphabetical Field Listing
atnd-from Data type: DATE
Format: 99/99/9999
Help: First day of attendance counted toward this letter
atnd-to Data type: DATE
Format: 99/99/9999
Help: Last day attendance counted toward this letter
bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building this letter is for
Attributes: Index Component
comments Data type: CHARACTER
Format: x(68)
Help: Comments for or about this letter
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
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
letter-date Data type: DATE
Format: 99/99/9999
Help: Date letter has been generated for/as-of
Attributes: Index Component
letter-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned letter identifier
Attributes: Index Component
letter-num Data type: INTEGER
Format: zzzzzzzz9
Help: Letter tracking number
Attributes: Index Component
letter-print-date Data type: DATE
Format: 99/99/9999
Help: Date (if any) letter was printed on
letter-printed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Has the letter been printed yet?
Attributes: Index Component
letter-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Letter sequence identifier
Attributes: Index Component
letter-verified Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Has the letter been verified?
Attributes: Index Component
letter-verified-date Data type: DATE
Format: 99/99/9999
Help: Date letter was verified on
primary-key Data type: INTEGER
Format: zzzzzzzzzzzz
Help: Unique, Primary key for record
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
stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Student Sequence #
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
verified-contact-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Contact who verified the letter
Created on 05/07/2012 by DBHTML V1.2