EVENT_ID |
Base Object | EVENT |
Attribute Name | Event Identifier |
ColumnName | EVENT_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
EVENT_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | NO |
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 Event Event Identifier |
NO | ||
ENGA (Oracle) EVENT 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 |
NM |
Base Object | EVENT |
Attribute Name | Name |
ColumnName | NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NM Security Types |
Name | Current Value |
NM Bound Attachments |
Name | Current Value |
NM Data Movement Rules |
Name | Type | Rule Text/Value |
NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Name |
NO | ||
ENGA (Oracle) EVENT NM |
NO |
NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR |
Base Object | EVENT |
Attribute Name | Description |
ColumnName | DESCR |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
DESCR Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DESCR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
DESCR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DESCR Security Types |
Name | Current Value |
DESCR Bound Attachments |
Name | Current Value |
DESCR Data Movement Rules |
Name | Type | Rule Text/Value |
DESCR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Description |
NO | ||
ENGA (Oracle) EVENT DESCR |
NO |
DESCR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DESCR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LOC |
Base Object | EVENT |
Attribute Name | Location |
ColumnName | LOC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
LOC Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LOC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
LOC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LOC Security Types |
Name | Current Value |
LOC Bound Attachments |
Name | Current Value |
LOC Data Movement Rules |
Name | Type | Rule Text/Value |
LOC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Location |
NO | ||
ENGA (Oracle) EVENT LOC |
NO |
LOC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LOC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LOC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LOC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE |
Base Object | EVENT |
Attribute Name | Start Date |
ColumnName | START_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
START_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
START_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
START_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
START_DTE Security Types |
Name | Current Value |
START_DTE Bound Attachments |
Name | Current Value |
START_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
START_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Start Date |
NO | ||
ENGA (Oracle) EVENT START_DTE |
NO |
START_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE |
Base Object | EVENT |
Attribute Name | End Date |
ColumnName | END_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
END_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
END_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
END_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
END_DTE Security Types |
Name | Current Value |
END_DTE Bound Attachments |
Name | Current Value |
END_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
END_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event End Date |
NO | ||
ENGA (Oracle) EVENT END_DTE |
NO |
END_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
END_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_TYPE_ID |
Base Object | EVENT |
Attribute Name | Event Type Identifier |
ColumnName | EVENT_TYPE_ID |
Logical Rolename | Event Type Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
EVENT_TYPE_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EVENT_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
EVENT_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EVENT_TYPE_ID Security Types |
Name | Current Value |
EVENT_TYPE_ID Bound Attachments |
Name | Current Value |
EVENT_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EVENT_TYPE_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Event Type Identifier |
NO | ||
ENGA (Oracle) EVENT EVENT_TYPE_ID |
NO |
EVENT_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EVENT_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOST_INST |
Base Object | EVENT |
Attribute Name | Institute Identifier |
ColumnName | HOST_INST |
Logical Rolename | Host Institute |
RoleName | HOST_INST |
Domain | |
Physical Only | NO |
Definition | Institute Identifer: Abbreviated identifier for a institute. |
Note |
HOST_INST Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HOST_INST Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
HOST_INST Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HOST_INST Security Types |
Name | Current Value |
HOST_INST Bound Attachments |
Name | Current Value |
HOST_INST Data Movement Rules |
Name | Type | Rule Text/Value |
HOST_INST Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Institute Identifier |
NO | ||
ENGA (Oracle) EVENT HOST_INST |
NO |
HOST_INST Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOST_INST Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOST_INST Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOST_INST Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CONFIRM_IND |
Base Object | EVENT |
Attribute Name | Confirmed Indicator |
ColumnName | CONFIRM_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
CONFIRM_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CONFIRM_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
CONFIRM_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
CONFIRM_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 |
CONFIRM_IND Security Types |
Name | Current Value |
CONFIRM_IND Bound Attachments |
Name | Current Value |
CONFIRM_IND Data Movement Rules |
Name | Type | Rule Text/Value |
CONFIRM_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Event Confirmed Indicator |
NO | ||
ENGA (Oracle) EVENT CONFIRM_IND |
NO |
CONFIRM_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CONFIRM_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CONFIRM_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CONFIRM_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |