INSTR_ID |
Base Object | INSTR |
Attribute Name | Instrument Identifier |
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 Instrument Identifier |
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 | Instrument Name |
ColumnName | INSTR_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
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 Instrument Name |
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 | Facility Identifier |
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 Facility Identifier |
NO | ||
Logical Instrument Facility Identifier |
NO | ||
Logical Instrument Facility Identifier |
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 | Group Identifier |
ColumnName | GRP_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Group Identifier: Abbreviated identier used to allow instruments to be group into logical associations.. |
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 Group Identifier |
NO | ||
Logical Instrument Group Identifier |
NO | ||
Logical Instrument Group Identifier |
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 Order |
ColumnName | SORT_ORD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Sort Order: Numerical sort order to control display order of instruments in charts and reports. |
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 Order |
NO | ||
Logical Instrument Sort Order |
NO | ||
Logical Instrument Sort Order |
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 |
DISP_IND |
Base Object | INSTR |
Attribute Name | Display Indicator |
ColumnName | DISP_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
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 | 'N' |
Bound Default |
DISP_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 |
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 Display Indicator |
NO | ||
Logical Instrument Display Indicator |
NO | ||
Logical Instrument Display Indicator |
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 |
SNGL_CRYST_ALIGN_IND |
Base Object | INSTR |
Attribute Name | Single Crystal Alignment Indicator |
ColumnName | SNGL_CRYST_ALIGN_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
SNGL_CRYST_ALIGN_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SNGL_CRYST_ALIGN_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
SNGL_CRYST_ALIGN_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
SNGL_CRYST_ALIGN_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 |
SNGL_CRYST_ALIGN_IND Security Types |
Name | Current Value |
SNGL_CRYST_ALIGN_IND Bound Attachments |
Name | Current Value |
SNGL_CRYST_ALIGN_IND Data Movement Rules |
Name | Type | Rule Text/Value |
SNGL_CRYST_ALIGN_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Single Crystal Alignment Indicator |
NO | ||
Logical Instrument Single Crystal Alignment Indicator |
NO | ||
Logical Instrument Single Crystal Alignment Indicator |
NO | ||
CNMS_PRPSL (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
EQUIP (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
EXPRESS (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
INSTR (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
Instrument Logbook (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
IPTSv5 (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
PROC (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
PRPSL (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
PUBL (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
SMPL (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO | ||
XF_ADMIN (Oracle) INSTR SNGL_CRYST_ALIGN_IND |
NO |
SNGL_CRYST_ALIGN_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNGL_CRYST_ALIGN_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNGL_CRYST_ALIGN_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNGL_CRYST_ALIGN_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUP_PRPSL_CALL_IND |
Base Object | INSTR |
Attribute Name | Supplemental Proposal Call Indicator |
ColumnName | SUP_PRPSL_CALL_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Supplemental Proposal Call Indicator: Indicates that this instrument will participate in a supplemental proposal call. |
Note |
SUP_PRPSL_CALL_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUP_PRPSL_CALL_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
SUP_PRPSL_CALL_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
SUP_PRPSL_CALL_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 |
SUP_PRPSL_CALL_IND Security Types |
Name | Current Value |
SUP_PRPSL_CALL_IND Bound Attachments |
Name | Current Value |
SUP_PRPSL_CALL_IND Data Movement Rules |
Name | Type | Rule Text/Value |
SUP_PRPSL_CALL_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Supplemental Proposal Call Indicator |
NO | ||
Logical Instrument Supplemental Proposal Call Indicator |
NO | ||
Logical Instrument Supplemental Proposal Call Indicator |
NO | ||
CNMS_PRPSL (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
EQUIP (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
EXPRESS (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
INSTR (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
Instrument Logbook (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
IPTSv5 (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
PROC (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
PRPSL (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
PUBL (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
SMPL (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO | ||
XF_ADMIN (Oracle) INSTR SUP_PRPSL_CALL_IND |
NO |
SUP_PRPSL_CALL_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUP_PRPSL_CALL_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUP_PRPSL_CALL_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUP_PRPSL_CALL_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AUTO_CLOSE_IND |
Base Object | INSTR |
Attribute Name | Auto-Close Indicator |
ColumnName | AUTO_CLOSE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
AUTO_CLOSE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AUTO_CLOSE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
AUTO_CLOSE_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
AUTO_CLOSE_IND Security Types |
Name | Current Value |
AUTO_CLOSE_IND Bound Attachments |
Name | Current Value |
AUTO_CLOSE_IND Data Movement Rules |
Name | Type | Rule Text/Value |
AUTO_CLOSE_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Auto-Close Indicator |
NO | ||
Logical Instrument Auto-Close Indicator |
NO | ||
Logical Instrument Auto-Close Indicator |
NO | ||
CNMS_PRPSL (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
EQUIP (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
EXPRESS (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
INSTR (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
Instrument Logbook (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
IPTSv5 (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
PROC (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
PRPSL (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
PUBL (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
SMPL (Oracle) INSTR AUTO_CLOSE_IND |
NO | ||
XF_ADMIN (Oracle) INSTR AUTO_CLOSE_IND |
NO |
AUTO_CLOSE_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTO_CLOSE_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTO_CLOSE_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AUTO_CLOSE_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_TMPL |
Base Object | INSTR |
Attribute Name | Statement of Research Template |
ColumnName | SOR_TMPL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SOR_TMPL Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
SOR_TMPL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
SOR_TMPL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOR_TMPL Security Types |
Name | Current Value |
SOR_TMPL Bound Attachments |
Name | Current Value |
SOR_TMPL Data Movement Rules |
Name | Type | Rule Text/Value |
SOR_TMPL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Statement of Research Template |
NO | ||
Logical Instrument Statement of Research Template |
NO | ||
Logical Instrument Statement of Research Template |
NO | ||
CNMS_PRPSL (Oracle) INSTR SOR_TMPL |
NO | ||
EQUIP (Oracle) INSTR SOR_TMPL |
NO | ||
EXPRESS (Oracle) INSTR SOR_TMPL |
NO | ||
INSTR (Oracle) INSTR SOR_TMPL |
NO | ||
Instrument Logbook (Oracle) INSTR SOR_TMPL |
NO | ||
IPTSv5 (Oracle) INSTR SOR_TMPL |
NO | ||
PROC (Oracle) INSTR SOR_TMPL |
NO | ||
PRPSL (Oracle) INSTR SOR_TMPL |
NO | ||
PUBL (Oracle) INSTR SOR_TMPL |
NO | ||
SMPL (Oracle) INSTR SOR_TMPL |
NO | ||
XF_ADMIN (Oracle) INSTR SOR_TMPL |
NO |
SOR_TMPL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_TMPL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_TMPL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_TMPL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_MIME_TYPE |
Base Object | INSTR |
Attribute Name | Statement of Research MIME Type |
ColumnName | SOR_MIME_TYPE |
Logical Rolename | |
RoleName | |
Domain | MIME Type |
Physical Only | NO |
Definition | MIME Type: Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support: |
Note |
SOR_MIME_TYPE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SOR_MIME_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
SOR_MIME_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOR_MIME_TYPE Security Types |
Name | Current Value |
SOR_MIME_TYPE Bound Attachments |
Name | Current Value |
SOR_MIME_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
SOR_MIME_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Statement of Research MIME Type |
NO | ||
Logical Instrument Statement of Research MIME Type |
NO | ||
Logical Instrument Statement of Research MIME Type |
NO | ||
CNMS_PRPSL (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
EQUIP (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
EXPRESS (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
INSTR (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
Instrument Logbook (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
IPTSv5 (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
PROC (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
PRPSL (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
PUBL (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
SMPL (Oracle) INSTR SOR_MIME_TYPE |
NO | ||
XF_ADMIN (Oracle) INSTR SOR_MIME_TYPE |
NO |
SOR_MIME_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_MIME_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_MIME_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_MIME_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_FILE_NM |
Base Object | INSTR |
Attribute Name | Statement of Research File Name |
ColumnName | SOR_FILE_NM |
Logical Rolename | |
RoleName | |
Domain | File Name |
Physical Only | NO |
Definition | File Name: An external file system file name. Often the external file name of data imported into the Rdb, such as EPICS .db files. |
Note |
SOR_FILE_NM Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SOR_FILE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
SOR_FILE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOR_FILE_NM Security Types |
Name | Current Value |
SOR_FILE_NM Bound Attachments |
Name | Current Value |
SOR_FILE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
SOR_FILE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Statement of Research File Name |
NO | ||
Logical Instrument Statement of Research File Name |
NO | ||
Logical Instrument Statement of Research File Name |
NO | ||
CNMS_PRPSL (Oracle) INSTR SOR_FILE_NM |
NO | ||
EQUIP (Oracle) INSTR SOR_FILE_NM |
NO | ||
EXPRESS (Oracle) INSTR SOR_FILE_NM |
NO | ||
INSTR (Oracle) INSTR SOR_FILE_NM |
NO | ||
Instrument Logbook (Oracle) INSTR SOR_FILE_NM |
NO | ||
IPTSv5 (Oracle) INSTR SOR_FILE_NM |
NO | ||
PROC (Oracle) INSTR SOR_FILE_NM |
NO | ||
PRPSL (Oracle) INSTR SOR_FILE_NM |
NO | ||
PUBL (Oracle) INSTR SOR_FILE_NM |
NO | ||
SMPL (Oracle) INSTR SOR_FILE_NM |
NO | ||
XF_ADMIN (Oracle) INSTR SOR_FILE_NM |
NO |
SOR_FILE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_FILE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_FILE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOR_FILE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIN_REV_NBR |
Base Object | INSTR |
Attribute Name | Minimum Reviewer Number |
ColumnName | MIN_REV_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MIN_REV_NBR Column Properties |
Datatype | NUMBER(1, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MIN_REV_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
MIN_REV_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIN_REV_NBR Security Types |
Name | Current Value |
MIN_REV_NBR Bound Attachments |
Name | Current Value |
MIN_REV_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
MIN_REV_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Minimum Reviewer Number |
NO | ||
Logical Instrument Minimum Reviewer Number |
NO | ||
Logical Instrument Minimum Reviewer Number |
NO | ||
CNMS_PRPSL (Oracle) INSTR MIN_REV_NBR |
NO | ||
EQUIP (Oracle) INSTR MIN_REV_NBR |
NO | ||
EXPRESS (Oracle) INSTR MIN_REV_NBR |
NO | ||
INSTR (Oracle) INSTR MIN_REV_NBR |
NO | ||
Instrument Logbook (Oracle) INSTR MIN_REV_NBR |
NO | ||
IPTSv5 (Oracle) INSTR MIN_REV_NBR |
NO | ||
PROC (Oracle) INSTR MIN_REV_NBR |
NO | ||
PRPSL (Oracle) INSTR MIN_REV_NBR |
NO | ||
PUBL (Oracle) INSTR MIN_REV_NBR |
NO | ||
SMPL (Oracle) INSTR MIN_REV_NBR |
NO | ||
XF_ADMIN (Oracle) INSTR MIN_REV_NBR |
NO |
MIN_REV_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIN_REV_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIN_REV_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIN_REV_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAX_REV_NBR |
Base Object | INSTR |
Attribute Name | Maximum Reviewer Number |
ColumnName | MAX_REV_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MAX_REV_NBR Column Properties |
Datatype | NUMBER(1, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MAX_REV_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
MAX_REV_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MAX_REV_NBR Security Types |
Name | Current Value |
MAX_REV_NBR Bound Attachments |
Name | Current Value |
MAX_REV_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
MAX_REV_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Maximum Reviewer Number |
NO | ||
Logical Instrument Maximum Reviewer Number |
NO | ||
Logical Instrument Maximum Reviewer Number |
NO | ||
CNMS_PRPSL (Oracle) INSTR MAX_REV_NBR |
NO | ||
EQUIP (Oracle) INSTR MAX_REV_NBR |
NO | ||
EXPRESS (Oracle) INSTR MAX_REV_NBR |
NO | ||
INSTR (Oracle) INSTR MAX_REV_NBR |
NO | ||
Instrument Logbook (Oracle) INSTR MAX_REV_NBR |
NO | ||
IPTSv5 (Oracle) INSTR MAX_REV_NBR |
NO | ||
PROC (Oracle) INSTR MAX_REV_NBR |
NO | ||
PRPSL (Oracle) INSTR MAX_REV_NBR |
NO | ||
PUBL (Oracle) INSTR MAX_REV_NBR |
NO | ||
SMPL (Oracle) INSTR MAX_REV_NBR |
NO | ||
XF_ADMIN (Oracle) INSTR MAX_REV_NBR |
NO |
MAX_REV_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAX_REV_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAX_REV_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAX_REV_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GRP_LEAD_BN |
Base Object | INSTR |
Attribute Name | Badge Number |
ColumnName | GRP_LEAD_BN |
Logical Rolename | Group Leader Badge Number |
RoleName | GRP_LEAD_BN |
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 Badge Number |
NO | ||
Logical Instrument Badge Number |
NO | ||
Logical Instrument Badge Number |
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 |