SHIFT_ACT_ID 
Base Object  SHIFT_ACT 
Attribute Name  Shift Activity Identifier 
ColumnName  SHIFT_ACT_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

SHIFT_ACT_ID Security Types 
Name  Current Value 

SHIFT_ACT_ID Bound Attachments 
Name  Current Value 

SHIFT_ACT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SHIFT_ACT_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Activity
Shift Activity Identifier 
NO     
OPER (Oracle)
SHIFT_ACT
SHIFT_ACT_ID 
NO     

SHIFT_ACT_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ACT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ACT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SHIFT_ACT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NM 
Base Object  SHIFT_ACT 
Attribute Name  Name 
ColumnName  NM 
Logical Rolename   
RoleName   
Domain  Name 
Physical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

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

NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  120 
Percent Null 

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

NM Security Types 
Name  Current Value 

NM Bound Attachments 
Name  Current Value 

NM Data Movement Rules 
Name  Type  Rule Text/Value 

NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Shift Activity
Name 
NO     
OPER (Oracle)
SHIFT_ACT
NM 
NO     

NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description