Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object provides information about a term; i.e., a reportable period of time.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requiriement |
|---|---|
| Add | A term is added. |
| Change | A term is changed. |
| Delete | A term is deleted. |
Object Population and Business Rules
| Requirement |
|---|
| The SIF Agent and Zone must have access rights assigned to TermInfo |
| The district must belong to the same calendar and year assigned to the SIF Zone in order to populate. |
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 TermInfo entity. | Term.termID, District.districtGUID | M | ||
| @SchoolInfoRefId | The Id (GUID) that identifies the school where the term is used. | M | |||
| @SchoolYear | School year for which the information is applicable, expressed as the four-digit year in which the school year ends (e.g., 2007 for the 2006-07 school year). | M | |||
| StartDate | Starting date of the term. | System Administration > Calendar > Calendar > Term | Term.StartDate | M | |
| EndDate | Ending date of the term (CCYYMMDD). | System Administration > Calendar > Calendar > Term | Term.endDate | M | |
| Description | Text-based description of the term. | System Administration > Calendar > Calendar > Term | Term.name | O | |
| RelativeDuration | Portion of the school year represented by this term, expressed in decimal form precise to 4 decimal places (e.g., 0.1333). | Optional do not report. | O | ||
| TermCode | Locally-defined code. | O | |||
| Track | The name, description, or code of the track that contains this term. This is used when there are multiple tracks within a school. For instance, kindergarten commonly has a different set of terms than other grades within the school. | O | |||
| TermSpan | O | ||||
| TermSpan/Code | Code for session type | Calculated value based upon COUNT(terms) Hard Coded: When c.summerSchool = 1 THEN 0833, When Temp.countTerms = 1 THEN 0827 When Temp.countTerms = 2 THEN 0828 When Temp.countTerms = 3 THEN 0829 When Temp.countTerms = 4 THEN 0830 When Temp.countTerms = 5 THEN 0831 When Temp.countTerms = 6 THEN 0832 When Temp.countTerms = 12 THEN 0837 ELSE 9999 Note: termInfo.TermSpan.Code field will not update when a term is deleted, or when the calendar is changed to summer. The record must be re-sent for the field to update. | Calculated value based upon COUNT(terms) | M | |
| TermSpan/ OtherCodeList | O | ||||
| TermSpan/ OtherCodeList/ OtherCode | 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. | System Administration > Calendar > Calendar > Term | TermSchedule.name | MR | |
| TermSpan/ OtherCodeList/ OtherCode/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Where Codeset = Text. | M | ||
| MarkingTerm | Does this TermInfo represent a marking period? | Optional do not report. | O | ||
| SchedulingTerm | Does this TermInfo represent a scheduling term? | Optional do not report. | O | ||
| AttendanceTerm | Does this TermInfo represent an attendance term? | Optional do not report. | O |
