COUNTRY

274 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null
ORGANIZATION.COUNTRY_ID ORGANIZATION_COUNTRY_FKR

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

Relationships