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