SYS_ID |
Base Object | SYST |
Attribute Name | SYS_ID |
ColumnName | SYS_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | System Code: The unique identifier for the Spalation Neutron Source Project System. |
Note |
SYS_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SYS_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
SYS_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SYS_ID Security Types |
Name | Current Value |
SYS_ID Bound Attachments |
Name | Current Value |
SYS_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SYS_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical System System Identifier |
NO | ||
EPICS (Oracle) SYST SYS_ID |
NO |
SYS_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_NM |
Base Object | SYST |
Attribute Name | SYS_NM |
ColumnName | SYS_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | System Name: The name of the system associated with the system code. |
Note |
SYS_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SYS_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 18 |
Percent Null | 0 |
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 Object | SYST |
Attribute Name | ACCUM_PATH_LNGTH |
ColumnName | ACCUM_PATH_LNGTH |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Accumulated Path Length: The accumulated path length from the start. |
Note |
ACCUM_PATH_LNGTH Column Properties |
Datatype | NUMBER(12, 6) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACCUM_PATH_LNGTH Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 100 |
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 Object | SYST |
Attribute Name | SYS_SEQ_NBR |
ColumnName | SYS_SEQ_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | System Sequence Number: Used to order systems for reporting purposes. |
Note |
SYS_SEQ_NBR Column Properties |
Datatype | NUMBER(3, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SYS_SEQ_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 10 |
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 |