DUCK View Documentation

DUCK View Documentation

2010-05-19

All views will contain the following fields because they are required by DUCK...

_DistBldg / The 4 digit (most cases) building code assigned to each school building.
_Year / The school year this record pertains to. An example would be the 2009-2010 school year. In this case the school year listed here would be 2009. In the case of the 2010-2011 school year, this would show 2010.

All student related views should *always* contain the following fields pertaining to basic student information that is needed on almost all reports. This was decided at the last DASLR/DUCK user group meeting in the fall of 2009-2010 school year...

StudentNumber / The district unique DASL student number.
StateStudentId / The unique SSID for a student.
FirstName / Student first name which does NOT include any prefixes, just the first name field on the DASL student profile.
MiddleName / Full Student Middle name on the Student Profile screen.
LastName / Student last name which does NOT include any suffixes, just the last name field on the DASL student profile.
StudentStatusCode / The current student's status CODE (e.g. not the name or full description).
Gender / M or F depending on if the student is male or female.
GradeLevelCode / The student's current grade level as related to the _Year field. So if a student is in 11th grade and _Year = 2009 then 'most likely' that student will show 10 when _Year = 2008 and will show 12 when _Year = 2010
HomeroomCode / The homeroom currently assigned to a student. This field is visible in DASL when a student is selected in the 'top box' as 'Homeroom'
EmisFDDisabilityCondition / The CURRENTLY ACTIVE EMIS disability condition as specified on the student profile FD-Attributes tab.

Also, in many cases there are some additional fields that are included in many of the student related views. In almost all cases you can ignore these fields (eg. don't select to pull them down). They are the actual database keys for each of the student records. Those that are pretty familiar with Microsoft Access could use these keys to join multiple views together, but in most cases just joining on the 'StudentNumber' field will work. These keys will never change.

DBID_StudentId / The globally unique ID assigned to every student when they are entered into the database. This is roughly equivalent to the 'StudentNumber' field except that the 'StudentNumber' field can be changed on the student profile, while this field will never change.
DBID_SchoolId / The globally unique ID associated to a specific school. This is basically the databases’ interpretation of the '_DistBldg' field. Even if a school code is changed this field will not.
DBID_SchoolYearId / The globally unique ID associated to each school year. These are hard coded in the database and will never change.
DBID_StudentAnnualId / The globally unique ID associated to a student annual record. This basically means it is a combination of the 3 previous fields. If any of the 3 previous fields change, so will this.

AbsenceDaily_DUCK

Home » SIS » Student » Attendance » School Absences

This view will show one record for each absence and tardy record that has been entered for a student. This view can easily return thousands of results so most likely you will want to filter on the fields...

Date / This is the date the attendance record applies to, aka the day the student was absent or tardy. Example: 04/28/2010
AbsenceTypeCode / This is the attendance CODE that was entered for the specific student on the specific day. Example: A
AbsenceTypeName / Same as above, but instead of the code, it contains the full attendance type name. Example: UNEXC ABS

AdmissionHistory_DUCK

Home » SIS » Student » Admission History » Admission/Calendar History

This view contains all admission and withdrawal records for each student. This view can be slightly confusing because of the way DASL stores Admission and Withdrawal changes in the database. The Admission and Withdrawals are stored in the same table with columns pertaining to Admission and some columns pertaining to Withdrawal.

Alerts_DUCK

Home » SIS » Student » Medical » Medical Alerts

Home » SIS » Student » Miscellaneous Alerts

Home » SIS » Student » Disability Alert

Home » SIS » Student » Custody Alert

This view contains all of a student's alerts and the date that alert applies to. You will most likely be filtering on the fields...

AlertName / This is name of the type of Alert record. Examples: Medical, Miscellaneous, Custody, Pending Withdraw
IsActive / If the record is actually active (e.g. Light bulb). This is included so you can differentiate between which records are actually active and which ones are not.

Assessment_DUCK

Home » SIS » Student » Assessment

Assessment_OGT_DUCK - Horizonal Version

Home » SIS » Student » Assessment » OGT

ClassList_DUCK

???

Community_DUCK

Home » SIS » Student » Community Service

Contacts_DUCK

Home » SIS » Student » Contacts

Course_DUCK

Home » Management » School Administration » Scheduling Administration » Course Maintenance » Courses

CourseRequests_duck

Home » EZ Query » EZ Students » Course Requests

CourseSection_DUCK

Home » Management » School Administration » Scheduling Administration » Course Maintenance » Course Sections

Discipline_DUCK

Home » SIS » Discipline » Discipline Incidents » Student Incident

FeeBalance_DUCK

Home » SIS » Student » Fees » View Fee Details

Gifted_DUCK

Home » SIS » Student » Gifted » Student Gifted Record

GPA_DUCK

Home » SIS » Course History » Student GPA/Rank

Homeroom_DUCK

Home » Management » School Administration » School Building Administration » Homerooms

Immunization_DUCK - Horizonal

Home » SIS » Student » Medical » Immunizations

Locker_DUCK

Home » Management » School Administration » School Building Administration » Locker Administration » Locker Maintenance

Marks_DUCK

Home » SIS » Student » Marks » Student Marks

Membership_DUCK

Home » SIS » Student » Student Memberships

Misc_DUCK

Home » SIS » Student » Misc. Data

SpecialEd_DUCK

Home » SIS » Student » Special Education

Staff_DUCK

Home » Management » Security » View Staff Members

Staff_HQ_DUCK

Home » SIS » School » Highly Qualified Teacher Worksheet

Student_DUCK

Home » SIS » Student » Edit Profile