Country Identifier |
Base Entity | Country |
Attribute Name | Country Identifier |
Logical Rolename | |
ColumnName | CNTRY_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Country Identifier: Abbreviated identrifier for a country. |
Note |
Country Identifier Logical Attribute Properties |
Logical Attribute Name | Country Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Country Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Country Identifier Security Types |
Name | Current Value |
Country Identifier Bound Attachments |
Name | Current Value |
Country Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Country Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Country Country Identifier |
NO | ||
CNMS_PRPSL (Oracle) CNTRY CNTRY_ID |
NO | ||
PRPSL (Oracle) CNTRY CNTRY_ID |
NO | ||
SMPL (Oracle) CNTRY CNTRY_ID |
NO | ||
XF_ADMIN (Oracle) CNTRY CNTRY_ID |
NO |
Country Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Country Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Country Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Country Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Country Name |
Base Entity | Country |
Attribute Name | Country Name |
Logical Rolename | |
ColumnName | CNTRY_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
Country Name Logical Attribute Properties |
Logical Attribute Name | Country Name |
Datatype | VARCHAR(120) |
Nullable | NO |
Country Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Country Name Security Types |
Name | Current Value |
Country Name Bound Attachments |
Name | Current Value |
Country Name Data Movement Rules |
Name | Type | Rule Text/Value |
Country Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Country Country Name |
NO | ||
CNMS_PRPSL (Oracle) CNTRY CNTRY_NM |
NO | ||
PRPSL (Oracle) CNTRY CNTRY_NM |
NO | ||
SMPL (Oracle) CNTRY CNTRY_NM |
NO | ||
XF_ADMIN (Oracle) CNTRY CNTRY_NM |
NO |
Country Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Country Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Country Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Country Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Region Code |
Base Entity | Country |
Attribute Name | Region Code |
Logical Rolename | |
ColumnName | REG_CD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Region Code: The world region in which the country resides. |
Note |
Region Code Logical Attribute Properties |
Logical Attribute Name | Region Code |
Datatype | VARCHAR(5) |
Nullable | YES |
Region Code Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Region Code Security Types |
Name | Current Value |
Region Code Bound Attachments |
Name | Current Value |
Region Code Data Movement Rules |
Name | Type | Rule Text/Value |
Region Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Country Region Code |
NO | ||
CNMS_PRPSL (Oracle) CNTRY REG_CD |
NO | ||
PRPSL (Oracle) CNTRY REG_CD |
NO | ||
SMPL (Oracle) CNTRY REG_CD |
NO | ||
XF_ADMIN (Oracle) CNTRY REG_CD |
NO |
Region Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Region Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Region Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Region Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sensitive Country Indicator |
Base Entity | Country |
Attribute Name | Sensitive Country Indicator |
Logical Rolename | |
ColumnName | SENS_CNTRY_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Sensitive Country Indicator Logical Attribute Properties |
Logical Attribute Name | Sensitive Country Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Sensitive Country Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Sensitive Country Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Sensitive Country Indicator Security Types |
Name | Current Value |
Sensitive Country Indicator Bound Attachments |
Name | Current Value |
Sensitive Country Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Sensitive Country Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Country Sensitive Country Indicator |
NO | ||
CNMS_PRPSL (Oracle) CNTRY SENS_CNTRY_IND |
NO | ||
PRPSL (Oracle) CNTRY SENS_CNTRY_IND |
NO | ||
SMPL (Oracle) CNTRY SENS_CNTRY_IND |
NO | ||
XF_ADMIN (Oracle) CNTRY SENS_CNTRY_IND |
NO |
Sensitive Country Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sensitive Country Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sensitive Country Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sensitive Country Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Terrorist Sponsoring Country Indicator |
Base Entity | Country |
Attribute Name | Terrorist Sponsoring Country Indicator |
Logical Rolename | |
ColumnName | TERROR_SPON_CNTRY_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Terrorist Sponsoring Country Indicator Logical Attribute Properties |
Logical Attribute Name | Terrorist Sponsoring Country Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Terrorist Sponsoring Country Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Terrorist Sponsoring Country Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Terrorist Sponsoring Country Indicator Security Types |
Name | Current Value |
Terrorist Sponsoring Country Indicator Bound Attachments |
Name | Current Value |
Terrorist Sponsoring Country Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Terrorist Sponsoring Country Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Country Terrorist Sponsoring Country Indicator |
NO | ||
CNMS_PRPSL (Oracle) CNTRY TERROR_SPON_CNTRY_IND |
NO | ||
PRPSL (Oracle) CNTRY TERROR_SPON_CNTRY_IND |
NO | ||
SMPL (Oracle) CNTRY TERROR_SPON_CNTRY_IND |
NO | ||
XF_ADMIN (Oracle) CNTRY TERROR_SPON_CNTRY_IND |
NO |
Terrorist Sponsoring Country Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Terrorist Sponsoring Country Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Terrorist Sponsoring Country Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Terrorist Sponsoring Country Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |