| APP_ID |
| Base Object | INST_APP |
| Attribute Name | App Id |
| ColumnName | APP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Application Identifier: A unique identifer for a given application. |
| Note |
| APP_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| APP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| APP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| APP_ID Security Types |
| Name | Current Value |
| APP_ID Bound Attachments |
| Name | Current Value |
| APP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| APP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst App App Id |
NO | ||
| INSTR (Oracle) INST_APP APP_ID |
NO |
| APP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_DESC |
| Base Object | INST_APP |
| Attribute Name | App Desc |
| ColumnName | APP_DESC |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| APP_DESC Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| APP_DESC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| APP_DESC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| APP_DESC Security Types |
| Name | Current Value |
| APP_DESC Bound Attachments |
| Name | Current Value |
| APP_DESC Data Movement Rules |
| Name | Type | Rule Text/Value |
| APP_DESC Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inst App App Desc |
NO | ||
| INSTR (Oracle) INST_APP APP_DESC |
NO |
| APP_DESC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_DESC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_DESC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APP_DESC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE |
| Base Object | INST_APP |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Modify Date |
| Physical Only | NO |
| Definition | Modify Date: The day the instrument information was modified. |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| 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 Inst App Modify Date |
NO | ||
| INSTR (Oracle) INST_APP 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 |
| MOD_BY_UID |
| Base Object | INST_APP |
| Attribute Name | Mod By Uid |
| ColumnName | MOD_BY_UID |
| Logical Rolename | |
| RoleName | |
| Domain | Userid |
| Physical Only | NO |
| Definition | Modify By: The userid of the person who last modified the instrument record. |
| Note |
| MOD_BY_UID Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| 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 Inst App Mod By Uid |
NO | ||
| INSTR (Oracle) INST_APP 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 |