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 |