Proposal Group Identifier 
Base Entity  Proposal Group 
Attribute Name  Proposal Group Identifier 
Logical Rolename   
ColumnName  PRPSL_GRP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Proposal Group Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Group Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Proposal Group Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Proposal Group Identifier Security Types 
Name  Current Value 

Proposal Group Identifier Bound Attachments 
Name  Current Value 

Proposal Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Group Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Group
Proposal Group Identifier 
NO     
EXPRESS (Oracle)
PRPSL_GRP
PRPSL_GRP_ID 
NO     

Proposal Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Proposal Group Name 
Base Entity  Proposal Group 
Attribute Name  Proposal Group Name 
Logical Rolename   
ColumnName  PRPSL_GRP_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Proposal Group Name Logical Attribute Properties 
Logical Attribute Name  Proposal Group Name 
Datatype  VARCHAR(120) 
Nullable  YES 

Proposal Group Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Proposal Group Name Security Types 
Name  Current Value 

Proposal Group Name Bound Attachments 
Name  Current Value 

Proposal Group Name Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Group Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Group
Proposal Group Name 
NO     
EXPRESS (Oracle)
PRPSL_GRP
PRPSL_GRP_NM 
NO     

Proposal Group Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Group Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Badge Number 
Base Entity  Proposal Group 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Badge Number Security Types 
Name  Current Value 

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Group
Badge Number 
NO     
EXPRESS (Oracle)
PRPSL_GRP
BN 
NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Active Indicator 
Base Entity  Proposal Group 
Attribute Name  Active Indicator 
Logical Rolename   
ColumnName  ACTIVE_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Active Indicator Logical Attribute Properties 
Logical Attribute Name  Active Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Active Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Active Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Active Indicator Security Types 
Name  Current Value 

Active Indicator Bound Attachments 
Name  Current Value 

Active Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Active Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Group
Active Indicator 
NO     
EXPRESS (Oracle)
PRPSL_GRP
ACTIVE_IND 
NO     

Active Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Active Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Active Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Active Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description