AUTHOR_ID |
Base Object | AUTHOR |
Attribute Name | Author Identifier |
ColumnName | AUTHOR_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
Note |
AUTHOR_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AUTHOR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
AUTHOR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AUTHOR_ID Security Types |
Name | Current Value |
AUTHOR_ID Bound Attachments |
Name | Current Value |
AUTHOR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
AUTHOR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Author Identifier |
NO | ||
PUBL (Oracle) AUTHOR AUTHOR_ID |
NO |
AUTHOR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHOR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHOR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHOR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NM |
Base Object | AUTHOR |
Attribute Name | Last Name |
ColumnName | LAST_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Last Name: person last name. |
Note |
LAST_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LAST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
LAST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LAST_NM Security Types |
Name | Current Value |
LAST_NM Bound Attachments |
Name | Current Value |
LAST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
LAST_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Last Name |
NO | ||
PUBL (Oracle) AUTHOR LAST_NM |
NO |
LAST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_INIT |
Base Object | AUTHOR |
Attribute Name | First Initial |
ColumnName | FIRST_INIT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FIRST_INIT Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FIRST_INIT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
FIRST_INIT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FIRST_INIT Security Types |
Name | Current Value |
FIRST_INIT Bound Attachments |
Name | Current Value |
FIRST_INIT Data Movement Rules |
Name | Type | Rule Text/Value |
FIRST_INIT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author First Initial |
NO | ||
PUBL (Oracle) AUTHOR FIRST_INIT |
NO |
FIRST_INIT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_INIT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_INIT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_INIT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MID_INIT |
Base Object | AUTHOR |
Attribute Name | Middle Initial |
ColumnName | MID_INIT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MID_INIT Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MID_INIT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
MID_INIT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MID_INIT Security Types |
Name | Current Value |
MID_INIT Bound Attachments |
Name | Current Value |
MID_INIT Data Movement Rules |
Name | Type | Rule Text/Value |
MID_INIT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Middle Initial |
NO | ||
PUBL (Oracle) AUTHOR MID_INIT |
NO |
MID_INIT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MID_INIT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MID_INIT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MID_INIT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
THIRD_INIT |
Base Object | AUTHOR |
Attribute Name | Third Initial |
ColumnName | THIRD_INIT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
THIRD_INIT Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
THIRD_INIT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
THIRD_INIT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
THIRD_INIT Security Types |
Name | Current Value |
THIRD_INIT Bound Attachments |
Name | Current Value |
THIRD_INIT Data Movement Rules |
Name | Type | Rule Text/Value |
THIRD_INIT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Third Initial |
NO | ||
PUBL (Oracle) AUTHOR THIRD_INIT |
NO |
THIRD_INIT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
THIRD_INIT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
THIRD_INIT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
THIRD_INIT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM |
Base Object | AUTHOR |
Attribute Name | First Name |
ColumnName | FIRST_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | First Name: Person first name. |
Note |
FIRST_NM Column Properties |
Datatype | VARCHAR2(64) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FIRST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
FIRST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FIRST_NM Security Types |
Name | Current Value |
FIRST_NM Bound Attachments |
Name | Current Value |
FIRST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
FIRST_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author First Name |
NO | ||
PUBL (Oracle) AUTHOR FIRST_NM |
NO |
FIRST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ALIAS |
Base Object | AUTHOR |
Attribute Name | Alias |
ColumnName | ALIAS |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Alias: Person sometimes publish under a name different than their legal name. |
Note |
ALIAS Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ALIAS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
ALIAS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ALIAS Security Types |
Name | Current Value |
ALIAS Bound Attachments |
Name | Current Value |
ALIAS Data Movement Rules |
Name | Type | Rule Text/Value |
ALIAS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Alias |
NO | ||
PUBL (Oracle) AUTHOR ALIAS |
NO |
ALIAS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ALIAS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ALIAS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ALIAS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR |
Base Object | AUTHOR |
Attribute Name | Email Address |
ColumnName | EMAIL_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Email Address: Person email address. |
Note |
EMAIL_ADDR Column Properties |
Datatype | VARCHAR2(100) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 100 |
Percent Null | 0 |
EMAIL_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMAIL_ADDR Security Types |
Name | Current Value |
EMAIL_ADDR Bound Attachments |
Name | Current Value |
EMAIL_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
EMAIL_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Email Address |
NO | ||
PUBL (Oracle) AUTHOR EMAIL_ADDR |
NO |
EMAIL_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CNTRY_ID |
Base Object | AUTHOR |
Attribute Name | Country Identifier |
ColumnName | CNTRY_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Country Identifier: Abbreviated identrifier for a country. |
Note |
CNTRY_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CNTRY_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
CNTRY_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CNTRY_ID Security Types |
Name | Current Value |
CNTRY_ID Bound Attachments |
Name | Current Value |
CNTRY_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CNTRY_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Country Identifier |
NO | ||
PUBL (Oracle) AUTHOR CNTRY_ID |
NO |
CNTRY_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CNTRY_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CNTRY_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CNTRY_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID |
Base Object | AUTHOR |
Attribute Name | Institute Identifier |
ColumnName | INST_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Institute Identifer: Abbreviated identifier for a institute. |
Note |
INST_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INST_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INST_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INST_ID Security Types |
Name | Current Value |
INST_ID Bound Attachments |
Name | Current Value |
INST_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INST_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Institute Identifier |
NO | ||
PUBL (Oracle) AUTHOR INST_ID |
NO |
INST_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESEARCH_ID |
Base Object | AUTHOR |
Attribute Name | Researcher Identifier |
ColumnName | RESEARCH_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | ResearcherID: A unique identifier assinged by Thomson Reuters to enable researchers to manage their publication lists, track their times cited counts and h-index, identify potential collaborators and avoid author misidentification. In addition, your ResearcherID information integrates with the Web of Science and is ORCID compliant, allowing you to claim and showcase your publications from a single one account. |
Note |
RESEARCH_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RESEARCH_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
RESEARCH_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RESEARCH_ID Security Types |
Name | Current Value |
RESEARCH_ID Bound Attachments |
Name | Current Value |
RESEARCH_ID Data Movement Rules |
Name | Type | Rule Text/Value |
RESEARCH_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Researcher Identifier |
NO | ||
PUBL (Oracle) AUTHOR RESEARCH_ID |
NO |
RESEARCH_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESEARCH_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESEARCH_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESEARCH_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORCID_ID |
Base Object | AUTHOR |
Attribute Name | ORCID Identitifer |
ColumnName | ORCID_ID |
Logical Rolename | |
RoleName | |
Domain | URI |
Physical Only | NO |
Definition | ORCID Id: The ORCID iD is a URI with a 16-digit number that is compatible with the ISO Standard (ISO 27729), also known as the International Standard Name Identifier (ISNI). Initially ORCID iDs will be randomly assigned by the ORCID Registry from a block of numbers that will not conflict with ISNI-formatted numbers assigned in other ways. ORCID iDs always need all 16-digits; they can not be shortened to remove leading zeros if they exist. |
Note |
ORCID_ID Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORCID_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
ORCID_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORCID_ID Security Types |
Name | Current Value |
ORCID_ID Bound Attachments |
Name | Current Value |
ORCID_ID Data Movement Rules |
Name | Type | Rule Text/Value |
ORCID_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author ORCID Identitifer |
NO | ||
PUBL (Oracle) AUTHOR ORCID_ID |
NO |
ORCID_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORCID_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORCID_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORCID_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID |
Base Object | AUTHOR |
Attribute Name | Person Identifier |
ColumnName | PERSON_ID |
Logical Rolename | Person Identifier |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
Note |
PERSON_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PERSON_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
PERSON_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PERSON_ID Security Types |
Name | Current Value |
PERSON_ID Bound Attachments |
Name | Current Value |
PERSON_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PERSON_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Person Identifier |
NO | ||
PUBL (Oracle) AUTHOR PERSON_ID |
NO |
PERSON_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | AUTHOR |
Attribute Name | Comment |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMNT Security Types |
Name | Current Value |
CMNT Bound Attachments |
Name | Current Value |
CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author Comment |
NO | ||
PUBL (Oracle) AUTHOR CMNT |
NO |
CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_IND |
Base Object | AUTHOR |
Attribute Name | HFIR Indicator |
ColumnName | HFIR_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
HFIR_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HFIR_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
HFIR_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
HFIR_IND 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 |
HFIR_IND Security Types |
Name | Current Value |
HFIR_IND Bound Attachments |
Name | Current Value |
HFIR_IND Data Movement Rules |
Name | Type | Rule Text/Value |
HFIR_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author HFIR Indicator |
NO | ||
PUBL (Oracle) AUTHOR HFIR_IND |
NO |
HFIR_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HFIR_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_IND |
Base Object | AUTHOR |
Attribute Name | SNS Indicator |
ColumnName | SNS_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
SNS_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SNS_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
SNS_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
SNS_IND 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 |
SNS_IND Security Types |
Name | Current Value |
SNS_IND Bound Attachments |
Name | Current Value |
SNS_IND Data Movement Rules |
Name | Type | Rule Text/Value |
SNS_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author SNS Indicator |
NO | ||
PUBL (Oracle) AUTHOR SNS_IND |
NO |
SNS_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_DIV_ID |
Base Object | AUTHOR |
Attribute Name | NSCD Division Identifier |
ColumnName | NSCD_DIV_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
NSCD_DIV_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NSCD_DIV_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
NSCD_DIV_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NSCD_DIV_ID Security Types |
Name | Current Value |
NSCD_DIV_ID Bound Attachments |
Name | Current Value |
NSCD_DIV_ID Data Movement Rules |
Name | Type | Rule Text/Value |
NSCD_DIV_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Author NSCD Division Identifier |
NO | ||
PUBL (Oracle) AUTHOR NSCD_DIV_ID |
NO |
NSCD_DIV_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_DIV_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_DIV_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_DIV_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |