Alphabetical Field Summary
Alphabetical Index Summary
Tables Daily_Attendance references
bldg-code Data type: CHARACTER
Format: x(8)
Description: Short name for this building
Attributes: Index Component
counselor Data type: CHARACTER
Format: x(32)
Description: Name of this person (last name first)
Attributes: Index Component
current-year Data type: LOGICAL
Format: yes/no (Initial Value: no)
daily-atnd-bldg-code Data type: CHARACTER
Format: x(8)
Description: Short name for this building
Attributes: Index Component
daily-atnd-code Data type: CHARACTER
Format: x(8)
Description: Name of this attendance code
Attributes: Index Component
daily-atnd-code-priority Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Priority of this attendance code, 1 (low) to 100 (high)
daily-atnd-date Data type: DATE
Format: 99/99/9999
Description: Date of this attendance entry
Attributes: Index Component
daily-atnd-fte Data type: DECIMAL (Decimals: 2)
Format: 9.999 (Initial Value: 0)
Description: Daily FTE (1.0 = full day, .5 = half day, etc)
daily-atnd-time Data type: CHARACTER
Format: x(8)
Description: Time of this attendance entry
daily-comments Data type: CHARACTER
Format: x(68)
Description: Comments for/about this attendance entry
daily-contact-authorized-to-care Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if contact is allowed to care for student
daily-contact-code Data type: CHARACTER
Format: x(8)
Description: Name of contact code
daily-contact-head-of-house Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Is this contact the head of the students household?
daily-contact-home-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Description: Home/Evening Phone number for this contact
daily-contact-lives-with-student Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if this contact lives with the student
daily-contact-name Data type: CHARACTER
Format: x(30)
Description: Name of contact, last name first
Attributes: Index Component
daily-contact-type Data type: CHARACTER
Format: x(8)
Description: Type of contact (Name, Address, Phone or Complete)
daily-contact-work-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Description: Work/Day Phone number for this contact
daily-contacted Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes when parent has been contacted about the attendance entr
daily-contacted-at Data type: CHARACTER
Format: x(8)
Description: Time parent was contacted
daily-contacted-date Data type: DATE
Format: 99/99/9999
Description: Date parent was contact on
daily-cre-date Data type: DATE
Format: 99/99/9999
Description: Date record was created
daily-cre-time Data type: CHARACTER
Format: x(8)
Description: Time this record was created at
daily-cre-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who created the record
daily-description Data type: CHARACTER
Format: x(28)
Description: Description of the attendance code
Attributes: Index Component
daily-excused Data type: LOGICAL
Format: Excused/Unexcused (Initial Value: no)
Description: Excused if the attendance code records an excused absence
daily-in-school Data type: LOGICAL
Format: In/Out (Initial Value: no)
Description: 'In' if attendance code can be for an in school event (tardy
daily-student-absent Data type: LOGICAL
Format: Absent/Present (Initial Value: no)
Description: Indicate whether this code track absences or presents
daily-upd-date Data type: DATE
Format: 99/99/9999
Description: Date record was last updated
daily-upd-time Data type: CHARACTER
Format: x(8)
Description: Time this record was last updated at
daily-upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user record was updated by
dw-valid-from Data type: DATE
Format: 99/99/9999
dw-valid-to Data type: DATE
Format: 99/99/9999
dw-version Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: 0)
enrolled Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if this status code means the student is enrolled
ethnic-code Data type: CHARACTER
Format: x(8)
Description: Ethnic code name
Attributes: Index Component
gender Data type: LOGICAL
Format: Male/Female (Initial Value: no)
Description: Gender or student, Male or Female
grade Data type: CHARACTER
Format: x(3)
Description: Name of this Grade (i.e. K, 1, 10, 12, etc)
Attributes: Index Component
home-room Data type: CHARACTER
Format: x(6)
Description: Room # or name
Attributes: Index Component
house-code Data type: CHARACTER
Format: x(8)
Description: Short name for this house
Attributes: Index Component
house-description Data type: CHARACTER
Format: x(28)
Description: Description of the house
Attributes: Index Component
promotion-path-name Data type: CHARACTER
Format: x(8)
Description: Name of this promotion path
Attributes: Index Component
school-year-name Data type: CHARACTER
Format: x(9)
Description: Name for school year (i.e. 1993/94, etc)
Attributes: Index Component
sped-code Data type: CHARACTER
Format: x(8)
Description: Name of student special education code
Attributes: Index Component
sped-fte Data type: DECIMAL (Decimals: 2)
Format: 9.999 (Initial Value: 0)
Description: Special Education FTE of student
state-ethnic-code Data type: CHARACTER
Format: x(8)
Description: State Assigned ethnic code
status-code Data type: CHARACTER
Format: x(8)
Description: Name of student status code
Attributes: Index Component
stu-fte Data type: DECIMAL (Decimals: 3)
Format: 9.999 (Initial Value: 0)
Description: Student's FTE equivilency
stu-id Data type: CHARACTER
Format: x(9)
Description: Students assigned ID #
Attributes: Index Component
stu-name Data type: CHARACTER
Format: x(32)
Description: Name of student, Last name first
Attributes: Index Component
stu-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Description: Students SSN (if available)
Attributes: Index Component
year-of-grad Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Expected year of graduation for a student in this grade
Attributes: Index Component
Created on 02/08/2008 by DBHTML V1.2