Equip Cat Id |
Base Entity | SCORE Snapshot Group |
Attribute Name | Equip Cat Id |
Logical Rolename | |
ColumnName | EQUIP_CAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Equip Cat Id Logical Attribute Properties |
Logical Attribute Name | Equip Cat Id |
Datatype | VARCHAR(10) |
Nullable | NO |
Equip Cat Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Equip Cat Id Security Types |
Name | Current Value |
Equip Cat Id Bound Attachments |
Name | Current Value |
Equip Cat Id Data Movement Rules |
Name | Type | Rule Text/Value |
Equip Cat Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Group Equip Cat Id |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_GRP EQUIP_CAT_ID |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_GRP EQUIP_CAT_ID |
NO |
Equip Cat Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Cat Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Cat Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Cat Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte |
Base Entity | SCORE Snapshot Group |
Attribute Name | Mod Dte |
Logical Rolename | |
ColumnName | MOD_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Mod Dte Logical Attribute Properties |
Logical Attribute Name | Mod Dte |
Datatype | DATE |
Nullable | NO |
Mod Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Mod Dte Security Types |
Name | Current Value |
Mod Dte Bound Attachments |
Name | Current Value |
Mod Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Mod Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Group Mod Dte |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_GRP MOD_DTE |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_GRP MOD_DTE |
NO |
Mod Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | SCORE Snapshot Group |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
Nullable | YES |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Group Description |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_GRP DESCR |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_GRP DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Userid |
Base Entity | SCORE Snapshot Group |
Attribute Name | Userid |
Logical Rolename | |
ColumnName | USERID |
RoleName | |
Domain | Userid |
Logical Only | NO |
Definition | |
Note |
Userid Logical Attribute Properties |
Logical Attribute Name | Userid |
Datatype | VARCHAR(64) |
Nullable | NO |
Userid Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Userid Security Types |
Name | Current Value |
Userid Bound Attachments |
Name | Current Value |
Userid Data Movement Rules |
Name | Type | Rule Text/Value |
Userid Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Group Userid |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_GRP USERID |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_GRP USERID |
NO |
Userid Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Userid Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Userid Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Userid Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pri Save Set Ind |
Base Entity | SCORE Snapshot Group |
Attribute Name | Pri Save Set Ind |
Logical Rolename | |
ColumnName | PRI_SAVE_SET_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Primary Save Set Indicator: Indicates that the SCORE set is Golden, the best one for operating efficiency. |
Note |
Pri Save Set Ind Logical Attribute Properties |
Logical Attribute Name | Pri Save Set Ind |
Datatype | CHAR(1) |
Nullable | NO |
Pri Save Set Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Pri Save Set Ind Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Pri Save Set Ind Security Types |
Name | Current Value |
Pri Save Set Ind Bound Attachments |
Name | Current Value |
Pri Save Set Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Pri Save Set Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Group Pri Save Set Ind |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_GRP PRI_SAVE_SET_IND |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_GRP PRI_SAVE_SET_IND |
NO |
Pri Save Set Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pri Save Set Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pri Save Set Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pri Save Set Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |