Definition of table stu-atnd-letter-event

Events that comprise a student attendance letter , Table Dump Name stu-alvt

Alphabetical Field Summary

atnd-code-id: (INTG) Attendance code for this entry

atnd-course-seq: (INTG) (this could become invalid later if original entry is delete

atnd-daily-seq: (INTG) (This could become invalid later if the original entry is de

bldg-id: (INTG) Building this letter is for

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

event-date: (DATE) Date of this event

event-fte: (DECM) FTE of this event (0.0 to 1.0)

event-num: (INTG) Chronological number of event

extern-guid: (CHAR) External Global Unique ID for this record

item-num: (INTG) Item # for this item

letter-id: (INTG) Internally assigned letter identifier

letter-seq: (INTG) Letter sequence identifier

period-occurance-count: (INTG) Number of selected periods in day for this occurance

period-tardy-count: (INTG) Number of period tardies for this event

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 #

tardy-event: (LOGC) Is this a tardy factored event?

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

Alphabetical Index Summary

extern-guid: extern-guid

stu-atnd-letter-event: (UNIQUE, PRIMARY) school-year-id, bldg-id, schd-version-id, stu-seq, letter-seq, item-num, event-num

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-slv.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-slv.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-slv.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-slv.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-slv.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-slv.p (SOURCE NOT AVAILABLE)

Tables stu-atnd-letter-event references

atnd-class-link - Links between the attendance codes and class files

atnd-code - Attendance Code definitions

atnd-letter - One entry per attendance letter

building - One record for each building, for each scheduling version, f

course-to-daily - Transalations for student course based attendance to daily b

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-atnd-letter - One entry per letter a student receives

stu-atnd-letter-item - This has one entry for each 'item' that appears on a letter.

stu-base - Student Base record

stu-daily-atnd - Daily student attendance entries

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-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Attendance code for this entry

atnd-course-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: (this could become invalid later if original entry is delete
Help: Course Atnd Sequence # (if any) for this event

atnd-daily-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: (This could become invalid later if the original entry is de
Help: Daily Seq # (if any) for this event

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

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

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

event-fte Data type: DECIMAL (Decimals: 3)
Format: 9.999 (Initial Value: 1.0)
Help: FTE of this event (0.0 to 1.0)

event-num Data type: INTEGER
Format: zz9
Help: Chronological number of event
Attributes: Index Component

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

item-num Data type: INTEGER
Format: zz9
Help: Item # for this item
Attributes: Index Component

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

letter-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Letter sequence identifier
Attributes: Index Component

period-occurance-count Data type: INTEGER
Format: zz9
Help: Number of selected periods in day for this occurance

period-tardy-count Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of period tardies for this event

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

tardy-event Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is this a tardy factored event?

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

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