Instrument Identifier 
Base Entity  Instrument 
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
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     

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 

Instrument Name 
Base Entity  Instrument 
Attribute Name  Instrument Name 
Logical Rolename   
ColumnName  INSTR_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Instrument Name Logical Attribute Properties 
Logical Attribute Name  Instrument Name 
Datatype  VARCHAR(120) 
Nullable  NO 

Instrument Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Instrument Name Security Types 
Name  Current Value 

Instrument Name Bound Attachments 
Name  Current Value 

Instrument Name Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Instrument Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Description 
Base Entity  Instrument 
Attribute Name  Instrument Description 
Logical Rolename   
ColumnName  INSTR_DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Instrument Description Logical Attribute Properties 
Logical Attribute Name  Instrument Description 
Datatype  VARCHAR(255) 
Nullable  YES 

Instrument Description Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Instrument Description Security Types 
Name  Current Value 

Instrument Description Bound Attachments 
Name  Current Value 

Instrument Description Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Instrument
Instrument Description 		 NO     
CNMS_PRPSL (Oracle)
INSTR
INSTR_DESCR 		 NO     
EQUIP (Oracle)
INSTR
INSTR_DESCR 		 NO     
EXPRESS (Oracle)
INSTR
INSTR_DESCR 		 NO     
INSTR (Oracle)
INSTR
INSTR_DESCR 		 NO     
Instrument Logbook (Oracle)
INSTR
INSTR_DESCR 		 NO     
IPTSv5 (Oracle)
INSTR
INSTR_DESCR 		 NO     
PROC (Oracle)
INSTR
INSTR_DESCR 		 NO     
PRPSL (Oracle)
INSTR
INSTR_DESCR 		 NO     
PUBL (Oracle)
INSTR
INSTR_DESCR 		 NO     
SMPL (Oracle)
INSTR
INSTR_DESCR 		 NO     
XF_ADMIN (Oracle)
INSTR
INSTR_DESCR 		 NO     

Instrument Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier 
Base Entity  Instrument 
Attribute Name  Facility Identifier 
Logical Rolename   
ColumnName  FACIL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.
 
Note 
 

Facility Identifier Logical Attribute Properties 
Logical Attribute Name  Facility Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Facility Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Facility Identifier Security Types 
Name  Current Value 

Facility Identifier Bound Attachments 
Name  Current Value 

Facility Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Facility Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier 
Base Entity  Instrument 
Attribute Name  Group Identifier 
Logical Rolename   
ColumnName  GRP_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Group Identifier: Abbreviated identier used to allow instruments to be group into logical associations..
 
Note 
 

Group Identifier Logical Attribute Properties 
Logical Attribute Name  Group Identifier 
Datatype  VARCHAR(20) 
Nullable  YES 

Group Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Group Identifier Security Types 
Name  Current Value 

Group Identifier Bound Attachments 
Name  Current Value 

Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Group Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sort Order 
Base Entity  Instrument 
Attribute Name  Sort Order 
Logical Rolename   
ColumnName  SORT_ORD 
RoleName   
Domain   
Logical Only  NO 
Definition  
Sort Order: Numerical sort order to control display order of instruments in charts and reports.
 
Note 
 

Sort Order Logical Attribute Properties 
Logical Attribute Name  Sort Order 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Sort Order Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sort Order Security Types 
Name  Current Value 

Sort Order Bound Attachments 
Name  Current Value 

Sort Order Data Movement Rules 
Name  Type  Rule Text/Value 

Sort Order Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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 Order Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sort Order Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sort Order Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sort Order Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Display Indicator 
Base Entity  Instrument 
Attribute Name  Display Indicator 
Logical Rolename   
ColumnName  DISP_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Display Indicator Logical Attribute Properties 
Logical Attribute Name  Display Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Display Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Display Indicator 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 

Display Indicator Security Types 
Name  Current Value 

Display Indicator Bound Attachments 
Name  Current Value 

Display Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Display Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Display Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Display Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Display Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Display Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Single Crystal Alignment Indicator 
Base Entity  Instrument 
Attribute Name  Single Crystal Alignment Indicator 
Logical Rolename   
ColumnName  SNGL_CRYST_ALIGN_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Single Crystal Alignment Indicator Logical Attribute Properties 
Logical Attribute Name  Single Crystal Alignment Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Single Crystal Alignment Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Single Crystal Alignment Indicator 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 

Single Crystal Alignment Indicator Security Types 
Name  Current Value 

Single Crystal Alignment Indicator Bound Attachments 
Name  Current Value 

Single Crystal Alignment Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Single Crystal Alignment Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Single Crystal Alignment Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Single Crystal Alignment Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Single Crystal Alignment Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Single Crystal Alignment Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Proposal Call Indicator 
Base Entity  Instrument 
Attribute Name  Supplemental Proposal Call Indicator 
Logical Rolename   
ColumnName  SUP_PRPSL_CALL_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Supplemental Proposal Call Indicator: Indicates that this instrument will participate in a supplemental proposal call.
 
Note 
 

Supplemental Proposal Call Indicator Logical Attribute Properties 
Logical Attribute Name  Supplemental Proposal Call Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Supplemental Proposal Call Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Supplemental Proposal Call Indicator 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 

Supplemental Proposal Call Indicator Security Types 
Name  Current Value 

Supplemental Proposal Call Indicator Bound Attachments 
Name  Current Value 

Supplemental Proposal Call Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Supplemental Proposal Call Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Supplemental Proposal Call Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Proposal Call Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Proposal Call Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Proposal Call Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Auto-Close Indicator 
Base Entity  Instrument 
Attribute Name  Auto-Close Indicator 
Logical Rolename   
ColumnName  AUTO_CLOSE_IND 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Auto-Close Indicator Logical Attribute Properties 
Logical Attribute Name  Auto-Close Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Auto-Close Indicator Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   
Auto-Close Indicator Security Types 
Name  Current Value 

Auto-Close Indicator Bound Attachments 
Name  Current Value 

Auto-Close Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Auto-Close Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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 Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Auto-Close Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Auto-Close Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Auto-Close Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Template 
Base Entity  Instrument 
Attribute Name  Statement of Research Template 
Logical Rolename   
ColumnName  SOR_TMPL 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Statement of Research Template Logical Attribute Properties 
Logical Attribute Name  Statement of Research Template 
Datatype  VARBINARY/BLOB(50) 
Nullable  YES 

Statement of Research Template Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Statement of Research Template Security Types 
Name  Current Value 

Statement of Research Template Bound Attachments 
Name  Current Value 

Statement of Research Template Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research Template Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Statement of Research Template Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Template Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Template Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Template Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type 
Base Entity  Instrument 
Attribute Name  Statement of Research MIME Type 
Logical Rolename   
ColumnName  SOR_MIME_TYPE 
RoleName   
Domain  MIME Type 
Logical Only  NO 
Definition  
MIME Type: Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support:



    * text in character sets other than US-ASCII;

    * non-text attachments;

    * message bodies with multiple parts; and

    * header information in non-ASCII character sets.



MIME's use, however, has grown beyond describing the content of e-mail to describing content type in general.
 
Note 
 

Statement of Research MIME Type Logical Attribute Properties 
Logical Attribute Name  Statement of Research MIME Type 
Datatype  VARCHAR(255) 
Nullable  YES 

Statement of Research MIME Type Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Statement of Research MIME Type Security Types 
Name  Current Value 

Statement of Research MIME Type Bound Attachments 
Name  Current Value 

Statement of Research MIME Type Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research MIME Type Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Statement of Research MIME Type Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name 
Base Entity  Instrument 
Attribute Name  Statement of Research File Name 
Logical Rolename   
ColumnName  SOR_FILE_NM 
RoleName   
Domain  File Name 
Logical 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 
 

Statement of Research File Name Logical Attribute Properties 
Logical Attribute Name  Statement of Research File Name 
Datatype  VARCHAR(255) 
Nullable  YES 

Statement of Research File Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Statement of Research File Name Security Types 
Name  Current Value 

Statement of Research File Name Bound Attachments 
Name  Current Value 

Statement of Research File Name Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Statement of Research File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Minimum Reviewer Number 
Base Entity  Instrument 
Attribute Name  Minimum Reviewer Number 
Logical Rolename   
ColumnName  MIN_REV_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Minimum Reviewer Number Logical Attribute Properties 
Logical Attribute Name  Minimum Reviewer Number 
Datatype  NUMERIC(1, 0) 
Nullable  YES 

Minimum Reviewer Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Minimum Reviewer Number Security Types 
Name  Current Value 

Minimum Reviewer Number Bound Attachments 
Name  Current Value 

Minimum Reviewer Number Data Movement Rules 
Name  Type  Rule Text/Value 

Minimum Reviewer Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Minimum Reviewer Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Minimum Reviewer Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Minimum Reviewer Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Minimum Reviewer Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Reviewer Number 
Base Entity  Instrument 
Attribute Name  Maximum Reviewer Number 
Logical Rolename   
ColumnName  MAX_REV_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Maximum Reviewer Number Logical Attribute Properties 
Logical Attribute Name  Maximum Reviewer Number 
Datatype  NUMERIC(1, 0) 
Nullable  YES 

Maximum Reviewer Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Maximum Reviewer Number Security Types 
Name  Current Value 

Maximum Reviewer Number Bound Attachments 
Name  Current Value 

Maximum Reviewer Number Data Movement Rules 
Name  Type  Rule Text/Value 

Maximum Reviewer Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Maximum Reviewer Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Reviewer Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Reviewer Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Reviewer Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Leader Badge Number 
Base Entity  Instrument 
Attribute Name  Badge Number 
Logical Rolename  Group Leader Badge Number 
ColumnName  GRP_LEAD_BN 
RoleName  GRP_LEAD_BN 
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Group Leader Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Group Leader Badge Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Group Leader Badge Number Security Types 
Name  Current Value 

Group Leader Badge Number Bound Attachments 
Name  Current Value 

Group Leader Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Group Leader Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
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     

Group Leader Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Leader Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Leader Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Leader Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description