EQUIP_CAT_ID |
Base Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | Equip Cat Id |
ColumnName | EQUIP_CAT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EQUIP_CAT_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EQUIP_CAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
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 Signal Equip Cat Id |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL EQUIP_CAT_ID |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL 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 Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | Mod Dte |
ColumnName | MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
MOD_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
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 Signal Mod Dte |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL MOD_DTE |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL 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 |
SET_PT_SGNL_ID |
Base Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | Set Pt Sgnl Id |
ColumnName | SET_PT_SGNL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SET_PT_SGNL_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SET_PT_SGNL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
SET_PT_SGNL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SET_PT_SGNL_ID Security Types |
Name | Current Value |
SET_PT_SGNL_ID Bound Attachments |
Name | Current Value |
SET_PT_SGNL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SET_PT_SGNL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Signal Set Pt Sgnl Id |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL SET_PT_SGNL_ID |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL SET_PT_SGNL_ID |
NO |
SET_PT_SGNL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_ID |
Base Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | RB Sgnl Id |
ColumnName | RB_SGNL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RB_SGNL_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RB_SGNL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
RB_SGNL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'NA' |
Bound Default |
RB_SGNL_ID Security Types |
Name | Current Value |
RB_SGNL_ID Bound Attachments |
Name | Current Value |
RB_SGNL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
RB_SGNL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Signal RB Sgnl Id |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL RB_SGNL_ID |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL RB_SGNL_ID |
NO |
RB_SGNL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_VAL |
Base Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | Set Pt Sgnl Val |
ColumnName | SET_PT_SGNL_VAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Set Point Signal Value: The values for the signal at the given timestamp. Implemented as an Oracle varray. |
Note |
SET_PT_SGNL_VAL Column Properties |
Datatype | VARCHAR2(15) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SET_PT_SGNL_VAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 15 |
Percent Null | 0 |
SET_PT_SGNL_VAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SET_PT_SGNL_VAL Security Types |
Name | Current Value |
SET_PT_SGNL_VAL Bound Attachments |
Name | Current Value |
SET_PT_SGNL_VAL Data Movement Rules |
Name | Type | Rule Text/Value |
SET_PT_SGNL_VAL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Signal Set Pt Sgnl Val |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL SET_PT_SGNL_VAL |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL SET_PT_SGNL_VAL |
NO |
SET_PT_SGNL_VAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_VAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_VAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SET_PT_SGNL_VAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_VAL |
Base Object | SCORE_SNAPSHOT_SGNL |
Attribute Name | RB Sgnl Val |
ColumnName | RB_SGNL_VAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Readback Signal Value: In some rare cases it will be necessary to restore the readback value into the PV, as opposed to the PV value at time of save. |
Note |
RB_SGNL_VAL Column Properties |
Datatype | VARCHAR2(15) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RB_SGNL_VAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 15 |
Percent Null | 0 |
RB_SGNL_VAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RB_SGNL_VAL Security Types |
Name | Current Value |
RB_SGNL_VAL Bound Attachments |
Name | Current Value |
RB_SGNL_VAL Data Movement Rules |
Name | Type | Rule Text/Value |
RB_SGNL_VAL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical SCORE Snapshot Signal RB Sgnl Val |
NO | ||
EPICS (Oracle) SCORE_SNAPSHOT_SGNL RB_SGNL_VAL |
NO | ||
SCORE (Oracle) SCORE_SNAPSHOT_SGNL RB_SGNL_VAL |
NO |
RB_SGNL_VAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_VAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_VAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RB_SGNL_VAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |