PersonCoreFields (ver12.1.0)
Database extension table associated to the Person table. These fields store general information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Alt_First_Name | 24.7.0 | Varchar2(100) | Stores the alternate first name. Currently, this field only used by Thailand State. |
| Alt_Middle_Name | 24.7.0 | Varchar2(100) | Stores the alternate middle name. Currently, this field only used by Thailand State. |
| Alt_Last_Name | 24.7.0 | Varchar2(100) | Stores the alternate last name. Currently, this field only used by Thailand State. |
| Alt_Third_Name | 24.7.0 | Varchar2(100) | Stores the alternate third name. Currently, this field only used by Thailand State. |
| Alt_Prefix_Codeset_ID | 24.7.0 | Number(19,0) | Stores the codesetID of alternative prefix. |
CountryOfOrigin | 12.1.0 | Varchar2(10) | The person's country of origin. |
DOB | 12.1.0 | Date | The person's date of birth. |
EducationLevel | 12.1.0 | Varchar2(10) | The person's education level. |
EmploymentStatus | 12.1.0 | Varchar2(20) | The person's employment status. |
GovWorkLoc | 12.1.0 | Varchar2(30) | Indicates whether or not the person works for the federal or state government. |
IsAvailableAtWork | 12.1.0 | Number(1) | Indicates whether or not the person is available when at work. Valid values: 1=True, 0=False. Default 1. Optional. |
IsDeceased | 12.1.0 | Number(1) | Indicates whether or not the person is deceased. Valid values: 1=True, 0=False. Default 1. Optional. |
IsOnActiveDuty | 12.1.0 | Number(1) | Indicates whether or not the person is on active duty. Valid values: 1=True, 0=False. Default 1. Optional. |
LivesOnBase | 12.1.0 | Number(1) | Indicates whether or not the person lives on base. Valid values: 1=True, 0=False. Default 1. Optional. |
MaidenName | 12.1.0 | Varchar2(305) | The person's mother's maiden name. |
MilitaryStatus | 12.1.0 | Varchar2(10) | The person's military status. |
NeedsInterpreterAssist | 12.1.0 | Number(1) | Indicates whether or not the person needs an interpreter's assistance. Valid values: 1=True, 0=False. Default 1. Optional. |
Occupation | 12.1.0 | Varchar2(30) | The person's occupation. |
PayGrade | 12.1.0 | Varchar2(5) | The person's military pay grade. |
| Race | 20.4.4 | Varchar2(10) | The person's race. |
ServiceBranch | 12.1.0 | Varchar2(20) | The person's military service branch. |
SSN | 12.1.0 | Varchar2(12) | The person's social security number. |
Third_Name | 24.7.0 | Varchar2(100) | Stores alias name. Currently, this field only used by Thailand State. |
| MaritalCodeSetID | 24.9.0 | Number(19) | Stores the Codeset Id of Marital status. |
| NationalityCodeSetID | 24.9.0 | Varchar2(32) | Stores the Codeset Id of Nationality. |
| NationalID | 24.9.0 | Number(19) | The person's national id. |