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

ACT_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ACT_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

ACT_ID Security Types 
Name  Current Value 

ACT_ID Bound Attachments 
Name  Current Value 

ACT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ACT_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Activity
Activity Identifier 
NO     
SMPL (Oracle)
SMPL_ACT
ACT_ID 
NO     

ACT_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DESCR 
Base Object  SMPL_ACT 
Attribute Name  Description 
ColumnName  DESCR 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

DESCR Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

DESCR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Activity
Description 
NO     
SMPL (Oracle)
SMPL_ACT
DESCR 
NO     

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description