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 |