Log Entry Id |
Base Entity | Daily Order Required Reading |
Attribute Name | Log Entry Id |
Logical Rolename | |
ColumnName | Log Entry Id |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Log Entry Identifier: The unique identifier for a log entry. This number is automatically generated in sequential order. |
Note |
Log Entry Id Logical Attribute Properties |
Logical Attribute Name | Log Entry Id |
Datatype | INTEGER |
Nullable | NO |
Log Entry Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Log Entry Id Security Types |
Name | Current Value |
Log Entry Id Bound Attachments |
Name | Current Value |
Log Entry Id Data Movement Rules |
Name | Type | Rule Text/Value |
Log Entry Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading Log Entry Id |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ Log Entry Id |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ 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 |
In Effect Ind |
Base Entity | Daily Order Required Reading |
Attribute Name | In Effect Ind |
Logical Rolename | |
ColumnName | In Effect Ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | In Effect Indicator: Indicates the Daily Order is in effect and must be acknowledged by the Operator. |
Note |
In Effect Ind Logical Attribute Properties |
Logical Attribute Name | In Effect Ind |
Datatype | CHAR(1) |
Nullable | NO |
In Effect Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
In Effect 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 |
In Effect Ind Security Types |
Name | Current Value |
In Effect Ind Bound Attachments |
Name | Current Value |
In Effect Ind Data Movement Rules |
Name | Type | Rule Text/Value |
In Effect Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading In Effect Ind |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ In Effect Ind |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ IN_EFFECT_IND |
NO |
In Effect Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
In Effect Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
In Effect Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
In Effect Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Reqd Read Freq Id |
Base Entity | Daily Order Required Reading |
Attribute Name | Reqd Read Freq Id |
Logical Rolename | |
ColumnName | REQD_READ_FREQ_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Required Reading Frequency Identifier: Unique numeric identifier for the required reading frequencies. |
Note |
Reqd Read Freq Id Logical Attribute Properties |
Logical Attribute Name | Reqd Read Freq Id |
Datatype | INTEGER |
Nullable | YES |
Reqd Read Freq Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Reqd Read Freq Id Security Types |
Name | Current Value |
Reqd Read Freq Id Bound Attachments |
Name | Current Value |
Reqd Read Freq Id Data Movement Rules |
Name | Type | Rule Text/Value |
Reqd Read Freq Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading Reqd Read Freq Id |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ REQD_READ_FREQ_ID |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ REQD_READ_FREQ_ID |
NO |
Reqd Read Freq Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Reqd Read Freq Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Reqd Read Freq Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Reqd Read Freq Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Creation Date |
Base Entity | Daily Order Required Reading |
Attribute Name | Daily Order Creation Date |
Logical Rolename | |
ColumnName | DO_CREATE_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Daily Order Creation Date Logical Attribute Properties |
Logical Attribute Name | Daily Order Creation Date |
Datatype | DATE |
Nullable | YES |
Daily Order Creation Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Daily Order Creation Date Security Types |
Name | Current Value |
Daily Order Creation Date Bound Attachments |
Name | Current Value |
Daily Order Creation Date Data Movement Rules |
Name | Type | Rule Text/Value |
Daily Order Creation Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading Daily Order Creation Date |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ DO_CREATE_DTE |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ DO_CREATE_DTE |
NO |
Daily Order Creation Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Creation Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Creation Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Creation Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Expiration Date |
Base Entity | Daily Order Required Reading |
Attribute Name | Daily Order Expiration Date |
Logical Rolename | |
ColumnName | DO_EXP_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Daily Order Expiration Date Logical Attribute Properties |
Logical Attribute Name | Daily Order Expiration Date |
Datatype | DATE |
Nullable | YES |
Daily Order Expiration Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Daily Order Expiration Date Security Types |
Name | Current Value |
Daily Order Expiration Date Bound Attachments |
Name | Current Value |
Daily Order Expiration Date Data Movement Rules |
Name | Type | Rule Text/Value |
Daily Order Expiration Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading Daily Order Expiration Date |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ DO_EXP_DTE |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ DO_EXP_DTE |
NO |
Daily Order Expiration Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Expiration Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Expiration Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Daily Order Expiration Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte |
Base Entity | Daily Order Required Reading |
Attribute Name | Mod Dte |
Logical Rolename | |
ColumnName | Mod Date |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Mod Dte Logical Attribute Properties |
Logical Attribute Name | Mod Dte |
Datatype | DATE |
Nullable | NO |
Mod Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Mod Dte Security Types |
Name | Current Value |
Mod Dte Bound Attachments |
Name | Current Value |
Mod Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Mod Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Daily Order Required Reading Mod Dte |
NO | ||
Instrument Logbook (Oracle) DAILY_ORDER_REQD_READ Mod Date |
NO | ||
Logbook (Oracle) DAILY_ORDER_REQD_READ MOD_DTE |
NO |
Mod Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |