Publication Identifer 
Base Entity  Publication Log 
Attribute Name  Publication Identifer 
Logical Rolename   
ColumnName  PUBL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Publication Identifer Logical Attribute Properties 
Logical Attribute Name  Publication Identifer 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Publication Identifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Publication Identifer Security Types 
Name  Current Value 

Publication Identifer Bound Attachments 
Name  Current Value 

Publication Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Publication Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Log
Publication Identifer 
NO     
PUBL (Oracle)
PUBL_LOG
PUBL_ID 
NO     

Publication Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Activity Identifier 
Base Entity  Publication Log 
Attribute Name  Activity Identifier 
Logical Rolename   
ColumnName  ACT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal.
 
Note 
 

Activity Identifier Logical Attribute Properties 
Logical Attribute Name  Activity Identifier 
Datatype  VARCHAR(10) 
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
Publication Log
Activity Identifier 
NO     
PUBL (Oracle)
PUBL_LOG
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 


Current Date 
Base Entity  Publication Log 
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
Publication Log
Current Date 
NO     
PUBL (Oracle)
PUBL_LOG
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 


Mod By Uid 
Base Entity  Publication Log 
Attribute Name  Mod By Uid 
Logical Rolename   
ColumnName  MOD_BY_UID 
RoleName   
Domain  Mod By Uid 
Logical Only  NO 
Definition 
Modified by Userid:  The database userid of the person who inserted or update a record in the table.
 
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
Publication Log
Mod By Uid 
NO     
PUBL (Oracle)
PUBL_LOG
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 


Comment 
Base Entity  Publication Log 
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
Publication Log
Comment 
NO     
PUBL (Oracle)
PUBL_LOG
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