Table Detail Report
MLLD_DDM_CONDITION
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_DDM_CONDITION
Column Name | Type | Null? | Definition |
---|---|---|---|
BODY_SYSTEM_ID | DOUBLE | N | Body System ID - FK from MLTM_DDM_BODY_SYSTEM table |
CONDITION_ID | DOUBLE | N | Condition ID - PK Column for this table. Also FK from MLTM_DDM_CONDITION_LIST table |
MEDICAL_SPECIALTY_ID | DOUBLE | N | Medical Specialty ID - FK from MLTM_MEDICAL_SPECIALTY table |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
MLLD_DDM_CONDITION_HCFA_MAP
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_DDM_CONDITION_HCFA_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
CONDITION_ID | DOUBLE | N | PK column for this table. Also FK from table MLTM_DDM_CONDITION_LIST |
ICD_9 | VARCHAR(6) | N | ICD_9 Text FK from MLTM_DDM_MAP table |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
MLLD_DDM_CONDITION_LIST
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_DDM_CONDITION_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ABBREVIATION | VARCHAR(30) | Y | Condition Abbreviation |
CONDITION_ID | DOUBLE | N | The PK Column for this table |
DESCRIPTION | VARCHAR(255) | Y | Condition Description |
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. |
MLLD_DDM_CONDITION_XREF_MAP
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_DDM_CONDITION_XREF_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
CONDITION_ID | DOUBLE | N | Condition ID - 2nd column of 2-column PK. FK from MLTM_DDM_CONDITION_LIST |
PARENT_CONDITION_ID | DOUBLE | N | Parent Condition ID - 1st column of 2-column PK. FK from MLTM_DDM_CONDITION |
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. |
MLLD_DDM_GROUP
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_DDM_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
GROUP_COMMENT | VARCHAR(4000) | Y | Group Comment Text |
GROUP_DESCRIPTION | VARCHAR(60) | Y | Group Description Text |
GROUP_ID | DOUBLE | N | Group ID - PK Column for this table |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |