| Field | Required? | Synergetic Meaning
(where tAttendances.AttendedFlag = 1) | Synergetic Meaning
(where tAttendances .AttendedFlag = 0) | Description | Type | XML Structure | Level | Status |
|---|
| StudentAttendancetimeList RefId | M | sif.BaseObject.RefID | sif.BaseObject.RefID | The ID (GUID) that uniquely identifies the instance of the object. | IdRefType | <StudentAttendancetimeList RefId=""> | 0 | TO DO | | StudentPersonalRefId | M | tAttendanecs.ID --> CommunityIdentifiers.SIF3RefId | AbsenceEvents.ID → CommunityIdentifiers.SIF3RefId | The ID (GUID) of the student for whom this attendance information is being reported. | IdRefType | <StudentPersonalRefId> | 1 | TO DO | | SchoolInfoRefId | M | sif.fnSettingValue( 'SchoolInfo_RefID' ) | sif.fnSettingValue( 'SchoolInfo_RefID' ) | The ID (GUID) of the school for which this attendance information is being reported. | IdRefType | <SchoolInfoRefId> | 1 | TO DO | | Date | M | AttendanceMaster.AttendanceDate | AbsenceEvents.EventDate | The calendar date to which this attendance reporting period relates. | xs:date | <Date> | 1 | TO DO | | SchoolYear | M | AttendanceMaster.FileYear | Year ( AbsenceEvents.EventDate ) | School year for which this enrollment is applicable, expressed as the four-digit year in which the school year ends (e.g. 2007). | xs:gYear | <SchoolYear> | 1 | TO DO | | AttendanceTimes | M | List | List | Breakdown of times that the student entered or returned to school. | AttendanceTimesType | <AttendanceTimes> | 1 |
| | AttendanceTime | MR |
|
| Time span that the student entered or returned to school |
| <AttendanceTime> | 2 |
| | AttendanceType | O |
--AbsenceEventTypeCode → luAbsenceEventType.Descriptiondbo.AbsenceEvents.EventTime (on MasterAbsenceEvent record)| AbsenceEventTypeCode | Nature of the attendance e.g. 'Taken at Roll Call' | string | <AttendanceType> | 3 | TO DO | | AttendanceCode | M |
|
| Locally defined code for attendance. | AttendanceCodeType | <AttendanceCode> | 3 |
| | Code | M | "100" - Present | dbo.AbsenceEvents.AbsenceTypeCode → lookup Outbound SIF code | Code representing the absence/attendance. | AUCodeSetsAttendanceCodeType | <Code> | 4 | TO DO | | OtherCodeList | O | List | List | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. If Code changes and OtherCodes are supported, both Code and all associated OtherCode elements must be present. | OtherCodeListType | <OtherCodeList> | 4 |
| | OtherCode CodeSet="" | MR | <no synergetic mapping> | <no synergetic mapping> | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | values: StateProvince, Local, Other, Text | <OtherCode CodeSet=""> | 5 | No Mapping | | OtherCode | M | <no synergetic mapping> | <no synergetic mapping> | A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element. | string | <OtherCode> | 5 | No Mapping | | AttendanceStatus | M | "NA" - Not Applicable | dbo.AbsenceEvents.AbsenceReasonCode → lookup SIF code | Approved or Unapproved status of this attendance code. | AUCodeSetsAttendanceStatusType | <AttendanceStatus> | 3 | TO DO | | StartTime | M |
AttendanceMaster.DateTimeFrom | IF AbsenceEvents.AbsenceTypeCode ->luAbsenceType and luAbsenceType.SynergyMeaning = LATE THEN AbsenceEvents.EventDateTime ELSE AttendanceMaster.AttendanceDateTimeFrom | The start of this particular time span. |
| <StartTime> | 3 | TO DO | | EndTime | M |
AttendanceMaster.DateTimeTo | dbo.AbsenceEvents.EventTime (on linked absence event record - via MasterAbsenceEventSeq)<calculated> (EndTime - StartTime) / Total-Minutes-In-Day | IF tAttendances.PossibleAbsenceCode ->luAbsenceType and luAbsenceType.SynergyMeaning = EarlyDepart THEN tAttendances.EarlyDepartureTime ELSE AttendanceMaster.AttendanceDateTimeTo | The end of this particular time span. |
| <EndTime> | 3 | TO DO | | DurationValue | O |
<calculated> (EndTime - StartTime) / Total-Minutes-In-Day | | No Mapping | No Mapping | The amount of absence represented by AttendanceCode, up to three decimal places. May be greater than 1.0. |
| <DurationValue> | 3 | TO DO | | TimeTableSubjectRefId | O |
dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record) | if found in tAttendances, then dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)| <no Synergetic mapping> | RefId of TimeTableSubject |
| <TimeTableSubjectRefId> | 3 |
TO DO--| "" | dbo.AbsenceEvents.EventComment | Note related to this particular time span. |
| <AttendanceNote> | 3 | TO DO | | PeriodAttendances | O | List | List | List of any period attendances that need to be captured as part of a full list of student attendance types. | PeriodAttendancesType | <PeriodAttendances> | 1 |
| | PeriodAttendance | MR |
|
| This container type allows recording of period level attendance for a student | PeriodAttendanceType | <PeriodAttendance> | 2 |
| | AttendanceType | O |
--AbsenceEventTypeCode → luAbsenceEventType.Description| AbsenceEventTypeCode | Nature of the attendance e.g. 'Taken at Roll Call' | xs:string | <AttendanceType> | 3 | TO DO | | AttendanceCode | M |
|
| Locally defined code for attendance. | AttendanceCodeType | <AttendanceCode> | 3 |
| | Code | M | "100" - Present | dbo.AbsenceEvents.AbsenceTypeCode → lookup Outbound SIF code | Code representing the absence/attendance. | AUCodeSetsAttendanceCodeType | <Code> | 4 | TO DO | | OtherCodeList | O | List | List | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. If Code changes and OtherCodes are supported, both Code and all associated OtherCode elements must be present. | OtherCodeListType | <OtherCodeList> | 4 |
| | OtherCode CodeSet="" | MR | <no synergetic mapping> | <no synergetic mapping> | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | values: StateProvince, Local, Other, Text | <OtherCode CodeSet=""> | 5 | No Mapping | | OtherCode | M | <no synergetic mapping> | <no synergetic mapping> | A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element. | string | <OtherCode> | 5 | No Mapping | | AttendanceStatus | M | "NA" - Not Applicable | dbo.AbsenceEvents.AbsenceReasonCode → outbound lookup SIF code | Approved or Unapproved status of this attendance code. | AUCodeSetsAttendanceStatusType | <AttendanceStatus> | 3 | TO DO | | Date | M |
dbo.AttendanceMaster.AttendanceDate | dbo.AttendanceMaster.AttendanceDate | The date of the attendance event. | xs:date | <Date> | 3 | TO DO | | SessionInfoRefId | O | No Mapping | The GUID of the session that this attendance applies to. | IdRefType | <SessionInfoRefId> | 3 | TO DO | | ScheduledActivityRefId | O | No Mapping
| The GUID of the ScheduledActivity Object attendance applies to. | IdRefType | <ScheduledActivityRefId> | 3 | TO DO | | TimetablePeriod | O |
dbo.AttendanceMaster.AttendancePeriod |
dbo.AttendanceMaster.AttendancePeriod | The period within which attendance is being reported, e.g. "4D". | xs:normalizedstring | <TimetablePeriod> | 3 | TO DO | | DayId | O |
dbo.AttendanceMaster.AttendanceDayNumber | dbo.AttendanceMaster.AttendanceDayNumber | Day Id. | xs:normalizedstring | <DayId> | 3 | TO DO | | StartTime | O |
dbo.AttendanceMaster.AttendanceDateTimeFrom |
dbo.AttendanceMaster.AttendanceDateTimeFrom | | Optional Start Time of Curriculum Session | xs:time | <StartTime> | 3 | TO DO | | EndTime | O |
dbo.AttendanceMaster.AttendanceDateTimeTodbo.AbsenceEvents.EventTime (on MasterAbsenceEvent record) |
dbo.AttendanceMaster.AttendanceDateTimeTo | Optional End Time of Curriculum Session | xs:time | <EndTime> | 3 | TO DO | | TimeIn | O |
dbo.AttendanceMaster.AttendanceDateTimeFrom | IF AbsenceEvents.AbsenceTypeCode ->luAbsenceType and luAbsenceType.SynergyMeaning = LATE THEN AbsenceEvents.EventDateTime ELSE AttendanceMaster.AttendanceDateTimeFrom | The time the student entered or returned to this class. | xs:time | <TimeIn> | 3 | TO DO | | TimeOut | O |
dbo.AttendanceMaster.AttendanceDateTimeTo | dbo.AbsenceEvents.EventTime (on linked absence event record - via MasterAbsenceEventSeq)<lookup timetable record from AttendanceMaster>IF tAttendances.PossibleAbsenceCode ->luAbsenceType and luAbsenceType.SynergyMeaning = EarlyDepart THEN tAttendances.EarlyDepartureTime ELSE AttendanceMaster.AttendanceDateTimeTo | The time the student left this class. | xs:time | <TimeOut> | 3 | TO DO | | TimeTableCellRefId | O |
<lookup timetable record from AttendanceMaster> | | <no Synergetic mapping> | The (GUID) of the piece of Curriculum (TT Grid) scheduled | IdRefType | <TimeTableCellRefId> | 3 |
TO DOdbo.SubjectClasses.SIF3RefId (via AttendanceMaster record) | dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record) | | <no Synergetic mapping> | RefId of TimeTableSubject | IdRefType | <TimeTableSubjectRefId> | 3 |
TO DO |
| | TeacherList | O | List | List | List of teachers | ScheduledTeacherListType | <TeacherList> | 3 |
| | TeacherCover | MR |
|
| Substructure to allow representing instances where teachers only take subsets of an event. Most typically, this occurs with exam supervision, where each teacher gets a 1-period duty. It also happens with schools with e.g. 4 long periods per day: a period of 1hr20mins can be split into 2 halves of 40 minutes each. | TeacherCoverType | <TeacherCover> | 4 |
| | StaffPersonalRefId | M | <no Synergetic mapping> | <no Synergetic mapping> | The Id (GUID) of the StaffPersonal record for the teacher supervising the event or event subset. | IdRefType | <StaffPersonalRefId> | 5 | No Mapping | | StaffLocalId | O | <no Synergetic mapping> | <no Synergetic mapping> | LocalId of the StaffPersonal record for the teacher supervising the event or event subset. | xs:normalizedstring | <StaffLocalId> | 5 | No Mapping | | StartTime | O | <no Synergetic mapping> | <no Synergetic mapping> | Start time for the subset of the event which the teacher supervises. If not present then we assume this teacher will be on the event for the full duration. | xs:time | <StartTime> | 5 | No Mapping | | FinishTime | O | <no Synergetic mapping> | <no Synergetic mapping> | Finish time for the subset of the event which the teacher supervises. If not present then we assume this teacher will be on the event for the full duration. Either both or neither StartTime and FinishTime should be provided. | xs:time | <FinishTime> | 5 | No Mapping | | Credit | O | <no Synergetic mapping> | <no Synergetic mapping> | How the activity is credited, from the perspective of the teacher(s) supervising the event. If a teacher is substituting for the normal teacher supervising, the credit indicates how the substituting teacher is credited. | AUCodeSetsTeacherCoverCreditType | <Credit> | 5 | No Mapping | | Supervision | O | <no Synergetic mapping> | <no Synergetic mapping> | How intensively the teacher supervises the activity. | AUCodeSetsTeacherCoverSupervisionType | <Supervision> | 5 | No Mapping | | Weighting | O | <no Synergetic mapping> | <no Synergetic mapping> | Weighting of credit assigned to teacher for activity. Assumes default of 1.0 assigned for classroom duty. | xs:decimal | <Weighting> | 5 | No Mapping | | RoomList | O | List | List | List of rooms | RoomListType | <RoomList> | 3 |
| | RoomInfoRefId | MR | <no Synergetic mapping> | <no Synergetic mapping> | The Id (GUID) of the Room in which the scheduled activity is held. | IdRefType | <RoomInfoRefId> | 4 | No Mapping | | AttendanceNote | O |
--| "" | dbo.AbsenceEvents.EventComment | Note related to this particular attendance. | xs:normalizedstring | <AttendanceNote> | 3 | TO DO | | SIF_Metadata | O | <no Synergetic mapping> | <no Synergetic mapping> |
| SIF_MetadataType | <SIF_Metadata> | 1 | No Mapping | | SIF_ExtendedElements | O | <no Synergetic mapping> | <no Synergetic mapping> |
| SIF_ExtendedElementsType | <SIF_ExtendedElements> | 1 | No Mapping |
|