Procedure Identifier 
Base Entity  Procedure 
Attribute Name  Procedure Identifier 
Logical Rolename   
ColumnName  PROC_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Procedure Identifier Logical Attribute Properties 
Logical Attribute Name  Procedure Identifier 
Datatype  VARCHAR(75) 
Nullable  NO 

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

Procedure Identifier Security Types 
Name  Current Value 

Procedure Identifier Bound Attachments 
Name  Current Value 

Procedure Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Procedure Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Procedure Identifier 
NO     
PROC (Oracle)
PROCEDURE
PROC_ID 
NO     

Procedure Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Procedure Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Procedure Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Procedure Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Title 
Base Entity  Procedure 
Attribute Name  Title 
Logical Rolename   
ColumnName  TITLE 
RoleName   
Domain  Title 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Title Security Types 
Name  Current Value 

Title Bound Attachments 
Name  Current Value 

Title Data Movement Rules 
Name  Type  Rule Text/Value 

Title Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Title 
NO     
PROC (Oracle)
PROCEDURE
TITLE 
NO     

Title Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Title Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Title Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Title Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Status Identifier 
Base Entity  Procedure 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Status Identifier Security Types 
Name  Current Value 

Status Identifier Bound Attachments 
Name  Current Value 

Status Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Status Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Status Identifier 
NO     
PROC (Oracle)
PROCEDURE
STAT_ID 
NO     

Status Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current Revision Number 
Base Entity  Procedure 
Attribute Name  Current Revision Number 
Logical Rolename   
ColumnName  CUR_REV_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Current Revision Number Domain Restrictions 

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

Current Revision Number Bound Attachments 
Name  Current Value 

Current Revision Number Data Movement Rules 
Name  Type  Rule Text/Value 

Current Revision Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Current Revision Number 
NO     
PROC (Oracle)
PROCEDURE
CUR_REV_NBR 
NO     

Current Revision Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Revision Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Revision Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Revision Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Revision Start Date 
Base Entity  Procedure 
Attribute Name  Revision Start Date 
Logical Rolename   
ColumnName  REV_STRT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Revision Start Date Logical Attribute Properties 
Logical Attribute Name  Revision Start Date 
Datatype  DATE 
Nullable  YES 

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

Revision Start Date Security Types 
Name  Current Value 

Revision Start Date Bound Attachments 
Name  Current Value 

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

Revision Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Revision Start Date 
NO     
PROC (Oracle)
PROCEDURE
REV_STRT_DTE 
NO     

Revision Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Scheduled Completion Date 
Base Entity  Procedure 
Attribute Name  Scheduled Completion Date 
Logical Rolename   
ColumnName  SCHED_CMPLT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Scheduled Completion Date Logical Attribute Properties 
Logical Attribute Name  Scheduled Completion Date 
Datatype  DATE 
Nullable  YES 

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

Scheduled Completion Date Security Types 
Name  Current Value 

Scheduled Completion Date Bound Attachments 
Name  Current Value 

Scheduled Completion Date Data Movement Rules 
Name  Type  Rule Text/Value 

Scheduled Completion Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Scheduled Completion Date 
NO     
PROC (Oracle)
PROCEDURE
SCHED_CMPLT_DTE 
NO     

Scheduled Completion Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Scheduled Completion Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Scheduled Completion Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Scheduled Completion Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Issue Date 
Base Entity  Procedure 
Attribute Name  Issue Date 
Logical Rolename   
ColumnName  ISSUE_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Issue Date Logical Attribute Properties 
Logical Attribute Name  Issue Date 
Datatype  DATE 
Nullable  YES 

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

Issue Date Security Types 
Name  Current Value 

Issue Date Bound Attachments 
Name  Current Value 

Issue Date Data Movement Rules 
Name  Type  Rule Text/Value 

Issue Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Issue Date 
NO     
PROC (Oracle)
PROCEDURE
ISSUE_DTE 
NO     

Issue Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Issue Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Issue Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Issue Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Author Badge Number 
Base Entity  Procedure 
Attribute Name  Author Badge Number 
Logical Rolename   
ColumnName  AUTHOR_BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

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

Author Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Author Badge Number Security Types 
Name  Current Value 

Author Badge Number Bound Attachments 
Name  Current Value 

Author Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Author Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Author Badge Number 
NO     
PROC (Oracle)
PROCEDURE
AUTHOR_BN 
NO     

Author Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Author Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sponsor Badge Number 
Base Entity  Procedure 
Attribute Name  Sponsor Badge Number 
Logical Rolename   
ColumnName  SPONSOR_BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

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

Sponsor Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sponsor Badge Number Security Types 
Name  Current Value 

Sponsor Badge Number Bound Attachments 
Name  Current Value 

Sponsor Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Sponsor Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Procedure
Sponsor Badge Number 
NO     
PROC (Oracle)
PROCEDURE
SPONSOR_BN 
NO     

Sponsor Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sponsor Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sponsor Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sponsor Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Comment 
Base Entity  Procedure 
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
Procedure
Comment 
NO     
PROC (Oracle)
PROCEDURE
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