Core SIF - AttendanceCodeInfo

Tool Search: SIF

The current version of SIF is v2.7.

This object provides information about a particular attendance code, allows applications to synchronize each other's attendance code tables, or provides a dynamic list of attendance codes.

SIF_Events are reported for this object.

Object Triggering

Event Type	Requirement
Add	When a new Attendance Code is created and saved in System Administration > Attendance > Attendance Codes > Attendance Excuses Editor >Attendance Excuse Detail. Report 2 AttendanceCodeInfo objects associated with the attendance code when Type = A and Excuse is NOT = X (unexcused, blank, unknown or excused). Each AttendanceCodeInfo will have a unique RefId: Object 1: Report the AbsenceValue = 1.0 Object 2: Report the AbsenceValue = 0.5 Report 1 AttendanceCodeInfo object associated with the attendance code when (Status = A and Excuse NOT = X) IS NOT TRUE. There will only be 1 RefId associated with this attendance code: Object 1: Report the AbsenceValue = 0.0 This is meant to communicate that we report a single RefId associated with this Attendance Code when the Attendance Code is not an unexcused, blank, unknown or excused absence. When an attendance code is changed from NOT (Status = A, Excuse NOT = X), both new RefIds must be added. This is meant to communicate that that when the Attendance code is for unexcused absences, we store and report 2 separate RefIds for this Attendance Code. We would not be using the same RefId as we would for the non unexcused absences since those will have an AbsenceValue = 0.0. The RefIds that are for unexcused absences will have AbsenceValue = 0.5 and 1.0.
Change	When an Attendance Code is changed and saved in System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail When an Attendance Code that is generating an object with an AbsenceValue = 1.0 or 0.5 is changed, a CHANGE event must be provided for both objects. When an Attendance code is changed from (Excuse = X) T1.b, to (Type = A and Excuse NOT = X) TR1a, both new RefIds must be added for: Object 1: Report the AbsenceValue = 1.0 Object 2: Report the AbsenceValue = 0.5 When an Attendance Code that is generating an object with an AbsenceValue = 1.0 or 0.5 is changed, a CHANGE event must be provided for both objects.
Delete	When an Attendance Code is deleted. When an Attendance Code that has (Excuse NOT = X) is deleted. When an Attendance Code that has (Excuse NOT = X) is changed to HAVE (Excuse = X). When an Attendance Code that has (Excuse = X) is deleted. When an Attendance Code that has (Excuse = X) is changed to HAVE (Excuse NOT = X). When an Attendance Code that has Status = A and Excuse NOT = X is deleted or changed to no longer have (Status = A, Excuse NOT = X), delete both objects associated with this Attendance Code. When an Attendance Code that DOES NOT have (Status = A and Excuse NOT = X) is deleted, send a delete for this object. When an Attendance Code that DOES NOT have (Status = A and Excuse NOT = X) is changed to HAVE (Status = A and Excuse NOT = X). The Attendance Code reporting 0.0 will be deleted and 2 new AttendanceCodeRefIds will be created with 0.5 and 1.0 AbsenceValue.

Event Type

Requirement

Add

When a new Attendance Code is created and saved in System Administration > Attendance > Attendance Codes > Attendance Excuses Editor >Attendance Excuse Detail.

Report 2 AttendanceCodeInfo objects associated with the attendance code when Type = A and Excuse is NOT = X (unexcused, blank, unknown or excused). Each AttendanceCodeInfo will have a unique RefId:
1. Object 1: Report the AbsenceValue = 1.0
2. Object 2: Report the AbsenceValue = 0.5
Report 1 AttendanceCodeInfo object associated with the attendance code when (Status = A and Excuse NOT = X) IS NOT TRUE. There will only be 1 RefId associated with this attendance code:
1. Object 1: Report the AbsenceValue = 0.0
2. This is meant to communicate that we report a single RefId associated with this Attendance Code when the Attendance Code is not an unexcused, blank, unknown or excused absence.
When an attendance code is changed from NOT (Status = A, Excuse NOT = X), both new RefIds must be added.
This is meant to communicate that that when the Attendance code is for unexcused absences, we store and report 2 separate RefIds for this Attendance Code. We would not be using the same RefId as we would for the non unexcused absences since those will have an AbsenceValue = 0.0. The RefIds that are for unexcused absences will have AbsenceValue = 0.5 and 1.0.

Change

When an Attendance Code is changed and saved in System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail

When an Attendance Code that is generating an object with an AbsenceValue = 1.0 or 0.5 is changed, a CHANGE event must be provided for both objects.

When an Attendance code is changed from (Excuse = X) T1.b, to (Type = A and Excuse NOT = X) TR1a, both new RefIds must be added for:
1. Object 1: Report the AbsenceValue = 1.0
2. Object 2: Report the AbsenceValue = 0.5
When an Attendance Code that is generating an object with an AbsenceValue = 1.0 or 0.5 is changed, a CHANGE event must be provided for both objects.

Delete

When an Attendance Code is deleted.

When an Attendance Code that has (Excuse NOT = X) is deleted.
When an Attendance Code that has (Excuse NOT = X) is changed to HAVE (Excuse = X).
When an Attendance Code that has (Excuse = X) is deleted.
When an Attendance Code that has (Excuse = X) is changed to HAVE (Excuse NOT = X).
When an Attendance Code that has Status = A and Excuse NOT = X is deleted or changed to no longer have (Status = A, Excuse NOT = X), delete both objects associated with this Attendance Code.
1. When an Attendance Code that DOES NOT have (Status = A and Excuse NOT = X) is deleted, send a delete for this object.
2. When an Attendance Code that DOES NOT have (Status = A and Excuse NOT = X) is changed to HAVE (Status = A and Excuse NOT = X).
3. The Attendance Code reporting 0.0 will be deleted and 2 new AttendanceCodeRefIds will be created with 0.5 and 1.0 AbsenceValue.

Object Population and Business Rules

Requirement
The SIF Agent and Zone must have access rights assigned to AttendanceCodeInfo.
The district must belong to the same calendar and year assigned to the SIF Zone in order to populate.
Does not have "Exclude From SIF Reporting" = Checked on the Calendar.
A Natural RefId is not created for this object, it is created by a compilation of IDs. Users can use other IDs within the object to run batch. Note: This object only has SchoolInfoRefId as other ID.

Object Data Elements

Data Element Label	Description	Business Rules	Data Source GUI Path	Database Field	M, C or O
@RefId	The Id (GUID) that uniquely identifies this AttendanceCodeInfo entity.				M
@SchoolInfoRefId	The Id (GUID) that identifies the school where the attendance code is used.	The RefId for the school		School.schoolID	M
AttendanceCode	Locally defined code for attendance.	Reports from Code	System Admin> Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail > Code	attendanceExcuse.code	M
AttendanceType	Type of attendance code.	Reports from Status Report based on the Status field on the AttendanceExcuse Detail: When Absent, report "Absent" When Tardy, report "Tardy" When Early Release, report "EarlyDeparture" When Present, report "Present" Otherwise, report "Other"	System Admin > Attendance > Attendance Codes > Attendance Excuses Editor> Attendance Excuse Detail > Status	attendanceExcuse.status	M
AttendanceStatus	Excused status of the attendance code.	Reports from Excuse Report based on the Excuse field on the AttendanceExcuse Detail: When Unknown, report "Unknown" When Excused, report "Excused" When Exempt, report "NA" When Unexcused, report "Unexcused" Otherwise, report "NA"	System Admin > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail > Excuse	attendanceExcuse.excuse	M
Description	The text description of the attendance code.	Reports the non-null Description When there is no non-null Description, do not report this element	System Admin > Attendance > Attendance Codes > Attendance Excuses Edito > Attendance Excuse Detail > Description	attendanceExcuse.description	O
AbsenceValue	The amount of absence represented by AttendanceCode, up to three decimal places.	Report 2 AttendanceCodeInfo objects associated with the attendance code when Status = A and Excuse NOT = X. Each AttendanceCodeInfo will have a unique RefId: Object 1: Report the AbsenceValue = 1.0 Object 2: Report the AbsenceValue = 0.5 Report 1 AttendanceCodeInfo object associated with the attendance code when (Status = A and Excuse = X) There will only be 1 RefId associated with this attendance code: Object 1: Report the AbsenceValue = 0.0	System Admin > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail > Status System Admin > Attendance > Attendance Codes > Attendance Excuses Editor >Attendance Excuse Detail> Excuse	attendanceExcuse.status	O
UsedForDailyAttendance	Is this attendance code used for daily attendance?	When AbsenceValue = 0.0, report "No". Otherwise, report "Yes".			M
UsedForPeriodAttendance	Is this attendance code used for period attendance?	When AbsenceValue = 0.0, report "No". Otherwise, report "Yes"			M

Core SIF - AttendanceCodeInfo

Object Triggering

Object Population and Business Rules

Object Data Elements

Related Articles