| Log Entry Id |
| Base Entity | Log Entry |
| Attribute Name | Log Entry Id |
| Logical Rolename | |
| ColumnName | Log Entry Id |
| RoleName | |
| Domain | |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Log Entry Id |
| Datatype | INTEGER |
| Nullable | NO |
| 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 | ||
| 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 |
| Badge Number |
| Base Entity | Log Entry |
| Attribute Name | Badge Number |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Badge Number Logical Attribute Properties |
| Logical Attribute Name | Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Badge Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Badge Number Security Types |
| Name | Current Value |
| Badge Number Bound Attachments |
| Name | Current Value |
| Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Badge Number |
NO | ||
| Logbook (Oracle) LOG_ENTRY BN |
NO |
| Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Prnt Log Entry Id |
| Base Entity | Log Entry |
| Attribute Name | Log Entry Id |
| Logical Rolename | Prnt Log Entry Id |
| ColumnName | Prnt Log Entry Id |
| RoleName | Prnt Log Entry Id |
| Domain | |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Log Entry Id |
| Datatype | INTEGER |
| Nullable | YES |
| 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 | ||
| Logbook (Oracle) LOG_ENTRY 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 Entity | Log Entry |
| Attribute Name | Type Id |
| Logical Rolename | |
| ColumnName | Type Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Type Id Logical Attribute Properties |
| Logical Attribute Name | Type Id |
| Datatype | INTEGER |
| Nullable | YES |
| 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 | ||
| 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 Entity | Log Entry |
| Attribute Name | Title |
| Logical Rolename | |
| ColumnName | Title |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Title: A short, one line title, describing the log entry. |
| Note |
| Title Logical Attribute Properties |
| Logical Attribute Name | Title |
| Datatype | VARCHAR(120) |
| Nullable | NO |
| 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 | ||
| 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 Entity | Log Entry |
| Attribute Name | Content |
| Logical Rolename | |
| ColumnName | Content |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Content: A free form text field used to store the specific log entry. This field may contain html code. |
| Note |
| Content Logical Attribute Properties |
| Logical Attribute Name | Content |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| 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 | ||
| 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 Entity | Log Entry |
| Attribute Name | HTML Indicator |
| Logical Rolename | |
| ColumnName | HTML Indicator |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | HTML Indicator: Default is "N." When set to "Y" it indicates the Content field contains HTML code. |
| Note |
| HTML Indicator Logical Attribute Properties |
| Logical Attribute Name | HTML Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 | ||
| 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 |
| Orignal Post |
| Base Entity | Log Entry |
| Attribute Name | Orignal Post |
| Logical Rolename | |
| ColumnName | ORIG_POST |
| RoleName | |
| Domain | Datetime |
| Logical Only | NO |
| Definition | Original Post Date: The date the log entry record was created. |
| Note |
| Orignal Post Logical Attribute Properties |
| Logical Attribute Name | Orignal Post |
| Datatype | DATETIME |
| Nullable | NO |
| Orignal Post Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Orignal Post Security Types |
| Name | Current Value |
| Orignal Post Bound Attachments |
| Name | Current Value |
| Orignal Post Data Movement Rules |
| Name | Type | Rule Text/Value |
| Orignal Post Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Orignal Post |
NO | ||
| Logbook (Oracle) LOG_ENTRY ORIG_POST |
NO |
| Orignal Post Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Orignal Post Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Orignal Post Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Orignal Post Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Occururence Date |
| Base Entity | Log Entry |
| Attribute Name | Occururence Date |
| Logical Rolename | |
| ColumnName | OCCUR_DTE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Occurrence Date: The date and time when the item being described in the logbook entry actually occurred. |
| Note |
| Occururence Date Logical Attribute Properties |
| Logical Attribute Name | Occururence Date |
| Datatype | DATE |
| Nullable | NO |
| Occururence Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Occururence Date Security Types |
| Name | Current Value |
| Occururence Date Bound Attachments |
| Name | Current Value |
| Occururence Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Occururence Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Occururence Date |
NO | ||
| Logbook (Oracle) LOG_ENTRY OCCUR_DTE |
NO |
| Occururence Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Occururence Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Occururence Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Occururence Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Notification Indicator |
| Base Entity | Log Entry |
| Attribute Name | Email Notification Indicator |
| Logical Rolename | |
| ColumnName | Email Notification Indicator |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Email Notifcation Indicator: Indicates the entry should have an email notification to user subscribers and group subscribers. |
| Note |
| Email Notification Indicator Logical Attribute Properties |
| Logical Attribute Name | Email Notification Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 | ||
| 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 |
| Annotation Indicator |
| Base Entity | Log Entry |
| Attribute Name | Annotation Indicator |
| Logical Rolename | |
| ColumnName | ANNOT_IND |
| RoleName | |
| Domain | Indicator |
| Logical 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 |
| Annotation Indicator Logical Attribute Properties |
| Logical Attribute Name | Annotation Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Annotation Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Annotation 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 |
| Annotation Indicator Security Types |
| Name | Current Value |
| Annotation Indicator Bound Attachments |
| Name | Current Value |
| Annotation Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Annotation Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Annotation Indicator |
NO | ||
| Logbook (Oracle) LOG_ENTRY ANNOT_IND |
NO |
| Annotation Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annotation Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annotation Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annotation Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Status Indicator |
| Base Entity | Log Entry |
| Attribute Name | Publication Status Indicator |
| Logical Rolename | |
| ColumnName | PUB_STAT_ID |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Status Indicator Logical Attribute Properties |
| Logical Attribute Name | Publication Status Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Publication Status Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Publication Status 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 |
| Publication Status Indicator Security Types |
| Name | Current Value |
| Publication Status Indicator Bound Attachments |
| Name | Current Value |
| Publication Status Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Status Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Log Entry Publication Status Indicator |
NO | ||
| Logbook (Oracle) LOG_ENTRY PUB_STAT_ID |
NO |
| Publication Status Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Status Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Status Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Status Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |