DIALOG_ID |
Base Object | DIALOG |
Attribute Name | Dialog Identifier |
ColumnName | DIALOG_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
DIALOG_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DIALOG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
DIALOG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DIALOG_ID Security Types |
Name | Current Value |
DIALOG_ID Bound Attachments |
Name | Current Value |
DIALOG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DIALOG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Dialog Identifier |
NO | ||
ENGA (Oracle) DIALOG DIALOG_ID |
NO |
DIALOG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREV_DIALOG_ID |
Base Object | DIALOG |
Attribute Name | Dialog Identifier |
ColumnName | PREV_DIALOG_ID |
Logical Rolename | Previous Dialog Identifier |
RoleName | PREV_DIALOG_ID |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PREV_DIALOG_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PREV_DIALOG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PREV_DIALOG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PREV_DIALOG_ID Security Types |
Name | Current Value |
PREV_DIALOG_ID Bound Attachments |
Name | Current Value |
PREV_DIALOG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PREV_DIALOG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Dialog Identifier |
NO | ||
ENGA (Oracle) DIALOG PREV_DIALOG_ID |
NO |
PREV_DIALOG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREV_DIALOG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREV_DIALOG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREV_DIALOG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_TYPE_ID |
Base Object | DIALOG |
Attribute Name | Dialog Type Identifier |
ColumnName | DIALOG_TYPE_ID |
Logical Rolename | Dialog Type Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
DIALOG_TYPE_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DIALOG_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
DIALOG_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DIALOG_TYPE_ID Security Types |
Name | Current Value |
DIALOG_TYPE_ID Bound Attachments |
Name | Current Value |
DIALOG_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DIALOG_TYPE_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Dialog Type Identifier |
NO | ||
ENGA (Oracle) DIALOG DIALOG_TYPE_ID |
NO |
DIALOG_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIALOG_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE |
Base Object | DIALOG |
Attribute Name | Current Date |
ColumnName | CUR_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
CUR_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CUR_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CUR_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
CUR_DTE Security Types |
Name | Current Value |
CUR_DTE Bound Attachments |
Name | Current Value |
CUR_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CUR_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Current Date |
NO | ||
ENGA (Oracle) DIALOG CUR_DTE |
NO |
CUR_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BN |
Base Object | DIALOG |
Attribute Name | Badge Number |
ColumnName | BN |
Logical Rolename | Badge Number |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
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 |
Logical Dialog Badge Number |
NO | ||
ENGA (Oracle) DIALOG 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 |
CMNT |
Base Object | DIALOG |
Attribute Name | Comment |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMNT Security Types |
Name | Current Value |
CMNT Bound Attachments |
Name | Current Value |
CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Comment |
NO | ||
ENGA (Oracle) DIALOG CMNT |
NO |
CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_IND |
Base Object | DIALOG |
Attribute Name | Folllowup Indicator |
ColumnName | FOLLOW_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
FOLLOW_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FOLLOW_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
FOLLOW_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
FOLLOW_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 |
FOLLOW_IND Security Types |
Name | Current Value |
FOLLOW_IND Bound Attachments |
Name | Current Value |
FOLLOW_IND Data Movement Rules |
Name | Type | Rule Text/Value |
FOLLOW_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Folllowup Indicator |
NO | ||
ENGA (Oracle) DIALOG FOLLOW_IND |
NO |
FOLLOW_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_DTE |
Base Object | DIALOG |
Attribute Name | Followup Date |
ColumnName | FOLLOW_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
FOLLOW_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FOLLOW_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
FOLLOW_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
FOLLOW_DTE Security Types |
Name | Current Value |
FOLLOW_DTE Bound Attachments |
Name | Current Value |
FOLLOW_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
FOLLOW_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Followup Date |
NO | ||
ENGA (Oracle) DIALOG FOLLOW_DTE |
NO |
FOLLOW_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_ID |
Base Object | DIALOG |
Attribute Name | Event Identifier |
ColumnName | EVENT_ID |
Logical Rolename | Event Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
EVENT_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EVENT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
EVENT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EVENT_ID Security Types |
Name | Current Value |
EVENT_ID Bound Attachments |
Name | Current Value |
EVENT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EVENT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Event Identifier |
NO | ||
ENGA (Oracle) DIALOG EVENT_ID |
NO |
EVENT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_CMNT |
Base Object | DIALOG |
Attribute Name | Followup Comment |
ColumnName | FOLLOW_CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
FOLLOW_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FOLLOW_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
FOLLOW_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FOLLOW_CMNT Security Types |
Name | Current Value |
FOLLOW_CMNT Bound Attachments |
Name | Current Value |
FOLLOW_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
FOLLOW_CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Followup Comment |
NO | ||
ENGA (Oracle) DIALOG FOLLOW_CMNT |
NO |
FOLLOW_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FOLLOW_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
URL |
Base Object | DIALOG |
Attribute Name | Uniform Resource Locator |
ColumnName | URL |
Logical Rolename | |
RoleName | |
Domain | URL |
Physical Only | NO |
Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
Note |
URL Column Properties |
Datatype | VARCHAR2(2048) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
URL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
URL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
URL Security Types |
Name | Current Value |
URL Bound Attachments |
Name | Current Value |
URL Data Movement Rules |
Name | Type | Rule Text/Value |
URL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Uniform Resource Locator |
NO | ||
ENGA (Oracle) DIALOG URL |
NO |
URL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
URL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
URL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
URL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SRVY_RSPNS_ID |
Base Object | DIALOG |
Attribute Name | Survey Response Identifier |
ColumnName | SRVY_RSPNS_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
SRVY_RSPNS_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SRVY_RSPNS_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SRVY_RSPNS_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SRVY_RSPNS_ID Security Types |
Name | Current Value |
SRVY_RSPNS_ID Bound Attachments |
Name | Current Value |
SRVY_RSPNS_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SRVY_RSPNS_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Dialog Survey Response Identifier |
NO | ||
ENGA (Oracle) DIALOG SRVY_RSPNS_ID |
NO |
SRVY_RSPNS_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SRVY_RSPNS_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SRVY_RSPNS_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SRVY_RSPNS_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |