Table Detail Report

ORG_TYPE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Type Relationship
Definition: The organization type relationship identifies the different roles that an organization can play within the system. For example, XYZ Company is an employer and a hospital.
Table Type: REFERENCE





Column Detail - ORG_TYPE_RELTN


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.
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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
ORG_TYPE_CD DOUBLE N Identifies the kind of organization. An organization can play different roles depending on relationships to other entities, therefore, an organization can have multiple organization
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 - ORG_TYPE_RELTN


Child Column in ORG_TYPE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PPR_CONSENT_POLICY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PPR Consent Policy
Definition: This table contains the consent policy which could be tied to an organization to the system.
Table Type: REFERENCE





Column Detail - PPR_CONSENT_POLICY


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
BLOB_REF_SCAN_ID DOUBLE N Blob reference id for a scanned in documents.
COMMENT_TXT VARCHAR(250) Y Contains any comments about the policy.
CONSENT_POLICY_ID DOUBLE N The Consent Policy Id that is maintained for all the minor versions. The unique primary key of this table.
CONSENT_TYPE_CD DOUBLE N Contains the code for the type of consent. An example would be privacy, record access, consent to treat, etc.
END_EFFECTIVE_DT_TM DATETIME Y 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.
EXTERNAL_ORG_CD DOUBLE N This code identifies the external organization related to this policy.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NAME_CD DOUBLE N The name of the policy.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
POLICY_ID DOUBLE N The Primary Key from the sequence Patient_privacy_seq
POLICY_MODEL_FLAG DOUBLE N Identifies the policy model; 0 - None; 1 - Pass-Through; 2 - Opt-In; 3 - Opt-Out
POLICY_TEXT_ID DOUBLE N The Long Blob ID where the Policy Text is stored.
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.
VERSION_NBR DOUBLE N Version Number for the policy updated automatically by the system, Read only by the application.



Relationship Detail - PPR_CONSENT_POLICY


Child Column in PPR_CONSENT_POLICY(FK) Parent Table Name Parent Column Name
Parents: BLOB_REF_SCAN_ID BLOB_REFERENCE BLOB_REF_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
POLICY_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in PPR_CONSENT_POLICY (PK) Child Table Name Child Column Name
Children: CONSENT_POLICY_ID ORG_CONTRIBUTOR_SYS_RELTN CONSENT_POLICY_ID
PPR_CONSENT_STATUS CONSENT_POLICY_ID


RESEARCH_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Research Account
Definition: Table used to store research accounts and information about them
Table Type: REFERENCE





Column Detail - RESEARCH_ACCOUNT


Column Name Type Null? Definition
ACCOUNT_NBR CHAR(100) Y Account Number associated with this research account
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 Y 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.
DESCRIPTION CHAR(100) Y Free-text description of the research account
ENCNTR_TYPE_CD DOUBLE N The encounter type that should be defaulted if this research account is used.
END_EFFECTIVE_DT_TM DATETIME Y 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.
NAME CHAR(40) Y Name of the research account
NAME_KEY CHAR(100) Y Keyed attribute used internally and derived from the name attribute
ORGANIZATION_ID DOUBLE N Organization that this research account is associated with.
RESEARCH_ACCOUNT_ID DOUBLE N Primary Key Attribute
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 - RESEARCH_ACCOUNT


Child Column in RESEARCH_ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in RESEARCH_ACCOUNT (PK) Child Table Name Child Column Name
Children: RESEARCH_ACCOUNT_ID ENCNTR_ORG_RELTN RESEARCH_ACCOUNT_ID
ORDER_DISPENSE RESEARCH_ACCOUNT_ID
PROT_CRPC_BILLING PROT_RESEARCH_ACCOUNT_ID