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 |