|
|
|
|
One of the things that SASIxp is
good at is using default dates as you do certain things. Unfortunately, this feature generates
mistakes if the defaults are not changed when students are enrolled on
non-school days or when students are scheduled after school starts. It's important to know the
differences between two fields used in the queries: 1.
EnterDate: The day the student enrolls in the SCHOOL. 2. StartDate: The day the student is placed in a CLASS. Please run these queries in your current SASIxp database to
print the lists; then, use those lists to make corrections. After making
the corrections, re-run the queries to confirm that there are no additional
errors. EnterDate < 1st Day: This query will print a list of all
students with an entry date prior to the first day of school. The
entry dates for these students must be changed to reflect the first day of
school or the actual entry date (if they entered after the first day of
school). Students cannot be
enrolled before the first day of school. PRINT ASTU 1,Status PermNum
LastName FirstName
MiddleName 1,SchoolNum 1,Grade
EnterDate 1,EnterCode LeaveDate
1,LeaveCode IF EnterDate <080801 StartDate <
EnterDate: This query will print a
list of all students with class start dates prior to their entry dates. The
start dates for the sections listed for each student must be changed to equal
the entry date. Students cannot
start classes before they are enrolled in the school. PRINT ASTU ACLS AMST
1,Status PermNum LastName
FirstName MiddleName
1,SchoolNum 1,Grade EnterDate
1,EnterCode LeaveDate 1,LeaveCode
TermCode StartDate SectionID
BegPeriod IF StartDate
< EnterDate StartDate >
EnterDate Sem 1: This query will print a
list of all students with class start dates after their enrollment/entry
dates. The start dates for the sections listed for each student must be
changed to equal the entry date -- unless the student transferred from
another class in this school.
Students must be in classes on the day of their entry into the school. PRINT ASTU ACLS AMST
1,Status PermNum LastName
FirstName MiddleName 1,SchoolNum 1,Grade
EnterDate 1,EnterCode LeaveDate
1,LeaveCode TermCode StartDate
SectionID BegPeriod IF StartDate
> EnterDate AND StartDate
<010102 |
|
|
|
|
