Equip Id 
Base Entity  Equipment Status 
Attribute Name  Equip Id 
Logical Rolename   
ColumnName  Equip Id 
RoleName   
Domain  Asset Identifier 
Logical Only  NO 
Definition 
Equipment Identifier: The unique identifier for the equipment.
 
Note 
 

Equip Id Logical Attribute Properties 
Logical Attribute Name  Equip Id 
Datatype  VARCHAR(30) 
Nullable  NO 

Equip Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Equip Id Security Types 
Name  Current Value 

Equip Id Bound Attachments 
Name  Current Value 

Equip Id Data Movement Rules 
Name  Type  Rule Text/Value 

Equip Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Status
Equip Id 
NO     

Equip Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Stat Dte 
Base Entity  Equipment Status 
Attribute Name  Stat Dte 
Logical Rolename   
ColumnName  Stat Dte 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Status Date: The date when the equipment changed status.
 
Note 
 

Stat Dte Logical Attribute Properties 
Logical Attribute Name  Stat Dte 
Datatype  DATE 
Nullable  NO 

Stat Dte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Stat Dte Security Types 
Name  Current Value 

Stat Dte Bound Attachments 
Name  Current Value 

Stat Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Stat Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Status
Stat Dte 
NO     

Stat Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Stat Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Stat Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Stat Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Equip Stat Id 
Base Entity  Equipment Status 
Attribute Name  Equip Stat Id 
Logical Rolename   
ColumnName  Equip Stat Id 
RoleName   
Domain   
Logical Only  NO 
Definition 
Equipment Status Code: The unique identifier for Equipment Status.
 
Note 
 

Equip Stat Id Logical Attribute Properties 
Logical Attribute Name  Equip Stat Id 
Datatype  VARCHAR(30) 
Nullable  NO 

Equip Stat Id Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Equip Stat Id Security Types 
Name  Current Value 

Equip Stat Id Bound Attachments 
Name  Current Value 

Equip Stat Id Data Movement Rules 
Name  Type  Rule Text/Value 

Equip Stat Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Status
Equip Stat Id 
NO     

Equip Stat Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Stat Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Stat Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Stat Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modify Date 
Base Entity  Equipment Status 
Attribute Name  Modify Date 
Logical Rolename   
ColumnName  MOD_DATE 
RoleName   
Domain  Modify Date 
Logical Only  NO 
Definition 
Modify Date: The date and time when the Equipment Status record was modified.
 
Note 
 

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

Modify Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modify Date Security Types 
Name  Current Value 

Modify Date Bound Attachments 
Name  Current Value 

Modify Date Data Movement Rules 
Name  Type  Rule Text/Value 

Modify Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Status
Modify Date 
NO     

Modify Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Mod By Uid 
Base Entity  Equipment Status 
Attribute Name  Mod By Uid 
Logical Rolename   
ColumnName  Mod By Uid 
RoleName   
Domain  Userid 
Logical Only  NO 
Definition 
Modify By Userid: The person who last modified the Equipment Status record
 
Note 
 

Mod By Uid Logical Attribute Properties 
Logical Attribute Name  Mod By Uid 
Datatype  VARCHAR(64) 
Nullable  NO 

Mod By Uid Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Mod By Uid Security Types 
Name  Current Value 

Mod By Uid Bound Attachments 
Name  Current Value 

Mod By Uid Data Movement Rules 
Name  Type  Rule Text/Value 

Mod By Uid Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Status
Mod By Uid 
NO     

Mod By Uid Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Mod By Uid Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Mod By Uid Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Mod By Uid Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description