| REC_TYPE_ID |
| Base Object | SGNL_REC_TYPE |
| 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 |
| 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 Type REC_TYPE_ID |
NO | ||
| EPICS (Oracle) SGNL_REC_TYPE REC_TYPE_ID |
NO | ||
| IRMISBase (Oracle) SGNL_REC_TYPE 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 |
| REC_TYPE_CODE |
| Base Object | SGNL_REC_TYPE |
| Attribute Name | REC_TYPE_CODE |
| ColumnName | REC_TYPE_CODE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Record Type Indicator: Indicates whether the record type is for EPICS, PLC, G3, etc. |
| Note |
| REC_TYPE_CODE Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| REC_TYPE_CODE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| REC_TYPE_CODE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'E' |
| Bound Default |
| REC_TYPE_CODE Security Types |
| Name | Current Value |
| REC_TYPE_CODE Bound Attachments |
| Name | Current Value |
| REC_TYPE_CODE Data Movement Rules |
| Name | Type | Rule Text/Value |
| REC_TYPE_CODE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Signal Record Type REC_TYPE_CODE |
NO | ||
| EPICS (Oracle) SGNL_REC_TYPE REC_TYPE_CODE |
NO | ||
| IRMISBase (Oracle) SGNL_REC_TYPE REC_TYPE_CODE |
NO |
| REC_TYPE_CODE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REC_TYPE_CODE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REC_TYPE_CODE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REC_TYPE_CODE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_DESC |
| Base Object | SGNL_REC_TYPE |
| Attribute Name | TYPE_DESC |
| ColumnName | TYPE_DESC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | EPICS Record Type Description: A text field used to describe an EPICS Record Type. |
| Note |
| TYPE_DESC Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| TYPE_DESC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| TYPE_DESC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TYPE_DESC Security Types |
| Name | Current Value |
| TYPE_DESC Bound Attachments |
| Name | Current Value |
| TYPE_DESC Data Movement Rules |
| Name | Type | Rule Text/Value |
| TYPE_DESC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Signal Record Type TYPE_DESC |
NO | ||
| EPICS (Oracle) SGNL_REC_TYPE TYPE_DESC |
NO | ||
| IRMISBase (Oracle) SGNL_REC_TYPE TYPE_DESC |
NO |
| TYPE_DESC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_DESC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_DESC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_DESC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ARCH_IND |
| Base Object | SGNL_REC_TYPE |
| Attribute Name | ARCH_IND |
| ColumnName | ARCH_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Archive Indicator: Indicates whether signals o this record type can be archived. |
| Note |
| ARCH_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| 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 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 Type ARCH_IND |
NO | ||
| EPICS (Oracle) SGNL_REC_TYPE ARCH_IND |
NO | ||
| IRMISBase (Oracle) SGNL_REC_TYPE 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 |