Table Detail Report

DRG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the DRG codes for a coded chart.
Definition: Stores fields like nomenclaure code, drg payor code and contributor system code
Table Type: ACTIVITY





Column Detail - DRG


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.
COMORBIDITY_CD DOUBLE N Identifies the comorbidity tier of the grouper.
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.
CREATE_DT_TM DATETIME Y This is the date and time that the row was created
CREATE_PRSNL_ID DOUBLE N The Person who created the row
DRG_ID DOUBLE N This is the value of the unique primary identifier of the DRG table. It is an internal system assigned number
DRG_PAYMENT DOUBLE Y This is the expected payment for this DRG
DRG_PAYOR_CD DOUBLE N Identifies the payer for the grouper.
DRG_PRIORITY DOUBLE Y This is the priority or order that we received the drg's (1,2,3¿ primary being 1)
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
GROUPER_CD DOUBLE N This is the grouper that was used to calculate the estimated reimbursement.
MDC_APR_CD DOUBLE N The code values for Major Diagnosis Code for 3Ms APR-DRG codes.
MDC_CD DOUBLE N The code values for Major Diagnosis Code
NOMENCLATURE_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number
OUTLIER_COST DOUBLE Y Indicates the difference in cost for the grouper vs. average cost.
OUTLIER_DAYS DOUBLE Y Indicates the difference in days for the grouper vs. average number of days.
OUTLIER_REIMBURSEMENT_COST DOUBLE Y Indicates the difference in reimbursement cost for the grouper vs. average reimbursement cost.
PARENT_ENTITY_ID DOUBLE N Primary key ID from the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N Parent table name.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RISK_OF_MORTALITY_CD DOUBLE N This is the code_value for risk of mortality
SEVERITY_OF_ILLNESS_CD DOUBLE N This is the code_value for severity of illness
SOURCE_VOCABULARY_CD DOUBLE N The code values for source_vocabulary
SVC_CAT_HIST_ID DOUBLE N This is the unique identifier for the service category history table.
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 - DRG


Child Column in DRG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID




Parent Column in DRG (PK) Child Table Name Child Column Name
Children: DRG_ID DRG_ENCNTR_EXTENSION DRG_ID


DRG_ENCNTR_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DRG ENCNTR EXTENSION
Definition: Encounter level DRG informantion such as weight, desc...
Table Type: ACTIVITY





Column Detail - DRG_ENCNTR_EXTENSION


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.
ALOS DOUBLE Y This is the alos assigned for this DRG
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.
CASE_RESOURCE_WEIGHT DOUBLE Y This is the assigned case resource weight
COMPLEXITY_OVERLAY DOUBLE Y This is the assigned complexity overlay assigned to this DRG
COMPLEXITY_OVERLAY_TEXT VARCHAR(255) Y This is the text that was assigned by the encoder and passed into Cerner systems.
DAY_THRESHOLD DOUBLE Y This is the day threshold that was assigned by the encoder and passed into Cerner systems.
DRG_ENCNTR_EXTENSION_ID DOUBLE N This is the unique identifier for the DRG encounter extension table, it is a system assigned number.
DRG_ID DOUBLE N This is the value of the unique primary identifier of the DRG table.
DRG_SPECIALTY_ID DOUBLE N This is the value of the unique primary identifier of the drg_specialty table.
DRG_WEIGHT DOUBLE Y Stores the DRG weight for groupers whose weights are not stored in the drg_extension table. Null = Look for the weight in the drg_extension table -1 = Blank Values >= 0 are valid weights.
ELOS DOUBLE Y This is the estimated length of stay that was assigned by the encoder and passed into Cerner systems.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
EPISODE_CLINICAL_COMPLEX_SCORE DOUBLE Y The ECCS is the measure of the cumulative effect of Diagnosis Complexity Level for a specific episode. Episode Clinical Complexity Score (ECCS), which replaces PCCL in AR-DRG v 8.0 and used for reimbursement calculation.
HIGH_TRIM_VALUE DOUBLE Y A figure representing the high trim point of the WIES calculation.
HOSPITAL_BASE_RATE DOUBLE Y This field is only populated when using the 3M Canadian encoder. It is base reimbursement rate for the hospitals
HRS_MECH_VENT_VALUE DOUBLE Y A figure representing a co-payment under WIES, used in accurate calculation of WIES
LOW_TRIM_VALUE DOUBLE Y A figure representing the low trim point of the WIES calculation.
MCC DOUBLE Y This is the MCC that was assigned by the encoder and passed into Cerner systems.
MCC_TEXT VARCHAR(255) Y This is the MCC text that was assigned by the encoder and passed into Cerner systems.
ONTARIO_CASE_WEIGHT DOUBLE Y This is the ontario case weight that was assigned by the encoder and passed into Cerner systems.
PATIENT_STATUS_CD DOUBLE N This is the patient status that was returned from the encoder (i.e. Typical Patient, Transfer patient, Long-stay patient...).
PERDIEM DOUBLE Y This is the Per diem that was assigned by the encoding system.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SOURCE_IDENTIFIER VARCHAR(50) N This is the source identifier (i.e. the DRG code).
SOURCE_VOCABULARY_CD DOUBLE N This is the type of code i.e. CPT, ICD-9-CM...
SVC_CAT_HIST_ID DOUBLE N This is the unique identifier for the service category history table.
TOTAL_EST_REIMB DOUBLE Y This is the estimated reimbursement amount for the particular code, returned from the encoder.
TOTAL_EST_REIMB_VALUE DOUBLE Y This field is only populated when using the 3M Canadian encoder. It stores the Ontario case weight except in the case of atypical lengths of stay
TOTAL_REIMB_VALUE DOUBLE Y This field is the actual total reimbursement value if one is collected from the Billing system.
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.
WIES_FUNDING_AMT DOUBLE Y The dollar amount allocated to the provider for healthcare reimbursement.
WIES_WEIGHT_VALUE DOUBLE Y A figure representing the Weighted Inlier Equivalent Separations.



Relationship Detail - DRG_ENCNTR_EXTENSION


Child Column in DRG_ENCNTR_EXTENSION(FK) Parent Table Name Parent Column Name
Parents: DRG_ID DRG DRG_ID
DRG_SPECIALTY_ID DRG_SPECIALTY DRG_SPECIALTY_ID
ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID


DRG_EXTENSION



Column Section Top of Page


Table-level Detail

Description: DRG Extension table hold additional DRG info now stored on the nomenclature
Definition: Stores fields such as MDC, DRG weight...
Table Type: REFERENCE





Column Detail - DRG_EXTENSION


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 Y 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 Y The person who caused the active_status_cd to be set or change.
AMLOS DOUBLE Y This stores the Arithmetic mean length of stay assigned for this DRG
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.
DRG_CATEGORY VARCHAR(10) Y The category that the Diagnostic Related Group is associated with in accordance with the Major Diagnostic Groups.
DRG_WEIGHT DOUBLE Y The weight of the diagnostic related group determines the amount of reimbursement entitled to the organization.
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.
GMLOS DOUBLE Y A way to figure the length of stay geometrically
MDC_CD DOUBLE Y Major Diagnostic Category Code
SEVERITY_OF_ILLNESS_CD DOUBLE N This is the code value for severity of illness.
SOURCE_IDENTIFIER VARCHAR(50) N The code or key from the source vocabulary that contributed the string to the nomenclature
SOURCE_VOCABULARY_CD DOUBLE N The external vocabulary or lexicon that contributed the string, example ICD-9, SNOMED etc.
TRANSFER_RULE_IND DOUBLE N This field indicates where the DRG is subject to the Transfer Rule
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.


DRG_SPECIALTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Drug Specialty
Definition: Used to store information for special groupers (such as HAC groupers) that will not be sent on the bill and may need special processing.
Table Type: ACTIVITY





Column Detail - DRG_SPECIALTY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME 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.
COMORBIDITY_CD DOUBLE N Identifies the comorbidity tier of the grouper.
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.
CREATE_DT_TM DATETIME Y This is the date and time that the row was created
CREATE_PRSNL_ID DOUBLE N The Person who created the row.
DRG_PAYMENT DOUBLE Y This is the expected payment for this drug.
DRG_PAYOR_CD DOUBLE N The drug payor code
DRG_PRIORITY DOUBLE Y This is the priority or order that we received the drug's (1,2,3? primary being 1).
DRG_SPECIALTY_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
EPISODE_CLINICAL_COMPLEX_SCORE DOUBLE Y The ECCS is the measure of the cumulative effect of Diagnosis Complexity Level for a specific episode. Episode Clinical Complexity Score (ECCS), which replaces PCCL in AR-DRG v 8.0 and used for reimbursement calculation.This column is **OBSOLETE** on this table.
GROUPER_CD DOUBLE N This is the grouper that was used to calculate the estimated reimbursement.
HAC_ADJUSTMENT_VALUE DOUBLE Y The adjustment value of the adopted HAC (i.e., the highest complexity HAC) used for the funding adjustment.
HAC_COMPLEXITY_GROUP_TXT VARCHAR(10) Y Complexity group of the adopted HAC used for the funding adjustment.
HAC_COMPLEX_SCORE_NBR DOUBLE Y The total complexity score of the adopted HAC used for the funding adjustment.
HAC_GROUP DOUBLE Y The HAC group of the adopted HAC used for the funding adjustment.
HAC_IND DOUBLE N Indicates whether the grouper was modified as a result of a Hospital Acquired Condition (HAC) diagnosis. This grouper would be the initial grouper before reimbursement was changed as a result of a HAC code.
MDC_APR_CD DOUBLE N The code values for Major Diagnosis Code for 3Ms APR-Drug codes.
MDC_CD DOUBLE N The code values for Major Diagnosis Code
NOMENCLATURE_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number.
OUTLIER_COST DOUBLE Y Indicates the difference in cost for the grouper vs. average cost.
OUTLIER_DAYS DOUBLE Y Indicates the difference in days for the grouper vs. average number of days.
OUTLIER_REIMBURSEMENT_COST DOUBLE Y Indicates the difference in reimbursement cost for the grouper vs. average reimbursement cost.
PARENT_ENTITY_ID DOUBLE N Primary key ID from the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N Parent table name.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RISK_OF_MORTALITY_CD DOUBLE N This is the code value for risk of mortality.
SEVERITY_OF_ILLNESS_CD DOUBLE N This is the code value for severity of illness.
SOURCE_VOCABULARY_CD DOUBLE N The code values for source vocabulary.
SVC_CAT_HIST_ID DOUBLE N This is the unique identifier for the service category history table.
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 - DRG_SPECIALTY


Child Column in DRG_SPECIALTY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID




Parent Column in DRG_SPECIALTY (PK) Child Table Name Child Column Name
Children: DRG_SPECIALTY_ID DRG_ENCNTR_EXTENSION DRG_SPECIALTY_ID


DSM_ASSESSMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DSM-IV Assessments
Definition: DSM-IV Assessments
Table Type: ACTIVITY





Column Detail - DSM_ASSESSMENT


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.
ASSESSMENT_DT_TM DATETIME Y The date/time that the assessment was recorded.
ASSESSMENT_TYPE_CD DOUBLE N Defines the timeframe of the assessment.
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.
CGI1_CD DOUBLE N CGI1
CGI2_CD DOUBLE N CGI2
DIAG_DT_TM DATETIME Y The date and time for which this assessment was added.
DIAG_PRSNL_ID DOUBLE N The person_id of the person on whose behalf the assessment was added.
DSM_ASSESSMENT_ID DOUBLE N Unique identification for an individual assessment
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person 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.



Relationship Detail - DSM_ASSESSMENT


Child Column in DSM_ASSESSMENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in DSM_ASSESSMENT (PK) Child Table Name Child Column Name
Children: DSM_ASSESSMENT_ID DSM_COMPONENT DSM_ASSESSMENT_ID