SGNL_ID |
Base Object | SGNL_REC |
Attribute Name | Sgnl Id |
ColumnName | SGNL_ID |
Logical Rolename | |
RoleName | |
Domain | Signal Id |
Physical Only | NO |
Definition | Signal Identifier: |
Note |
SGNL_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
SGNL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SGNL_ID Security Types |
Name | Current Value |
SGNL_ID Bound Attachments |
Name | Current Value |
SGNL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SGNL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Sgnl Id |
NO | ||
BLM (Oracle) SGNL_REC SGNL_ID |
NO | ||
DIAG (Oracle) SGNL_REC SGNL_ID |
NO | ||
EPICS (Oracle) SGNL_REC SGNL_ID |
NO | ||
IRMISBase (Oracle) SGNL_REC SGNL_ID |
NO | ||
MPS (Oracle) SGNL_REC SGNL_ID |
NO | ||
PV_LOGGER (Oracle) SGNL_REC SGNL_ID |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec SGNL_ID |
NO |
SGNL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID |
Base Object | SGNL_REC |
Attribute Name | Device Identifer |
ColumnName | DVC_ID |
Logical Rolename | |
RoleName | |
Domain | Device Id |
Physical Only | NO |
Definition | Device Identifier 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 |
DVC_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_ID Security Types |
Name | Current Value |
DVC_ID Bound Attachments |
Name | Current Value |
DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Device Identifer |
NO | ||
BLM (Oracle) SGNL_REC DVC_ID |
NO | ||
DIAG (Oracle) SGNL_REC DVC_ID |
NO | ||
EPICS (Oracle) SGNL_REC DVC_ID |
NO | ||
IRMISBase (Oracle) SGNL_REC DVC_ID |
NO | ||
MPS (Oracle) SGNL_REC DVC_ID |
NO | ||
PV_LOGGER (Oracle) SGNL_REC DVC_ID |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec DVC_ID |
NO |
DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EPICS_GRP_ID |
Base Object | SGNL_REC |
Attribute Name | EPICS_GRP_ID |
ColumnName | EPICS_GRP_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EPICS_GRP_ID Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EPICS_GRP_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
EPICS_GRP_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EPICS_GRP_ID Security Types |
Name | Current Value |
EPICS_GRP_ID Bound Attachments |
Name | Current Value |
EPICS_GRP_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EPICS_GRP_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record EPICS_GRP_ID |
NO | ||
BLM (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
DIAG (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
EPICS (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
IRMISBase (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
MPS (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
PV_LOGGER (Oracle) SGNL_REC EPICS_GRP_ID |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec EPICS_GRP_ID |
NO |
EPICS_GRP_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EPICS_GRP_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EPICS_GRP_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EPICS_GRP_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REC_TYPE_ID |
Base Object | SGNL_REC |
Attribute Name | Rec Type ID |
ColumnName | REC_TYPE_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Epics Record Type: A text field used to categories different EPICS records. |
Note |
REC_TYPE_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REC_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
REC_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REC_TYPE_ID Security Types |
Name | Current Value |
REC_TYPE_ID Bound Attachments |
Name | Current Value |
REC_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
REC_TYPE_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Rec Type ID |
NO | ||
BLM (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
DIAG (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
EPICS (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
IRMISBase (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
MPS (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
PV_LOGGER (Oracle) SGNL_REC REC_TYPE_ID |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec REC_TYPE_ID |
NO |
REC_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REC_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REC_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REC_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_DESC |
Base Object | SGNL_REC |
Attribute Name | Signal Identifer Description |
ColumnName | SGNL_ID_DESC |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
SGNL_ID_DESC Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_ID_DESC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
SGNL_ID_DESC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SGNL_ID_DESC Security Types |
Name | Current Value |
SGNL_ID_DESC Bound Attachments |
Name | Current Value |
SGNL_ID_DESC Data Movement Rules |
Name | Type | Rule Text/Value |
SGNL_ID_DESC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Signal Identifer Description |
NO | ||
BLM (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
DIAG (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
EPICS (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
IRMISBase (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
MPS (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
PV_LOGGER (Oracle) SGNL_REC SGNL_ID_DESC |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec SGNL_ID_DESC |
NO |
SGNL_ID_DESC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_DESC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_DESC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_DESC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MCHN_PROT_IND |
Base Object | SGNL_REC |
Attribute Name | Mchn Prot Ind |
ColumnName | MCHN_PROT_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Machine Protection Indicator: Default is "N" |
Note |
MCHN_PROT_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MCHN_PROT_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
MCHN_PROT_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
MCHN_PROT_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 |
MCHN_PROT_IND Security Types |
Name | Current Value |
MCHN_PROT_IND Bound Attachments |
Name | Current Value |
MCHN_PROT_IND Data Movement Rules |
Name | Type | Rule Text/Value |
MCHN_PROT_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Mchn Prot Ind |
NO | ||
BLM (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
DIAG (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
EPICS (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
MPS (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC MCHN_PROT_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Mchn Prot Ind |
NO |
MCHN_PROT_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MCHN_PROT_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MCHN_PROT_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MCHN_PROT_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC |
Base Object | SGNL_REC |
Attribute Name | Ext Src |
ColumnName | EXT_SRC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | External Source: The originating tool from which the signal was created in cases where the signal was imported from an external source. |
Note |
EXT_SRC Column Properties |
Datatype | VARCHAR2(200) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXT_SRC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 200 |
Percent Null | 0 |
EXT_SRC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EXT_SRC Security Types |
Name | Current Value |
EXT_SRC Bound Attachments |
Name | Current Value |
EXT_SRC Data Movement Rules |
Name | Type | Rule Text/Value |
EXT_SRC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Ext Src |
NO | ||
BLM (Oracle) SGNL_REC EXT_SRC |
NO | ||
DIAG (Oracle) SGNL_REC EXT_SRC |
NO | ||
EPICS (Oracle) SGNL_REC EXT_SRC |
NO | ||
IRMISBase (Oracle) SGNL_REC EXT_SRC |
NO | ||
MPS (Oracle) SGNL_REC EXT_SRC |
NO | ||
PV_LOGGER (Oracle) SGNL_REC EXT_SRC |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Ext Src |
NO |
EXT_SRC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXT_SRC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MULTIMODE_IND |
Base Object | SGNL_REC |
Attribute Name | Multimode Ind |
ColumnName | MULTIMODE_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Multimode Indicator: Default is "N" |
Note |
MULTIMODE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MULTIMODE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
MULTIMODE_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
MULTIMODE_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 |
MULTIMODE_IND Security Types |
Name | Current Value |
MULTIMODE_IND Bound Attachments |
Name | Current Value |
MULTIMODE_IND Data Movement Rules |
Name | Type | Rule Text/Value |
MULTIMODE_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Multimode Ind |
NO | ||
BLM (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
DIAG (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
EPICS (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
MPS (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC MULTIMODE_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Multimode Ind |
NO |
MULTIMODE_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MULTIMODE_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MULTIMODE_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MULTIMODE_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INVALID_ID_IND |
Base Object | SGNL_REC |
Attribute Name | Invalid Id Ind |
ColumnName | INVALID_ID_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
INVALID_ID_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INVALID_ID_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
INVALID_ID_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
INVALID_ID_IND Security Types |
Name | Current Value |
INVALID_ID_IND Bound Attachments |
Name | Current Value |
INVALID_ID_IND Data Movement Rules |
Name | Type | Rule Text/Value |
INVALID_ID_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Invalid Id Ind |
NO | ||
BLM (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
DIAG (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
EPICS (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
MPS (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC INVALID_ID_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec INVALID_ID_IND |
NO |
INVALID_ID_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INVALID_ID_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INVALID_ID_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INVALID_ID_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_NM |
Base Object | SGNL_REC |
Attribute Name | Sgnl Nm |
ColumnName | SGNL_NM |
Logical Rolename | |
RoleName | |
Domain | Signal Name |
Physical Only | NO |
Definition | Signal Name: This field is parsed from the signal identifier and verified against the DVC Type Sgnl table. |
Note |
SGNL_NM Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
SGNL_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SGNL_NM Security Types |
Name | Current Value |
SGNL_NM Bound Attachments |
Name | Current Value |
SGNL_NM Data Movement Rules |
Name | Type | Rule Text/Value |
SGNL_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Sgnl Nm |
NO | ||
BLM (Oracle) SGNL_REC SGNL_NM |
NO | ||
DIAG (Oracle) SGNL_REC SGNL_NM |
NO | ||
EPICS (Oracle) SGNL_REC SGNL_NM |
NO | ||
IRMISBase (Oracle) SGNL_REC SGNL_NM |
NO | ||
MPS (Oracle) SGNL_REC SGNL_NM |
NO | ||
PV_LOGGER (Oracle) SGNL_REC SGNL_NM |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Sgnl Nm |
NO |
SGNL_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_ALIAS |
Base Object | SGNL_REC |
Attribute Name | Sgnl Id Alias |
ColumnName | SGNL_ID_ALIAS |
Logical Rolename | |
RoleName | |
Domain | Signal Id |
Physical Only | NO |
Definition | Signal Identifier Alias: This field is used to the "to-be" signal identifier. Currently non-standard signal identifiers are stored in the signal identifier field. The alias field is used to store the signal identifier that will later become the actual identifier for the signal. |
Note |
SGNL_ID_ALIAS Column Properties |
Datatype | VARCHAR2(75) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_ID_ALIAS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
SGNL_ID_ALIAS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SGNL_ID_ALIAS Security Types |
Name | Current Value |
SGNL_ID_ALIAS Bound Attachments |
Name | Current Value |
SGNL_ID_ALIAS Data Movement Rules |
Name | Type | Rule Text/Value |
SGNL_ID_ALIAS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Sgnl Id Alias |
NO | ||
BLM (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
DIAG (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
EPICS (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
IRMISBase (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
MPS (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
PV_LOGGER (Oracle) SGNL_REC SGNL_ID_ALIAS |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Sgnl Id Alias |
NO |
SGNL_ID_ALIAS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_ALIAS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_ALIAS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID_ALIAS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BULK_IND |
Base Object | SGNL_REC |
Attribute Name | Bulk Ind |
ColumnName | BULK_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Bulk Indicator: A signal that provides field set for multiple devices. Default is "N." |
Note |
BULK_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BULK_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
BULK_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
BULK_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 |
BULK_IND Security Types |
Name | Current Value |
BULK_IND Bound Attachments |
Name | Current Value |
BULK_IND Data Movement Rules |
Name | Type | Rule Text/Value |
BULK_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Bulk Ind |
NO | ||
BLM (Oracle) SGNL_REC BULK_IND |
NO | ||
DIAG (Oracle) SGNL_REC BULK_IND |
NO | ||
EPICS (Oracle) SGNL_REC BULK_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC BULK_IND |
NO | ||
MPS (Oracle) SGNL_REC BULK_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC BULK_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Bulk Ind |
NO |
BULK_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BULK_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BULK_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BULK_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_IND |
Base Object | SGNL_REC |
Attribute Name | Arch Ind |
ColumnName | ARCH_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Archive Indicator: Indicates that this signal is to be included in the channel archiver, archived at the interval specified in the arch_freq attribute if the arch_type is Periodic. |
Note |
ARCH_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ARCH_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
ARCH_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'Y' |
Bound Default |
ARCH_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 |
ARCH_IND Security Types |
Name | Current Value |
ARCH_IND Bound Attachments |
Name | Current Value |
ARCH_IND Data Movement Rules |
Name | Type | Rule Text/Value |
ARCH_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Arch Ind |
NO | ||
BLM (Oracle) SGNL_REC ARCH_IND |
NO | ||
DIAG (Oracle) SGNL_REC ARCH_IND |
NO | ||
EPICS (Oracle) SGNL_REC ARCH_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC ARCH_IND |
NO | ||
MPS (Oracle) SGNL_REC ARCH_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC ARCH_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Arch Ind |
NO |
ARCH_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_FREQ |
Base Object | SGNL_REC |
Attribute Name | Arch Freq |
ColumnName | ARCH_FREQ |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Archive Frequency: The interval in seconds or fractions of seconds at which the channel archiver will save the process variable value when in periodic mode. (e.g. .5) |
Note |
ARCH_FREQ Column Properties |
Datatype | NUMBER(6, 2) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ARCH_FREQ Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
ARCH_FREQ Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 60 |
Bound Default |
ARCH_FREQ Security Types |
Name | Current Value |
ARCH_FREQ Bound Attachments |
Name | Current Value |
ARCH_FREQ Data Movement Rules |
Name | Type | Rule Text/Value |
ARCH_FREQ Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Arch Freq |
NO | ||
BLM (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
DIAG (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
EPICS (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
IRMISBase (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
MPS (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
PV_LOGGER (Oracle) SGNL_REC ARCH_FREQ |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Arch Freq |
NO |
ARCH_FREQ Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_FREQ Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_FREQ Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_FREQ Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_TYPE |
Base Object | SGNL_REC |
Attribute Name | Arch Type |
ColumnName | ARCH_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Archiver Type: Indicates whether the signal should be archived as Periodic or Monitor. |
Note |
ARCH_TYPE Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ARCH_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
ARCH_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'Monitor' |
Bound Default |
ARCH_TYPE Security Types |
Name | Current Value |
ARCH_TYPE Bound Attachments |
Name | Current Value |
ARCH_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
ARCH_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Arch Type |
NO | ||
BLM (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
DIAG (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
EPICS (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
IRMISBase (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
MPS (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
PV_LOGGER (Oracle) SGNL_REC ARCH_TYPE |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Arch Type |
NO |
ARCH_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ARCH_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CBL_CMPLT_IND |
Base Object | SGNL_REC |
Attribute Name | Cbl Cmplt Ind |
ColumnName | CBL_CMPLT_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Cabling Complete Indicator: Indicates that the cable on which the signal traverses has been pulled and signed off. |
Note |
CBL_CMPLT_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CBL_CMPLT_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
CBL_CMPLT_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
CBL_CMPLT_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 |
CBL_CMPLT_IND Security Types |
Name | Current Value |
CBL_CMPLT_IND Bound Attachments |
Name | Current Value |
CBL_CMPLT_IND Data Movement Rules |
Name | Type | Rule Text/Value |
CBL_CMPLT_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Cbl Cmplt Ind |
NO | ||
BLM (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
DIAG (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
EPICS (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
MPS (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC CBL_CMPLT_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Cbl Cmplt Ind |
NO |
CBL_CMPLT_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CBL_CMPLT_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CBL_CMPLT_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CBL_CMPLT_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ALARM_IND |
Base Object | SGNL_REC |
Attribute Name | Alarm Ind |
ColumnName | ALARM_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Alarm Indicator: Indicates that the signal can be alarmed. |
Note |
ALARM_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ALARM_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
ALARM_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
ALARM_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 |
ALARM_IND Security Types |
Name | Current Value |
ALARM_IND Bound Attachments |
Name | Current Value |
ALARM_IND Data Movement Rules |
Name | Type | Rule Text/Value |
ALARM_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Alarm Ind |
NO | ||
BLM (Oracle) SGNL_REC ALARM_IND |
NO | ||
DIAG (Oracle) SGNL_REC ALARM_IND |
NO | ||
EPICS (Oracle) SGNL_REC ALARM_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC ALARM_IND |
NO | ||
MPS (Oracle) SGNL_REC ALARM_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC ALARM_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Alarm Ind |
NO |
ALARM_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ALARM_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ALARM_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ALARM_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE_IND |
Base Object | SGNL_REC |
Attribute Name | Active Ind |
ColumnName | ACTIVE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Active Indicator: Indicates that the signal is currently in use in the control system. |
Note |
ACTIVE_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACTIVE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
ACTIVE_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'Y' |
Bound Default |
ACTIVE_IND Security Types |
Name | Current Value |
ACTIVE_IND Bound Attachments |
Name | Current Value |
ACTIVE_IND Data Movement Rules |
Name | Type | Rule Text/Value |
ACTIVE_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Active Ind |
NO | ||
BLM (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
DIAG (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
EPICS (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
IRMISBase (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
MPS (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
PV_LOGGER (Oracle) SGNL_REC ACTIVE_IND |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec ACTIVE_IND |
NO |
ACTIVE_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID |
Base Object | SGNL_REC |
Attribute Name | Mod By Uid |
ColumnName | MOD_BY_UID |
Logical Rolename | |
RoleName | |
Domain | Mod By Uid |
Physical Only | NO |
Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
Note |
MOD_BY_UID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_BY_UID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
MOD_BY_UID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_BY_UID Security Types |
Name | Current Value |
MOD_BY_UID Bound Attachments |
Name | Current Value |
MOD_BY_UID Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_BY_UID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Signal Record Mod By Uid |
NO | ||
BLM (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
DIAG (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
EPICS (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
IRMISBase (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
MPS (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
PV_LOGGER (Oracle) SGNL_REC MOD_BY_UID |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec Mod By Uid |
NO |
MOD_BY_UID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE |
Base Object | SGNL_REC |
Attribute Name | Mod Dte |
ColumnName | MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Modify Date: The date the record was created or modified. |
Note |
MOD_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
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 | |
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 Signal Record Mod Dte |
NO | ||
BLM (Oracle) SGNL_REC MOD_DTE |
NO | ||
DIAG (Oracle) SGNL_REC MOD_DTE |
NO | ||
EPICS (Oracle) SGNL_REC MOD_DTE |
NO | ||
IRMISBase (Oracle) SGNL_REC MOD_DTE |
NO | ||
MPS (Oracle) SGNL_REC MOD_DTE |
NO | ||
PV_LOGGER (Oracle) SGNL_REC MOD_DTE |
NO | ||
XAL_OPTICS (Oracle) Sgnl_Rec 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 |