Current State Date 
Base Entity  Operation State 
Attribute Name  Current State Date 
Logical Rolename   
ColumnName  CUR_STATE_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

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

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

Current State Date Security Types 
Name  Current Value 

Current State Date Bound Attachments 
Name  Current Value 

Current State Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current State Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation State
Current State Date 
NO     
OPER (Oracle)
OPER_STATE
CUR_STATE_DTE 
NO     

Current State Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current State Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current State Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current State Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Activity Identifier 
Base Entity  Operation State 
Attribute Name  Activity Identifier 
Logical Rolename   
ColumnName  ACT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Period Identifier: Abbreviated identifier given to a run cycle period.
 
Note 
 

Activity Identifier Logical Attribute Properties 
Logical Attribute Name  Activity Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

Activity Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Activity Identifier Security Types 
Name  Current Value 

Activity Identifier Bound Attachments 
Name  Current Value 

Activity Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Activity Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation State
Activity Identifier 
NO     
OPER (Oracle)
OPER_STATE
ACT_ID 
NO     

Activity Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Operation Status Identifer 
Base Entity  Operation State 
Attribute Name  Operation Status Identifer 
Logical Rolename   
ColumnName  OPER_STAT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Operation Status Identifer Logical Attribute Properties 
Logical Attribute Name  Operation Status Identifer 
Datatype  VARCHAR(100) 
Nullable  NO 

Operation Status Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Operation Status Identifer Security Types 
Name  Current Value 

Operation Status Identifer Bound Attachments 
Name  Current Value 

Operation Status Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Status Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation State
Operation Status Identifer 
NO     
OPER (Oracle)
OPER_STATE
OPER_STAT_ID 
NO     

Operation Status Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Status Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Status Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Status Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Comment 
Base Entity  Operation State 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

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

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation State
Comment 
NO     
OPER (Oracle)
OPER_STATE
CMNT 
NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Estimated Restart Date 
Base Entity  Operation State 
Attribute Name  Estimated Restart Date 
Logical Rolename   
ColumnName  EST_RESTART_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Estimated Restart Date Logical Attribute Properties 
Logical Attribute Name  Estimated Restart Date 
Datatype  DATE 
Nullable  YES 

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

Estimated Restart Date Security Types 
Name  Current Value 

Estimated Restart Date Bound Attachments 
Name  Current Value 

Estimated Restart Date Data Movement Rules 
Name  Type  Rule Text/Value 

Estimated Restart Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation State
Estimated Restart Date 
NO     
OPER (Oracle)
OPER_STATE
EST_RESTART_DTE 
NO     

Estimated Restart Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Estimated Restart Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Estimated Restart Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Estimated Restart Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description