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 |