Page Comparison

...

Table filter

inverse	,,
sparkName	Sparkline
column	Required?,Status
limitHeight
separator	Point (.)
labels	‚‚
default	,,
cell-width	,,
userfilter	Description
datepattern	dd M yy
id	1570066819760_2144025330
worklog	5\|8\|w d h m\|w d h m
isOR	AND
order	0,1,2

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	""	dbo.AbsenceEvents.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	IF AbsenceEvents.

AbsenceTypeCode>

AbsenceTypeCode ->luAbsenceType

and luAbsenceType.SynergyMeaning = LATE

then

THEN

AbsenceEvents.EventDateTime

ELSE

AttendanceMaster.AttendanceDateTimeFrom

The start of this particular time span.

3

TO DO

EndTime

M

IF tAttendances.

PossibleAbsenceCode>

PossibleAbsenceCode ->luAbsenceType

and luAbsenceType.SynergyMeaning = EarlyDepart

then <calculated> (EndTime - StartTime) / Total-Minutes-In-Day

THEN

tAttendances.EarlyDepartureTime

ELSE

AttendanceMaster.AttendanceDateTimeTo

The end of this particular time span.

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)

RefId of TimeTableSubject

3

TO DO


AttendanceNote	O

--

""	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

--

""	dbo.AbsenceEvents.

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

3

TO DO

TimeOut

O

dbo.AttendanceMaster.AttendanceDateTimeTodbo.AbsenceEvents.EventTime (on linked absence event record - via MasterAbsenceEventSeq)

IF tAttendances.PossibleAbsenceCode ->luAbsenceType

and luAbsenceType.SynergyMeaning = EarlyDepart THEN

tAttendances.EarlyDepartureTime

ELSE

AttendanceMaster.AttendanceDateTimeTo

The time the student left this class.

xs:time

3

TO DO

TimeTableCellRefId

O

The (GUID) of the piece of Curriculum (TT Grid) scheduled

IdRefType

3

TO DO


TimeTableSubjectRefId	O

dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)dbo.SubjectClasses.SIF3RefId (via AttendanceMaster record)

RefId of TimeTableSubject

IdRefType

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

Versions Compared

Old Version 3

New Version Current

Key