Person, 188 (ver5.0.0)
This table is now used to manage unlimited contacts. Person ID is used to associate a person's contact information with the person. This table is utilized in Family Management. Due to the integral place this table holds for the Student Contact functionality, it is no longer available in DDA and is no longer considered a core table able to be referenced by table number.
Note: There is expanded data in this table, both in content and types of records created. The Person table will contain information for Students, Parents, Guardians, Emergency Contacts, etc. now. If there are any customizations or reports that access the Person table, they should be retested with this content.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| DCID | 12.0.0 | Number(16,0) | Unique sequential number generated by the application. Indexed. Required. |
| Employer | 12.0.0 | Varchar2(4000) | The name of the person’s employer. Optional. |
| ExcludeFromStateReporting | 12.0.0 | Number(1,0) | Indicates if this contact is excluded from reporting to state. Valid values: 1=Exclude, 0=Do not exclude. Defaults to 0. Required. |
FirstName | 12.0.0 | Varchar2(100) | The person's first name. Indexed. Optional. |
| GenderCodeSetID | 12.0.0 | Number(16,0) | Indicates the hierarchical code sets for gender. Indexed. Optional. |
| ID | 12.0.0 | Number(16,0) | Unique sequential number generated by the application. Indexed. Required. |
| IsActive | 12.0.0 | Number(1,0) | Decides if this contact person is active. Valid values: 1=Active, 0=Inactive. Defaults to 1. Required. |
| LastName | 12.0.0 | Varchar2(100) | The person's last name. Indexed. Optional. |
| MiddleName | 12.0.0 | Varchar2(100) | The person's middle name. Optional. |
| PrefixCodeSetID | 12.0.0 | Number(16,0) | Indicates person’s prefix, such as Mr. or Mrs. Indexed. Optional. |
| StateContactID | 12.0.0 | Varchar2(40) | For state and provincial reporting use. Can be a combination of letters and numbers. Indexed. Optional. |
| StateContactNumber | 12.0.0 | Number(19,0) | Generated by the school district. Indexed. Optional. |
| SuffixCodeSetID | 12.0.0 | Number(16,0) | Indicates person’s suffix, such as Jr. or Sr. Indexed. Optional. |
| 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. |