Table Detail Report
LONG_EXTENSION
Column Section | Top of Page |
Table-level Detail
Description: | Long Extension |
Definition: | An extension to the Long Text and Long Blob tables to contain additional information about the data stored in the long row. |
Table Type: | ACTIVITY |
Column Detail - LONG_EXTENSION
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. |
ATTRIBUTE_ENTITY_ID | DOUBLE | N | Uniquely identifies the entry on the related entity defined in the attribute entity name column. For example a code number. |
ATTRIBUTE_ENTITY_NAME | VARCHAR(30) | Y | Contains the name of the attribute - for example: code_value |
ATTRIBUTE_NUMBER | DOUBLE | N | Contains the attribute number - for example: a number that was not codified. |
ATTRIBUTE_TXT | VARCHAR(100) | Y | Contains the attribute text - for example the actual text describing an attribute |
ATTRIBUTE_TYPE_NAME | VARCHAR(30) | N | Defines what type of attribute is being stored. - for example a format code. |
LONG_EXTENSION_ID | DOUBLE | N | Uniquely identifies additional information related to a long table. |
PARENT_ENTITY_ID | DOUBLE | N | Uniquely identifies a row on the entity identified in the parent_entity_name. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Contains the Name of the Entity to which this data is an extension. |
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. |
LONG_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Long Text |
Definition: | Used to store long text information for reference activity data information |
Table Type: | ACTIVITY |
Column Detail - LONG_TEXT
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 | 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. |
LONG_TEXT | LONGTEXT | N | Used to store the text for the long text identifier |
LONG_TEXT_ID | DOUBLE | N | Stores the long text identifier |
PARENT_ENTITY_ID | DOUBLE | N | Used to store the identifier for the parent |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Used to store the name for the parent |
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. |
UPDT_TZ | DOUBLE | Y | The time zone where the row was last inserted or updated. |
Relationship Detail - LONG_TEXT
Parent Column in LONG_TEXT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LONG_TEXT_ID | ACCESSION_EXTERNAL_SMRY | EXTERNAL_ACCESSION_COMMENT_ID |
ACT_PW_COMP | COND_NOTE_ID | ||
ADDRESS | LONG_TEXT_ID | ||
ALERT_AUDIT_ALLERGY | DESC_LONG_TEXT_ID | ||
ALERT_AUDIT_ALLERGY_DOM | OVERRIDE_REASON_LONG_TEXT_ID | ||
ALERT_AUDIT_DRUG | DESC_LONG_TEXT_ID | ||
ALERT_AUDIT_DRUG_DOM | OVERRIDE_REASON_LONG_TEXT_ID | ||
ALERT_AUDIT_DUP_DOM | OVERRIDE_REASON_LONG_TEXT_ID | ||
ALERT_AUDIT_FOOD | DESC_LONG_TEXT_ID | ||
ALERT_AUDIT_FOOD_DOM | OVERRIDE_REASON_LONG_TEXT_ID | ||
AP_CASE_QUERY_DETAILS | FREETEXT_LONG_TEXT_ID | ||
AP_CASE_QUERY_DETAILS | SYNOPTIC_CCL_LONG_TEXT_ID | ||
AP_CASE_QUERY_DETAILS | SYNOPTIC_XML_LONG_TEXT_ID | ||
AP_CASE_SYNOPTIC_WS | FOREIGN_WS_RESULT_TEXT_ID | ||
AP_CASE_SYNOPTIC_WS_DATA | ANSWER_LONG_TEXT_ID | ||
AP_DC_EVENT | LONG_TEXT_ID | ||
AP_DIAG_QUERY_PARAM | FREETEXT_LONG_TEXT_ID | ||
AP_DIAG_QUERY_PARAM | SYNOPTIC_CCL_LONG_TEXT_ID | ||
AP_DIAG_QUERY_PARAM | SYNOPTIC_XML_LONG_TEXT_ID | ||
AP_FOLDER | COMMENT_ID | ||
AP_FOLDER_ENTITY | COMMENT_ID | ||
AP_FT_EVENT | TERM_LONG_TEXT_ID | ||
AP_PROMPT_TEST | LONG_TEXT_ID | ||
AUTHORIZATION | COMMENT_ID | ||
AUTHORIZATION | DELAY_REASON_COMMENT_ID | ||
AUTH_DETAIL | LONG_TEXT_ID | ||
BATCH_TRANS_FILE | LONG_TEXT_ID | ||
BB_EXCEPTION | REVIEW_DOC_ID | ||
BB_QC_RESULT | COMMENT_TEXT_ID | ||
BB_REVIEW_QUEUE | REVIEW_DOC_ID | ||
BB_UPLOAD_LONG_TEXT_R | LONG_TEXT_ID | ||
BLOOD_BANK_COMMENT | LONG_TEXT_ID | ||
CAC_DOCUMENT | LONG_TEXT_ID | ||
CASE_SPECIMEN | SPEC_COMMENTS_LONG_TEXT_ID | ||
CCL_REPORT_AUDIT | LONG_TEXT_ID | ||
CDI_WORK_ITEM | COMMENT_ID | ||
CDI_WORK_ITEM_ACTION | LONG_TEXT_ID | ||
CE_DYNAMIC_LABEL | LONG_TEXT_ID | ||
CE_EVENT_PRSNL | LONG_TEXT_ID | ||
CE_STRING_RESULT | STRING_LONG_TEXT_ID | ||
CHART_FORMAT | ADDITIONAL_INFO_ID | ||
CHART_FORMAT | RESUBMIT_DISCLAIMER_ID | ||
CLARIFICATION | DISPLAY_TEXT_ID | ||
CLARIFICATION | MORE_INFO_TEXT_ID | ||
CLINICAL_EVENT | MODIFIER_LONG_TEXT_ID | ||
CLRFCTN_ACTION | ACCEPTED_TEXT_ID | ||
CLRFCTN_RESPONSE | PROPOSED_TEXT_ID | ||
CMT_IMPORT_LOG | LONG_TEXT_ID | ||
CONTAINER | COLL_COMMENT_ID | ||
CONTAINER_EVENT | COLL_COMMENT_ID | ||
CORSP_LOG | LONG_TEXT_ID | ||
CORSP_LOG_RELTN | LONG_TEXT_ID | ||
CR_REPORT_REQUEST | EMAIL_BODY_ID | ||
CR_REPORT_REQUEST | EMAIL_SUBJECT_ID | ||
CR_REPORT_REQUEST | REQUEST_XML_ID | ||
CR_REPORT_REQUEST | STATUS_TEXT_ID | ||
CR_REPORT_REQUEST | SUMMARY_REPORT_XML_ID | ||
CSM_REQUESTS | CSM_REQ_COM_ID | ||
CSM_REQUESTS | CSM_RSLT_COM_ID | ||
CSM_REQUESTS | PROBLEM_REQ_COMMENT_ID | ||
CS_COMPONENT | LONG_TEXT_ID | ||
CS_COMPONENT | ORD_COM_TEMPLATE_LONG_TEXT_ID | ||
CT_PRESCREEN_JOB | LONG_TEXT_ID | ||
CV_CASE_FILE_ROW | LONG_TEXT_ID | ||
CV_OPERATOR | LONG_TEXT_ID | ||
CV_XREF | ERROR_TEXT_ID | ||
CV_XREF | WARNING_TEXT_ID | ||
DA_BATCH_QUERY_LOG | ERROR_TXT_ID | ||
DA_BATCH_REPORT_LOG | ERROR_TXT_ID | ||
DA_BATCH_SCHED_LOG | ERROR_TXT_ID | ||
DMS_EVENT | LONG_TEXT_ID | ||
DMS_MEDIA_INSTANCE | LONG_TEXT_ID | ||
DMS_MEDIA_METADATA_REF | LONG_TEXT_ID | ||
DM_DCM_WORK_PLAN | WORK_PLAN_TEXT_ID | ||
DRC_DOSE_RANGE | LONG_TEXT_ID | ||
DRC_DOSE_RANGE_VER | LONG_TEXT_ID | ||
DRUG_CLASS_INT_CUSTOM | LONG_TEXT_ID | ||
EEM_BENEFIT_PLAN | LONG_TEXT_ID | ||
EEM_COMMENT | TEXT_ID | ||
EEM_ENTITY_NTWK_RELTN | LONG_TEXT_ID | ||
EEM_ENTITY_PROV_TAX_RELTN | LONG_TEXT_ID | ||
EEM_LOG | LONG_TEXT_ID | ||
EEM_PROV_TAX_RELTN | LONG_TEXT_ID | ||
EEM_SERVICE_TYPE | LONG_TEXT_ID | ||
EKS_ALERT_ESCALATION | MSG_LONG_TEXT_ID | ||
EKS_ALERT_ESC_HIST | MSG_LONG_TEXT_ID | ||
EKS_DLG_EVENT | ALERT_LONG_TEXT_ID | ||
EKS_DLG_EVENT | LONG_TEXT_ID | ||
ENCNTR_APPEAL | COMMENT_LONG_TEXT_ID | ||
ENCNTR_AVOIDABLE_DAYS | COMMENT_LONG_TEXT_ID | ||
ENCNTR_BENEFIT_R | COMMENT_ID | ||
ENCNTR_CARE_MGMT_COMM | COMMENT_ID | ||
ENCNTR_CLIN_REVIEW | RESULT_XML_LONG_TEXT_ID | ||
ENCNTR_CLIN_REVIEW | REVIEW_COMMENT_ID | ||
ENCNTR_CLIN_REVIEW | REVIEW_SUB_TYPE_ID | ||
ENCNTR_CLIN_REVIEW_ADDNDM | ADDENDUM_COMMENT_ID | ||
ENCNTR_CLIN_REVIEW_RESULT | RESULT_COMMENT_ID | ||
ENCNTR_CLIN_REVIEW_RESULT | RESULT_LONG_TEXT_ID | ||
ENCNTR_CLIN_SEC_REVIEW | SEC_REVIEW_COMMENT_ID | ||
ENCNTR_CMNTY_CASE_ID_PGM | SUP_FACTS_LONG_TEXT_ID | ||
ENCNTR_DENIED_DAYS | COMMENT_LONG_TEXT_ID | ||
ENCNTR_INFO_HIST | LONG_TEXT_ID | ||
ENCNTR_ORG_SERVICE_RELTN | COMMENT_LONG_TEXT_ID | ||
ENCNTR_PLAN_RELTN | COVERAGE_COMMENTS_LONG_TEXT_ID | ||
ENCNTR_POSTACUTE_ORG_RELTN | COMMENT_LONG_TEXT_ID | ||
ENCNTR_READMIT_ASSESS | COMMENT_ID | ||
FHX_LONG_TEXT_R | LONG_TEXT_ID | ||
FILL_PRINT_ORD_HX | COMPOUND_TEXT_ID | ||
FILL_PRINT_ORD_HX | DISPENSE_COMMENT_TEXT_ID | ||
FILL_PRINT_ORD_HX | FILL_NOTE_ID | ||
FILL_PRINT_ORD_HX | LABEL1_ID | ||
FILL_PRINT_ORD_HX | LABEL2_ID | ||
FILL_PRINT_ORD_HX | ORDER_COMMENT_ID | ||
FILL_PRINT_ORD_HX | PATIENT_TEXT_ID | ||
FILL_PRINT_ORD_HX | PAT_TEXT_ID | ||
FILL_PRINT_ORD_HX | PHARM_COMMENT_TEXT_ID | ||
FILL_PRINT_ORD_HX | PRODUCT_NOTE_ID | ||
FILL_PRINT_ORD_HX | SIG_ALT_LANG_TEXT_ID | ||
FILL_PRINT_ORD_HX | SIG_TEXT_ID | ||
GEL_RESULT_COMMENT | LONG_TEXT_ID | ||
HAPLOTYPE_CHART | COMMENT_LONG_TEXT_ID | ||
HAPLOTYPE_DONOR | COMMENT_LONG_TEXT_ID | ||
HEALTH_PLAN_INFO | LONG_TEXT_ID | ||
HIM_REQUEST_CRITERIA | LONG_TEXT_ID | ||
HLA_AB_SCREEN_RESULT | COMMENT_LONG_TEXT_ID | ||
HLA_SERA_QUERY_QUERIES | QUERY_LONG_TEXT_ID | ||
HLA_TYP_RES_TRAY | COMMENT_LONG_TEXT_ID | ||
HLA_XM_RES_TRAY | COMMENT_LONG_TEXT_ID | ||
HM_EXPECT_MOD | LONG_TEXT_ID | ||
HM_EXPECT_MOD_HIST | LONG_TEXT_ID | ||
HM_RECOMMENDATION_ACTION | LONG_TEXT_ID | ||
IMMUNIZATION_MODIFIER | CONSENT_LONG_TEXT_ID | ||
IMPLANT_HISTORY | LONG_TEXT_ID | ||
INFUSION_BILLING_EVENT | COMMENT_LONG_TEXT_ID | ||
INTERP_DATA | LONG_TEXT_ID | ||
LH_CNT_ADVSR_EVENT | COMMENT_LONG_TEXT_ID | ||
LH_CNT_ADVSR_EVENT | UNCHART_LONG_TEXT_ID | ||
LH_CNT_READMIT_USER_LIST | LONG_TEXT_ID | ||
LH_CNT_REPORT | LONG_TEXT_ID | ||
LH_CNT_WL_FLTR_LIST | LONG_TEXT_ID | ||
MEDICATION_DEFINITION | COMMENT1_ID | ||
MED_OE_DEFAULTS | COMMENT1_ID | ||
MED_OE_DEFAULTS | COMMENT2_ID | ||
MESSAGING_AUDIT | MSG_TEXT_ID | ||
MIC_CORRELATION_FOOTNOTE | LONG_TEXT_ID | ||
MIC_ERR_DATA_R | DATA_TEXT_ID | ||
MIC_EVENT_LOG | LONG_TEXT_ID | ||
MIC_LONG_TEXT_SUBTYPE | LONG_TEXT_ID | ||
MIC_ORDER_LAB | INTERP_TEXT_ID | ||
MIC_QC_NODE_OUTCOME | ACTION_TEXT_ID | ||
MIC_QC_RESULT | COMMENT_TEXT_ID | ||
MIC_QC_RESULT | CORRECTION_TEXT_ID | ||
MIC_RESULT_FOOTNOTE_R | LONG_TEXT_ID | ||
MIC_SCRIPT_NODE_ACTION | LONG_TEXT_ID | ||
MIC_STAT_FOOTNOTE | LONG_TEXT_ID | ||
MIC_STAT_ORDER | FREETEXT_SOURCE_ID | ||
MIC_STAT_ORDER | INTERP_TEXT_ID | ||
MIC_STAT_ORDER | ORDER_COMMENT_ID | ||
MIC_STAT_ORDER | ORDER_NOTE_ID | ||
MIC_STAT_TASK | FREETEXT_RESULT_ID | ||
MM_DISCREPANCY | RESOLVED_COMMENT_TEXT_ID | ||
ONC_CHEMO_VERIFY | LONG_TEXT_ID | ||
ONC_II_AUTO_ACTIVITY | LONG_TEXT_ID | ||
ONC_TC_CAL_ITEMS | LONG_TEXT_ID | ||
ORDER_ALERTS | ACTION_TEXT_ID | ||
ORDER_CATALOG_SYNONYM | HIGH_ALERT_LONG_TEXT_ID | ||
ORDER_DISPENSE | ERX_MSG_LONG_TEXT_ID | ||
ORDER_INGREDIENT | DOSE_CALCULATOR_LONG_TEXT_ID | ||
ORDER_PROPOSAL_INGREDIENT | DOSE_CALCULATOR_LONG_TEXT_ID | ||
ORDER_RX_SCRATCHPAD | COMMENT_LONG_TEXT_ID | ||
ORM_ORD_HIST_SNAPSHOT_COMP | COMPLIANCE_LONG_TEXT_ID | ||
OUTCOME_ACTIVITY | COMMENT_ID | ||
PATHOLOGY_CASE | COMMENTS_LONG_TEXT_ID | ||
PATIENT_CASE | COMMENT_ID | ||
PAT_ED_DOC_FOLLOWUP | ADD_LONG_TEXT_ID | ||
PAT_ED_DOC_FOLLOWUP | CMT_LONG_TEXT_ID | ||
PAT_ED_DOC_FOLLOWUP | RECIPIENT_LONG_TEXT_ID | ||
PAT_ED_FOLLOWUP_FAVORITES | COMMENT_TXT_ID | ||
PAT_ED_FOLLOWUP_FAVORITES | RECIPIENT_TXT_ID | ||
PAT_ED_FOLLOWUP_FAVORITES | WHERE_TXT_ID | ||
PCS_RSLT_TMPLT_DFLT | TEXT_DISPLAY_ID | ||
PC_ANNOUNCEMENT_TEXT | ANNOUNCEMENT_LONG_TEXT_ID | ||
PERIOPERATIVE_DOCUMENT | LONG_TEXT_ID | ||
PERSON_BENEFIT_R | COMMENT_ID | ||
PERSON_HLA_AB_SCN_AUDIT | COMMENT_LONG_TEXT_ID | ||
PERSON_HLA_AB_SCREEN | COMMENT_LONG_TEXT_ID | ||
PERSON_HLA_EVENT | HLA_EVENT_TEXT_ID | ||
PERSON_HLA_EVENT_AUDIT | HLA_EVENT_TEXT_ID | ||
PERSON_HLA_TYPE_AUDIT | COMMENT_LONG_TEXT_ID | ||
PERSON_HLA_XM | COMMENT_LONG_TEXT_ID | ||
PERSON_HLA_XM | INTERPRETATION_LONG_TEXT_ID | ||
PERSON_HLA_XM_AUDIT | COMMENT_LONG_TEXT_ID | ||
PERSON_HLA_XM_AUDIT | INTERPRETATION_LONG_TEXT_ID | ||
PERSON_INFO_HIST | LONG_TEXT_ID | ||
PERSON_ORGAN_DONOR | COMMENT_LONG_TEXT_ID | ||
PERSON_PLAN_RELTN | COVERAGE_COMMENTS_LONG_TEXT_ID | ||
PERSON_TRANSPLANT_CANDIDATE | COMMENT_LONG_TEXT_ID | ||
PFT_CLAIM_STATUS_HIST | LONG_TEXT_ID | ||
PFT_QUEUE_ITEM | LONG_TEXT_ID | ||
PFT_QUEUE_ITEM_WF_HIST | LONG_TEXT_ID | ||
PM_USER_DEFINED_HIST | VALUE_LONG_TEXT_ID | ||
PM_WAIT_LIST_STATUS | COMMENT_LONG_TEXT_ID | ||
PP_ERROR_LOG | LONG_TEXT_ID | ||
PREF_CARD_DEF_DETAIL | LONG_TEXT_ID | ||
PREF_CARD_SEGMENT | LONG_TEXT_ID | ||
PREGNANCY_INFORMATION | LONG_TEXT_ID | ||
PROCESSING_TASK | COMMENTS_LONG_TEXT_ID | ||
PROCESSING_TASK | HOLD_COMMENT_LONG_TEXT_ID | ||
PT_ELIG_TRACKING_NOTES | NOTE_LONG_TEXT_ID | ||
PW_VARIANCE_RELTN | NOTE_TEXT_ID | ||
RCM_CLARIFICATION | LONG_TEXT_ID | ||
RCM_DOC_REVIEW | COMMENT_TEXT_ID | ||
RCM_DOC_REVIEW_FOLLOWUP | OUTCOME_COMMENT_TEXT_ID | ||
RCM_MSG_CENTER_COMM | LONG_TEXT_ID | ||
RCM_NOTE | LONG_TEXT_ID | ||
RCM_TRANSACTION | LONG_TEXT_ID | ||
RC_EDI_TRANSACTION | REPLY_LONG_TEXT_ID | ||
RC_EDI_TRANSACTION | REQUEST_LONG_TEXT_ID | ||
REFERRAL | INSTRUCTIONS_TO_STAFF_TEXT_ID | ||
REFERRAL | REFERRAL_REASON_TEXT_ID | ||
REFERRAL | TREATMENT_TO_DATE_TEXT_ID | ||
REFERRAL_CONTACT | COMMENT_TEXT_ID | ||
REFERRAL_HIST | INSTRUCTIONS_TO_STAFF_TEXT_ID | ||
REFERRAL_HIST | REFERRAL_REASON_TEXT_ID | ||
REFERRAL_HIST | TREATMENT_TO_DATE_TEXT_ID | ||
REGIMEN_ACTION | LONG_TEXT_ID | ||
REGIMEN_DETAIL_ACTION | LONG_TEXT_ID | ||
REPORT_TASK | COMMENTS_LONG_TEXT_ID | ||
REPORT_TASK | HOLD_COMMENT_LONG_TEXT_ID | ||
ROUND_ROBIN_COMMENT | LONG_TEXT_ID | ||
RXS_FOREIGN_DEVICE_ALERT | MSG_BODY_LONG_TEXT_ID | ||
RXS_MED_REQUEST | REASON_LONG_TEXT_ID | ||
RXS_MED_REQUEST | RX_REASON_LONG_TEXT_ID | ||
RXS_TASK_SR_HX | MSG_BODY_LONG_TEXT_ID | ||
RX_CLAIM | CLAIM_TEXT_ID | ||
RX_CLAIM | COMMENT_TXT_ID | ||
RX_CLAIM | RESPONSE_TEXT_ID | ||
RX_IMAGE | COMMENT_ID | ||
RX_MED_REQUEST | REQUEST_REASON_LONG_TEXT_ID | ||
RX_MED_REQUEST | RX_REASON_LONG_TEXT_ID | ||
RX_PENDING_REFILL | MSG_TEXT_ID | ||
RX_REFILL_HX | MSG_TEXT_ID | ||
SA_FLUID_ADMIN | ORDER_LONG_TEXT_ID | ||
SA_MEDICATION_ADMIN | ORDER_LONG_TEXT_ID | ||
SA_TODO_ACTION | LONG_TEXT_ID | ||
SA_TODO_FLUID | LONG_TEXT_ID | ||
SA_TODO_ITEM | LONG_TEXT_ID | ||
SA_TODO_MEDICATION | LONG_TEXT_ID | ||
SCH_APPLY | TEXT_ID | ||
SCH_COMMENT | TEXT_ID | ||
SCH_EVENT_COMM | TEXT_ID | ||
SCH_EVENT_RECUR_COMM | TEXT_ID | ||
SCH_LOG_LIST | TEXT_ID | ||
SCH_WARNING | COMMENT_TEXT_ID | ||
SCH_WARNING_TYPE | DISPLAY_TEXT_ID | ||
SCH_WARNING_TYPE | INFO_SCH_TEXT_ID | ||
SCH_WARN_LEVEL | INFO_SCH_TEXT_ID | ||
SCH_WARN_TYPE | INFO_SCH_TEXT_ID | ||
SEGMENT_REFERENCE | POST_CARE_TEXT_ID | ||
SEGMENT_REFERENCE | PRE_CARE_TEXT_ID | ||
SHX_ACTIVITY | LONG_TEXT_ID | ||
SHX_COMMENT | LONG_TEXT_ID | ||
SI_ERROR_RELTN | ERROR_LONG_TEXT_ID | ||
SI_REPO_REG_RELTN | LONG_TEXT_ID | ||
SI_XDOC_METADATA | COMMENTS_ID | ||
SN_CASE_LONG_TEXT | LONG_TEXT_ID | ||
SN_COMMENT | LONG_TEXT_ID | ||
STORAGE_CONTENT_EVENT | COMMENT_ID | ||
TRACKING_TEXT_MAP | LONG_TEXT_ID | ||
TRANSACTION_ADDRESS_VERIFY | REQUEST_LONG_TEXT_ID | ||
TRANSACTION_ADDRESS_VERIFY | RESPONSE_LONG_TEXT_ID | ||
TRANSACTION_ADMIT_ERROR | LONG_TEXT_ID | ||
TRANSACTION_ELIGIBILITY | REVIEWER_LONG_TEXT_ID | ||
TRANSACTION_ELIG_ERROR | LONG_TEXT_ID | ||
UCM_KARYOTYPE | KARYOTYPE_TEXT_ID | ||
WORKFLOW_TASK_PAUSED | REPLY_LONG_TEXT_ID | ||
WORKFLOW_TASK_PAUSED | REQUEST_LONG_TEXT_ID | ||
WORKFLOW_TASK_QUEUE | REPLY_LONG_TEXT_ID | ||
WORKFLOW_TASK_QUEUE | REQUEST_LONG_TEXT_ID | ||
WORKFLOW_TASK_QUEUE_HIST | REPLY_LONG_TEXT_ID | ||
WORKFLOW_TASK_QUEUE_HIST | REQUEST_LONG_TEXT_ID | ||
WP_TEMPLATE_TEXT | LONG_TEXT_ID |
LONG_TEXT_REFERENCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LONG TEXT REFERENCE |
Definition: | Used to store LONG data that is associated with reference data. |
Table Type: | REFERENCE |
Column Detail - LONG_TEXT_REFERENCE
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 | 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. |
LONG_TEXT | LONGTEXT | N | contains the actual long data |
LONG_TEXT_ID | DOUBLE | N | unique key for each row |
PARENT_ENTITY_ID | DOUBLE | N | Primary key of the parent row |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Name of the parent entity |
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 - LONG_TEXT_REFERENCE
Parent Column in LONG_TEXT_REFERENCE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LONG_TEXT_ID | AP_PROMPT | LONG_TEXT_ID |
BB_QC_TROUBLESHOOTING | TROUBLESHOOTING_TEXT_ID | ||
CAC_RULE | LONG_TEXT_ID | ||
CDI_COVER_PAGE_TEMPLATE | LONG_TEXT_ID | ||
CHART_AP_FORMAT | AP_CPT_LONG_TEXT_ID | ||
CHART_GENERIC_FORMAT | PARAM_LONG_TEXT_ID | ||
CONCEPT_PROPERTY | LONG_TEXT_ID | ||
CR_REPORT_LEGEND | LONG_TEXT_ID | ||
CR_REPORT_SECTION | LONG_TEXT_ID | ||
CR_REPORT_STATIC_REGION | LONG_TEXT_ID | ||
CR_REPORT_STYLE_PROFILE | LONG_TEXT_ID | ||
CR_REPORT_TEMPLATE | LONG_TEXT_ID | ||
CR_TEMPLATE_PUBLISH | LONG_TEXT_ID | ||
CSA_USER_AGREEMENT | AGREEMENT_TEXT_ID | ||
CS_CPP_RULE | LONG_TEXT_ID | ||
CT_RN_PROT_CONFIG | LONG_TEXT_ID | ||
CV_COMPONENT | LONG_TEXT_ID | ||
DASH_COMPONENT | CONTENT_DATA_ID | ||
DASH_COMPONENT | MINI_WIKI_TXT_ID | ||
DA_BATCH_QUERY | ADDITIONAL_PARAMETER_TXT_ID | ||
DA_BATCH_QUERY | RUNTIME_PROMPT_TXT_ID | ||
DA_BATCH_REPORT | ADDITIONAL_PARAMETER_TXT_ID | ||
DA_BATCH_REPORT | REPORT_PARAMETER_TXT_ID | ||
DA_BATCH_REPORT | RUNTIME_PROMPT_TXT_ID | ||
DA_BUS_VIEW | CAT_COL_LONG_TEXT_ID | ||
DA_DOMAIN | DOMAIN_OPTIONS_TXT_ID | ||
DA_ELEMENT | COLUMN_STRING_TXT_ID | ||
DA_ELEMENT | WHERE_CLAUSE_TXT_ID | ||
DA_GROUP_SECURITY | ELEMENT_FILTER_TXT_ID | ||
DA_QUERY | QUERY_TEXT_ID | ||
DA_QUERY_DEFAULT_PROMPTS | DEFAULT_PROMPTS_TEXT_ID | ||
DA_REPORT | LONG_TEXT_ID | ||
DA_REPORT_DEFAULT_PROMPTS | DEFAULT_PROMPTS_TEXT_ID | ||
DA_TABLE_INFO | TABLE_QUERY_TEXT_ID | ||
DA_TABLE_RELTN | FROM_CLAUSE_TXT_ID | ||
DA_TABLE_RELTN | WHERE_CLAUSE_TXT_ID | ||
DA_USER_SECURITY | ELEMENT_FILTER_TXT_ID | ||
DMS_MEDIA_METADATA_REF | LONG_TEXT_ID | ||
DM_REFCHG_INSTRUCTION | INSTRUCTION_TEXT_ID | ||
DM_TEXT_FIND_DETAIL | DETAIL_TEXT_ID | ||
EEM_ABN_DATA | LONG_TEXT_ID | ||
EEM_BENEFIT | INFO_TEXT_ID | ||
EEM_BENEFIT | LONG_TEXT_ID | ||
EEM_BENEFIT_QUAL | LONG_TEXT_ID | ||
EEM_FILE | INFO_TEXT_ID | ||
EEM_IMPORT_ERROR | LONG_TEXT_ID | ||
EEM_NETWORK | LONG_TEXT_ID | ||
EEM_NTWK_PRSNL_RELTN | LONG_TEXT_ID | ||
EEM_PRSNL_LOC_RELTN | LONG_TEXT_ID | ||
ELIG_QUEST_LIBRARY | LONG_TEXT_ID | ||
HE_RULE_GROUP | RULE_TEXT_ID | ||
INTERP_RESULT | LONG_TEXT_ID | ||
INVTN_PROGRAM_GROUP | AUTO_GEN_CRITERIA_TEXT_ID | ||
LH_CNT_IC_ANTIBGRM_ORG_DSC | LONG_TEXT_ID | ||
MED_DISPENSE | RX_STATION_NOTES_ID | ||
MLTM_XP_CLIN_TEXT | LONG_TEXT_ID | ||
MM_MP_WORKLIST_FILTER | LONG_TEXT_ID | ||
PATHWAY_CUSTOMIZED_NOTIFY | LONG_TEXT_ID | ||
PFT_RULE | RULE_LONG_TEXT_ID | ||
PFT_RULE_ACTION | VALUE_LONG_TEXT_ID | ||
PFT_RULE_QUALIFICATION | QUAL_LONG_TEXT_ID | ||
PFT_RULE_QUALIFICATION | VALUE_LONG_TEXT_ID | ||
PFT_WF_ISSUE | EVENT_DEFINITION_ID | ||
PFT_WF_ISSUE | LONG_TEXT_ID | ||
PFT_WF_PROCESS_MODEL | DESCRIPTION_LONG_TEXT_ID | ||
PM_FLX_CONVERSATION | COPY_FIELDS_LONG_TEXT_ID | ||
PM_FLX_CONVERSATION | EPSD_COLUMNS_LONG_TEXT_ID | ||
PM_FLX_CONVERSATION | OPTIONS_LONG_TEXT_REF_ID | ||
PM_FLX_CONV_OPTIONS | VALUE_LONG_TEXT_REF_ID | ||
PM_FLX_PROMPT | EXT_OPTIONS_LONG_TEXT_REF_ID | ||
PM_FLX_PROMPT | RULE_LONG_TEXT_ID | ||
PM_QUE_WORK_LIST | EXEC_SCRIPT_LONG_TEXT_ID | ||
PPR_CONSENT_POLICY | POLICY_TEXT_ID | ||
PROT_ELIG_QUEST | LONG_TEXT_ID | ||
PROT_OBJECTIVE | LONG_TEXT_ID | ||
PROT_QUESTIONNAIRE | DESC_LONG_TEXT_ID | ||
PROT_QUESTIONNAIRE | SPECIAL_INST_LONG_TEXT_ID | ||
PRSNL_COMMENT | COMMENT_LONG_TEXT_ID | ||
RCM_INTERQUAL_ACCOUNT | URL_LONG_TEXT_ID | ||
RCM_THIRD_PARTY_ACCOUNT | URL_LONG_TEXT_ID | ||
RCM_THIRD_PARTY_ACCT_ATTR | LONG_TEXT_ID | ||
RCM_TLC_ACCOUNT | TLC_PRIVATE_KEY_LONG_TEXT_ID | ||
RCM_TLC_ACCOUNT | TLC_PUBLIC_KEY_LONG_TEXT_ID | ||
RCM_TLC_ACCOUNT | URL_LONG_TEXT_ID | ||
RC_CONT_MODEL | DISPLAY_DATA_LONG_TEXT_ID | ||
RC_CONT_NODE | DISPLAY_DATA_LONG_TEXT_ID | ||
RC_CONT_NODE_EDGE | DISPLAY_DATA_LONG_TEXT_ID | ||
RC_RULE | RAW_RULE_LONG_TEXT_ID | ||
RC_RULE | TRSNL_RULE_LONG_TEXT_ID | ||
RX_METHOD | LONG_TEXT_ID | ||
RX_PREP_INFO | LONG_TEXT_ID | ||
RX_THERAP_SBSTTN_FROM | COMMENT_LONG_TEXT_ID | ||
RX_WF_WS | MIXING_INSTR_TEXT_ID | ||
RX_WS | MIXING_INSTR_TEXT_ID | ||
SCH_ACTIVITY | INFO_SCH_TEXT_ID | ||
SCH_APPT_BOOK | INFO_SCH_TEXT_ID | ||
SCH_APPT_SYN | INFO_SCH_TEXT_ID | ||
SCH_APPT_TYPE | INFO_SCH_TEXT_ID | ||
SCH_BOOK_INSTR | INFO_SCH_TEXT_ID | ||
SCH_CAB_SERVICE | INFO_SCH_TEXT_ID | ||
SCH_CODE_REF | INFO_SCH_TEXT_ID | ||
SCH_DATA_COMMENT | TEXT_ID | ||
SCH_DATE_SET | INFO_SCH_TEXT_ID | ||
SCH_DEF_SCHED | INFO_SCH_TEXT_ID | ||
SCH_DISP_SCHEME | INFO_SCH_TEXT_ID | ||
SCH_FLEX_STRING | INFO_SCH_TEXT_ID | ||
SCH_FLEX_TOKEN | INFO_SCH_TEXT_ID | ||
SCH_LIST_ROLE | INFO_SCH_TEXT_ID | ||
SCH_OBJECT | INFO_SCH_TEXT_ID | ||
SCH_QUERY | INFO_SCH_TEXT_ID | ||
SCH_QUERY | TEXT_ID | ||
SCH_REF_COMMENT | TEXT_ID | ||
SCH_REF_FREQ | INFO_SCH_TEXT_ID | ||
SCH_REPORT | INFO_SCH_TEXT_ID | ||
SCH_RESOURCE | INFO_SCH_TEXT_ID | ||
SCH_RESOURCE_LIST | INFO_SCH_TEXT_ID | ||
SCH_RES_GROUP | INFO_SCH_TEXT_ID | ||
SCH_ROLE | INFO_SCH_TEXT_ID | ||
SCH_ROUTE | INFO_SCH_TEXT_ID | ||
SCH_SEC_COMMENT | TEXT_ID | ||
SCH_SEQ_GROUP | INFO_SCH_TEXT_ID | ||
SCH_SLOT_GROUP | INFO_SCH_TEXT_ID | ||
SCH_SLOT_TYPE | INFO_SCH_TEXT_ID | ||
SCH_SUB_TEXT | INFO_SCH_TEXT_ID | ||
SCH_TEMPLATE | INFO_SCH_TEXT_ID | ||
SCH_TEMPLATE | TEXT_ID | ||
SCH_WARNING_LEVEL | INFO_SCH_TEXT_ID | ||
SCH_WARNING_TOKEN | INFO_SCH_TEXT_ID | ||
SCH_WIZARD_COMMENT | TEXT_ID | ||
SCH_WIZARD_TYPE | INFO_SCH_TEXT_ID | ||
SCH_WIZARD_TYPE | TEXT_ID | ||
STATION | DESCRIPTION_TEXT_ID | ||
SYS_CHG_MESSAGE | LONG_TEXT_ID | ||
TPL_APPL_DETAIL | FILE_TMPLT_LONG_TEXT_ID | ||
UCMR_KARYOTYPE | KARYOTYPE_TEXT_REF_ID | ||
UCMR_LAYOUT | XML_FORMATTING_TEXT_ID | ||
UCMR_POSITION_MAP | LONG_TEXT_NOTES_ID | ||
UCMR_STATEMENT | XML_FORMATTING_TEXT_ID | ||
UCMR_WORKSHEET | XML_FORMATTING_TEXT_ID | ||
UCMR_WORKSHEET_STATEMENT_R | XML_FORMATTING_TEXT_ID | ||
USER_DEFINED_VALUE | LONG_TEXT_ID | ||
VISITCODE_INI | LONG_TEXT_ID | ||
WL_CRITERIA | LONG_TEXT_ID |
OCD_INSTALL_LOG
Column Section | Top of Page |
Table-level Detail
Description: | OCD INSTALL LOG |
Definition: | Log table for tracking of components installed via OCD. |
Table Type: | ACTIVITY |
Column Detail - OCD_INSTALL_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPONENT_TYPE | VARCHAR(40) | N | Component type. |
END_STATE | VARCHAR(40) | N | End state name or number. |
INSTALL_DT_TM | DATETIME | N | Date and time of the installation. |
INSTALL_TEXT | VARCHAR(1000) | Y | Stores free text information related to package installation. |
LOG_ID | DOUBLE | N | Primary key. |
OCD | DOUBLE | N | OCD containing the component. |
UPDATE_IND | DOUBLE | N | Update indicator (for future use). |
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. |
TIME_ZONE_R
Column Section | Top of Page |
Table-level Detail
Description: | Time zone relationship table. |
Definition: | Contains relationships between entities like locations and Ops jobs and in what time zones they are located. |
Table Type: | REFERENCE |
Column Detail - TIME_ZONE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | Unique id from the table stored in parent_entity_name. E.g. the location_cd or ops_job_id which isassociated with the time_zone. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Table from which the parent_entity_id comes. E.g. "LOCATION" or "OPS_JOB". |
TIME_ZONE | VARCHAR(100) | Y | Time zone string from the datertl that the parent_entity_name/id is associated with. E.g. 'America/Phoenix'. |
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. |