C_StudentLookup (ver7.7.1)
This table is a table extension (part of the C_StudentLocator schema extension) associated to the Students table and tracks additional student information necessary for doing student transfer from one district to another using the Student Transfer function.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
IsOk_To_Transfer | 7.7.1 | Number(1,0) | Indicates whether a student can be transferred. Valid values: 0, 1. |
Next_Locator | 7.7.1 | Varchar2(100) | The SIS locator for the district where the student has been transferred to. Indicates students next district SIS information, such as local:260 (local:<districtnumber>). |
Prev_Locator | 7.7.1 | Varchar2(100) | The SIS locator for the district where the student has been transferred from. Indicates students previous district SIS information, such as local:260 (local:<districtnumber>). |
StudentsDCID | 7.7.1 | Number(10,0) | Unique identifier for this table. Indexed. Required. This ID column relates this extended table to the Students table DCID column. |
WhenCreated | 7.7.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.7.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 7.7.1 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 7.7.1 | Varchar2(100) | The name of person who modified the record. Defaults to user. |