DCP_CF_TRANS_CAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Facts transfer categories |
Definition: | The purpose of the table is to hold the reference content that will used tor transfer the clinical facts from a patient A to Patient B during pregnancy, organ donation and so on. |
Table Type: | REFERENCE |
Column Detail - DCP_CF_TRANS_CAT
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. |
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. |
CF_CATEGORY_NAME | VARCHAR(100) | N | Name of the category as defined by the user for which the transfer of data is going to happen. |
CF_TRANSFER_TYPE_CD | DOUBLE | N | Describe for what Transfer_type they are going to use the category for. Code_set : 7000 will define transfer_type_cd |
DCP_CF_TRANS_CAT_ID | DOUBLE | N | Unique identifier for the table |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
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 - DCP_CF_TRANS_CAT
Parent Column in DCP_CF_TRANS_CAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DCP_CF_TRANS_CAT_ID | DCP_CF_TRANS_CAT_RELTN | DCP_CF_TRANS_CAT_ID |
DCP_CF_TRANS_CAT_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Facts transfer categories |
Definition: | The purpose of the table is to hold the reference content that will relate DCP_FT_TRANS_CAT and DCP_CF_TRANS_EVENT_CD_R table |
Table Type: | REFERENCE |
Column Detail - DCP_CF_TRANS_CAT_RELTN
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. |
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. |
DCP_CF_TRANS_CAT_ID | DOUBLE | N | Identifier for the category of results that needs to be transferred. |
DCP_CF_TRANS_CAT_RELTN_ID | DOUBLE | N | TO have Primary key on the table. |
DCP_CF_TRANS_EVENT_CD_R_ID | DOUBLE | N | Identifier where the event cd relationship exists |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
RELTN_SEQUENCE | DOUBLE | N | The sequence of relation |
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 - DCP_CF_TRANS_CAT_RELTN
Child Column in DCP_CF_TRANS_CAT_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DCP_CF_TRANS_CAT_ID | DCP_CF_TRANS_CAT | DCP_CF_TRANS_CAT_ID |
DCP_CF_TRANS_EVENT_CD_R_ID | DCP_CF_TRANS_EVENT_CD_R | DCP_CF_TRANS_EVENT_CD_R_ID |
DCP_CF_TRANS_EVENT_CD_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Facts transfer categories |
Definition: | The purpose of the table is to hold the reference content that will relate source and target event code based on transfer_type and related indentifier that is needed to move the data |
Table Type: | REFERENCE |
Column Detail - DCP_CF_TRANS_EVENT_CD_R
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. |
ASSOCIATION_IDENTIFIER_CD | DOUBLE | N | This is unique identifier that will define either fetus/baby identifier or organ identifier. This will zero if the data need moved for all identifier. Code set:6999. |
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. |
CF_TRANSFER_TYPE_CD | DOUBLE | N | This will specify the reason for moving the data from target to source domain. Possible reasons for transferring specified in the code_set:7000 |
DCP_CF_TRANS_EVENT_CD_R_ID | DOUBLE | N | To have Primary key/unique identifier on the table. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
SOURCE_EVENT_CD | DOUBLE | N | From code_set:72. This is the event_cd that's when results are documented, since target is not established. |
TARGET_EVENT_CD | DOUBLE | N | This is the event_cd is where the results are going to transfer to on targets record. From code_set:72. This is the event_cd that's when results are going to be transfer to target_cd |
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 - DCP_CF_TRANS_EVENT_CD_R
Parent Column in DCP_CF_TRANS_EVENT_CD_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DCP_CF_TRANS_EVENT_CD_R_ID | DCP_CF_TRANS_CAT_RELTN | DCP_CF_TRANS_EVENT_CD_R_ID |