Citizenship
The Citizenship table is a secondary table designed to hold information regarding an individual's nationality, citizenship, visa, passport, or other associations of a similar character. The exact nature of the information in each row is defined by the Citizenship Type field, which is driven by the Citizenship Type lookup table. While there is no direct link between any of the rows in the Citizenship table and the Basic Data, the two tables are associated for display purposes only. This means that in the standard profile display, the constituent's Citizenship table rows will display together, following the Basic Data display.
Millennium system administrators or the database administrator can configure audit logging for the Citizenship data table. For more information, see Audit Log.
An Administrator can remove the Citizenship table from the Millennium Explorer if not used. See Table Options for more information.
Citizenship Field Descriptions
Citizenship data is stored in the nationality data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition.
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.
|
Field Name Field Label |
Lookup Table |
Type Length [Default] {Check} |
Description |
|---|---|---|---|
|
natkey non-displaying |
none |
numeric/number 13,0
|
The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System field) |
|
natid non-displaying |
none |
char 10
|
This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System field) |
|
natdoc non-displaying |
none |
char 1 ['N']
|
This field holds a Y/N flag to indicate the existence of a linked document for this row. (System field) |
|
natdate no label |
none |
datetime/date
[getdate()]
|
The date that this citizenship row was last updated. This field is automatically entered by the system. (System field) |
|
natuserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this citizenship row. It is automatically entered by the system. (System field) |
|
natugroup non-displaying |
none |
char 1 ['Z']
|
This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field) |
|
nattype no label |
Citizenship Type |
char 6 [' ']
|
The characteristic associated with this constituent. |
|
natcountry Country |
Countries |
char 6 [' ']
|
The country with which this Citizenship Type is associated. |
|
natstrt Start |
none |
datetime/date
|
Indicates the date on which this citizenship became effective. |
|
natstop Stop |
none |
datetime/date
|
Indicates the date on which this citizenship ceases to be valid. |
|
natsource Source |
Source |
char 6 [' ']
|
The source for this citizenship information. |
|
natpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (System field) |
|
natfnum non-displaying |
none |
char 2 ['25'] {'25'} |
The file (table) number for the Citizenship table. (System field) |
|
natcrdate non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (System field) |
|
natcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
|
natdate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natmny1
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny2
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natnum1
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum2
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natyesno
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natlook1
|
Nationality Lookup1 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
natlook2
|
Nationality Lookup2 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
natlook3
|
Nationality Lookup3 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
nattext
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natdte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
natmny3
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny4
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny5
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny6
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny7
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny8
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny9
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny10
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny11
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natmny12
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
natnum3
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum4
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum5
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum6
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum7
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum8
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum9
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum10
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum11
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natnum12
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
natchk1
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk2
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk3
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk4
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk5
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk6
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk7
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk8
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk9
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
natchk10
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
nattxt1
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
nattxt2
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
nattxt3
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
nattxt4
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
nattxt5
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
Indices - Citizenship
| Index | Primary | Foreign | Unique | Fields | Sort |
|---|---|---|---|---|---|
| pk_national | Y | Y | natkey | ASC | |
| nationality02 | Y | natid | ASC |