System Identifier |
Base Entity | System |
Attribute Name | System Identifier |
Logical Rolename | |
ColumnName | SYS_ID |
RoleName | |
Domain | System Id |
Logical Only | NO |
Definition | System Code: The unique identifier for the Spalation Neutron Source Project System. |
Note |
System Identifier Logical Attribute Properties |
Logical Attribute Name | System Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
System Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
System Identifier Security Types |
Name | Current Value |
System Identifier Bound Attachments |
Name | Current Value |
System Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
System Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical System System Identifier |
NO | ||
EPICS (Oracle) SYST SYS_ID |
NO |
System Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
System Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
System Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
System Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Nm |
Base Entity | System |
Attribute Name | Sys Nm |
Logical Rolename | |
ColumnName | Sys Nm |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | System Name: The name of the system associated with the system code. |
Note |
Sys Nm Logical Attribute Properties |
Logical Attribute Name | Sys Nm |
Datatype | VARCHAR(120) |
Nullable | NO |
Sys Nm Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sys Nm Security Types |
Name | Current Value |
Sys Nm Bound Attachments |
Name | Current Value |
Sys Nm Data Movement Rules |
Name | Type | Rule Text/Value |
Sys Nm Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical System Sys Nm |
NO | ||
EPICS (Oracle) SYST Sys Nm |
NO |
Sys Nm Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Nm Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Nm Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Nm Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Accum Path Lngth |
Base Entity | System |
Attribute Name | Accum Path Lngth |
Logical Rolename | |
ColumnName | Accum Path Lngth |
RoleName | |
Domain | Distance |
Logical Only | NO |
Definition | Accumulated Path Length: The accumulated path length from the start. |
Note |
Accum Path Lngth Logical Attribute Properties |
Logical Attribute Name | Accum Path Lngth |
Datatype | NUMERIC(12, 6) |
Nullable | YES |
Accum Path Lngth Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Accum Path Lngth Security Types |
Name | Current Value |
Accum Path Lngth Bound Attachments |
Name | Current Value |
Accum Path Lngth Data Movement Rules |
Name | Type | Rule Text/Value |
Accum Path Lngth Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical System Accum Path Lngth |
NO | ||
EPICS (Oracle) SYST Accum Path Lngth |
NO |
Accum Path Lngth Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Accum Path Lngth Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Accum Path Lngth Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Accum Path Lngth Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Seq Nbr |
Base Entity | System |
Attribute Name | Sys Seq Nbr |
Logical Rolename | |
ColumnName | Sys Seq Nbr |
RoleName | |
Domain | |
Logical Only | NO |
Definition | System Sequence Number: Used to order systems for reporting purposes. |
Note |
Sys Seq Nbr Logical Attribute Properties |
Logical Attribute Name | Sys Seq Nbr |
Datatype | NUMERIC(3, 0) |
Nullable | YES |
Sys Seq Nbr Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sys Seq Nbr Security Types |
Name | Current Value |
Sys Seq Nbr Bound Attachments |
Name | Current Value |
Sys Seq Nbr Data Movement Rules |
Name | Type | Rule Text/Value |
Sys Seq Nbr Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical System Sys Seq Nbr |
NO | ||
EPICS (Oracle) SYST Sys Seq Nbr |
NO |
Sys Seq Nbr Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Seq Nbr Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Seq Nbr Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sys Seq Nbr Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |