Instrument Identifier |
Base Entity | Instrument Scientist |
Attribute Name | Instrument Identifier |
Logical Rolename | |
ColumnName | INSTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Instrument Identifier: Abbreviated identier for the instrument. |
Note |
Instrument Identifier Logical Attribute Properties |
Logical Attribute Name | Instrument Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Instrument Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Instrument Identifier Security Types |
Name | Current Value |
Instrument Identifier Bound Attachments |
Name | Current Value |
Instrument Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Instrument Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Scientist Instrument Identifier |
NO | ||
XF_ADMIN (Oracle) INSTR_SCI INSTR_ID |
NO |
Instrument Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number |
Base Entity | Instrument Scientist |
Attribute Name | Badge Number |
Logical Rolename | |
ColumnName | BN |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Badge Number Logical Attribute Properties |
Logical Attribute Name | Badge Number |
Datatype | VARCHAR(10) |
Nullable | NO |
Badge Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Badge Number Security Types |
Name | Current Value |
Badge Number Bound Attachments |
Name | Current Value |
Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Scientist Badge Number |
NO | ||
XF_ADMIN (Oracle) INSTR_SCI BN |
NO |
Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Role Code |
Base Entity | Instrument Scientist |
Attribute Name | Role Code |
Logical Rolename | |
ColumnName | ROLE_CD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Role Code Logical Attribute Properties |
Logical Attribute Name | Role Code |
Datatype | CHAR(1) |
Nullable | NO |
Role Code Domain Restrictions |
CheckConstraint | @var IN ('L') | ||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Role Code Security Types |
Name | Current Value |
Role Code Bound Attachments |
Name | Current Value |
Role Code Data Movement Rules |
Name | Type | Rule Text/Value |
Role Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Scientist Role Code |
NO | ||
XF_ADMIN (Oracle) INSTR_SCI ROLE_CD |
NO |
Role Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Role Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Role Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Role Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |