Table Detail Report

SI_PROPERTY_NAME



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Property Name
Definition: This table stores a reusable set of property names, that can be used on other tables e.g. SI_SERVICE_PROPERTY.
Table Type: REFERENCE





Column Detail - SI_PROPERTY_NAME


Column Name Type Null? Definition
APPLICATION_CONTEXT VARCHAR(60) N The application context that owns the property name extension. This value can be: REQUEST_IMMUNIZATION_HISTORY
PROPERTY_DESCRIPTION VARCHAR(255) N The property name description.
PROPERTY_NAME VARCHAR(60) N The property name
SI_PROPERTY_NAME_ID DOUBLE N PRIMARY KEY
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_PROPERTY_NAME




Parent Column in SI_PROPERTY_NAME (PK) Child Table Name Child Column Name
Children: SI_PROPERTY_NAME_ID SI_PROPERTY_NAME_EXT SI_PROPERTY_NAME_ID


SI_PROPERTY_NAME_EXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Property Name Extension
Definition: This table stores property name extensions for the SI_PROPERTY_NAME table. The extensions will identify how a property should be used, and default values.
Table Type: REFERENCE





Column Detail - SI_PROPERTY_NAME_EXT


Column Name Type Null? Definition
EXTENSION_SEQUENCE DOUBLE N Sequence of the extension, when an extension type has multiple extension values.
EXTENSION_TYPE VARCHAR(60) N The property name extension type. This value can be: CLIENT_SERVICE_PROPERTY, HL7_FIELD, OEN_HEADER_NAME
EXTENSION_VALUE_TXT VARCHAR(255) N The corresponding property name extension type value
SI_PROPERTY_NAME_EXT_ID DOUBLE N PRIMARY KEY
SI_PROPERTY_NAME_ID DOUBLE N FK value from the SI_PROPERTY_NAME table. Lilnks to the Property Name.
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_PROPERTY_NAME_EXT


Child Column in SI_PROPERTY_NAME_EXT(FK) Parent Table Name Parent Column Name
Parents: SI_PROPERTY_NAME_ID SI_PROPERTY_NAME SI_PROPERTY_NAME_ID


SI_REPO_REG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Repository Registry Relation
Definition: Relates registered document information with repository information.
Table Type: ACTIVITY





Column Detail - SI_REPO_REG_RELTN


Column Name Type Null? Definition
ACK_SI_MESSAGE_LOG_ID DOUBLE N Foreign key to the SI_MESSAGE_LOG table for the audited transport protocol message containing the acknowledgement after it is received inbound.
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.
DOCUMENT_ENTRY_UUID VARCHAR(50) Y XDSDocumentEntry entryUUID
ENDPOINT_URL VARCHAR(255) Y The endpoint URL that is the target of a document registration or the source of a document retrieval.
LONG_TEXT_ID DOUBLE N Foreign Key to the LONG_TEXT table
MESSAGE_TYPE VARCHAR(100) Y Type of document registration message sent to/received from a repository. Valid values are ProvideAndRegister, Register, RegisterOnDemand, Retrieve, and RetrieveOnDemand
QUEUE_ID DOUBLE N Foreign key to the CQM_OENINTERFACE_QUE table for the document that has been enqueued to Open Engine.
REQUEST_STATUS_FLAG DOUBLE N The Status of the request to registry from the related repository.
SI_DOCUMENT_INFO_ID DOUBLE N FK value from table SI_DOCUMENT_INFO
SI_MESSAGE_LOG_ID DOUBLE N Foreign key to the SI_MESSAGE_LOG table for the audited transport protocol message containing the document submission after it is sent outbound.
SI_REPO_REG_RELTN_ID DOUBLE N Primary Key to the SI_Repo_Reg_Reltn table.
SUBMISSION_ENTRY_UUID VARCHAR(50) Y XDSSubmissionSet entryUUID
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SI_REPO_REG_RELTN


Child Column in SI_REPO_REG_RELTN(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_OENINTERFACE_QUE QUEUE_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SI_DOCUMENT_INFO_ID SI_DOCUMENT_INFO SI_DOCUMENT_INFO_ID
ACK_SI_MESSAGE_LOG_ID SI_MESSAGE_LOG SI_MESSAGE_LOG_ID
SI_MESSAGE_LOG_ID SI_MESSAGE_LOG SI_MESSAGE_LOG_ID


SI_SERVICE_PROPERTY



Column Section Top of Page


Table-level Detail

Description: SI SERVICE PROPERTY
Definition: Service Properties
Table Type: REFERENCE





Column Detail - SI_SERVICE_PROPERTY


Column Name Type Null? Definition
ENCRYPTION_FLAG DOUBLE N modes of encryption Flag Values: 0 = MODE ZERO , 1 = MODE ONE
PARENT_ENTITY_ID DOUBLE N Entity the property is associated with.ID value from the table name identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Contains the table name related to the PARENT_ENTITY_ID value
PROP_NAME VARCHAR(100) N The Name of the Property
PROP_VALUE VARCHAR(255) Y The Property Value
SI_SERVICE_PROPERTY_ID DOUBLE N PRIMARY KEY
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_SERVICE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Service Relation
Definition: Relates entities like Contributor Systems and OIDs to Services
Table Type: REFERENCE





Column Detail - SI_SERVICE_RELTN


Column Name Type Null? Definition
AUTHORIZATION_TYPE_CD DOUBLE N Authorization Type Code
AUTH_LOCATION_URI VARCHAR(255) Y Location of the Authorization Uniform Resource Identifier
CERTIFICATE_LOCATION_URI VARCHAR(255) Y Location of the Certificate Uniform Resource Identifier
CERTIFICATE_TYPE_CD DOUBLE N Certificate Type Code
CONTENT_CAT_FILTER_CD DOUBLE N Optional value used to filter services to used based on the content category of the service request.
DEFAULT_IND DOUBLE N Indicates that this row is the default reltn to use based on the external_service_type_cd, parent_entity_name, parent_entity_id, and content_cat_filter_cd values
EXTERNAL_SERVICE_TYPE_CD DOUBLE N The type of service utilized for this system.
LISTENER_ALIAS VARCHAR(48) Y The selected Listener Alias used for processing as it relates to the External Service.
PARENT_ENTITY_ID DOUBLE N The primary key of the entity table related to the service.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the entity that will relate to the service in question. This value can be CONTRIBUTOR_SYSTEM, LOCATION, ORGANIZATION, or SI_OID.
SERVICE_URI VARCHAR(512) Y Location of the Service Uniform Resource Identifier
SI_EXTERNAL_SERVICE_ID DOUBLE N Number that identifies a single row on the SI_EXTERNAL_SERVICE table
SI_SERVICE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the SI_SERVICE_RELTN table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SI_SERVICE_RELTN


Child Column in SI_SERVICE_RELTN(FK) Parent Table Name Parent Column Name
Parents: SI_EXTERNAL_SERVICE_ID SI_EXTERNAL_SERVICE SI_EXTERNAL_SERVICE_ID