Practice Dictionary CLS

The dictionary definition and loading process is complex, and varies depending on the dictionary and the needs of the company. You can use CLS as a practice dictionary. All the control, data, and SQL files you need are provided in a zip file on the My Oracle Support website. You can use these files as examples when you create your own dictionaries.

For more information, see:

• CLS Structure Diagram
  
• CLS Level Definitions
  
• CLS Level Relations Definitions
  

CLS Structure Diagram

The CLS structure diagram in Figure A-1 corresponds to the Level Definitions in CLS Level Definitions and Level Relations Definitions in CLS Level Relations Definitions.

Figure A-1 Figure A-1 CLS Structure Diagram

CLS Level Definitions

See Defining the Dictionary Levels for instructions on defining dictionary levels using the Define Dictionaries window in TMS.

Table A-1 CLS Level Definitions

Short Name	Name	Classification Level?	Report Value?	Level Order	Level Type	Term Unique?	Group Short Name
ATC	Anatomical-Therapeutic- Chemical Classification Group				Group Level
ATC1	ATC 1		X		Level		ATC
ATC2	ATC 2		X		Level		ATC
ATC3	ATC 3		X		Level		ATC
ATC4	ATC 4		X		Level		ATC
VTC	Verbatim Term Classification Group	X			Group Level	X
PN	Preferred Name		X		Level		VTC
SYN	Synonym		X	1	Level		VTC
BNA	Drug Constituents			2	Level
DDSRC	Source of Drug			1	Level
MAN	Manufacturers			2	Level

CLS Level Relations Definitions

See Defining Relations Between Levels (Strong Dictionaries Only) for instructions on defining Level Relations in the Define Dictionaries window.

Table A-2 CLS Level Relations Definitions

Setting	Parent Level	Child Level
Level Name	Anatomical-Therapeutic-Chemical- Classification Group	ATC 1
Relation Type: Top Sublevel
Short Name	ATC	ATC1
Mandatory?
Many Cardinality?
Primary Link?		n/a
Derivable?		n/a
Level Name	ATC 1	ATC 2
Relation Type: Level
Short Name	ATC1	ATC2
Mandatory?		X
Many Cardinality?		X
Primary Link?		n/a
Derivable?	X	n/a
Level Name	ATC 2	ATC 3
Relation Type: Level
Short Name	ATC2	ATC3
Mandatory?		X
Many Cardinality?		X
Primary Link?		n/a
Derivable?	X	n/a
Level Name	ATC 3	ATC 4
Relation Type: Level
Short Name	ATC3	ATC4
Mandatory?		X
Many Cardinality?		X
Primary Link?		n/a
Derivable?	X	n/a
Level Name	Anat.-Therap.-Chem.-Classification Group	Preferred Name
Relation Type: Level
Short Name	ATC	PN
Mandatory?
Many Cardinality?	X	X
Primary Link?	X	n/a
Derivable?	X	n/a
Level Name	Preferred Name	Synonym
Relation Type: Level
Short Name	PN	SYN
Mandatory?		X
Many Cardinality?		X
Primary Link?		n/a
Derivable?	X	n/a
Level Name	Preferred Name	Drug Constituents
Relation Type: Level
Short Name	PN	BNA
Mandatory?
Many Cardinality?	X	X
Primary Link?		n/a
Derivable?		n/a
Level Name	Drug Constituents	Source of Drug
Relation Type: Level
Short Name	BNA	DDSRC
Mandatory?
Many Cardinality?	X
Primary Link?		n/a
Derivable?		n/a
Level Name	Verbatim Term Classification Group	Preferred Name
Relation Type: Top Sublevel
Short Name	VTC	PN
Mandatory?
Many Cardinality?
Primary Link?		n/a
Derivable?		n/a
Level Name	Verbatim Term Classification Group	Manufacturers
Relation Type: Level
Short Name	VTC	MAN
Mandatory?
Many Cardinality?	X
Primary Link?		n/a
Derivable?		n/a
Level Name	Verbatim Term Classification Group	Source of Drug
Relation Type: Level
Short Name	VTC	DDSRC
Mandatory?
Many Cardinality?	X
Primary Link?		n/a
Derivable?		n/a