GROUP_ENTITY_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | Group Entity Relationship |
Definition: | This table will be used to store relationships between Organization and Organization Group. |
Table Type: | REFERENCE |
Column Detail - GROUP_ENTITY_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
COLLATION_SEQ | DOUBLE | N | sequence of collation |
GROUP_ENTITY_RELTN_ID | DOUBLE | N | The unique ID of the group relation. |
GROUP_ID | DOUBLE | N | Group identifier e.g. ORG_SET_ID or PERSON_GROUP_ID |
GROUP_NAME | VARCHAR(30) | N | Group Name - e.g. Org group, Personnel Group |
RELATED_ID | DOUBLE | N | Related Identifier, e.g. Organization_ID |
RELATED_NAME | VARCHAR(30) | N | Related Name, e.g. "ORGANIZATION" |
RELATED_TYPE_CD | DOUBLE | N | Code value of relation type |
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. |
ORGANIZATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Organization |
Definition: | The organization table is a reference of the business entities in the system. Examples of some types of organizations are as follows: employer, client, hospital, blood center, IHO, insurance co., medical review organization, reference lab, etc. |
Table Type: | REFERENCE |
Column Detail - ORGANIZATION
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_SOURCE_CD | DOUBLE | Y | The code value for the contributing system. |
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. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
EXTERNAL_IND | DOUBLE | N | Set to true (1), if the personnel is external to the hospital network. Otherwise, set to false (0). |
FEDERAL_TAX_ID_NBR | VARCHAR(100) | Y | The federal tax id number assigned to the organization by the Internal Revenue Service for reporting purposes. |
FT_ENTITY_ID | DOUBLE | N | Primary key of the table row associated with a free text row. |
FT_ENTITY_NAME | VARCHAR(32) | Y | Name of the table associated with a free text row. |
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. |
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_CLASS_CD | DOUBLE | N | Organization Class Code Value (free text or authenticated organization) |
ORG_NAME | VARCHAR(100) | N | The name of the organization. |
ORG_NAME_KEY | VARCHAR(100) | Y | This organization name in all capitals with punctuation removed. This field is used for indexing and searching for a organization by name. |
ORG_NAME_KEY_A_NLS | VARCHAR(400) | Y | ORG_NAME_KEY_A_NLS column |
ORG_NAME_KEY_NLS | VARCHAR(202) | Y | Org Name Key field converted to NLS format for internationalization requirements. |
ORG_STATUS_CD | DOUBLE | N | The organization status indicates the rank, standing or condition of the business entity (I.e., bankrupt) |
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 - ORGANIZATION
Child Column in ORGANIZATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in ORGANIZATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORGANIZATION_ID | ACCRED_SYSTEM | ORGANIZATION_ID |
AC_CLASS_PERSON_RELTN | ORGANIZATION_ID | ||
ADDITIONAL_AMOUNT_DEF | ORGANIZATION_ID | ||
ALLERGY | ORGANIZATION_ID | ||
BATCH_TRANS | PAYEE_ORG_ID | ||
BATCH_TRANS | PAYOR_ORG_ID | ||
BATCH_TRANS_FILE | CC_TRANS_ORG_ID | ||
BATCH_TRANS_FILE | PAYOR_ORG_ID | ||
BBHIST_PRODUCT | SUPPLIER_ID | ||
BB_EDN_ADMIN | SOURCE_ORG_ID | ||
BB_FACILITY_PRINTER_R | BB_ORGANIZATION_ID | ||
BB_GS1_GTIN | MANUFACTURER_ID | ||
BB_ISBT_SUPPLIER | ORGANIZATION_ID | ||
BB_MOD_NEW_PRODUCT | DEFAULT_SUPPLIER_ID | ||
BB_MOD_POOL_NBR | ORGANIZATION_ID | ||
BB_SHIPMENT | ORGANIZATION_ID | ||
BB_SUPPLIER | ORGANIZATION_ID | ||
BE_HISTORY | ORGANIZATION_ID | ||
BE_ORG_RELTN | ORGANIZATION_ID | ||
BILLING_ENTITY | ORGANIZATION_ID | ||
BT_COND_CRIT_GRP_RELTN | ORGANIZATION_ID | ||
BUSINESS_SERVICE | ORGANIZATION_ID | ||
CBOS_PERSON_RELTN | ORGANIZATION_ID | ||
CDI_AC_BATCHCLASS | ORGANIZATION_ID | ||
CDI_AC_USER | ORGANIZATION_ID | ||
CDI_CM_LOGIN | ORGANIZATION_ID | ||
CDI_PENDING_BATCH | ORGANIZATION_ID | ||
CE_EVENT_PRSNL | ACTION_ORGANIZATION_ID | ||
CHARGE | ORIGINAL_ORG_ID | ||
CHARGE | PAYOR_ID | ||
CHART_OF_ACCOUNT | ORGANIZATION_ID | ||
CHART_SEQ_GROUP_RELTN | ORGANIZATION_ID | ||
CHART_TEMP | ORGANIZATION_ID | ||
CHART_TRIGGER | SENDING_ORG_ID | ||
CHRG_GRP_EXCEPTION | PRIMARY_INS_ORG_ID | ||
CHRG_GRP_EXCEPTION | SECONDARY_INS_ORG_ID | ||
CMS_CRITICAL_LOCATION | ORGANIZATION_ID | ||
CODING_FLEX_SUMMARY | ORGANIZATION_ID | ||
COMMITTEE | SPONSORING_ORG_ID | ||
COMMITTEE_MEMBER | ORGANIZATION_ID | ||
CONSENT | ORGANIZATION_ID | ||
CONSENT_PATIENTSYNC_AUDIT | ORGANIZATION_ID | ||
CONSENT_PROVISION | ORGANIZATION_ID | ||
CONSENT_SYNC_AUDIT | ORGANIZATION_ID | ||
CONS_BO_SCHED | ORGANIZATION_ID | ||
CONTAINER_ORG_R | ORGANIZATION_ID | ||
CONTRACT_PROPERTY | ORGANIZATION_ID | ||
CONTRIBUTING_DEPT | ORGANIZATION_ID | ||
CONTRIBUTOR_SYSTEM | ORGANIZATION_ID | ||
CORRECTED_PRODUCT | DESTRUCTION_ORG_ID | ||
CORRECTED_PRODUCT | MANUFACTURER_ID | ||
CORRECTED_PRODUCT | SUPPLIER_ID | ||
CR_REPORT_REQUEST | CUSTODIAL_ORG_ID | ||
CR_STATIC_REGION_ORG_RELTN | ORGANIZATION_ID | ||
CSA_USER_AGREEMENT | ORGANIZATION_ID | ||
CSM_Q_ORG_XREF | ORGANIZATION_ID | ||
CSM_REQUESTS | ORGANIZATION_ID | ||
CSM_REQUESTS_ARCHIVE | ORGANIZATION_ID | ||
CS_ORG_RELTN | ORGANIZATION_ID | ||
CT_DEFAULT_MILESTONES | ORGANIZATION_ID | ||
CT_EXCLUDED_CLIENTS | ORGANIZATION_ID | ||
CT_MILESTONES | ORGANIZATION_ID | ||
CT_PROT_MILESTONES | ORGANIZATION_ID | ||
CT_RULESET_TIER | INS_ORG_ID | ||
CT_RULESET_TIER | ORGANIZATION_ID | ||
CW_DATA_CACHE | ORGANIZATION_ID | ||
DASH_COMPONENT | ORG_ID | ||
DASH_COMPONENT_SETTING | ORG_ID | ||
DASH_DASHBOARD | ORG_ID | ||
DASH_FILTER | ORG_ID | ||
DASH_ITEM_GROUP | ORG_ID | ||
DASH_TYPE | ORG_ID | ||
DA_DOCUMENT_ORG_RELTN | ORGANIZATION_ID | ||
DEPOSIT_ACCT | ORGANIZATION_ID | ||
DERIVATIVE | MANUFACTURER_ID | ||
DESTRUCTION | DESTRUCTION_ORG_ID | ||
DEVICE_OUTPUT_RELTN_R | ORGANIZATION_ID | ||
DOCUMENT_QUALITY_REVIEW | ORGANIZATION_ID | ||
DQR_DOCUMENT_ACTION | ORGANIZATION_ID | ||
EEM_ABN_CHECK | PAYER_ID | ||
EEM_ABN_CHECK | SPONSOR_ID | ||
EEM_ADDRESS_DETAIL | PAYER_ID | ||
EEM_AUTH_DETAIL | PAYER_ID | ||
EEM_BATCH | PAYER_ID | ||
EEM_BENEFIT_ALLOC | ORGANIZATION_ID | ||
EEM_COVERAGE_DETAIL | PAYER_ID | ||
EEM_DEMOG_DETAIL | PAYER_ID | ||
EEM_ELIG_DETAIL | PAYOR_ID | ||
EEM_JOB | PAYER_ID | ||
EEM_MOH_DETAIL | PAYER_ID | ||
EEM_NEWBORN_DETAIL | PAYER_ID | ||
EEM_NOTIFICATION_DETAIL | PAYER_ID | ||
EEM_PROFILE | PAYOR_ID | ||
EEM_REVIEW_RELTN | ORGANIZATION_ID | ||
EEM_RX_ELIG_DETAIL | ORGANIZATION_ID | ||
EEM_RX_ELIG_DETAIL | PBM_ORGANIZATION_ID | ||
EEM_RX_MED_HIST_DETAIL | ORGANIZATION_ID | ||
ENCNTR_ACCIDENT | ACC_EMPL_ORG_ID | ||
ENCNTR_APPEAL | PAYER_ORG_ID | ||
ENCNTR_AVOIDABLE_DAYS | RESP_PARTY_BUSINESS_ORG_ID | ||
ENCNTR_AVOIDABLE_DAYS | RESP_PARTY_PAYER_ORG_ID | ||
ENCNTR_CARE_MGMT_COMM | ORGANIZATION_ID | ||
ENCNTR_CATCHMENT_RELTN | CATCHMENT_ORG_ID | ||
ENCNTR_CATCHMENT_RELTN | SUBREGION_ORG_ID | ||
ENCNTR_CATCHMENT_R_HIST | CATCHMENT_ORG_ID | ||
ENCNTR_CATCHMENT_R_HIST | SUBREGION_ORG_ID | ||
ENCNTR_DENIED_DAYS | PAYER_ORG_ID | ||
ENCNTR_FLEX_HIST | CHART_ACCESS_ORGANIZATION_ID | ||
ENCNTR_FLEX_HIST | CLIENT_ORGANIZATION_ID | ||
ENCNTR_FLEX_HIST | ORGANIZATION_ID | ||
ENCNTR_FLEX_HIST | PLACE_OF_SVC_ORG_ID | ||
ENCNTR_FLEX_HIST | SERVICE_PROVIDER_ORG_ID | ||
ENCNTR_LOCATION | FACILITY_ORG_ID | ||
ENCNTR_LOC_HIST | ORGANIZATION_ID | ||
ENCNTR_ORG_RELTN | ORGANIZATION_ID | ||
ENCNTR_ORG_SERVICE_RELTN | ORGANIZATION_ID | ||
ENCNTR_ORG_SERVICE_RELTN | PAYER_ORG_ID | ||
ENCNTR_PLAN_RELTN | INS_OFFICE_ORG_ID | ||
ENCNTR_PLAN_RELTN | ORGANIZATION_ID | ||
ENCNTR_POSTACUTE_ORG_RELTN | ORGANIZATION_ID | ||
ENCNTR_READMIT_ASSESS | ORGANIZATION_ID | ||
ENCOUNTER | CHART_ACCESS_ORGANIZATION_ID | ||
ENCOUNTER | CLIENT_ORGANIZATION_ID | ||
ENCOUNTER | ORGANIZATION_ID | ||
ENCOUNTER | PLACE_OF_SVC_ORG_ID | ||
ENCOUNTER | SERVICE_PROVIDER_ORG_ID | ||
EPA_RECORD | ORGANIZATION_ID | ||
EXPEDITE_MANUAL | SENDING_ORG_ID | ||
EXPEDITE_PARAMS | SENDING_ORG_ID | ||
FHX_ACTIVITY | ORGANIZATION_ID | ||
FINANCIAL_YEAR | ORGANIZATION_ID | ||
FN_EV_SURVEY_REF | ORGANIZATION_ID | ||
FORMAT_ORG_RELTN | ORGANIZATION_ID | ||
GL_TRANS_QUALIFIER | CLIENT_ORG_ID | ||
GL_TRANS_QUALIFIER | CURRENT_INS_ORG_ID | ||
GL_TRANS_QUALIFIER | INS_ORG_ID | ||
GS_MED_CLAIM | PAYER_ORG_ID | ||
HANDHELD_UPLOAD | ORGANIZATION_ID | ||
HIM_EVENT_EXTENSION | ORGANIZATION_ID | ||
HIM_PV_CHART | ORGANIZATION_ID | ||
HIM_PV_DOCUMENT | ORGANIZATION_ID | ||
HIM_REQUEST | ORGANIZATION_ID | ||
HIM_UNSIGNED_ORDERS | ORGANIZATION_ID | ||
HM_EXPECT_MOD | ORGANIZATION_ID | ||
HM_EXPECT_MOD_HIST | ORGANIZATION_ID | ||
IMMUNIZATION_MODIFIER | ORGANIZATION_ID | ||
IM_DEVICE_ORG_R | ORGANIZATION_ID | ||
IND_IDE_OWNERSHIP | ORGANIZATION_ID | ||
ITEM_ORG_RELTN | ORG_ID | ||
ITEM_PRICE | ORGANIZATION_ID | ||
ITEM_PRICE_HIST | ORGANIZATION_ID | ||
LH_MU_FX_OPS_PARAM | ORGANIZATION_ID | ||
LOCATION | ORGANIZATION_ID | ||
LOCATION_INV_INFO | ORGANIZATION_ID | ||
MEDIA_MASTER | ORGANIZATION_ID | ||
MEDIA_ORG_RELTN | ORGANIZATION_ID | ||
MED_HISTORY_AUDIT | FACILITY_ORGANIZATION_ID | ||
MESSAGING_AUDIT | ORG_ID | ||
MM_APPROVAL | ORGANIZATION_ID | ||
MM_APPROVAL_QUEUE | ORGANIZATION_ID | ||
MM_AP_LOG_HEADER_HMW | ORGANIZATION_ID | ||
MM_AP_LOG_LINE_HMW | ORGANIZATION_ID | ||
MM_BUYER_ROUTING | ORGANIZATION_ID | ||
MM_CNTRCT_HDR_TIER | ORGANIZATION_ID | ||
MM_CNTRCT_ORG | ORGANIZATION_ID | ||
MM_CS_PATIENT_PRICE | ORGANIZATION_ID | ||
MM_DB_LOG | ORGANIZATION_ID | ||
MM_INSTANCE | ORGANIZATION_ID | ||
MM_OMF_INVOICE | ORGANIZATION_ID | ||
MM_OMF_INVOICE_LINE | ORGANIZATION_ID | ||
MM_OMF_ITEMLOC | ORGANIZATION_ID | ||
MM_OMF_PO | ORGANIZATION_ID | ||
MM_OMF_PO_LINE | ORGANIZATION_ID | ||
MM_OMF_RECEIPT | ORGANIZATION_ID | ||
MM_OMF_RECEIPT_LINE | ORGANIZATION_ID | ||
MM_PRICE_FORMULA | ORGANIZATION_ID | ||
MM_PROFILE | ORGANIZATION_ID | ||
MM_XFI_CNTRCT_HDR_TIER | ORGANIZATION_ID | ||
MM_XFI_CNTRCT_ORG | ORG_ID | ||
MM_XFI_COST | ORGANIZATION_ID | ||
MM_XFI_INSTANCE | ORGANIZATION_ID | ||
MM_XFI_ITEM | ORGANIZATION_ID | ||
MM_XFI_ITEMLOC | ORGANIZATION_ID | ||
MM_XFI_LOCATOR | ORGANIZATION_ID | ||
MM_XFI_QOH | ORGANIZATION_ID | ||
MM_XFI_REQ_FILL | ORGANIZATION_ID | ||
NETWORK | CARRIER_ID | ||
OMF_COST | ORGANIZATION_ID | ||
OMF_COST_PARAMS | ORGANIZATION_ID | ||
OMF_ENCNTR_ST | EMP_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | ORGANIZATION_ID | ||
OMF_ENCNTR_ST | OTHER_EMP_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | OTHER_INS_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | PRIM_EMP_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | PRIM_INS_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | SEC_EMP_ORGANIZATION_ID | ||
OMF_ENCNTR_ST | SEC_INS_ORGANIZATION_ID | ||
ORD_FAVORITE_DEST | ORGANIZATION_ID | ||
ORGANIZATION_ALIAS | ORGANIZATION_ID | ||
ORG_ALIAS_POOL_RELTN | ORGANIZATION_ID | ||
ORG_BARCODE_FORMAT | ORGANIZATION_ID | ||
ORG_BARCODE_ORG | LABEL_ORGANIZATION_ID | ||
ORG_BARCODE_ORG | SCAN_ORGANIZATION_ID | ||
ORG_CONTRIBUTOR_SYS_RELTN | ORGANIZATION_ID | ||
ORG_EVENT_SET_RELTN | ORGANIZATION_ID | ||
ORG_GROUP_RELTN | ORGANIZATION_ID | ||
ORG_INFO | ORGANIZATION_ID | ||
ORG_NTWK_PRVDR | ORGANIZATION_ID | ||
ORG_ORG_RELTN | ORGANIZATION_ID | ||
ORG_ORG_RELTN | RELATED_ORG_ID | ||
ORG_PLAN_RELTN | ORGANIZATION_ID | ||
ORG_SET_ORG_R | ORGANIZATION_ID | ||
ORG_SHIPMENT | ORGANIZATION_ID | ||
ORG_TIMELY_FILING | ORGANIZATION_ID | ||
ORG_TRANS_IDENT | ORGANIZATION_ID | ||
ORG_TRANS_PAYER_RELTN | ALT_PAYER_ORG_ID | ||
ORG_TRANS_PAYER_RELTN | PAYER_ORG_ID | ||
ORG_TYPE_RELTN | ORGANIZATION_ID | ||
OSM_CLIENT_DEFAULTS | ORGANIZATION_ID | ||
OSM_DEFAULTS | LAB_ORG_ID | ||
OSM_FORM_CLIENT_VALUES | ORGANIZATION_ID | ||
OSM_FORM_ORG_GRP_XREF | ORGANIZATION_ID | ||
OSM_FORM_PRINTING | ORGANIZATION_ID | ||
OSM_INSURANCE | SPONSOR_ID | ||
OSM_ORG_XREF | ORGANIZATION_ID | ||
PATIENT_CASE_IN_PMT_AGMT | RECEIVING_CARE_UNIT_ORG_ID | ||
PATIENT_CASE_IN_PMT_AGMT | RECEIVING_FACILITY_ORG_ID | ||
PATIENT_CASE_OUT_PMT_AGMT | REFERRING_CARE_GIVER_ORG_ID | ||
PATIENT_CASE_OUT_PMT_AGMT | REFERRING_CARE_UNIT_ORG_ID | ||
PATIENT_CASE_OUT_PMT_AGMT | REFERRING_FACILITY_ORG_ID | ||
PAT_ED_DOC_FOLLOWUP | ORGANIZATION_ID | ||
PAYMENT_DETAIL | CC_TRANS_ORG_ID | ||
PCS_CHARGE_MOD_ABN | ORGANIZATION_ID | ||
PEER_REVIEWER | ORGANIZATION_ID | ||
PERSON_MILITARY | ASSIGNED_UNIT_ORG_ID | ||
PERSON_MILITARY | ATTACHED_UNIT_ORG_ID | ||
PERSON_MILITARY_HIST | ASSIGNED_UNIT_ORG_ID | ||
PERSON_MILITARY_HIST | ATTACHED_UNIT_ORG_ID | ||
PERSON_ORG_RELTN | ORGANIZATION_ID | ||
PERSON_ORG_RELTN_HIST | ORGANIZATION_ID | ||
PERSON_PHR_INFO | ORGANIZATION_ID | ||
PERSON_PHR_INFO_HIST | ORGANIZATION_ID | ||
PERSON_PLAN_RELTN | INS_OFFICE_ORG_ID | ||
PERSON_PLAN_RELTN | ORGANIZATION_ID | ||
PERSON_PLAN_RELTN_HIST | INS_OFFICE_ORG_ID | ||
PERSON_PREF | FACILITY_ORGANIZATION_ID | ||
PERSON_PREF_HIST | FACILITY_ORGANIZATION_ID | ||
PERSON_PRSNL_ORG_OVERRIDE | CHART_ACCESS_ORGANIZATION_ID | ||
PERSON_PRSNL_ORG_OVERRIDE | SOURCE_CHILD_ORGANIZATION_ID | ||
PERSON_PRSNL_ORG_OVERRIDE | SOURCE_PARENT_ORGANIZATION_ID | ||
PFT_AP_REFUND | EMPLOYER_ID | ||
PFT_BALANCE | CLIENT_ORG_ID | ||
PFT_CHARGE | BE_ORG_ID | ||
PFT_CHARGE | CLIENT_ORG_ID | ||
PFT_CHARGE_GLOBAL_DAYS | ORGANIZATION_ID | ||
PFT_COLLECTION_AGENCY | ORGANIZATION_ID | ||
PFT_GPCI_CONTENT | ORGANIZATION_ID | ||
PFT_PAYMENT_LOCATION | ORGANIZATION_ID | ||
PFT_PROVIDER_NBR | INSURANCE_ORG_ID | ||
PFT_REVENUE_SUMMARY | PAYOR_ORG_ID | ||
PFT_SYSTEM_ACTIVITY_LOG | ORGANIZATION_ID | ||
PFT_WF_ISSUE | ORGANIZATION_ID | ||
PHA_DISP_OBS_ST | ORGANIZATION_ID | ||
PHA_ORD_ACT_OBS_ST | ORGANIZATION_ID | ||
PHA_PROD_DISP_OBS_ST | ORGANIZATION_ID | ||
PLAN_CONTACT | CARRIER_ID | ||
PL_CATALOG_SEGMENTS | ORGANIZATION_ID | ||
PL_CLIENT_DEFAULTS | ORGANIZATION_ID | ||
PL_DEMOGRAPHICS | ORGANIZATION_ID | ||
PL_EXCHANGE_DEFAULTS | ORGANIZATION_ID | ||
PL_INSURANCE_DEFAULTS | ORGANIZATION_ID | ||
PL_MENU_OPTIONS | ORGANIZATION_ID | ||
PL_ORG_LOGO_XREF | ORGANIZATION_ID | ||
PL_PC_ORG_DIAG_XREF | ORGANIZATION_ID | ||
PL_PC_ORG_GRP_XREF | ORGANIZATION_ID | ||
PL_PC_ORG_TAB_XREF | ORGANIZATION_ID | ||
PL_XREF_DEFAULTS | ORGANIZATION_ID | ||
PM_FLX_TASK_CONV_RELTN | ORGANIZATION_ID | ||
PM_HIST_TRACKING | FACILITY_ORG_ID | ||
PM_POST_DOC | PRIMARY_CARE_ORGANIZATION_ID | ||
PM_POST_DOC | REFERRING_ORGANIZATION_ID | ||
PM_POST_DOC_ORG_RELTN | ORGANIZATION_ID | ||
PM_POST_PROCESS | ORGANIZATION_ID | ||
PM_ROOM_BED_CHARGE | ORGANIZATION_ID | ||
PM_TRANSACTION | N_CHART_ACCESS_ORGANIZATION_ID | ||
PM_TRANSACTION | N_ORGANIZATION_ID | ||
PM_TRANSACTION | O_CHART_ACCESS_ORGANIZATION_ID | ||
PM_TRANSACTION | O_ORGANIZATION_ID | ||
PM_TYPE_PARAMS | ORGANIZATION_ID | ||
POOL_OPTION | DEFAULT_SUPPLIER_ID | ||
PPR_CONSENT_POLICY | ORGANIZATION_ID | ||
PPR_CONSENT_STATUS | ORGANIZATION_ID | ||
PRACTICE_SITE | ORGANIZATION_ID | ||
PREGNANCY_INSTANCE | ORGANIZATION_ID | ||
PROBLEM | ORGANIZATION_ID | ||
PROCEDURE | ORGANIZATION_ID | ||
PROCEDURE_HIST | ORGANIZATION_ID | ||
PRODUCT | CUR_SUPPLIER_ID | ||
PRODUCT_EVENT | ORGANIZATION_ID | ||
PRODUCT_INDEX | DEFAULT_SUPPLIER_ID | ||
PROT_DEFAULT_ROLES | ORGANIZATION_ID | ||
PROT_GRANT_SPONSOR | ORGANIZATION_ID | ||
PROT_MASTER | COLLAB_SITE_ORG_ID | ||
PROT_MASTER | RESEARCH_SPONSOR_ORG_ID | ||
PROT_ROLE | ORGANIZATION_ID | ||
PROT_STRATUM | ORGANIZATION_ID | ||
PROVIDER_ENROLLMENT | PAYER_ORG_ID | ||
PRSNL_GROUP_ORG_RELTN | ORGANIZATION_ID | ||
PRSNL_ORG_RELTN | ORGANIZATION_ID | ||
PRSNL_ORG_RELTN_TYPE | ORGANIZATION_ID | ||
PRSNL_ROLE_ORG_POS_RELTN | ORGANIZATION_ID | ||
PRSNL_SUSPENSION | ORGANIZATION_ID | ||
PT_CONSENT | CONSENTING_ORGANIZATION_ID | ||
PT_ELIG_RESULT | ELIG_VALUE_PROVIDER_ORG_ID | ||
PT_ELIG_TRACKING | ELIG_REQUEST_ORG_ID | ||
PT_ELIG_TRACKING | ELIG_REVIEW_ORG_ID | ||
PT_PROT_REG | ENROLLING_ORGANIZATION_ID | ||
PT_PROT_REG | OFF_TX_REMOVAL_ORGANIZATION_ID | ||
PT_PROT_REG | ON_TX_ORGANIZATION_ID | ||
PT_PROT_REG | REMOVAL_ORGANIZATION_ID | ||
PURCHASE_ORDER | ORGANIZATION_ID | ||
RAD_STG_DATA | AUTHORIZING_ORG_ID | ||
RAD_STG_DATA | TRANSMITTING_ORG_ID | ||
RAD_STG_EXT_IDENTIFIER | ORG_ID | ||
RCA_MOBILE_PROFILE | FACILITY_ORG_ID | ||
RCM_FACILITY_PLAN_RELTN | ORGANIZATION_ID | ||
RCM_INTERQUAL_ACCT_ORG_R | ORGANIZATION_ID | ||
RCM_THIRD_PARTY_ACCT_ORG_R | ORGANIZATION_ID | ||
RCM_TLC_ACCT_ORG_R | ORGANIZATION_ID | ||
RC_CLOUD_SYNC | ORGANIZATION_ID | ||
RC_ORG_SERVICE_SET_RELTN | FACILITY_ORG_ID | ||
RC_PRSNL_SERVICE_SET_RELTN | FACILITY_ORG_ID | ||
RC_SLA_RULE | PAYER_ID | ||
REFERRAL | REFER_FROM_ORGANIZATION_ID | ||
REFERRAL | REFER_TO_ORGANIZATION_ID | ||
REFERRAL_HIST | REFER_FROM_ORGANIZATION_ID | ||
REFERRAL_HIST | REFER_TO_ORGANIZATION_ID | ||
RESEARCH_ACCOUNT | ORGANIZATION_ID | ||
REVIEW_GROUP_RELTN | ORGANIZATION_ID | ||
ROLE_TYPE_CRDNTL | ORGANIZATION_ID | ||
ROLE_TYPE_RESP | ORGANIZATION_ID | ||
SCD_STORY_ORG_RELTN | ORGANIZATION_ID | ||
SCH_APPT | REFERRING_ORG_ID | ||
SCH_EVENT_ACTION | ORGANIZATION_ID | ||
SCH_EVENT_ACTION | PRACTICE_ORG_ID | ||
SCH_EVENT_ACTION | PROXY_ORGANIZATION_ID | ||
SCH_ORG_SECURITY | ORGANIZATION_ID | ||
SCH_PEND_ENCNTR_DETAIL | CLIENT_ORG_ID | ||
SCH_PEND_ENCNTR_DETAIL | FACILITY_ORG_ID | ||
SCH_RESOURCE | OWNER_ORG_ID | ||
SECT_POSITION_RELTN | ORGANIZATION_ID | ||
SERVICE_RESOURCE | ORGANIZATION_ID | ||
SHX_ACTIVITY | ORGANIZATION_ID | ||
SI_CONTRIBUTOR_SYSTEM_HIST | ORGANIZATION_ID | ||
SI_DOCUMENT_INFO | ORGANIZATION_ID | ||
SI_SYSTEM_ORG_RELTN | ORGANIZATION_ID | ||
SI_UNMTCHD_PRSN_QUE | ORGANIZATION_ID | ||
SI_XDOC_QUERY_PERSON_RELTN | ORGANIZATION_ID | ||
SN_RPT | ORGANIZATION_ID | ||
STATEMENT_CYCLE_RELTN | EXCLUDE_FACILITY_ORG_ID | ||
STATEMENT_CYCLE_RELTN | INSURANCE_ORG_ID | ||
TAG_COLOR | ORGANIZATION_ID | ||
TASK_ACTIVITY | ORGANIZATION_ID | ||
TRANSACTION_ADMIT_NOTIFY | ORGANIZATION_ID | ||
TRANSACTION_ADMIT_NOTIFY | PAYER_ID | ||
TRANSACTION_ELIGIBILITY | ORGANIZATION_ID | ||
TRANSACTION_ELIGIBILITY | PAYER_ID | ||
UM_CHARGE_EVENT_ST | CLIENT_ID | ||
WF_SHIFT_SCHED | ORGANIZATION_ID | ||
WF_XFI_SHIFT_SCHED | ORGANIZATION_ID |
ORGANIZATION_ALIAS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Organization Alias |
Definition: | The organization alias table contains information used to identify the organization (I.e., employer number, insurance company number, client number, hospital id, etc.) |
Table Type: | REFERENCE |
Column Detail - ORGANIZATION_ALIAS
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. |
ALIAS | VARCHAR(100) | Y | The alias is an identifier (I.e., client number, hospital id, employer number, insurance company number, etc.) for an organization. The alias may be unique or non-unique depending on the type of alias. |
ALIAS_KEY | VARCHAR(100) | Y | It is the UPPERcase, no spaces or special character version of ALIAS, which is, an identifier (I.e., client number, hospital id, employer number, insurance company number, etc.) for an organization. |
ALIAS_KEY_A_NLS | VARCHAR(400) | Y | ALIAS_KEY_A_NLS column |
ALIAS_KEY_NLS | VARCHAR(202) | Y | It is the National Language Support version of ALIAS, which is, an identifier (I.e., client number, hospital id, employer number, insurance company number, etc.) for an organization. |
ALIAS_POOL_CD | DOUBLE | N | Alias pool code identifies a unique set or list of organization 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 | 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. |
CHECK_DIGIT | DOUBLE | Y | This is the value of the check digit calculated according to the check_digit_method_cd. If the check digit is stored as part of the alias number, which is typical, then the check digit field may be NULL. |
CHECK_DIGIT_METHOD_CD | DOUBLE | N | The check digit method code identifies a specific routine, using the alias field, to calculate a check digit. |
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. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
ORGANIZATION_ALIAS_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization alias table. It is an internal system assigned number. |
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_ALIAS_SUB_TYPE_CD | DOUBLE | N | Future Use |
ORG_ALIAS_TYPE_CD | DOUBLE | N | Organization alias type code identifies a kind or type of alias (i.e., Client Number.). They are Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias. |
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 - ORGANIZATION_ALIAS
Child Column in ORGANIZATION_ALIAS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
ORG_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORG INFO |
Definition: | Allows the storage of comments at the organization level |
Table Type: | REFERENCE |
Column Detail - ORG_INFO
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. |
CHARTABLE_IND | DOUBLE | N | Determines whether this comment should show on the chart |
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. |
INFO_SUB_TYPE_CD | DOUBLE | N | Information Sub Type Code identifies the category if additional information contained in the row. (For Example: Clerical Contact, etc.) |
INFO_TYPE_CD | DOUBLE | N | Information Type Code identifies the type of the information. (For Example: Comment, General Announcement, etc.) |
LONG_TEXT_ID | DOUBLE | N | The unique identifier to the LONG_TEXT table where textual comments are stored |
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_INFO_ID | DOUBLE | N | This is the value of the unique primary identifier of the org_info table. It is an internal system assigned number. |
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. |
VALUE_CD | DOUBLE | Y | If the comment if of a codified type, the value should be placed in this attribute |
VALUE_DT_TM | DATETIME | Y | If the comment stored is of a date and time format, store the information in this attribute |
VALUE_NUMERIC | DOUBLE | Y | If the comment stored is of a numeric format, store the information in this attribute |
Relationship Detail - ORG_INFO
Child Column in ORG_INFO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
ORG_ORG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Organization Organization Relationship |
Definition: | The organization-organization relationship table contains the relationships of independent organizations to each other. For example, XYZ Physician Office is a client of ABC Reference Lab. |
Table Type: | REFERENCE |
Column Detail - ORG_ORG_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 | 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. |
COMMENT_TEXT | LONGTEXT | Y | Future Use |
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. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
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_ORG_RELTN_CD | DOUBLE | N | Identifies the specific type of relationship between two independent organizations. This field is user defined (I.e., client, contractor, etc.). |
ORG_ORG_RELTN_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization organization relationship table. It is an internal system assigned number. |
RELATED_ORG_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. This is a 'role' name for the reference to organization_id in the organization table and used to differentiate between other references to organization_id in this 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 - ORG_ORG_RELTN
Child Column in ORG_ORG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
RELATED_ORG_ID | ORGANIZATION | ORGANIZATION_ID |
Parent Column in ORG_ORG_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORG_ORG_RELTN_ID | ORG_ORG_RELTN_INFO | ORG_ORG_RELTN_ID |