Definition of table atnd-calendar-day

Building Attendance calendar , Table Dump Name atnd-cal

Alphabetical Field Summary

atnd-calendar-group-id: (INTG) Attendance Group Id

atnd-day-weight: (DECM) Amount of day dedicated to student instruction (not inservic

atnd-letter-day: (LOGC) Yes if date should be used for Atnd Letter calculations

atnd-report-card-day: (LOGC) Yes if this day should be used for report card atnd reportin

atnd-report-day: (LOGC) Yes if day should be used for attendance reports

atnd-required-day: (LOGC) Attendace must be taken on this day

atnd-scan-day: (LOGC) Yes if day should be used for scanning attendance

atnd-transcript-day: (LOGC) Yes if the day should be included in transcript attendance

bldg-id: (INTG) Building ID associated with this record

calendar-date: (DATE) Date for this day in the school year

comments: (CHAR) Comments for/about this date

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

day-in-year: (INTG) Day # within this school year (1-?)

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

interleave-code-id: (INTG) Optional Schedule Interleave code for this day

membership-day: (LOGC) Is this date considered a membership or in school day?

msds-first-day: (LOGC) Is this the first day to consider for MSDS attendance?

msds-last-day: (LOGC) Is this the last day to consider for MSDS attendance?

primary-key: (INTG) Unique, Primary key for record

reporting-period-num: (INTG) State reporting period number

school-year-id: (INTG) School year ID associated with this record

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

atnd-calendar: (UNIQUE, PRIMARY) school-year-id, bldg-id, atnd-calendar-group-id, calendar-date

extern-guid: extern-guid

Alphabetical Trigger Summary

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

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

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

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

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

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

Tables atnd-calendar-day references

atnd-calendar-group - Attendance calendar group

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

interleave-code - Scheduler Interleave codes

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-calendar-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Attendance Group Id
Attributes: Index Component

atnd-day-weight Data type: DECIMAL (Decimals: 2)
Format: 9.99 (Initial Value: 1)
Help: Amount of day dedicated to student instruction (not inservic

atnd-letter-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if date should be used for Atnd Letter calculations

atnd-report-card-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this day should be used for report card atnd reportin

atnd-report-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if day should be used for attendance reports

atnd-required-day Data type: LOGICAL
Format: yes/no (Initial Value: no)
Description: Attendace must be taken on this day

atnd-scan-day Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if day should be used for scanning attendance

atnd-transcript-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if the day should be included in transcript attendance

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building ID associated with this record
Attributes: Index Component

calendar-date Data type: DATE
Format: 99/99/9999
Help: Date for this day in the school year
Attributes: Index Component

comments Data type: CHARACTER
Format: x(68)
Help: Comments for/about this date

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

day-in-year Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Day # within this school year (1-?)

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

interleave-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Optional Schedule Interleave code for this day

membership-day Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this date considered a membership or in school day?

msds-first-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is this the first day to consider for MSDS attendance?

msds-last-day Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is this the last day to consider for MSDS attendance?

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

reporting-period-num Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: State reporting period number
Help: Enter the attendance reporting period number for this date

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

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