Operation Procedure Manual Identifier 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Operation Procedure Manual Identifier 
Logical Rolename   
ColumnName  OPER_PROC_MAN_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Operation Procedure Manual Identifier Logical Attribute Properties 
Logical Attribute Name  Operation Procedure Manual Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

Operation Procedure Manual Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Operation Procedure Manual Identifier Security Types 
Name  Current Value 

Operation Procedure Manual Identifier Bound Attachments 
Name  Current Value 

Operation Procedure Manual Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Procedure Manual Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Operation Procedure Manual Identifier 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
OPER_PROC_MAN_ID 
NO     

Operation Procedure Manual Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Procedure Manual Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Procedure Manual Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Procedure Manual Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Revision Number 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Revision Number 
Logical Rolename   
ColumnName  REV_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Revision Number Logical Attribute Properties 
Logical Attribute Name  Revision Number 
Datatype  NUMERIC(4, 0) 
Nullable  NO 

Revision Number Domain Restrictions 

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

Revision Number Bound Attachments 
Name  Current Value 

Revision Number Data Movement Rules 
Name  Type  Rule Text/Value 

Revision Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Revision Number 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
REV_NBR 
NO     

Revision Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Review Status Identifier 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Review Status Identifier 
Logical Rolename   
ColumnName  REVIEW_STAT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Review Status Identifier Logical Attribute Properties 
Logical Attribute Name  Review Status Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

Review Status Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Review Status Identifier Security Types 
Name  Current Value 

Review Status Identifier Bound Attachments 
Name  Current Value 

Review Status Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Review Status Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Review Status Identifier 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
REVIEW_STAT_ID 
NO     

Review Status Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Review Status Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Review Status Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Review Status Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Last Revision Date 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Last Revision Date 
Logical Rolename   
ColumnName  LAST_REVIS_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Last Revision Date Logical Attribute Properties 
Logical Attribute Name  Last Revision Date 
Datatype  DATE 
Nullable  NO 

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

Last Revision Date Security Types 
Name  Current Value 

Last Revision Date Bound Attachments 
Name  Current Value 

Last Revision Date Data Movement Rules 
Name  Type  Rule Text/Value 

Last Revision Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Last Revision Date 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
LAST_REVIS_DTE 
NO     

Last Revision Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Revision Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Revision Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Revision Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Last Review Date 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Last Review Date 
Logical Rolename   
ColumnName  LAST_REVIEW_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Last Review Date Logical Attribute Properties 
Logical Attribute Name  Last Review Date 
Datatype  DATE 
Nullable  NO 

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

Last Review Date Security Types 
Name  Current Value 

Last Review Date Bound Attachments 
Name  Current Value 

Last Review Date Data Movement Rules 
Name  Type  Rule Text/Value 

Last Review Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Last Review Date 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
LAST_REVIEW_DTE 
NO     

Last Review Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Review Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Last Review Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Last Review Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Next Review Date 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  Next Review Date 
Logical Rolename   
ColumnName  NEXT_REVIEW_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Next Review Date Logical Attribute Properties 
Logical Attribute Name  Next Review Date 
Datatype  DATE 
Nullable  NO 

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

Next Review Date Security Types 
Name  Current Value 

Next Review Date Bound Attachments 
Name  Current Value 

Next Review Date Data Movement Rules 
Name  Type  Rule Text/Value 

Next Review Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
Next Review Date 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
NEXT_REVIEW_DTE 
NO     

Next Review Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Next Review Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Next Review Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Next Review Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


File Name 
Base Entity  Operation Procedure Manual Revision 
Attribute Name  File Name 
Logical Rolename   
ColumnName  FILE_NM 
RoleName   
Domain  File Name 
Logical Only  NO 
Definition 
File Name: An external file system file name.  Often the external file name of data imported into the Rdb, such as EPICS .db files.
 
Note 
 

File Name Logical Attribute Properties 
Logical Attribute Name  File Name 
Datatype  VARCHAR(255) 
Nullable  NO 

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

File Name Security Types 
Name  Current Value 

File Name Bound Attachments 
Name  Current Value 

File Name Data Movement Rules 
Name  Type  Rule Text/Value 

File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Operation Procedure Manual Revision
File Name 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
FILE_NM 
NO     

File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Comment 
Base Entity  Operation Procedure Manual Revision 
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 Procedure Manual Revision
Comment 
NO     
OPER (Oracle)
OPER_PROC_MAN_REV
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