| INSTR_ID |
| Base Object | INSTR |
| Attribute Name | INSTR_ID |
| ColumnName | INSTR_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Instrument Identifier: Abbreviated identier for the instrument. |
| Note |
| INSTR_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | NO |
| 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 Inst INSTR_ID |
NO | ||
| Logical Instrument Instrument Identifier |
NO | ||
| Logical Instrument Instrument Identifier |
NO | ||
| CNMS_PRPSL (Oracle) INSTR INSTR_ID |
NO | ||
| EQUIP (Oracle) INSTR INSTR_ID |
NO | ||
| EXPRESS (Oracle) INSTR INSTR_ID |
NO | ||
| INSTR (Oracle) INSTR INSTR_ID |
NO | ||
| Instrument Logbook (Oracle) INSTR INSTR_ID |
NO | ||
| IPTSv5 (Oracle) INSTR INSTR_ID |
NO | ||
| PROC (Oracle) INSTR INSTR_ID |
NO | ||
| PRPSL (Oracle) INSTR INSTR_ID |
NO | ||
| PUBL (Oracle) INSTR INSTR_ID |
NO | ||
| SMPL (Oracle) INSTR INSTR_ID |
NO | ||
| XF_ADMIN (Oracle) INSTR 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 |
| INSTR_NM |
| Base Object | INSTR |
| Attribute Name | INSTR_NM |
| ColumnName | INSTR_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| INSTR_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INSTR_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| INSTR_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INSTR_NM Security Types |
| Name | Current Value |
| INSTR_NM Bound Attachments |
| Name | Current Value |
| INSTR_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| INSTR_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst Instr Nm |
NO | ||
| Logical Instrument Instrument Name |
NO | ||
| Logical Instrument INSTR_NM |
NO | ||
| CNMS_PRPSL (Oracle) INSTR INSTR_NM |
NO | ||
| EQUIP (Oracle) INSTR INSTR_NM |
NO | ||
| EXPRESS (Oracle) INSTR INSTR_NM |
NO | ||
| INSTR (Oracle) INSTR INSTR_NM |
NO | ||
| Instrument Logbook (Oracle) INSTR INSTR_NM |
NO | ||
| IPTSv5 (Oracle) INSTR INSTR_NM |
NO | ||
| PROC (Oracle) INSTR INSTR_NM |
NO | ||
| PRPSL (Oracle) INSTR INSTR_NM |
NO | ||
| PUBL (Oracle) INSTR INSTR_NM |
NO | ||
| SMPL (Oracle) INSTR INSTR_NM |
NO | ||
| XF_ADMIN (Oracle) INSTR INSTR_NM |
NO |
| INSTR_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID |
| Base Object | INSTR |
| Attribute Name | FACIL_ID |
| ColumnName | FACIL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place. |
| Note |
| FACIL_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FACIL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| FACIL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FACIL_ID Security Types |
| Name | Current Value |
| FACIL_ID Bound Attachments |
| Name | Current Value |
| FACIL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| FACIL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst FACIL_ID |
NO | ||
| Logical Instrument Facility Identifier |
NO | ||
| Logical Instrument FACIL_ID |
NO | ||
| CNMS_PRPSL (Oracle) INSTR FACIL_ID |
NO | ||
| EQUIP (Oracle) INSTR FACIL_ID |
NO | ||
| EXPRESS (Oracle) INSTR FACIL_ID |
NO | ||
| INSTR (Oracle) INSTR FACIL_ID |
NO | ||
| Instrument Logbook (Oracle) INSTR FACIL_ID |
NO | ||
| IPTSv5 (Oracle) INSTR FACIL_ID |
NO | ||
| PROC (Oracle) INSTR FACIL_ID |
NO | ||
| PRPSL (Oracle) INSTR FACIL_ID |
NO | ||
| PUBL (Oracle) INSTR FACIL_ID |
NO | ||
| SMPL (Oracle) INSTR FACIL_ID |
NO | ||
| XF_ADMIN (Oracle) INSTR FACIL_ID |
NO |
| FACIL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID |
| Base Object | INSTR |
| Attribute Name | GRP_ID |
| ColumnName | GRP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| GRP_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| GRP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| GRP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GRP_ID Security Types |
| Name | Current Value |
| GRP_ID Bound Attachments |
| Name | Current Value |
| GRP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| GRP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst GRP_ID |
NO | ||
| Logical Instrument Group Identifier |
NO | ||
| Logical Instrument GRP_ID |
NO | ||
| CNMS_PRPSL (Oracle) INSTR GRP_ID |
NO | ||
| EQUIP (Oracle) INSTR GRP_ID |
NO | ||
| EXPRESS (Oracle) INSTR GRP_ID |
NO | ||
| INSTR (Oracle) INSTR GRP_ID |
NO | ||
| Instrument Logbook (Oracle) INSTR GRP_ID |
NO | ||
| IPTSv5 (Oracle) INSTR GRP_ID |
NO | ||
| PROC (Oracle) INSTR GRP_ID |
NO | ||
| PRPSL (Oracle) INSTR GRP_ID |
NO | ||
| PUBL (Oracle) INSTR GRP_ID |
NO | ||
| SMPL (Oracle) INSTR GRP_ID |
NO | ||
| XF_ADMIN (Oracle) INSTR GRP_ID |
NO |
| GRP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SORT_ORD |
| Base Object | INSTR |
| Attribute Name | SORT_ORD |
| ColumnName | SORT_ORD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SORT_ORD Column Properties |
| Datatype | NUMBER(3, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SORT_ORD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| SORT_ORD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SORT_ORD Security Types |
| Name | Current Value |
| SORT_ORD Bound Attachments |
| Name | Current Value |
| SORT_ORD Data Movement Rules |
| Name | Type | Rule Text/Value |
| SORT_ORD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst SORT_ORD |
NO | ||
| Logical Instrument Sort Order |
NO | ||
| Logical Instrument SORT_ORD |
NO | ||
| CNMS_PRPSL (Oracle) INSTR SORT_ORD |
NO | ||
| EQUIP (Oracle) INSTR SORT_ORD |
NO | ||
| EXPRESS (Oracle) INSTR SORT_ORD |
NO | ||
| INSTR (Oracle) INSTR SORT_ORD |
NO | ||
| Instrument Logbook (Oracle) INSTR SORT_ORD |
NO | ||
| IPTSv5 (Oracle) INSTR SORT_ORD |
NO | ||
| PROC (Oracle) INSTR SORT_ORD |
NO | ||
| PRPSL (Oracle) INSTR SORT_ORD |
NO | ||
| PUBL (Oracle) INSTR SORT_ORD |
NO | ||
| SMPL (Oracle) INSTR SORT_ORD |
NO | ||
| XF_ADMIN (Oracle) INSTR SORT_ORD |
NO |
| SORT_ORD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SORT_ORD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SORT_ORD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SORT_ORD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CARD_FACIL_NBR |
| Base Object | INSTR |
| Attribute Name | USER_CARD_FACIL_NBR |
| ColumnName | USER_CARD_FACIL_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| USER_CARD_FACIL_NBR Column Properties |
| Datatype | NUMBER(3, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_CARD_FACIL_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| USER_CARD_FACIL_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USER_CARD_FACIL_NBR Security Types |
| Name | Current Value |
| USER_CARD_FACIL_NBR Bound Attachments |
| Name | Current Value |
| USER_CARD_FACIL_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_CARD_FACIL_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst USER_CARD_FACIL_NBR |
NO | ||
| Logical Instrument USER_CARD_FACIL_NBR |
NO | ||
| Logical Instrument USER_CARD_FACIL_NBR |
NO | ||
| CNMS_PRPSL (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| EQUIP (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| EXPRESS (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| INSTR (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| Instrument Logbook (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| IPTSv5 (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| PROC (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| PRPSL (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| PUBL (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| SMPL (Oracle) INSTR USER_CARD_FACIL_NBR |
NO | ||
| XF_ADMIN (Oracle) INSTR USER_CARD_FACIL_NBR |
NO |
| USER_CARD_FACIL_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CARD_FACIL_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CARD_FACIL_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_CARD_FACIL_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_LEAD_BN |
| Base Object | INSTR |
| Attribute Name | GRP_LEAD_BN |
| ColumnName | GRP_LEAD_BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| GRP_LEAD_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| GRP_LEAD_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| GRP_LEAD_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GRP_LEAD_BN Security Types |
| Name | Current Value |
| GRP_LEAD_BN Bound Attachments |
| Name | Current Value |
| GRP_LEAD_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| GRP_LEAD_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst GRP_LEAD_BN |
NO | ||
| Logical Instrument Badge Number |
NO | ||
| Logical Instrument GRP_LEAD_BN |
NO | ||
| CNMS_PRPSL (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| EQUIP (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| EXPRESS (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| INSTR (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| Instrument Logbook (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| IPTSv5 (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| PROC (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| PRPSL (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| PUBL (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| SMPL (Oracle) INSTR GRP_LEAD_BN |
NO | ||
| XF_ADMIN (Oracle) INSTR GRP_LEAD_BN |
NO |
| GRP_LEAD_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_LEAD_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_LEAD_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_LEAD_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_IND |
| Base Object | INSTR |
| Attribute Name | DISP_IND |
| ColumnName | DISP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DISP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DISP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DISP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'Y' |
| Bound Default |
| DISP_IND Security Types |
| Name | Current Value |
| DISP_IND Bound Attachments |
| Name | Current Value |
| DISP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| DISP_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst DISP_IND |
NO | ||
| Logical Instrument Display Indicator |
NO | ||
| Logical Instrument DISP_IND |
NO | ||
| CNMS_PRPSL (Oracle) INSTR DISP_IND |
NO | ||
| EQUIP (Oracle) INSTR DISP_IND |
NO | ||
| EXPRESS (Oracle) INSTR DISP_IND |
NO | ||
| INSTR (Oracle) INSTR DISP_IND |
NO | ||
| Instrument Logbook (Oracle) INSTR DISP_IND |
NO | ||
| IPTSv5 (Oracle) INSTR DISP_IND |
NO | ||
| PROC (Oracle) INSTR DISP_IND |
NO | ||
| PRPSL (Oracle) INSTR DISP_IND |
NO | ||
| PUBL (Oracle) INSTR DISP_IND |
NO | ||
| SMPL (Oracle) INSTR DISP_IND |
NO | ||
| XF_ADMIN (Oracle) INSTR DISP_IND |
NO |
| DISP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |