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 |