ControlArea Identifier 
Base Entity  Control Area Inventory 
Attribute Name  ControlArea Identifier 
Logical Rolename   
ColumnName  CTRL_AREA_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

ControlArea Identifier Logical Attribute Properties 
Logical Attribute Name  ControlArea Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

ControlArea Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ControlArea Identifier Security Types 
Name  Current Value 

ControlArea Identifier Bound Attachments 
Name  Current Value 

ControlArea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

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

ControlArea Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current Date 
Base Entity  Control Area Inventory 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Current Date Logical Attribute Properties 
Logical Attribute Name  Current Date 
Datatype  DATE 
Nullable  NO 

Current Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Inventory
Current Date 
NO     
SMPL (Oracle)
CTRL_AREA_INVT
CUR_DTE 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Inventory Date 
Base Entity  Control Area Inventory 
Attribute Name  Inventory Date 
Logical Rolename   
ColumnName  INVT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Inventory Date Logical Attribute Properties 
Logical Attribute Name  Inventory Date 
Datatype  DATE 
Nullable  NO 

Inventory Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Inventory Date Security Types 
Name  Current Value 

Inventory Date Bound Attachments 
Name  Current Value 

Inventory Date Data Movement Rules 
Name  Type  Rule Text/Value 

Inventory Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Inventory
Inventory Date 
NO     
SMPL (Oracle)
CTRL_AREA_INVT
INVT_DTE 
NO     

Inventory Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Badge Number 
Base Entity  Control Area Inventory 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Badge Number Domain Restrictions 

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

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Control Area Inventory
Badge Number 
NO     
SMPL (Oracle)
CTRL_AREA_INVT
BN 
NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description