Table Detail Report

CYTO_STANDARD_RPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Standard Report
Definition: This reference table contains the parameters (excluding the definition of result values) for each standard report created for a specific cytology report order catalog item.
Table Type: REFERENCE





Column Detail - CYTO_STANDARD_RPT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
CATALOG_CD DOUBLE N This field contains the internal identification code of the cytology report for which the standard report has been defined. This value could be used to join to the order catalog tables, if desired.
DESCRIPTION VARCHAR(40) Y This field contains the long description of the standard report.
HOT_KEY_SEQUENCE DOUBLE Y If a hot key has been established for the standard report, this field contains a value representing the hot key sequence (first, second, third¿ tenth).
SHORT_DESC CHAR(5) Y This field contains the short description of the standard report.
STANDARD_RPT_ID DOUBLE N This field uniquely defines a row (a standard report) included on the CYTO_STANDARD_REPORT table. This field would be used to join to other tables, such as the CYTO_STANDARD_REPORT_R reference 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.



Relationship Detail - CYTO_STANDARD_RPT


Child Column in CYTO_STANDARD_RPT(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD




Parent Column in CYTO_STANDARD_RPT (PK) Child Table Name Child Column Name
Children: STANDARD_RPT_ID CYTO_SCREENING_EVENT STANDARD_RPT_ID
CYTO_STANDARD_RPT_R STANDARD_RPT_ID


CYTO_STANDARD_RPT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Standard Report Reltn
Definition: This reference table contains the result value parameters associated with each standard report created for a specific cytology report order catalog item.
Table Type: REFERENCE





Column Detail - CYTO_STANDARD_RPT_R


Column Name Type Null? Definition
NOMENCLATURE_ID DOUBLE N This field contains the internal ID code of the alpha response value associated with the report component procedure. This field includes a valid option only if the procedure result type is alpha, and if the result is included in the standard report.
RESULT_CD DOUBLE N This column is obsolete.
RESULT_TEXT LONGTEXT Y This field contains the result text value associated with the report component procedure. This field includes text only if the procedure result type is textual, and if the result is included in the standard report.
STANDARD_RPT_ID DOUBLE N This field contains the foreign key value identifying the standard report to which the report component procedure information is associated. This value could be used to join to the CYTO_STANDARD_REPORT table.
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code of the report component (discrete task) for which result values are defined to be included within the standard report.
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 - CYTO_STANDARD_RPT_R


Child Column in CYTO_STANDARD_RPT_R(FK) Parent Table Name Parent Column Name
Parents: STANDARD_RPT_ID CYTO_STANDARD_RPT STANDARD_RPT_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


DAILY_CYTOLOGY_COUNTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Daily Cytology Counts
Definition: This activity table contains daily slide count and rescreening information for a specific cytotechnologist. Information such as the # of screening hours, # of slides screened, # of slide rescreened, and # slides selected for rescreening are included.
Table Type: ACTIVITY





Column Detail - DAILY_CYTOLOGY_COUNTS


Column Name Type Null? Definition
CHR_CASES DOUBLE Y This field includes the number of cases that were selected for rescreening due to the clinically high risk indicator, for the cytotechnologist, for a single day.
CHR_SLIDES DOUBLE Y This field includes the number of slides that were evaluated (but possibly not selected) for rescreening due to the clinically high risk indicator, for the cytotechnologist, for a single day.
CHR_SLIDES_REQUEUED DOUBLE Y This field includes the number of slides that were selected for rescreening due to the clinically high risk indicator, for the cytotechnologist, for a single day.
COMMENTS VARCHAR(100) Y This field includes a daily statistics comment entered by the cytotechnologist, if present.
EXCEEDED_LIMIT_CASES DOUBLE Y This field includes the number of cases that were screened or rescreened by the cytotechnologist after the cytotechnologist's daily limit had been exceeded.
EXCEEDED_LIMIT_SLIDES DOUBLE Y This field includes the number of slides that were screened or rescreened by the cytotechnologist after the cytotechnologist's daily limit had been exceeded.
GYN_CASES_IS DOUBLE Y This field includes the total number of gynecologic cytology cases initially screened for a single day.
GYN_CASES_RS DOUBLE Y This field includes the total number of gynecologic cytology cases rescreened for a single day.
GYN_INSTRUMENT_SCREENING DOUBLE Y This field is not used at this time.
GYN_SLIDES_IS DOUBLE Y This field includes the total number of gynecologic cytology slides initially screened for a single day.
GYN_SLIDES_RS DOUBLE Y This field includes the total number of gynecologic cytology slides rescreened for a single day.
NGYN_CASES_IS DOUBLE Y This field includes the total number of non-gynecologic cytology cases initially screened for a single day.
NGYN_CASES_RS DOUBLE Y This field includes the total number of non-gynecologic cytology cases rescreened for a single day.
NGYN_SLIDES_IS DOUBLE Y This field includes the total number of non-gynecologic cytology slides initially screened for a single day.
NGYN_SLIDES_RS DOUBLE Y This field includes the total number of non-gynecologic cytology slides rescreened for a single day.
NORMAL_CASES DOUBLE Y This field includes the number of cases that were selected for rescreening due to the previous normal flag, for the cytotechnologist, for a single day.
NORMAL_SLIDES DOUBLE Y This field includes the number of slides that were evaluated (but possibly not selected) for rescreening due to the previous normal flag, for the cytotechnologist, for a single day.
NORMAL_SLIDES_REQUEUED DOUBLE Y This field includes the number of slides that were selected for rescreening due to the previous normal flag, for the cytotechnologist, for a single day.
OUTSIDE_GYN_IS DOUBLE Y This field includes the total number of gynecologic cytology slides screened at outside institutions.
OUTSIDE_GYN_RS DOUBLE Y This field includes the total number of gynecologic cytology slides rescreened at outside institutions.
OUTSIDE_HOURS DOUBLE Y This field includes the total number of hours spent screening or rescreening slides for outside institutions.
OUTSIDE_NGYN_IS DOUBLE Y This field includes the total number of non-gynecologic cytology slides screened at outside institutions.
OUTSIDE_NGYN_RS DOUBLE Y This field includes the total number of non-gynecologic cytology slides rescreened at outside institutions.
PREV_ABNORMAL_CASES DOUBLE Y This field includes the number of cases that were selected for rescreening due to the previous abnormal flag, for the cytotechnologist, for a single day.
PREV_ABNORMAL_SLIDES DOUBLE Y This field includes the number of slides that were evaluated (but possibly not selected) for rescreening due to the previous abnormal flag, for the cytotechnologist, for a single day.
PREV_ABN_SLIDES_REQUEUED DOUBLE Y This field includes the number of slides that were selected for rescreening due to the previous abnormal flag, for the cytotechnologist, for a single day.
PREV_ATYPICAL_CASES DOUBLE Y This field includes the number of cases that were selected for rescreening due to the previous atypical flag, for the cytotechnologist, for a single day.
PREV_ATYPICAL_SLIDES DOUBLE Y This field includes the number of slides that were evaluated (but possibly not selected) for rescreening due to the previous atypical flag, for the cytotechnologist, for a single day.
PREV_ATYP_SLIDES_REQUEUED DOUBLE Y This field includes the number of slides that were selected for rescreening due to the previous atypical flag, for the cytotechnologist, for a single day.
PROFICIENCY_SLIDES DOUBLE Y This field includes the number of proficiency slides that were screened.
PRSNL_ID DOUBLE N This field uniquely identifies the cytotechnologist for whom the DAILY_SLIDE_COUNTS record was written. This value could be used to join to other tables, such as the PRSNL, PERSON, and CYTO_SCREENING_LIMITS, for example.
QA_SLIDES DOUBLE Y This field includes the number of quality assurance slides that were screened.
RECORD_DT_TM DATETIME N This field includes the date for which the DAILY_CYTOLOGY_COUNTS record is associated.
SCREEN_HOURS DOUBLE Y This field documents the number of screening hours accepted by the cytotechnologist for the specific date.
UNSAT_CASES DOUBLE Y This field includes the number of cases that were selected for rescreening due to an unsatisfactory result, for the cytotechnologist, for a single day.
UNSAT_SLIDES DOUBLE Y This field includes the number of slides that were evaluated (but possibly not selected) for rescreening due to an unsatisfactory result, for the cytotechnologist, for a single day.
UNSAT_SLIDES_REQUEUED DOUBLE Y This field includes the number of slides that were selected for rescreening due to an unsatisfactory result, for the cytotechnologist, for a single day.
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.
USER_PREFERENCE_CASES DOUBLE Y This field includes the number of cases that were manually selected (by the cytotechnologist) for rescreening for the specific date.
USER_PREFERENCE_SLIDES DOUBLE Y This field includes the number of slides that were manually selected (by the cytotechnologist) for rescreening for the specific date.



Relationship Detail - DAILY_CYTOLOGY_COUNTS


Child Column in DAILY_CYTOLOGY_COUNTS(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


FT_TERM_CANDIDATE_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Followup Tracking Termination Candidate List
Definition: This activity table contains records of all patients, for whom an active follow-up tracking record is present, who are considered (based on pathology activity) candidates to have their current follow-up tracking activity terminated.
Table Type: ACTIVITY





Column Detail - FT_TERM_CANDIDATE_LIST


Column Name Type Null? Definition
FOLLOWUP_EVENT_ID DOUBLE N This field contains the foreign key value used to join to follow-up tracking information stored on the AP_FT_EVENT activity table.
REVIEW_CASE_ID DOUBLE N This field contains the foreign key value used to identify the pathology case which caused the system to flag the follow-up tracking event as a possible termination candidate. This could be used to join to case information stored on PATHOLOGY_CASE.
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 - FT_TERM_CANDIDATE_LIST


Child Column in FT_TERM_CANDIDATE_LIST(FK) Parent Table Name Parent Column Name
Parents: FOLLOWUP_EVENT_ID AP_FT_EVENT FOLLOWUP_EVENT_ID
REVIEW_CASE_ID PATHOLOGY_CASE CASE_ID


INSTRUMENT_PROTOCOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Instrument Protocol
Definition: Stores the protocols for an instrument type.
Table Type: REFERENCE





Column Detail - INSTRUMENT_PROTOCOL


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.
INSTRUMENT_PROTOCOL_ID DOUBLE N Uniquely identifies the protocol for an instrument type.
INSTRUMENT_TYPE_CD DOUBLE N Contains the code value for the staining instrument type.
PLACER_FIELD_1 VARCHAR(60) N This field provides additional information to the instrument such as the label template (OBR - 18 in HL7 message).
PROC_CODE_TXT VARCHAR(250) N Specific procedure code for the universal service identifier (OBR - 44 in HL7 message).
PROTOCOL_NAME VARCHAR(50) N Contains the free text description of the instrument protocol.
SUPLMTL_SERV_INFO_TXT VARCHAR(250) N Describes additional service information for the universal service identifier (OBR - 46 in HL7 message).
UNIVERSAL_SERVICE_IDENT VARCHAR(250) N The string identifier of the instrument protocol (OBR - 4 in HL7 message).
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 - INSTRUMENT_PROTOCOL




Parent Column in INSTRUMENT_PROTOCOL (PK) Child Table Name Child Column Name
Children: INSTRUMENT_PROTOCOL_ID PROC_INSTRMT_PROTCL_R INSTRUMENT_PROTOCOL_ID
TASK_INSTRMT_PROTCL_R INSTRUMENT_PROTOCOL_ID