SAS Import Fields
Code | Description | [Table]Field | Length |
|---|---|---|---|
Student Number | Values cannot be blank. During the import this number is linked to the student record and student's DCID number is used to populate studentDcid field in the SAS table. If the student number is not linked to an existing student record, an error message will display; the record is not imported. | [StudentAttendanceSummary]studentDcid | N/A |
School ID | Values cannot be blank; the school number must be valid. During the import this number is linked to school and school's DCID number is used to populate schoolDcid field in the SAS table. If the school number is not linked to an existing school record, an error message will display; the record is not imported. | [StudentAttendanceSummary]schoolDcid | N/A |
Start Date | Format is MM/DD/YYYY. Values cannot be blank. This date cannot conflict with another record. | [StudentAttendanceSummary]StartDate | 10 |
End Date | Format is MM/DD/YYYY. Values cannot be blank. This date cannot conflict with another record. | [StudentAttendanceSummary]EndDate | 10 |
School Year | Format is YYYY. Values cannot be blank. You may have duplicate school years. | [StudentAttendanceSummary]SchoolYear | 4 |
Membership | Leave this field blank to set this field value to zero (0). | [StudentAttendanceSummary]MembershipValue | 5 |
Attendance | Leave this field blank to set this field value to zer0 (0). | [StudentAttendanceSummary]DaysAttended | 5 |
Absences | Values cannot be blank; however zero (0) is a valid entry. | [StudentAttendanceSummary]DaysTransportedEligibleStAid | 5 |
Unexcused Absences | Leave this field blank to set this field value to zero (0). | [StudentAttendanceSummary]UnexcusedAbsences | 5 |
Excused Absences | Leave this field blank to set this field value to zero (0). | [StudentAttendanceSummary]ExcusedAbsences | 5 |
Start Day | Enter a numeric value that is greater than or equal to 1. | [StudentAttendanceSummary]StartDay | 3 |
End Day | Enter a numeric value that is greater than or equal to the start day. | [StudentAttendanceSummary]EndDay | 3 |
Resident | Enter Yes if the student is a resident of the school district; No if the student is an out-of-district student; or Unknown if the student's residency status is unknown. | [StudentAttendanceSummary]MA_SAS_Resident | 7 |