Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table filter
inverse,,
sparkNameSparkline
columnRequired?,Status
limitHeight
separatorPoint (.)
labels‚‚
default,,
cell-width,,
userfilterDescription
datepatterndd M yy
id1570066819760_2144025330
worklog5|8|w d h m|w d h m
isORAND
order0,1,2


FieldRequired?Synergetic Meaning
(where tAttendances.AttendedFlag = 1)
Synergetic Meaning
(where tAttendances .AttendedFlag = 0)
DescriptionTypeXML StructureLevelStatus
StudentAttendancetimeList RefIdMsif.BaseObject.RefIDsif.BaseObject.RefIDThe ID (GUID) that uniquely identifies the instance of the object.IdRefType<StudentAttendancetimeList RefId="">0TO DO
StudentPersonalRefIdMtAttendanecs.ID --> CommunityIdentifiers.SIF3RefIdAbsenceEvents.ID → CommunityIdentifiers.SIF3RefIdThe ID (GUID) of the student for whom this attendance information is being reported.IdRefType<StudentPersonalRefId>1TO DO
SchoolInfoRefIdMsif.fnSettingValue( 'SchoolInfo_RefID' )sif.fnSettingValue( 'SchoolInfo_RefID' )The ID (GUID) of the school for which this attendance information is being reported.IdRefType<SchoolInfoRefId>1TO DO
DateMAttendanceMaster.AttendanceDateAbsenceEvents.EventDateThe calendar date to which this attendance reporting period relates.xs:date<Date>1TO DO
SchoolYearMAttendanceMaster.FileYearYear ( 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>1TO DO
AttendanceTimesMListListBreakdown of times that the student entered or returned to school.AttendanceTimesType<AttendanceTimes>1
AttendanceTimeMR

Time span that the student entered or returned to school
<AttendanceTime>2
AttendanceTypeO
--
""dbo.AbsenceEvents.
AbsenceEventTypeCode → luAbsenceEventType.Description
AbsenceEventTypeCode Nature of the attendance e.g. 'Taken at Roll Call'string<AttendanceType>3TO DO
AttendanceCodeM

Locally defined code for attendance.AttendanceCodeType<AttendanceCode>3
CodeM"100" - Presentdbo.AbsenceEvents.AbsenceTypeCode → lookup Outbound SIF codeCode representing the absence/attendance.AUCodeSetsAttendanceCodeType<Code>4TO DO
OtherCodeListOListListList 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="">5No Mapping
OtherCodeM<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>5No Mapping
AttendanceStatusM"NA" - Not Applicabledbo.AbsenceEvents.AbsenceReasonCode → lookup SIF codeApproved or Unapproved status of this attendance code.AUCodeSetsAttendanceStatusType<AttendanceStatus>3TO DO
StartTimeMAttendanceMaster.DateTimeFromdbo.AbsenceEvents.EventTime (on MasterAbsenceEvent record)The start of this particular time span.
<StartTime>3TO DO
EndTimeMAttendanceMaster.DateTimeTodbo.AbsenceEvents.EventTime (on linked absence event record - via MasterAbsenceEventSeq)The end of this particular time span.
<EndTime>3TO DO
DurationValueO<calculated> (EndTime - StartTime) / Total-Minutes-In-Day<calculated> (EndTime - StartTime) / Total-Minutes-In-DayThe amount of absence represented by AttendanceCode, up to three decimal places. May be greater than 1.0.
<DurationValue>3TO DO
TimeTableSubjectRefIdOdbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)if found in tAttendances, then dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)RefId of TimeTableSubject
<TimeTableSubjectRefId>3TO DO
AttendanceNoteO--dbo.AbsenceEvents.EventCommentNote related to this particular time span.
<AttendanceNote>3TO DO
PeriodAttendancesOListListList of any period attendances that need to be captured as part of a full list of student attendance types.PeriodAttendancesType<PeriodAttendances>1
PeriodAttendanceMR

This container type allows recording of period level attendance for a studentPeriodAttendanceType<PeriodAttendance>2
AttendanceTypeO--dbo.AbsenceEvents.AbsenceEventTypeCode → luAbsenceEventType.DescriptionNature of the attendance e.g. 'Taken at Roll Call'xs:string<AttendanceType>3TO DO
AttendanceCodeM

Locally defined code for attendance.AttendanceCodeType<AttendanceCode>3
CodeM"100" - Presentdbo.AbsenceEvents.AbsenceTypeCode → lookup SIF codeCode representing the absence/attendance.AUCodeSetsAttendanceCodeType<Code>4TO DO
OtherCodeListOListListList 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="">5No Mapping
OtherCodeM<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>5No Mapping
AttendanceStatusM"NA" - Not Applicabledbo.AbsenceEvents.AbsenceReasonCode → lookup SIF codeApproved or Unapproved status of this attendance code.AUCodeSetsAttendanceStatusType<AttendanceStatus>3TO DO
DateMdbo.AttendanceMaster.AttendanceDatedbo.AttendanceMaster.AttendanceDateThe date of the attendance event.xs:date<Date>3TO DO
SessionInfoRefIdO

The GUID of the session that this attendance applies to.IdRefType<SessionInfoRefId>3TO DO
ScheduledActivityRefIdO

The GUID of the ScheduledActivity Object attendance applies to.IdRefType<ScheduledActivityRefId>3TO DO
TimetablePeriodOdbo.AttendanceMaster.AttendancePerioddbo.AttendanceMaster.AttendancePeriodThe period within which attendance is being reported, e.g. "4D".xs:normalizedstring<TimetablePeriod>3TO DO
DayIdOdbo.AttendanceMaster.AttendanceDayNumberdbo.AttendanceMaster.AttendanceDayNumberDay Id.xs:normalizedstring<DayId>3TO DO
StartTimeOdbo.AttendanceMaster.AttendanceDateTimeFromdbo.AttendanceMaster.AttendanceDateTimeFromOptional Start Time of Curriculum Sessionxs:time<StartTime>3TO DO
EndTimeOdbo.AttendanceMaster.AttendanceDateTimeTodbo.AttendanceMaster.AttendanceDateTimeToOptional End Time of Curriculum Sessionxs:time<EndTime>3TO DO
TimeInOdbo.AttendanceMaster.AttendanceDateTimeFromdbo.AbsenceEvents.EventTime (on MasterAbsenceEvent record)The time the student entered or returned to this class.xs:time<TimeIn>3TO DO
TimeOutOdbo.AttendanceMaster.AttendanceDateTimeTodbo.AbsenceEvents.EventTime (on linked absence event record - via MasterAbsenceEventSeq)The time the student left this class.xs:time<TimeOut>3TO DO
TimeTableCellRefIdO<lookup timetable record from AttendanceMaster><lookup timetable record from AttendanceMaster>The (GUID) of the piece of Curriculum (TT Grid) scheduledIdRefType<TimeTableCellRefId>3TO DO
TimeTableSubjectRefIdOdbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)RefId of TimeTableSubjectIdRefType<TimeTableSubjectRefId>3TO DO
TeacherListOListListList of teachersScheduledTeacherListType<TeacherList>3
TeacherCoverMR

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
StaffPersonalRefIdM<no Synergetic mapping><no Synergetic mapping>The Id (GUID) of the StaffPersonal record for the teacher supervising the event or event subset.IdRefType<StaffPersonalRefId>5No Mapping
StaffLocalIdO<no Synergetic mapping><no Synergetic mapping>LocalId of the StaffPersonal record for the teacher supervising the event or event subset.xs:normalizedstring<StaffLocalId>5No Mapping
StartTimeO<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>5No Mapping
FinishTimeO<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>5No Mapping
CreditO<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>5No Mapping
SupervisionO<no Synergetic mapping><no Synergetic mapping>How intensively the teacher supervises the activity.AUCodeSetsTeacherCoverSupervisionType<Supervision>5No Mapping
WeightingO<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>5No Mapping
RoomListOListListList of roomsRoomListType<RoomList>3
RoomInfoRefIdMR<no Synergetic mapping><no Synergetic mapping>The Id (GUID) of the Room in which the scheduled activity is held.IdRefType<RoomInfoRefId>4No Mapping
AttendanceNoteO--dbo.AbsenceEvents.EventCommentNote related to this particular attendance.xs:normalizedstring<AttendanceNote>3TO DO
SIF_MetadataO<no Synergetic mapping><no Synergetic mapping>
SIF_MetadataType<SIF_Metadata>1No Mapping
SIF_ExtendedElementsO<no Synergetic mapping><no Synergetic mapping>
SIF_ExtendedElementsType<SIF_ExtendedElements>1No Mapping