Table Detail Report

BB_UPLOAD_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: BB Upload Review
Definition: This table will be used to track errors during the history upload of person ABO/Rh's. When an error occurs with the upload, one row will be written to this table.
Table Type: ACTIVITY





Column Detail - BB_UPLOAD_REVIEW


Column Name Type Null? Definition
BB_UPLOAD_REVIEW_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row.
DEMOG_ABORH_DT_TM DATETIME Y Date/Time the demographic ABO/Rh was last resulted or uploaded.
DEMOG_PERSON_ABORH_ID DOUBLE N This is the value of the unique identifier to the person_aborh table for the previous ABO/Rh value that was inactivated.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REVIEWED_IND DOUBLE N An indicator showing if this row has been reviewed.
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.
UPLOAD_DT_TM DATETIME N Date/Time the upload occurred.
UPLOAD_PERSON_ABORH_ID DOUBLE N This is the value of the unique identifier to the person_aborh table for the ABO/Rh value uploaded.



Relationship Detail - BB_UPLOAD_REVIEW


Child Column in BB_UPLOAD_REVIEW(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
DEMOG_PERSON_ABORH_ID PERSON_ABORH PERSON_ABORH_ID
UPLOAD_PERSON_ABORH_ID PERSON_ABORH PERSON_ABORH_ID




Parent Column in BB_UPLOAD_REVIEW (PK) Child Table Name Child Column Name
Children: BB_UPLOAD_REVIEW_ID BB_UPLOAD_LONG_TEXT_R BB_UPLOAD_REVIEW_ID
BB_UPLOAD_PERSON_ABORH_R BB_UPLOAD_REVIEW_ID