Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID based in which the source identifies the Country. |
||||
DESCRIPTION | VARCHAR2 | 1000 | √ | null |
|
|
The full name of the Country. To be displayed on OIM among the available options for the Country of the user account. |
|||
AUTHORITY_TYPE_ID | VARCHAR2 | 30 | √ | null |
|
|
The category ID of the category type of the country. It is used by some of the MarApps Web Services and for enabling filtering for OIM fields. |
|||
AUTHORITY_TYPE | VARCHAR2 | 100 | √ | null |
|
|
The category code of the category type of the country. |
|||
ALPHACODE2 | VARCHAR2 | 2 | √ | null |
|
|
The short code (2 digits) to be displayed among the available options to be selected for country from OIM. |
|||
ALPHACODE3 | VARCHAR2 | 3 | √ | null |
|
|
The short code (3 digits) |
|||
ACTIVE | CHAR | 1 | √ | null |
|
|
Indicates if this Country is active or deleted. In case of false, thic Country won’t be displayed among the available options within OIM |
|||
LAST_CHANGED | TIMESTAMP(6) | 11,6 | √ | null |
|
|
The date and time of the last change of the record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
COUNTRY_PK | Primary key | Asc | OBJECT_ID |
COUNTRY__UN | Must be unique | Asc | ALPHACODE2 |