ACT_ID 
Base Object  EXPRESS_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
Express Activity
Activity Identifier 
NO     
EXPRESS (Oracle)
EXPRESS_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 


ACT_USE_CD 
Base Object  EXPRESS_ACT 
Attribute Name  Activity Usage Code 
ColumnName  ACT_USE_CD 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Activity Usage Code: Activity applies to: G - Global (Available to alll scheduling activities), L - Laboratory, R - Resource, S - Schedule, 
 
Note 
 

ACT_USE_CD Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ACT_USE_CD Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ACT_USE_CD Domain Restrictions 
CheckConstraint  ACT_USE_CD IN ('G','L','R','S') 
Check Constraint Name  CK_EXPRESS_ACT_USE_CD 
Bound Rule   
Declared Default   
Bound Default   

ACT_USE_CD Security Types 
Name  Current Value 

ACT_USE_CD Bound Attachments 
Name  Current Value 

ACT_USE_CD Data Movement Rules 
Name  Type  Rule Text/Value 

ACT_USE_CD Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Express Activity
Activity Usage Code 
NO     
EXPRESS (Oracle)
EXPRESS_ACT
ACT_USE_CD 
NO     

ACT_USE_CD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_USE_CD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_USE_CD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACT_USE_CD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DESCR 
Base Object  EXPRESS_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
Express Activity
Description 
NO     
EXPRESS (Oracle)
EXPRESS_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