Table Detail Report

RAD_TRANS_STATS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Transcription Statistics
Definition: The rad_trans_stats table stores transcription productivity statistics at the report level.
Table Type: ACTIVITY





Column Detail - RAD_TRANS_STATS


Column Name Type Null? Definition
CHAR_CNT DOUBLE Y The char_cnt column stores the number of characters that were a part of a given reports edit session.
LAST_TRANS_DT_TM DATETIME Y The last_trans_dt_tm column stores the date and time that the reports edit session was completed.
LAST_TRANS_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LINE_CNT DOUBLE Y The line_cnt column stores the number of lines that were a part of a given reports edit session.
RAD_REPORT_ID DOUBLE N The rad_report_id column serves as a foreign key to the rad_report table. It uniquely identifies the report that the transcription statistics are related to.
SEQUENCE DOUBLE N The sequence along with the rad_report_id column serve as a unique identifier for a row on the rad_trans_stats table.
TRANS_PRSNL_ID DOUBLE Y The trans_prsnl_id serves as a foreign key to the prsnl table. It uniquely identifies the transcriptionist responsible for the transcription productivity.
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.
WORD_CNT DOUBLE Y The word_cnt column stores the number of words that were a part of a given reports edit session.



Relationship Detail - RAD_TRANS_STATS


Child Column in RAD_TRANS_STATS(FK) Parent Table Name Parent Column Name
Parents: TRANS_PRSNL_ID PRSNL PERSON_ID
RAD_REPORT_ID RAD_REPORT RAD_REPORT_ID