CTRL_AREA_ID 
Base Object  CTRL_AREA_SUBAREA 
Attribute Name  ControlArea Identifier 
ColumnName  CTRL_AREA_ID 
Logical Rolename   
RoleName  CTRL_AREA_ID 
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

CTRL_AREA_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CTRL_AREA_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

CTRL_AREA_ID Security Types 
Name  Current Value 

CTRL_AREA_ID Bound Attachments 
Name  Current Value 

CTRL_AREA_ID Data Movement Rules 
Name  Type  Rule Text/Value 

CTRL_AREA_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Subarea
ControlArea Identifier 
NO     
SMPL (Oracle)
CTRL_AREA_SUBAREA
CTRL_AREA_ID 
NO     

CTRL_AREA_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CTRL_AREA_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CTRL_AREA_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CTRL_AREA_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SUBAREA_ID 
Base Object  CTRL_AREA_SUBAREA 
Attribute Name  SubArea Identifier 
ColumnName  SUBAREA_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

SUBAREA_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SUBAREA_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

SUBAREA_ID Security Types 
Name  Current Value 

SUBAREA_ID Bound Attachments 
Name  Current Value 

SUBAREA_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SUBAREA_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Subarea
SubArea Identifier 
NO     
SMPL (Oracle)
CTRL_AREA_SUBAREA
SUBAREA_ID 
NO     

SUBAREA_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SUBAREA_NM 
Base Object  CTRL_AREA_SUBAREA 
Attribute Name  SubArea Name 
ColumnName  SUBAREA_NM 
Logical Rolename   
RoleName   
Domain  Name 
Physical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

SUBAREA_NM Column Properties 
Datatype  VARCHAR2(120) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SUBAREA_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  120 
Percent Null 

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

SUBAREA_NM Security Types 
Name  Current Value 

SUBAREA_NM Bound Attachments 
Name  Current Value 

SUBAREA_NM Data Movement Rules 
Name  Type  Rule Text/Value 

SUBAREA_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Subarea
SubArea Name 
NO     
SMPL (Oracle)
CTRL_AREA_SUBAREA
SUBAREA_NM 
NO     

SUBAREA_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBAREA_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description