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.