| LOG_ENTRY_ID |
| Base Object | LOG_ENTRY |
| Attribute Name | Log Entry Id |
| ColumnName | LOG_ENTRY_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Log Entry Identifier: The unique identifier for a log entry. This number is automatically generated in sequential order. |
| Note |
| LOG_ENTRY_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LOG_ENTRY_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| LOG_ENTRY_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LOG_ENTRY_ID Security Types |
| Name | Current Value |
| LOG_ENTRY_ID Bound Attachments |
| Name | Current Value |
| LOG_ENTRY_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOG_ENTRY_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Log Entry Id |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY LOG_ENTRY_ID |
NO | ||
| Logbook (Oracle) LOG_ENTRY LOG_ENTRY_ID |
NO |
| LOG_ENTRY_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_ENTRY_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_ENTRY_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOG_ENTRY_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN |
| Base Object | LOG_ENTRY |
| Attribute Name | Badge Number |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BN Security Types |
| Name | Current Value |
| BN Bound Attachments |
| Name | Current Value |
| BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Badge Number |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY BN |
NO | ||
| Logbook (Oracle) LOG_ENTRY BN |
NO |
| BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRNT_LOG_ENTRY_ID |
| Base Object | LOG_ENTRY |
| Attribute Name | Log Entry Id |
| ColumnName | PRNT_LOG_ENTRY_ID |
| Logical Rolename | Prnt Log Entry Id |
| RoleName | PRNT_LOG_ENTRY_ID |
| Domain | |
| Physical Only | NO |
| Definition | Parent Log Entry Identifier: The unique identifier pointing the to parent log entry. This provides the ability to develop a "chain" of log entries related to a specific topic. |
| Note |
| PRNT_LOG_ENTRY_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRNT_LOG_ENTRY_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| PRNT_LOG_ENTRY_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRNT_LOG_ENTRY_ID Security Types |
| Name | Current Value |
| PRNT_LOG_ENTRY_ID Bound Attachments |
| Name | Current Value |
| PRNT_LOG_ENTRY_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRNT_LOG_ENTRY_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Log Entry Id |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY PRNT_LOG_ENTRY_ID |
NO | ||
| Logbook (Oracle) LOG_ENTRY PRNT_LOG_ENTRY_ID |
NO |
| PRNT_LOG_ENTRY_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRNT_LOG_ENTRY_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRNT_LOG_ENTRY_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRNT_LOG_ENTRY_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_ID |
| Base Object | LOG_ENTRY |
| Attribute Name | Type Id |
| ColumnName | TYPE_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TYPE_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TYPE_ID Security Types |
| Name | Current Value |
| TYPE_ID Bound Attachments |
| Name | Current Value |
| TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Type Id |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY TYPE_ID |
NO | ||
| Logbook (Oracle) LOG_ENTRY TYPE_ID |
NO |
| TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE |
| Base Object | LOG_ENTRY |
| Attribute Name | Title |
| ColumnName | TITLE |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Title: A short, one line title, describing the log entry. |
| Note |
| TITLE Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TITLE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| TITLE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TITLE Security Types |
| Name | Current Value |
| TITLE Bound Attachments |
| Name | Current Value |
| TITLE Data Movement Rules |
| Name | Type | Rule Text/Value |
| TITLE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Title |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY TITLE |
NO | ||
| Logbook (Oracle) LOG_ENTRY TITLE |
NO |
| TITLE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONTENT |
| Base Object | LOG_ENTRY |
| Attribute Name | Content |
| ColumnName | CONTENT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Content: A free form text field used to store the specific log entry. This field may contain html code. |
| Note |
| CONTENT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CONTENT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CONTENT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CONTENT Security Types |
| Name | Current Value |
| CONTENT Bound Attachments |
| Name | Current Value |
| CONTENT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CONTENT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Content |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY CONTENT |
NO | ||
| Logbook (Oracle) LOG_ENTRY CONTENT |
NO |
| CONTENT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONTENT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONTENT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONTENT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HTML_INDICATOR |
| Base Object | LOG_ENTRY |
| Attribute Name | HTML Indicator |
| ColumnName | HTML_INDICATOR |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | HTML Indicator: Default is "N." When set to "Y" it indicates the Content field contains HTML code. |
| Note |
| HTML_INDICATOR Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HTML_INDICATOR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| HTML_INDICATOR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| HTML_INDICATOR Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| HTML_INDICATOR Security Types |
| Name | Current Value |
| HTML_INDICATOR Bound Attachments |
| Name | Current Value |
| HTML_INDICATOR Data Movement Rules |
| Name | Type | Rule Text/Value |
| HTML_INDICATOR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry HTML Indicator |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY HTML_INDICATOR |
NO | ||
| Logbook (Oracle) LOG_ENTRY HTML_INDICATOR |
NO |
| HTML_INDICATOR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HTML_INDICATOR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HTML_INDICATOR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HTML_INDICATOR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORIG_POST |
| Base Object | LOG_ENTRY |
| Attribute Name | Orignal Post |
| ColumnName | ORIG_POST |
| Logical Rolename | |
| RoleName | |
| Domain | Datetime |
| Physical Only | NO |
| Definition | Original Post Date: The date the log entry record was created. |
| Note |
| ORIG_POST Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | NO |
| Not Null Constraint | |
| Time Zone | NO |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORIG_POST Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| ORIG_POST Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORIG_POST Security Types |
| Name | Current Value |
| ORIG_POST Bound Attachments |
| Name | Current Value |
| ORIG_POST Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORIG_POST Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Orignal Post |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY ORIG_POST |
NO | ||
| Logbook (Oracle) LOG_ENTRY ORIG_POST |
NO |
| ORIG_POST Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORIG_POST Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORIG_POST Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORIG_POST Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OCCUR_DTE |
| Base Object | LOG_ENTRY |
| Attribute Name | Occururence Date |
| ColumnName | OCCUR_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Modify Date |
| Physical Only | NO |
| Definition | Occurrence Date: The date and time when the item being described in the logbook entry actually occurred. |
| Note |
| OCCUR_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OCCUR_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| OCCUR_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OCCUR_DTE Security Types |
| Name | Current Value |
| OCCUR_DTE Bound Attachments |
| Name | Current Value |
| OCCUR_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| OCCUR_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Occururence Date |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY OCCUR_DTE |
NO | ||
| Logbook (Oracle) LOG_ENTRY OCCUR_DTE |
NO |
| OCCUR_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OCCUR_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OCCUR_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OCCUR_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_NOTIFICATION_INDICATOR |
| Base Object | LOG_ENTRY |
| Attribute Name | Email Notification Indicator |
| ColumnName | EMAIL_NOTIFICATION_INDICATOR |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Email Notifcation Indicator: Indicates the entry should have an email notification to user subscribers and group subscribers. |
| Note |
| EMAIL_NOTIFICATION_INDICATOR Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_NOTIFICATION_INDICATOR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| EMAIL_NOTIFICATION_INDICATOR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| EMAIL_NOTIFICATION_INDICATOR Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| EMAIL_NOTIFICATION_INDICATOR Security Types |
| Name | Current Value |
| EMAIL_NOTIFICATION_INDICATOR Bound Attachments |
| Name | Current Value |
| EMAIL_NOTIFICATION_INDICATOR Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_NOTIFICATION_INDICATOR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Email Notification Indicator |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY EMAIL_NOTIFICATION_INDICATOR |
NO | ||
| Logbook (Oracle) LOG_ENTRY EMAIL_NOTIFICATION_INDICATOR |
NO |
| EMAIL_NOTIFICATION_INDICATOR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_NOTIFICATION_INDICATOR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_NOTIFICATION_INDICATOR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_NOTIFICATION_INDICATOR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ANNOT_IND |
| Base Object | LOG_ENTRY |
| Attribute Name | Annotation Indicator |
| ColumnName | ANNOT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Annotation Indicator: If an entry's annotation value is 'Y' then it indicates that this entry is an annotation to it parent entry rather than a thread response. In this way the author of an entry can annotate their original entry (parent entry) and it will be displayed sequentially with the parent entry in chronological order. Users can use this feature to correct mistakes but without actually editing the original entry. Effectively, they can append to their original entry. |
| Note |
| ANNOT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ANNOT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| ANNOT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| ANNOT_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| ANNOT_IND Security Types |
| Name | Current Value |
| ANNOT_IND Bound Attachments |
| Name | Current Value |
| ANNOT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ANNOT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Annotation Indicator |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY ANNOT_IND |
NO | ||
| Logbook (Oracle) LOG_ENTRY ANNOT_IND |
NO |
| ANNOT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ANNOT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ANNOT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ANNOT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_STAT_ID |
| Base Object | LOG_ENTRY |
| Attribute Name | Publication Status Indicator |
| ColumnName | PUB_STAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_STAT_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PUB_STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PUB_STAT_ID Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| PUB_STAT_ID Security Types |
| Name | Current Value |
| PUB_STAT_ID Bound Attachments |
| Name | Current Value |
| PUB_STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_STAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Publication Status Indicator |
NO | ||
| Instrument Logbook (Oracle) LOG_ENTRY PUB_STAT_ID |
NO | ||
| Logbook (Oracle) LOG_ENTRY PUB_STAT_ID |
NO |
| PUB_STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |