BN |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | BN |
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 |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER 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 |
USER_ID |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | USER_ID |
ColumnName | USER_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
USER_ID Column Properties |
Datatype | VARCHAR2(11) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
USER_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
USER_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
USER_ID Security Types |
Name | Current Value |
USER_ID Bound Attachments |
Name | Current Value |
USER_ID Data Movement Rules |
Name | Type | Rule Text/Value |
USER_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER USER_ID |
NO |
USER_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
USER_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
USER_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_CODE |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | EMP_CODE |
ColumnName | EMP_CODE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMP_CODE Column Properties |
Datatype | VARCHAR2(2) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMP_CODE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
EMP_CODE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMP_CODE Security Types |
Name | Current Value |
EMP_CODE Bound Attachments |
Name | Current Value |
EMP_CODE Data Movement Rules |
Name | Type | Rule Text/Value |
EMP_CODE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER EMP_CODE |
NO |
EMP_CODE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_CODE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_CODE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_CODE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_EMP_IND |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ACT_EMP_IND |
ColumnName | ACT_EMP_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ACT_EMP_IND Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACT_EMP_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
ACT_EMP_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ACT_EMP_IND Security Types |
Name | Current Value |
ACT_EMP_IND Bound Attachments |
Name | Current Value |
ACT_EMP_IND Data Movement Rules |
Name | Type | Rule Text/Value |
ACT_EMP_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ACT_EMP_IND |
NO |
ACT_EMP_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_EMP_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_EMP_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_EMP_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | FIRST_NM |
ColumnName | FIRST_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FIRST_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FIRST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
FIRST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FIRST_NM Security Types |
Name | Current Value |
FIRST_NM Bound Attachments |
Name | Current Value |
FIRST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
FIRST_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER FIRST_NM |
NO |
FIRST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FIRST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDDLE_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | MIDDLE_NM |
ColumnName | MIDDLE_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MIDDLE_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MIDDLE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
MIDDLE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIDDLE_NM Security Types |
Name | Current Value |
MIDDLE_NM Bound Attachments |
Name | Current Value |
MIDDLE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
MIDDLE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER MIDDLE_NM |
NO |
MIDDLE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDDLE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDDLE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDDLE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NAME |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | LAST_NAME |
ColumnName | LAST_NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
LAST_NAME Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LAST_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
LAST_NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LAST_NAME Security Types |
Name | Current Value |
LAST_NAME Bound Attachments |
Name | Current Value |
LAST_NAME Data Movement Rules |
Name | Type | Rule Text/Value |
LAST_NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER LAST_NAME |
NO |
LAST_NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_FIRST_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PREF_FIRST_NM |
ColumnName | PREF_FIRST_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PREF_FIRST_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PREF_FIRST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
PREF_FIRST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PREF_FIRST_NM Security Types |
Name | Current Value |
PREF_FIRST_NM Bound Attachments |
Name | Current Value |
PREF_FIRST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
PREF_FIRST_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PREF_FIRST_NM |
NO |
PREF_FIRST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_FIRST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_FIRST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_FIRST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_MID_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PREF_MID_NM |
ColumnName | PREF_MID_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PREF_MID_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PREF_MID_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
PREF_MID_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PREF_MID_NM Security Types |
Name | Current Value |
PREF_MID_NM Bound Attachments |
Name | Current Value |
PREF_MID_NM Data Movement Rules |
Name | Type | Rule Text/Value |
PREF_MID_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PREF_MID_NM |
NO |
PREF_MID_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_MID_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_MID_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_MID_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_LAST_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PREF_LAST_NM |
ColumnName | PREF_LAST_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PREF_LAST_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PREF_LAST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
PREF_LAST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PREF_LAST_NM Security Types |
Name | Current Value |
PREF_LAST_NM Bound Attachments |
Name | Current Value |
PREF_LAST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
PREF_LAST_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PREF_LAST_NM |
NO |
PREF_LAST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_LAST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_LAST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PREF_LAST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BUILD |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | BUILD |
ColumnName | BUILD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BUILD Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BUILD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
BUILD Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BUILD Security Types |
Name | Current Value |
BUILD Bound Attachments |
Name | Current Value |
BUILD Data Movement Rules |
Name | Type | Rule Text/Value |
BUILD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER BUILD |
NO |
BUILD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BUILD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BUILD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BUILD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ROOM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ROOM |
ColumnName | ROOM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ROOM Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ROOM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ROOM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ROOM Security Types |
Name | Current Value |
ROOM Bound Attachments |
Name | Current Value |
ROOM Data Movement Rules |
Name | Type | Rule Text/Value |
ROOM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ROOM |
NO |
ROOM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ROOM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ROOM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ROOM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAIL_STOP |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | MAIL_STOP |
ColumnName | MAIL_STOP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MAIL_STOP Column Properties |
Datatype | VARCHAR2(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MAIL_STOP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
MAIL_STOP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MAIL_STOP Security Types |
Name | Current Value |
MAIL_STOP Bound Attachments |
Name | Current Value |
MAIL_STOP Data Movement Rules |
Name | Type | Rule Text/Value |
MAIL_STOP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER MAIL_STOP |
NO |
MAIL_STOP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAIL_STOP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MAIL_STOP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MAIL_STOP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CERT_MAIL_STOP |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | CERT_MAIL_STOP |
ColumnName | CERT_MAIL_STOP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CERT_MAIL_STOP Column Properties |
Datatype | VARCHAR2(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CERT_MAIL_STOP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
CERT_MAIL_STOP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CERT_MAIL_STOP Security Types |
Name | Current Value |
CERT_MAIL_STOP Bound Attachments |
Name | Current Value |
CERT_MAIL_STOP Data Movement Rules |
Name | Type | Rule Text/Value |
CERT_MAIL_STOP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER CERT_MAIL_STOP |
NO |
CERT_MAIL_STOP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CERT_MAIL_STOP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CERT_MAIL_STOP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CERT_MAIL_STOP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_PHONE_NO |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | WORK_PHONE_NO |
ColumnName | WORK_PHONE_NO |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
WORK_PHONE_NO Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
WORK_PHONE_NO Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
WORK_PHONE_NO Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WORK_PHONE_NO Security Types |
Name | Current Value |
WORK_PHONE_NO Bound Attachments |
Name | Current Value |
WORK_PHONE_NO Data Movement Rules |
Name | Type | Rule Text/Value |
WORK_PHONE_NO Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER WORK_PHONE_NO |
NO |
WORK_PHONE_NO Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_PHONE_NO Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_PHONE_NO Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_PHONE_NO Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FAX_NO |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | FAX_NO |
ColumnName | FAX_NO |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FAX_NO Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FAX_NO Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
FAX_NO Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FAX_NO Security Types |
Name | Current Value |
FAX_NO Bound Attachments |
Name | Current Value |
FAX_NO Data Movement Rules |
Name | Type | Rule Text/Value |
FAX_NO Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER FAX_NO |
NO |
FAX_NO Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FAX_NO Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FAX_NO Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FAX_NO Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CELL_NO |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | CELL_NO |
ColumnName | CELL_NO |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CELL_NO Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CELL_NO Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
CELL_NO Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CELL_NO Security Types |
Name | Current Value |
CELL_NO Bound Attachments |
Name | Current Value |
CELL_NO Data Movement Rules |
Name | Type | Rule Text/Value |
CELL_NO Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER CELL_NO |
NO |
CELL_NO Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CELL_NO Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CELL_NO Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CELL_NO Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_NO |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PAGER_NO |
ColumnName | PAGER_NO |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAGER_NO Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAGER_NO Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
PAGER_NO Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PAGER_NO Security Types |
Name | Current Value |
PAGER_NO Bound Attachments |
Name | Current Value |
PAGER_NO Data Movement Rules |
Name | Type | Rule Text/Value |
PAGER_NO Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PAGER_NO |
NO |
PAGER_NO Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_NO Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_NO Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_NO Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_EXT |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PAGER_EXT |
ColumnName | PAGER_EXT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAGER_EXT Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAGER_EXT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
PAGER_EXT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PAGER_EXT Security Types |
Name | Current Value |
PAGER_EXT Bound Attachments |
Name | Current Value |
PAGER_EXT Data Movement Rules |
Name | Type | Rule Text/Value |
PAGER_EXT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PAGER_EXT |
NO |
PAGER_EXT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_EXT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_EXT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_EXT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_CARR_NM |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PAGER_CARR_NM |
ColumnName | PAGER_CARR_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAGER_CARR_NM Column Properties |
Datatype | VARCHAR2(3) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAGER_CARR_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
PAGER_CARR_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PAGER_CARR_NM Security Types |
Name | Current Value |
PAGER_CARR_NM Bound Attachments |
Name | Current Value |
PAGER_CARR_NM Data Movement Rules |
Name | Type | Rule Text/Value |
PAGER_CARR_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PAGER_CARR_NM |
NO |
PAGER_CARR_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_CARR_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_CARR_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_CARR_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_TYPE |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PAGER_TYPE |
ColumnName | PAGER_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAGER_TYPE Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAGER_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
PAGER_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PAGER_TYPE Security Types |
Name | Current Value |
PAGER_TYPE Bound Attachments |
Name | Current Value |
PAGER_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
PAGER_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PAGER_TYPE |
NO |
PAGER_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAGER_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOME_PAGE_URL |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | HOME_PAGE_URL |
ColumnName | HOME_PAGE_URL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
HOME_PAGE_URL Column Properties |
Datatype | VARCHAR2(100) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HOME_PAGE_URL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 100 |
Percent Null | 0 |
HOME_PAGE_URL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HOME_PAGE_URL Security Types |
Name | Current Value |
HOME_PAGE_URL Bound Attachments |
Name | Current Value |
HOME_PAGE_URL Data Movement Rules |
Name | Type | Rule Text/Value |
HOME_PAGE_URL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER HOME_PAGE_URL |
NO |
HOME_PAGE_URL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOME_PAGE_URL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOME_PAGE_URL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOME_PAGE_URL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_LOC_CODE |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PHYS_LOC_CODE |
ColumnName | PHYS_LOC_CODE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PHYS_LOC_CODE Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PHYS_LOC_CODE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
PHYS_LOC_CODE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PHYS_LOC_CODE Security Types |
Name | Current Value |
PHYS_LOC_CODE Bound Attachments |
Name | Current Value |
PHYS_LOC_CODE Data Movement Rules |
Name | Type | Rule Text/Value |
PHYS_LOC_CODE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PHYS_LOC_CODE |
NO |
PHYS_LOC_CODE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_LOC_CODE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_LOC_CODE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PHYS_LOC_CODE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | EMAIL_ADDR |
ColumnName | EMAIL_ADDR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMAIL_ADDR Column Properties |
Datatype | VARCHAR2(100) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 100 |
Percent Null | 0 |
EMAIL_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMAIL_ADDR Security Types |
Name | Current Value |
EMAIL_ADDR Bound Attachments |
Name | Current Value |
EMAIL_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
EMAIL_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER EMAIL_ADDR |
NO |
EMAIL_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_ID |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ORG_ID |
ColumnName | ORG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORG_ID Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ORG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORG_ID Security Types |
Name | Current Value |
ORG_ID Bound Attachments |
Name | Current Value |
ORG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
ORG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ORG_ID |
NO |
ORG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_POS |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | EMP_POS |
ColumnName | EMP_POS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMP_POS Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMP_POS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
EMP_POS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMP_POS Security Types |
Name | Current Value |
EMP_POS Bound Attachments |
Name | Current Value |
EMP_POS Data Movement Rules |
Name | Type | Rule Text/Value |
EMP_POS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER EMP_POS |
NO |
EMP_POS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_POS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_POS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_POS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAYROLL |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | PAYROLL |
ColumnName | PAYROLL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAYROLL Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAYROLL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
PAYROLL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PAYROLL Security Types |
Name | Current Value |
PAYROLL Bound Attachments |
Name | Current Value |
PAYROLL Data Movement Rules |
Name | Type | Rule Text/Value |
PAYROLL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER PAYROLL |
NO |
PAYROLL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAYROLL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PAYROLL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PAYROLL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_GROUP |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | EMP_GROUP |
ColumnName | EMP_GROUP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMP_GROUP Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMP_GROUP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
EMP_GROUP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMP_GROUP Security Types |
Name | Current Value |
EMP_GROUP Bound Attachments |
Name | Current Value |
EMP_GROUP Data Movement Rules |
Name | Type | Rule Text/Value |
EMP_GROUP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER EMP_GROUP |
NO |
EMP_GROUP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_GROUP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_GROUP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_GROUP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_SUBGROUP |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | EMP_SUBGROUP |
ColumnName | EMP_SUBGROUP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMP_SUBGROUP Column Properties |
Datatype | VARCHAR2(2) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMP_SUBGROUP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
EMP_SUBGROUP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMP_SUBGROUP Security Types |
Name | Current Value |
EMP_SUBGROUP Bound Attachments |
Name | Current Value |
EMP_SUBGROUP Data Movement Rules |
Name | Type | Rule Text/Value |
EMP_SUBGROUP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER EMP_SUBGROUP |
NO |
EMP_SUBGROUP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_SUBGROUP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_SUBGROUP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMP_SUBGROUP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUPR_BN |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | SUPR_BN |
ColumnName | SUPR_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SUPR_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUPR_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
SUPR_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUPR_BN Security Types |
Name | Current Value |
SUPR_BN Bound Attachments |
Name | Current Value |
SUPR_BN Data Movement Rules |
Name | Type | Rule Text/Value |
SUPR_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER SUPR_BN |
NO |
SUPR_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUPR_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUPR_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUPR_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SECR_BN |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | SECR_BN |
ColumnName | SECR_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SECR_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SECR_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
SECR_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SECR_BN Security Types |
Name | Current Value |
SECR_BN Bound Attachments |
Name | Current Value |
SECR_BN Data Movement Rules |
Name | Type | Rule Text/Value |
SECR_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER SECR_BN |
NO |
SECR_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SECR_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SECR_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SECR_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_STAT |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | WORK_STAT |
ColumnName | WORK_STAT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
WORK_STAT Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
WORK_STAT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
WORK_STAT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WORK_STAT Security Types |
Name | Current Value |
WORK_STAT Bound Attachments |
Name | Current Value |
WORK_STAT Data Movement Rules |
Name | Type | Rule Text/Value |
WORK_STAT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER WORK_STAT |
NO |
WORK_STAT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_STAT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_STAT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WORK_STAT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_CODE |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | SHIFT_CODE |
ColumnName | SHIFT_CODE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SHIFT_CODE Column Properties |
Datatype | VARCHAR2(2) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SHIFT_CODE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
SHIFT_CODE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SHIFT_CODE Security Types |
Name | Current Value |
SHIFT_CODE Bound Attachments |
Name | Current Value |
SHIFT_CODE Data Movement Rules |
Name | Type | Rule Text/Value |
SHIFT_CODE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER SHIFT_CODE |
NO |
SHIFT_CODE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_CODE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_CODE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_CODE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
COCS_CODE |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | COCS_CODE |
ColumnName | COCS_CODE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
COCS_CODE Column Properties |
Datatype | VARCHAR2(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
COCS_CODE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
COCS_CODE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
COCS_CODE Security Types |
Name | Current Value |
COCS_CODE Bound Attachments |
Name | Current Value |
COCS_CODE Data Movement Rules |
Name | Type | Rule Text/Value |
COCS_CODE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER COCS_CODE |
NO |
COCS_CODE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
COCS_CODE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
COCS_CODE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
COCS_CODE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL1 |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ORGLVL1 |
ColumnName | ORGLVL1 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORGLVL1 Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORGLVL1 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ORGLVL1 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORGLVL1 Security Types |
Name | Current Value |
ORGLVL1 Bound Attachments |
Name | Current Value |
ORGLVL1 Data Movement Rules |
Name | Type | Rule Text/Value |
ORGLVL1 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ORGLVL1 |
NO |
ORGLVL1 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL1 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL1 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL1 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL2 |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ORGLVL2 |
ColumnName | ORGLVL2 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORGLVL2 Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORGLVL2 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ORGLVL2 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORGLVL2 Security Types |
Name | Current Value |
ORGLVL2 Bound Attachments |
Name | Current Value |
ORGLVL2 Data Movement Rules |
Name | Type | Rule Text/Value |
ORGLVL2 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ORGLVL2 |
NO |
ORGLVL2 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL2 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL2 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL2 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL3 |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ORGLVL3 |
ColumnName | ORGLVL3 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORGLVL3 Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORGLVL3 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ORGLVL3 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORGLVL3 Security Types |
Name | Current Value |
ORGLVL3 Bound Attachments |
Name | Current Value |
ORGLVL3 Data Movement Rules |
Name | Type | Rule Text/Value |
ORGLVL3 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ORGLVL3 |
NO |
ORGLVL3 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL3 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL3 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL3 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL4 |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | ORGLVL4 |
ColumnName | ORGLVL4 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORGLVL4 Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORGLVL4 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
ORGLVL4 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORGLVL4 Security Types |
Name | Current Value |
ORGLVL4 Bound Attachments |
Name | Current Value |
ORGLVL4 Data Movement Rules |
Name | Type | Rule Text/Value |
ORGLVL4 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER ORGLVL4 |
NO |
ORGLVL4 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL4 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL4 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORGLVL4 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
COST_DIV |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | COST_DIV |
ColumnName | COST_DIV |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
COST_DIV Column Properties |
Datatype | VARCHAR2(8) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
COST_DIV Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
COST_DIV Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
COST_DIV Security Types |
Name | Current Value |
COST_DIV Bound Attachments |
Name | Current Value |
COST_DIV Data Movement Rules |
Name | Type | Rule Text/Value |
COST_DIV Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER COST_DIV |
NO |
COST_DIV Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
COST_DIV Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
COST_DIV Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
COST_DIV Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIV |
Base Object | PSEUDO_ELOG_USER |
Attribute Name | DIV |
ColumnName | DIV |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DIV Column Properties |
Datatype | VARCHAR2(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DIV Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
DIV Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DIV Security Types |
Name | Current Value |
DIV Bound Attachments |
Name | Current Value |
DIV Data Movement Rules |
Name | Type | Rule Text/Value |
DIV Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Instrument Logbook (Oracle) PSEUDO_ELOG_USER DIV |
NO |
DIV Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIV Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIV Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIV Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |