Device Identifer 
Base Entity  MPS BLM Parameter 
Attribute Name  Device Identifer 
Logical Rolename   
ColumnName  DVC_ID 
RoleName   
Domain  Device Id 
Logical Only  NO 
Definition 
The unique identifier for the device.  It is represented in the form of a bar code.  The identifier consists of the concatenation of the following fields:  System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
 
Note 
 

Device Identifer Logical Attribute Properties 
Logical Attribute Name  Device Identifer 
Datatype  VARCHAR(50) 
Nullable  NO 

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

Device Identifer Security Types 
Name  Current Value 

Device Identifer Bound Attachments 
Name  Current Value 

Device Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Device Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS BLM Parameter
Device Identifer 
NO     
MPS (Oracle)
MPS_BLM_PARAM
DVC_ID 
NO     

Device Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Appr Dte 
Base Entity  MPS BLM Parameter 
Attribute Name  Appr Dte 
Logical Rolename   
ColumnName  Appr Dte 
RoleName   
Domain   
Logical Only  NO 
Definition 
Approval Date
 
Note 
 

Appr Dte Logical Attribute Properties 
Logical Attribute Name  Appr Dte 
Datatype  DATE 
Nullable  NO 

Appr Dte Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   
Appr Dte Security Types 
Name  Current Value 

Appr Dte Bound Attachments 
Name  Current Value 

Appr Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Appr Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS BLM Parameter
Appr Dte 
NO     
MPS (Oracle)
MPS_BLM_PARAM
APPR_DTE 
NO     

Appr Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Appr Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Appr Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Appr Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Channel Nbr 
Base Entity  MPS BLM Parameter 
Attribute Name  Channel Nbr 
Logical Rolename   
ColumnName  Channel Nbr 
RoleName   
Domain   
Logical Only  NO 
Definition 
Channel Number
 
Note 
 

Channel Nbr Logical Attribute Properties 
Logical Attribute Name  Channel Nbr 
Datatype  NUMERIC(3, 0) 
Nullable  NO 

Channel Nbr Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Channel Nbr Security Types 
Name  Current Value 

Channel Nbr Bound Attachments 
Name  Current Value 

Channel Nbr Data Movement Rules 
Name  Type  Rule Text/Value 

Channel Nbr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS BLM Parameter
Channel Nbr 
NO     
MPS (Oracle)
MPS_BLM_PARAM
CHANNEL_NBR 
NO     

Channel Nbr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Channel Nbr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Channel Nbr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Channel Nbr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Param Nm 
Base Entity  MPS BLM Parameter 
Attribute Name  Param Nm 
Logical Rolename   
ColumnName  PARAM_NM 
RoleName   
Domain  Param Nm 
Logical Only  NO 
Definition 
Parameter Name: The name assigned to a parameter which in turn will have a corresponding value.
 
Note 
 

Param Nm Logical Attribute Properties 
Logical Attribute Name  Param Nm 
Datatype  VARCHAR(50) 
Nullable  NO 

Param Nm Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Param Nm Security Types 
Name  Current Value 

Param Nm Bound Attachments 
Name  Current Value 

Param Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Param Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS BLM Parameter
Param Nm 
NO     
MPS (Oracle)
MPS_BLM_PARAM
PARAM_NM 
NO     

Param Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Param Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Param Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Param Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Param Val 
Base Entity  MPS BLM Parameter 
Attribute Name  Param Val 
Logical Rolename   
ColumnName  PARAM_VAL 
RoleName   
Domain  Param Val 
Logical Only  NO 
Definition 
Parameter Value: The value assigned to a corresponding value.
 
Note 
 

Param Val Logical Attribute Properties 
Logical Attribute Name  Param Val 
Datatype  VARCHAR(50) 
Nullable  NO 

Param Val Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Param Val Security Types 
Name  Current Value 

Param Val Bound Attachments 
Name  Current Value 

Param Val Data Movement Rules 
Name  Type  Rule Text/Value 

Param Val Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS BLM Parameter
Param Val 
NO     
MPS (Oracle)
MPS_BLM_PARAM
PARAM_VAL 
NO     

Param Val Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Param Val Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Param Val Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Param Val Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description