StudentContactDetail (ver12.0.0)
This table provides details for a Student Contact record for a period of time beginning on the start date and ending on the end date.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| ConfidentialCommFlag | 22.7.0 | Number(1,0) | Indicates whether or not the contact will receive confidential information for the selected student. Valid values: 0=No, 1=Yes. Defaults to 0. Reserved for Unified Home Communication. |
EndDate | 12.0.0 | Date | End date of the relationship between the contact and the student. Does not relate to lives with or school pick up columns. Null date implies that the relationship is permanent. Optional |
ExcludeFromStateReportingFlg | 12.0.0 | Number(1,0) | Indicates if this record should be excluded from state reports. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
| GeneralCommFlag | 22.7.0 | Number(1,0) | Indicates whether or not the contact will receive general information for the selected student. Valid values: 0=No, 1=Yes. Defaults to 0. Reserved for Unified Home Communication. |
IsActive | 12.0.0 | Number(1,0) | Flag indicating if this record is the currently active record among all records associated with the same parent StudentContactAssoc record. The active record will be the one that has the current date contained by the start and end date values. If no record contains the current date, active will be the record with the closest future start date. If there are also no future records, active will be the one with the closest past end date. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
IsCustodial | 12.0.0 | Number(1,0) | Indicates whether or not the contact has custody over the student. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
IsEmergency | 12.0.0 | Number(1,0) | Indicates whether or not the contact is designated as an emergency contact. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
LivesWithFlg | 12.0.0 | Number(1,0) | Indicates whether or not the the student lives with the contact. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
ReceivesMailFlg | 12.0.0 | Number(1,0) | Indicates if the student contact receives mail from the school. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
| RelationshipNote | 12.0.0 | Varchar2(4000) | Any associated note for the Student Contact record. Optional. |
| RelationshipTypeCodeSetID | 12.0.0 | Number(16,0) | Identification number of the related CodeSet table row. Indexed. Required. |
| SchoolPickupFlg | 12.0.0 | Number(1,0) | Indicates whether or not the the student can be picked up by the contact. Valid values: 0=No, 1=Yes. Defaults to 0. Required. |
StartDate | 12.0.0 | Date | Start date of the relationship between the contact and the student. Does not relate to lives with or school pick up columns. Null date implies that the relationship is permanent. Indexed with StudentContactAssocID. Optional. |
| StudentContactAssocID | 12.0.0 | Number(16,0) | Identification number of the related StudentContactAssoc table row. Indexed. Required. |
StudentContactDetailID | 12.0.0 | Number(16,0) | Unique sequential number generated by the application that uniquely identifies the row in the table. Indexed. Required. |
| WhenCreated | 12.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 12.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
| WhoModified | 12.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |