Alphabetical Field Summary
Alphabetical Index Summary
Tables Course_Attendance references
atnd-code Data type: CHARACTER
Format: x(8)
Description: Name of this attendance code
Attributes: Index Component
atnd-code-excused Data type: LOGICAL
Format: Excused/Unexcused (Initial Value: no)
Description: Excused if the attendance code records an excused absence
Attributes: Index Component
atnd-code-in-school Data type: LOGICAL
Format: In/Out (Initial Value: no)
Description: 'In' if attendance code can be for an in school event (tardy
Attributes: Index Component
atnd-code-priority Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Priority of this attendance code, 1 (low) to 100 (high)
atnd-code-student-absent Data type: LOGICAL
Format: Absent/Present (Initial Value: no)
Description: Indicate whether this code track absences or presents
Attributes: Index Component
atnd-comments Data type: CHARACTER
Format: x(68)
Description: Comments for/about this attendance entry
atnd-contact-authorized-for-care Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if contact is allowed to care for student
atnd-contact-code Data type: CHARACTER
Format: x(8)
Description: Name of contact code
atnd-contact-contact-name Data type: CHARACTER
Format: x(30)
Description: Name of contact, last name first
Attributes: Index Component
atnd-contact-head-of-house Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Is this contact the head of the students household?
atnd-contact-home-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Description: Home/Evening Phone number for this contact
atnd-contact-lives-with-student Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if this contact lives with the student
atnd-contact-work-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Description: Work/Day Phone number for this contact
atnd-date Data type: DATE
Format: 99/99/9999
Description: Date of this attendance entry
Attributes: Index Component
atnd-description Data type: CHARACTER
Format: x(28)
Description: Description of the attendance code
Attributes: Index Component
atnd-parent-contacted Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes when parent has been contacted about the attendance entr
atnd-parent-contacted-at Data type: CHARACTER
Format: x(8)
Description: Time parent was contacted
atnd-parent-contacted-date Data type: DATE
Format: 99/99/9999
Description: Date parent was contact on
atnd-period-name Data type: CHARACTER
Format: x(4)
Description: Name of the period (1, 2, GYM, HOME, etc)
Attributes: Index Component
atnd-time Data type: CHARACTER
Format: x(8)
Description: Time of this attendance entry
birth-date Data type: DATE
Format: 99/99/9999
Description: Students Birthdate
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
course-bldg-code Data type: CHARACTER
Format: x(8)
Description: Short name for this building
course-day-list Data type: CHARACTER
Format: x(16)
Description: Preformatted meeting day list
course-dept-name Data type: CHARACTER
Format: x(8)
Description: Department Code/Short Name
Attributes: Index Component
course-description Data type: CHARACTER
Format: x(28)
Description: Description of this course
course-group-code Data type: CHARACTER
Format: x(8)
Description: Name of this course group
Attributes: Index Component
course-multiple-meets Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Set to Yes if this only shows the first meeting record
course-name Data type: CHARACTER
Format: x(9)
Description: Formatted course/section number (i.e. 1003-01)
course-period-list Data type: CHARACTER
Format: x(16)
Description: List of meeting periods
course-room-name Data type: CHARACTER
Format: x(6)
Description: Room # or name
course-schd-period-list Data type: CHARACTER
Format: x(20)
Description: Scheduling Period List
course-teacher-name Data type: CHARACTER
Format: x(28)
Description: Scheduling Period List
current-year Data type: LOGICAL
Format: yes/no (Initial Value: no)
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