Table Detail Report

OUTBOUND_FIELD_PROCESSING



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO Outbound Field Processing Table
Definition: Defines the field processing methods for outbound transaction from HNA Millenium
Table Type: REFERENCE





Column Detail - OUTBOUND_FIELD_PROCESSING


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FIELD_PROCESSING_CD DOUBLE N This field defines the processing method for the specified processing type.
FIELD_PROCESSING_CS DOUBLE Y This field defines the code_set for the processing method for the specified processing type.
NULL_STRING VARCHAR(200) Y This defines a string attribute associated with the process type.
PROCESS_TYPE_CD DOUBLE N Define the processing type entity.
SEQ_NUM DOUBLE N Defines the sequence number in the table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OUTBOUND_FIELD_PROCESSING




Parent Column in OUTBOUND_FIELD_PROCESSING (PK) Child Table Name Child Column Name
Children: CONTRIBUTOR_SYSTEM_CD SI_OUTBOUND_FIELD_PROCESS_HIST CONTRIBUTOR_SYSTEM_CD
PROCESS_TYPE_CD SI_OUTBOUND_FIELD_PROCESS_HIST PROCESS_TYPE_CD


OUTBOUND_SELECTION



Column Section Top of Page


Table-level Detail

Description: ESO Outbound Selection Table
Definition: Defines the selection criteria for outbound transaction from HNA Millenium
Table Type: REFERENCE





Column Detail - OUTBOUND_SELECTION


Column Name Type Null? Definition
ACTION_TYPE_CD DOUBLE N Send transaction based upon order action type (i.e. New Order, Complete, ...)
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_TYPE_CD DOUBLE N Send transactions based upon order activity type
AFTER_DISCHARGE_IND DOUBLE Y Send transaction based upon patient discharge, the NUMBER_OF_DAYS element should be used to specify the days after discharge
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CS_FLAG DOUBLE Y Order Management Careset Flag
DEPT_ORDER_STATUS_CD DOUBLE N Send transaction based upon the department status of the order.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FROM_CONTRIB_SYS_CD DOUBLE N Send transactions based upon the "FROM" sending contributor system. This field is typically associated with order transaction.
HL7_EVENT_CD DOUBLE N Send transactions based upon the HL7 trigger event code. Examples are A01, A02, ALL ADTS, etc.
HL7_ORDER_CTRL_CD DOUBLE N Send Order Transactions based upon the HL7 Order Control Mnemonic.
NUMBER_OF_DAYS DOUBLE Y When the AFTER_DISCHARGE_IND is set, this send transactions if the number of days after discharge of the patient meets or exceeds this number
ORDERABLE_TYPE_FLAG DOUBLE Y Order Management Orderable Type Flag.
ORDER_STATUS_CD DOUBLE N Send transaction based upon the order status.
ORDER_TEMPLATE_FLAG DOUBLE Y Send transaction based upon whether the order is part os a template
ORGANIZTION_ID DOUBLE N Send transaction based upon organization Id. This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PATIENT_TYPE_CD DOUBLE N Send transaction based upon patient type. Encounter type is synonymous with patient type. Encounter type is used to categorize patients into inpatient and outpatient groups.
PROCESSING_CD DOUBLE N This field identifies the processing method for each row. The typical configuration will identify whether to send or don't send.
SELECTION_TYPE_CD DOUBLE N Identifies the selection criteria for the DB row. This is part of the unique identifier for this table.
SEQ_NUM DOUBLE N Defines the sequence number in the table.
TO_CONTRIB_SYS_CD DOUBLE N Send transactions based upon the "TO" sending contributor system. This field is typically associated with order transaction.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


SIM_QUEUE_DETAIL_INFO



Column Section Top of Page


Table-level Detail

Description: SIM Queue Detail Information
Definition: This table contains details for the Cerner defined Queue Detail options. It is related to the FSIESO_QUE_DETAIL->Parent_Entity_Name
Table Type: REFERENCE





Column Detail - SIM_QUEUE_DETAIL_INFO


Column Name Type Null? Definition
ENTITY_DISPLAY VARCHAR(60) N This value is used if the Entity_Name is unclear in descriptive terms. Display this value to the user if populated.
ENTITY_NAME VARCHAR(40) N This value ties to the PARENT_ENTITY_NAMEs on the FSIESO_QUE_DETAIL table.
ENTITY_TYPE_FLAG DOUBLE N This value describes the type of values available for this Entity_Name. 0 - No Description 1 - Code Set 2 - ID
ENTITY_TYPE_SOURCE_NBR DOUBLE N This is the numerical value that describes the source of the Entity_Name.
ENTITY_TYPE_SOURCE_TEXT VARCHAR(255) N This is a textual description of the options available for the Entity_Name. Example - 'Person', 'Chart Trigger ID'. This can also hold delaminated values.
OCCURRENCE_NBR DOUBLE N This value is interpreted by the calling application to decide upon placement. This value is a binary enumerator. Each bit represents a specific section of the search. 0 means that the value is displayed everywhere.
SIM_QUEUE_DETAIL_INFO_ID DOUBLE N Primary key for this table. Value comes from ESO_SEQ sequence
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


SI_CODE_SET_INTERFACE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Code Set Interface History
Definition: This table store historical information created by modifications to the CODE_SET_INTERFACE table.
Table Type: REFERENCE





Column Detail - SI_CODE_SET_INTERFACE_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIAS_TYPE_MEANING VARCHAR(12) N The Alias Type Meaning of the modified record from the Code Set Interface table.
CODE_SET DOUBLE N The Code Set of the modified record from the Code Set Interface table.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DEFAULT_ALIAS VARCHAR(255) N The Default Alias of the modified record from the Code Set Interface table.
DEFAULT_CD DOUBLE N The Default Code of the modified record from the Code Set Interface table.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the code_set_interface table
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original record on the code_set_interface table
PARENT_ACTIVE_IND DOUBLE N Active_Ind of the modified record from the code_set_interface table
PROCESS_CD DOUBLE N The Process Code of the modified record from the Code Set Interface table.
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM from the code_set_interface Table
SI_CODE_SET_INTERFACE_HIST_ID DOUBLE N Primary Key
SYS_DIRECTION_CD DOUBLE N The System Direction code of the modified record from the Code Set Interface table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SI_CODE_SET_INTERFACE_HIST


Child Column in SI_CODE_SET_INTERFACE_HIST(FK) Parent Table Name Parent Column Name
Parents: MODIFY_PRSNL_ID PRSNL PERSON_ID
ORIG_PRSNL_ID PRSNL PERSON_ID


SI_OUTBOUND_FIELD_PROCESS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Outbound Field Processing History
Definition: This table contains records related to the Outbound Field Processing table.
Table Type: REFERENCE





Column Detail - SI_OUTBOUND_FIELD_PROCESS_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FIELD_PROCESSING_CD DOUBLE N This field defines the processing method for the specified processing type.
FIELD_PROCESSING_CS DOUBLE N This field defines the code_set for the processing method for the specified processing type.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the Outbound_Field_Processing table
NULL_STRING VARCHAR(200) Y This defines a string attribute associated with the process type.
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original modification on the Outbound_Field_Processing table
PROCESS_TYPE_CD DOUBLE N Define the processing type entity.
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM from the Outbound_Field_Processing Table
SEQ_NUM DOUBLE N Defines the sequence number of the related outbound field processin the table.
SI_OUTBOUND_FIELD_PRCS_HIST_ID DOUBLE N Primary Key column
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SI_OUTBOUND_FIELD_PROCESS_HIST


Child Column in SI_OUTBOUND_FIELD_PROCESS_HIST(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD OUTBOUND_FIELD_PROCESSING CONTRIBUTOR_SYSTEM_CD
PROCESS_TYPE_CD OUTBOUND_FIELD_PROCESSING PROCESS_TYPE_CD
MODIFY_PRSNL_ID PRSNL PERSON_ID
ORIG_PRSNL_ID PRSNL PERSON_ID