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 |
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 |
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 |
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 |
BN |
Base Object | LOG_ENTRY |
Attribute Name | BN |
ColumnName | BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Author Identifier: The badge number of the person who created the log entry. Only the originator of the entry is allowed to modify the entry. |
Note |
BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
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 |
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 |
TITLE |
Base Object | LOG_ENTRY |
Attribute Name | TITLE |
ColumnName | TITLE |
Logical Rolename | |
RoleName | |
Domain | |
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 | 120 |
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 |
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 | |
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(4000) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CONTENT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
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 |
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_IND |
Base Object | LOG_ENTRY |
Attribute Name | HTML_IND |
ColumnName | HTML_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | HTML Indicator: Default is "N." When set to "Y" it indicates the Content field contains HTML code. |
Note |
HTML_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HTML_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
HTML_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
HTML_IND Security Types |
Name | Current Value |
HTML_IND Bound Attachments |
Name | Current Value |
HTML_IND Data Movement Rules |
Name | Type | Rule Text/Value |
HTML_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) LOG_ENTRY HTML_IND |
NO | ||
Logbook (Oracle) LOG_ENTRY HTML_IND |
NO |
HTML_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HTML_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HTML_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HTML_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORIG_POST |
Base Object | LOG_ENTRY |
Attribute Name | ORIG_POST |
ColumnName | ORIG_POST |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Original Posting: The date and time the entry was posted. |
Note |
ORIG_POST Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
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 |
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 | OCCUR_DTE |
ColumnName | OCCUR_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Modify Date: The date the log entry record was last modified. |
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 |
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 |
LABEL_ID |
Base Object | LOG_ENTRY |
Attribute Name | LABEL_ID |
ColumnName | LABEL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
LABEL_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LABEL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
LABEL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LABEL_ID Security Types |
Name | Current Value |
LABEL_ID Bound Attachments |
Name | Current Value |
LABEL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
LABEL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) LOG_ENTRY LABEL_ID |
NO | ||
Logbook (Oracle) LOG_ENTRY LABEL_ID |
NO |
LABEL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LABEL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LABEL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LABEL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRIOR_ID |
Base Object | LOG_ENTRY |
Attribute Name | PRIOR_ID |
ColumnName | PRIOR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PRIOR_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PRIOR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PRIOR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 3 |
Bound Default |
PRIOR_ID Security Types |
Name | Current Value |
PRIOR_ID Bound Attachments |
Name | Current Value |
PRIOR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PRIOR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) LOG_ENTRY PRIOR_ID |
NO | ||
Logbook (Oracle) LOG_ENTRY PRIOR_ID |
NO |
PRIOR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRIOR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRIOR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRIOR_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 |
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 |
EMAIL_NOTIF_IND |
Base Object | LOG_ENTRY |
Attribute Name | EMAIL_NOTIF_IND |
ColumnName | EMAIL_NOTIF_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMAIL_NOTIF_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL_NOTIF_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
EMAIL_NOTIF_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
EMAIL_NOTIF_IND Security Types |
Name | Current Value |
EMAIL_NOTIF_IND Bound Attachments |
Name | Current Value |
EMAIL_NOTIF_IND Data Movement Rules |
Name | Type | Rule Text/Value |
EMAIL_NOTIF_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) LOG_ENTRY EMAIL_NOTIF_IND |
NO | ||
Logbook (Oracle) LOG_ENTRY EMAIL_NOTIF_IND |
NO |
EMAIL_NOTIF_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_NOTIF_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_NOTIF_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_NOTIF_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ANNOT_IND |
Base Object | LOG_ENTRY |
Attribute Name | ANNOT_IND |
ColumnName | ANNOT_IND |
Logical Rolename | |
RoleName | |
Domain | |
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 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 |
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 |