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