INSTR_SUP_ACT_ID |
Base Object | INSTR_SUP_ACT |
Attribute Name | Instrument Support Activity Identifier |
ColumnName | INSTR_SUP_ACT_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
INSTR_SUP_ACT_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTR_SUP_ACT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INSTR_SUP_ACT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTR_SUP_ACT_ID Security Types |
Name | Current Value |
INSTR_SUP_ACT_ID Bound Attachments |
Name | Current Value |
INSTR_SUP_ACT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INSTR_SUP_ACT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Instrument Support Activity Identifier |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT INSTR_SUP_ACT_ID |
NO |
INSTR_SUP_ACT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_SUP_ACT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_SUP_ACT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_SUP_ACT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE |
Base Object | INSTR_SUP_ACT |
Attribute Name | Start Date |
ColumnName | START_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | |
Note |
START_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
START_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
START_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
START_DTE Security Types |
Name | Current Value |
START_DTE Bound Attachments |
Name | Current Value |
START_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
START_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Start Date |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT START_DTE |
NO |
START_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE |
Base Object | INSTR_SUP_ACT |
Attribute Name | End Date |
ColumnName | END_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | |
Note |
END_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
END_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
END_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
END_DTE Security Types |
Name | Current Value |
END_DTE Bound Attachments |
Name | Current Value |
END_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
END_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity End Date |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT END_DTE |
NO |
END_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID |
Base Object | INSTR_SUP_ACT |
Attribute Name | INSTR_ID |
ColumnName | INSTR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INSTR_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INSTR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTR_ID Security Types |
Name | Current Value |
INSTR_ID Bound Attachments |
Name | Current Value |
INSTR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INSTR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Instrument Identifier |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT INSTR_ID |
NO |
INSTR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BN |
Base Object | INSTR_SUP_ACT |
Attribute Name | BN |
ColumnName | BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BN Security Types |
Name | Current Value |
BN Bound Attachments |
Name | Current Value |
BN Data Movement Rules |
Name | Type | Rule Text/Value |
BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Badge Number |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT BN |
NO |
BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_GRP_ID |
Base Object | INSTR_SUP_ACT |
Attribute Name | OPER_GRP_ID |
ColumnName | OPER_GRP_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
OPER_GRP_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OPER_GRP_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
OPER_GRP_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OPER_GRP_ID Security Types |
Name | Current Value |
OPER_GRP_ID Bound Attachments |
Name | Current Value |
OPER_GRP_ID Data Movement Rules |
Name | Type | Rule Text/Value |
OPER_GRP_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Operation Group Identifier |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT OPER_GRP_ID |
NO |
OPER_GRP_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_GRP_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_GRP_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_GRP_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_SUBGRP1_ID |
Base Object | INSTR_SUP_ACT |
Attribute Name | OPER_SUBGRP1_ID |
ColumnName | OPER_SUBGRP1_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
OPER_SUBGRP1_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OPER_SUBGRP1_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
OPER_SUBGRP1_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OPER_SUBGRP1_ID Security Types |
Name | Current Value |
OPER_SUBGRP1_ID Bound Attachments |
Name | Current Value |
OPER_SUBGRP1_ID Data Movement Rules |
Name | Type | Rule Text/Value |
OPER_SUBGRP1_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Operation Subgroup1 Identifier |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT OPER_SUBGRP1_ID |
NO |
OPER_SUBGRP1_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_SUBGRP1_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_SUBGRP1_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPER_SUBGRP1_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT |
Base Object | INSTR_SUP_ACT |
Attribute Name | Activity |
ColumnName | ACT |
Logical Rolename | |
RoleName | |
Domain | Note |
Physical Only | NO |
Definition | |
Note |
ACT Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
ACT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ACT Security Types |
Name | Current Value |
ACT Bound Attachments |
Name | Current Value |
ACT Data Movement Rules |
Name | Type | Rule Text/Value |
ACT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Activity |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT ACT |
NO |
ACT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
IMPACT_AREA |
Base Object | INSTR_SUP_ACT |
Attribute Name | Impact Area |
ColumnName | IMPACT_AREA |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
IMPACT_AREA Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
IMPACT_AREA Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
IMPACT_AREA Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IMPACT_AREA Security Types |
Name | Current Value |
IMPACT_AREA Bound Attachments |
Name | Current Value |
IMPACT_AREA Data Movement Rules |
Name | Type | Rule Text/Value |
IMPACT_AREA Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Impact Area |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT IMPACT_AREA |
NO |
IMPACT_AREA Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMPACT_AREA Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMPACT_AREA Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IMPACT_AREA Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_PRIOR_IND |
Base Object | INSTR_SUP_ACT |
Attribute Name | High Priority Indicator |
ColumnName | HIGH_PRIOR_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
HIGH_PRIOR_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HIGH_PRIOR_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
HIGH_PRIOR_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
HIGH_PRIOR_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 |
HIGH_PRIOR_IND Security Types |
Name | Current Value |
HIGH_PRIOR_IND Bound Attachments |
Name | Current Value |
HIGH_PRIOR_IND Data Movement Rules |
Name | Type | Rule Text/Value |
HIGH_PRIOR_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity High Priority Indicator |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT HIGH_PRIOR_IND |
NO |
HIGH_PRIOR_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_PRIOR_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_PRIOR_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_PRIOR_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID |
Base Object | INSTR_SUP_ACT |
Attribute Name | Status Identifier |
ColumnName | STAT_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
STAT_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
STAT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
STAT_ID Security Types |
Name | Current Value |
STAT_ID Bound Attachments |
Name | Current Value |
STAT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
STAT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instrument Support Activity Status Identifier |
NO | ||
NS_OPER (Oracle) INSTR_SUP_ACT STAT_ID |
NO |
STAT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |