Instrument Identifier: Abbreviated identier for the instrument.

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

Name: A long description name usually accompanied by an abbreviated code.

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

Description: Often used in validation tables accompanying an abbreviated identifer.

INSTR_DESCR Column Properties

Datatype	VARCHAR2(255)
Nullable	YES
Not Null Constraint
Character Set	BYTE
Encrypted	NO
Encryption Algorithm	--
SALT	--

INSTR_DESCR Growth Metrics

COLUMN METRIC	COLUMN METRIC VALUE
Average Width	255
Percent Null	0

INSTR_DESCR Domain Restrictions

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

INSTR_DESCR Security Types

Name	Current Value

INSTR_DESCR Bound Attachments

Name	Current Value

INSTR_DESCR Data Movement Rules

Name

Type

Rule Text/Value

INSTR_DESCR Where Used

Mapped Object	Is User Defined?	Description	Bound Attachments
Logical Inst Instrument Description	NO
Logical Instrument Instrument Description	NO
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

INSTR_DESCR Direct Source Mappings

Columns

Transformation Logic

Transformation Description

INSTR_DESCR Secondary Source Mappings

Columns

Transformation Logic

Transformation Description

INSTR_DESCR Direct Target Mappings

Columns

Transformation Logic

Transformation Description

INSTR_DESCR Secondary Target Mappings

Columns

Transformation Logic

Transformation Description

Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.

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

Group Identifier: Abbreviated identier used to allow instruments to be group into logical associations..

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 Order: Numerical sort order to control display order of instruments in charts and reports.

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

Supplemental Proposal Call Indicator: Indicates that this instrument will participate in a supplemental proposal call.

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

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.

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

File Name: An external file system file name.  Often the external file name of data imported into the Rdb, such as EPICS .db files.

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