DVC_ID |
Base Object | ICS_COMM_DVC |
Attribute Name | DVC_ID |
ColumnName | DVC_ID |
Logical Rolename | |
RoleName | |
Domain | |
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(40) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
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 ICS Communication Device Device Identifer |
NO | ||
EPICS (Oracle) ICS_COMM_DVC 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 |
IP_ADDR |
Base Object | ICS_COMM_DVC |
Attribute Name | IP_ADDR |
ColumnName | IP_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Internet Protocol Address: The internet protocol address assigned to the ICS Comm Device. |
Note |
IP_ADDR Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
IP_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 71 |
IP_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IP_ADDR Security Types |
Name | Current Value |
IP_ADDR Bound Attachments |
Name | Current Value |
IP_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
IP_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device IP Address |
NO | ||
EPICS (Oracle) ICS_COMM_DVC IP_ADDR |
NO |
IP_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IP_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IP_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IP_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ETHER_ADDR |
Base Object | ICS_COMM_DVC |
Attribute Name | ETHER_ADDR |
ColumnName | ETHER_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Ethernet Address: The ethernet address for the IOC. |
Note |
ETHER_ADDR Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ETHER_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 69 |
ETHER_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ETHER_ADDR Security Types |
Name | Current Value |
ETHER_ADDR Bound Attachments |
Name | Current Value |
ETHER_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
ETHER_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device Ethernet Address |
NO | ||
EPICS (Oracle) ICS_COMM_DVC ETHER_ADDR |
NO |
ETHER_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ETHER_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ETHER_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ETHER_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NET_MASK |
Base Object | ICS_COMM_DVC |
Attribute Name | NET_MASK |
ColumnName | NET_MASK |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Network Mask: The network mask for the device. |
Note |
NET_MASK Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NET_MASK Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 66 |
NET_MASK Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NET_MASK Security Types |
Name | Current Value |
NET_MASK Bound Attachments |
Name | Current Value |
NET_MASK Data Movement Rules |
Name | Type | Rule Text/Value |
NET_MASK Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device Network Mask |
NO | ||
EPICS (Oracle) ICS_COMM_DVC NET_MASK |
NO |
NET_MASK Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NET_MASK Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NET_MASK Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NET_MASK Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NET_DOMAIN |
Base Object | ICS_COMM_DVC |
Attribute Name | NET_DOMAIN |
ColumnName | NET_DOMAIN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Net Domain: Network Domain Name. |
Note |
NET_DOMAIN Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NET_DOMAIN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 66 |
NET_DOMAIN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NET_DOMAIN Security Types |
Name | Current Value |
NET_DOMAIN Bound Attachments |
Name | Current Value |
NET_DOMAIN Data Movement Rules |
Name | Type | Rule Text/Value |
NET_DOMAIN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device Network Domain |
NO | ||
EPICS (Oracle) ICS_COMM_DVC NET_DOMAIN |
NO |
NET_DOMAIN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NET_DOMAIN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NET_DOMAIN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NET_DOMAIN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VLAN_NBR |
Base Object | ICS_COMM_DVC |
Attribute Name | VLAN_NBR |
ColumnName | VLAN_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Virtual Local Area Network Number: |
Note |
VLAN_NBR Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
VLAN_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 84 |
VLAN_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VLAN_NBR Security Types |
Name | Current Value |
VLAN_NBR Bound Attachments |
Name | Current Value |
VLAN_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
VLAN_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device VLAN Number |
NO | ||
EPICS (Oracle) ICS_COMM_DVC VLAN_NBR |
NO |
VLAN_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VLAN_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VLAN_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VLAN_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ICS_NET_NM |
Base Object | ICS_COMM_DVC |
Attribute Name | ICS_NET_NM |
ColumnName | ICS_NET_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Integrated Control Systems Network Name: Internal name for controls devices attached to the network. |
Note |
ICS_NET_NM Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ICS_NET_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 36 |
ICS_NET_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ICS_NET_NM Security Types |
Name | Current Value |
ICS_NET_NM Bound Attachments |
Name | Current Value |
ICS_NET_NM Data Movement Rules |
Name | Type | Rule Text/Value |
ICS_NET_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device ICS Network Name |
NO | ||
EPICS (Oracle) ICS_COMM_DVC ICS_NET_NM |
NO |
ICS_NET_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ICS_NET_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ICS_NET_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ICS_NET_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SW_DVC_ID |
Base Object | ICS_COMM_DVC |
Attribute Name | DVC_ID |
ColumnName | SW_DVC_ID |
Logical Rolename | SW_DVC_ID |
RoleName | SW_DVC_ID |
Domain | |
Physical Only | NO |
Definition | Switch Device Id: The device id of the switch to which the IOC is connected. |
Note |
SW_DVC_ID Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SW_DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SW_DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SW_DVC_ID Security Types |
Name | Current Value |
SW_DVC_ID Bound Attachments |
Name | Current Value |
SW_DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SW_DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DVC_ID |
NO | ||
EPICS (Oracle) ICS_COMM_DVC SW_DVC_ID |
NO |
SW_DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SW_DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SW_DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SW_DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SW_PORT_NBR |
Base Object | ICS_COMM_DVC |
Attribute Name | SW_PORT_NBR |
ColumnName | SW_PORT_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Switch Port: The switch port to which the IOC connects. |
Note |
SW_PORT_NBR Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SW_PORT_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 88 |
SW_PORT_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SW_PORT_NBR Security Types |
Name | Current Value |
SW_PORT_NBR Bound Attachments |
Name | Current Value |
SW_PORT_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
SW_PORT_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device SW_PORT_NBR |
NO | ||
EPICS (Oracle) ICS_COMM_DVC SW_PORT_NBR |
NO |
SW_PORT_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SW_PORT_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SW_PORT_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SW_PORT_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_DVC_ID |
Base Object | ICS_COMM_DVC |
Attribute Name | DVC_ID |
ColumnName | TSRV_DVC_ID |
Logical Rolename | TSRV_DVC_ID |
RoleName | TSRV_DVC_ID |
Domain | |
Physical Only | NO |
Definition | Terminal Server Device Identifer: The terminal server to which the device is connected. |
Note |
TSRV_DVC_ID Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TSRV_DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
TSRV_DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TSRV_DVC_ID Security Types |
Name | Current Value |
TSRV_DVC_ID Bound Attachments |
Name | Current Value |
TSRV_DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
TSRV_DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DVC_ID |
NO | ||
EPICS (Oracle) ICS_COMM_DVC TSRV_DVC_ID |
NO |
TSRV_DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_PORT_NBR |
Base Object | ICS_COMM_DVC |
Attribute Name | TSRV_PORT_NBR |
ColumnName | TSRV_PORT_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Terminal Server Port: The device port to which the terminal server connects. |
Note |
TSRV_PORT_NBR Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TSRV_PORT_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 94 |
TSRV_PORT_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TSRV_PORT_NBR Security Types |
Name | Current Value |
TSRV_PORT_NBR Bound Attachments |
Name | Current Value |
TSRV_PORT_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
TSRV_PORT_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device TSRV_PORT_NBR |
NO | ||
EPICS (Oracle) ICS_COMM_DVC TSRV_PORT_NBR |
NO |
TSRV_PORT_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_PORT_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_PORT_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TSRV_PORT_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_DVC_ID |
Base Object | ICS_COMM_DVC |
Attribute Name | DVC_ID |
ColumnName | RPC_DVC_ID |
Logical Rolename | RPC_DVC_ID |
RoleName | RPC_DVC_ID |
Domain | |
Physical Only | NO |
Definition | Remote Power Controller Device Identifer: The RPC that will reboot the device. |
Note |
RPC_DVC_ID Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RPC_DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
RPC_DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RPC_DVC_ID Security Types |
Name | Current Value |
RPC_DVC_ID Bound Attachments |
Name | Current Value |
RPC_DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
RPC_DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DVC_ID |
NO | ||
EPICS (Oracle) ICS_COMM_DVC RPC_DVC_ID |
NO |
RPC_DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_ADDR |
Base Object | ICS_COMM_DVC |
Attribute Name | RPC_ADDR |
ColumnName | RPC_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Remote Power Controller Device Identifer: The RPC that will reboot the device. |
Note |
RPC_ADDR Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RPC_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 89 |
RPC_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RPC_ADDR Security Types |
Name | Current Value |
RPC_ADDR Bound Attachments |
Name | Current Value |
RPC_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
RPC_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device RPC_ADDR |
NO | ||
EPICS (Oracle) ICS_COMM_DVC RPC_ADDR |
NO |
RPC_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPC_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NOTES |
Base Object | ICS_COMM_DVC |
Attribute Name | NOTES |
ColumnName | NOTES |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Notes: |
Note |
NOTES Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NOTES Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 86 |
NOTES Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NOTES Security Types |
Name | Current Value |
NOTES Bound Attachments |
Name | Current Value |
NOTES Data Movement Rules |
Name | Type | Rule Text/Value |
NOTES Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device Notes |
NO | ||
EPICS (Oracle) ICS_COMM_DVC NOTES |
NO |
NOTES Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NOTES Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NOTES Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NOTES Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_BGN |
Base Object | ICS_COMM_DVC |
Attribute Name | DSGN_CAB_SLOT_BGN |
ColumnName | DSGN_CAB_SLOT_BGN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Design Cabinet Beginning Slot Number: The first slot the equipment occupies in the cabinet. |
Note |
DSGN_CAB_SLOT_BGN Column Properties |
Datatype | NUMBER(3, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DSGN_CAB_SLOT_BGN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 74 |
DSGN_CAB_SLOT_BGN Domain Restrictions |
CheckConstraint | dsgn_cab_slot_bgn > 0 |
Check Constraint Name | ICS_COMM_DVC_ZERO_CK |
Bound Rule | |
Declared Default | |
Bound Default |
DSGN_CAB_SLOT_BGN Security Types |
Name | Current Value |
DSGN_CAB_SLOT_BGN Bound Attachments |
Name | Current Value |
DSGN_CAB_SLOT_BGN Data Movement Rules |
Name | Type | Rule Text/Value |
DSGN_CAB_SLOT_BGN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DSGN_CAB_SLOT_BGN |
NO | ||
EPICS (Oracle) ICS_COMM_DVC DSGN_CAB_SLOT_BGN |
NO |
DSGN_CAB_SLOT_BGN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_BGN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_BGN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_BGN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_END |
Base Object | ICS_COMM_DVC |
Attribute Name | DSGN_CAB_SLOT_END |
ColumnName | DSGN_CAB_SLOT_END |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Design Cabinet Ending Slot Number: If more than one slot is required for equipment, this field indicates the last slot number used. |
Note |
DSGN_CAB_SLOT_END Column Properties |
Datatype | NUMBER(3, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DSGN_CAB_SLOT_END Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 74 |
DSGN_CAB_SLOT_END Domain Restrictions |
CheckConstraint | dsgn_cab_slot_end < 46 |
Check Constraint Name | ICS_COMM_DVC_SLOT_END_CK |
Bound Rule | |
Declared Default | |
Bound Default |
DSGN_CAB_SLOT_END Security Types |
Name | Current Value |
DSGN_CAB_SLOT_END Bound Attachments |
Name | Current Value |
DSGN_CAB_SLOT_END Data Movement Rules |
Name | Type | Rule Text/Value |
DSGN_CAB_SLOT_END Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DSGN_CAB_SLOT_END |
NO | ||
EPICS (Oracle) ICS_COMM_DVC DSGN_CAB_SLOT_END |
NO |
DSGN_CAB_SLOT_END Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_END Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_END Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_END Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_POS_IND |
Base Object | ICS_COMM_DVC |
Attribute Name | DSGN_CAB_SLOT_POS_IND |
ColumnName | DSGN_CAB_SLOT_POS_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Design Cabinet Slot Position Indicator: Used to indicate how the device is installed into the cabinet. Valid values include "F - Front" or "B-Back". |
Note |
DSGN_CAB_SLOT_POS_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DSGN_CAB_SLOT_POS_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
DSGN_CAB_SLOT_POS_IND Domain Restrictions |
CheckConstraint | dsgn_cab_slot_pos_ind in ('F','B','L','R') |
Check Constraint Name | ICS_COMM_DVC_CK |
Bound Rule | |
Declared Default | 'F' |
Bound Default |
DSGN_CAB_SLOT_POS_IND Security Types |
Name | Current Value |
DSGN_CAB_SLOT_POS_IND Bound Attachments |
Name | Current Value |
DSGN_CAB_SLOT_POS_IND Data Movement Rules |
Name | Type | Rule Text/Value |
DSGN_CAB_SLOT_POS_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device DSGN_CAB_SLOT_POS_IND |
NO | ||
EPICS (Oracle) ICS_COMM_DVC DSGN_CAB_SLOT_POS_IND |
NO |
DSGN_CAB_SLOT_POS_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_POS_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_POS_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DSGN_CAB_SLOT_POS_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
POS_WITHIN_SLOTS |
Base Object | ICS_COMM_DVC |
Attribute Name | POS_WITHIN_SLOTS |
ColumnName | POS_WITHIN_SLOTS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Position Within Slots: Indicates the relative position of the device in a slot where more than one device is used. |
Note |
POS_WITHIN_SLOTS Column Properties |
Datatype | NUMBER(3, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
POS_WITHIN_SLOTS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 100 |
POS_WITHIN_SLOTS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
POS_WITHIN_SLOTS Security Types |
Name | Current Value |
POS_WITHIN_SLOTS Bound Attachments |
Name | Current Value |
POS_WITHIN_SLOTS Data Movement Rules |
Name | Type | Rule Text/Value |
POS_WITHIN_SLOTS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical ICS Communication Device POS_WITHIN_SLOTS |
NO | ||
EPICS (Oracle) ICS_COMM_DVC POS_WITHIN_SLOTS |
NO |
POS_WITHIN_SLOTS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
POS_WITHIN_SLOTS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
POS_WITHIN_SLOTS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
POS_WITHIN_SLOTS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |