Table Detail Report

MONTHLY_CYTOLOGY_COUNTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Monthly Cytology Counts
Definition: This activity table contains monthly 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 - MONTHLY_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 month.
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 month.
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 month.
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 the month.
GYN_CASES_RS DOUBLE Y This field includes the total number of gynecologic cytology cases rescreened for the month.
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 the month.
GYN_SLIDES_RS DOUBLE Y This field includes the total number of gynecologic cytology slides rescreened for the month.
NGYN_CASES_IS DOUBLE Y This field includes the total number of non-gynecologic cytology cases initially screened for the month.
NGYN_CASES_RS DOUBLE Y This field includes the total number of non-gynecologic cytology cases rescreened for the month.
NGYN_SLIDES_IS DOUBLE Y This field includes the total number of non-gynecologic cytology slides initially screened for the month.
NGYN_SLIDES_RS DOUBLE Y This field includes the total number of non-gynecologic cytology slides rescreened for the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 the month.
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 MONTHLY_CYTOLOGY_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 of the first day of the month to which this MONTHLY_CYTOLOGY_COUNTS record is associated.
SCREEN_HOURS DOUBLE Y This field documents the number of screening hours accepted by the cytotechnologist for the month.
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 the month.
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 the month.
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 the month.
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 month.
USER_PREFERENCE_SLIDES DOUBLE Y This field includes the number of slides that were manually selected (by the cytotechnologist) for rescreening for the month.



Relationship Detail - MONTHLY_CYTOLOGY_COUNTS


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


PATHOLOGY_CASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathology Case
Definition: This activity table contains a single record for every pathology case included in the PathNet Anatomic Pathology system. It is a key table for most queries (every case has a record included), and the records are maintained indefinately.
Table Type: ACTIVITY





Column Detail - PATHOLOGY_CASE


Column Name Type Null? Definition
ACCESSIONED_DT_TM DATETIME Y This field includes the date and time the case was accessioned.
ACCESSION_NBR CHAR(21) Y This field includes the case number assigned to the pathology case.
ACCESSION_PRSNL_ID DOUBLE N This field contains the internal identification code associated with the user who accessioned the case (the user who caused the row to be added to the PATHOLOGY_CASE table. This value could be used to join to information on the PRSNL and PERSON tables.
AUTOPSY_DESCRIPTION VARCHAR(100) Y This field is not used at this time.
AUTOPSY_SCOPE_CD DOUBLE N This field is not used at this time.
BLOB_BITMAP DOUBLE Y This column indicates whether or not there is any additional blob data associated with this case row (i.e. case images).
CANCEL_CD DOUBLE N If the case is cancelled, this field contains the identification code associated with the cancellation reason.
CANCEL_DT_TM DATETIME Y If the case is cancelled, this field contains the date and time the cancellation event occurred.
CANCEL_ID DOUBLE N If the case is cancelled, this field contains the internal identification code of the user who executed the cancellation event. This value could be used to join to user information stored on the PRSNL and PERSON tables.
CASE_COLLECT_DT_TM DATETIME Y This field includes the collection date and time associated with the case. Note that collection date and time information specific to the specimen(s) submitted for the case is stored on the CASE_SPECIMEN table.
CASE_ID DOUBLE N This field uniquely identifies a row included on the PATHOLOGY_CASE table. This field is used to represent a pathology case, and would be used to join to other tables (as a foreign key) such as the CASE_REPORT and CASE_SPECIMEN tables.
CASE_NUMBER DOUBLE N This field includes the sequential number portion of the case (accession) number. The entire number is stored in the ACCESSION_NBR field.
CASE_RECEIVED_DT_TM DATETIME Y This field includes the received date and time associated with the case. Note that the received date and time information specific to the specimen(s) submitted for the case is stored on the CASE_SPECIMEN table.
CASE_TYPE_CD DOUBLE N This field includes the identification code associated with the case type value. The case type is used to generically categorize the case based on the accession prefix value. Examples of case types include surgical, gyn, non-gyn, and autopsy.
CASE_YEAR DOUBLE N This field includes the year portion of the case (accession) number. The entire number is stored in the ACCESSION_NBR field.
CHR_IND DOUBLE Y This indicator value specifies, for a pathology case, whether or not the patient was flagged as being at "clinical high risk (CHR)" for developing cervical cancer. If a value exists in the MAIN_REPORT_COMPLETE_DT_TM field for the case, the CHR flag is classified as a final (historical) flag. If a date/time value does not exist, the flag is classified as a preliminary flag.
COMMENTS VARCHAR(255) Y This field is no longer used. Refer to the COMMENTS_LONG_TEXT_ID for information regarding the pathology case comment.
COMMENTS_LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the pathology case comment.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATASET_UID VARCHAR(128) Y This field contains the dataset UID string that will be assigned for this case. Each DICOM image that is attached to this case will use this dataset UID string.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXT_ACCESSION_NBR CHAR(21) Y This field contains the 'accession_nbr' from a contributor_system_cd. This field is only field out on a AP history upload.
GROUP_ID DOUBLE N This field contains the foreign key value used to join to accession group information. Accession group information is stored in common tables, and AP-specific accession group information is stored on the PREFIX_GROUP table.
INTERFACE_SEND_CNT DOUBLE N This field counts the number of times a case is interfaced to a foreign system is sent outbound.
LOC_BUILDING_CD DOUBLE N This field contains the internal identification code of the "building" portion of the ordering location value, if specified. This value could be used to join to location-specific information stored on the LOCATION table and associated codesets.
LOC_FACILITY_CD DOUBLE N This field contains the internal identification code of the "facility" portion of the ordering location value, if specified. This value could be used to join to location-specific information stored on the LOCATION table and associated codesets.
LOC_NURSE_UNIT_CD DOUBLE N This field contains the internal identification code of the "nursing station" portion of the ordering location value, if specified. This value could be used to join to location-specific information stored on the LOCATION table and associated codesets.
MAIN_REPORT_CMPLETE_DT_TM DATETIME Y This field contains the date and time the primary report associated with the case was verified.
NEXT_FOREIGN_WS_NBR DOUBLE N Maintains the next available foreign worksheet number for a pathology case.
ORIGIN_FLAG DOUBLE Y This field contains a flag value documenting how the case was added to the PATHOLOGY_CASE table. Cases can be added by accessioning, cases can be added to history manually, and cases can be added to history via an interface, for example.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREFIX_ID DOUBLE N This field includes the identification code representing the prefix portion of the case (accession) number. The entire number is stored in the ACCESSION_NBR field. Accession prefix information is stored on the AP_PREFIX table.
RECEIVED_SMEAR_IND DOUBLE Y Indicator value specifies whether the gynecological smears for the case were received from outside the laboratory.
REQUESTING_PHYSICIAN_ID DOUBLE N This field includes the internal identification code associated with the physician who is designated as the requesting physician for this case. Other physicians for this case (copy to physicians) are stored on the CASE_PROVIDER table.
RESERVED_IND DOUBLE Y This field includes an indicator documenting whether or not the case is accession number is in a reserved status.
RESPONSIBLE_PATHOLOGIST_ID DOUBLE N This field includes the internal identification code associated with the pathologist assigned to the case, if present. This value could be used to join to user information stored on the PRSNL and PERSON tables.
RESPONSIBLE_RESIDENT_ID DOUBLE N This field includes the internal identification code associated with the resident assigned to the case, if present. This value could be used to join to user information stored on the PRSNL and PERSON tables.
SOURCE_OF_SMEAR_CD DOUBLE N This field contains the identification code associated with the source of the gynecological smears for the case. Examples would be GP, GUM, and NHS Hospital
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PATHOLOGY_CASE


Child Column in PATHOLOGY_CASE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
COMMENTS_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
GROUP_ID PREFIX_GROUP GROUP_ID
ACCESSION_PRSNL_ID PRSNL PERSON_ID
CANCEL_ID PRSNL PERSON_ID
REQUESTING_PHYSICIAN_ID PRSNL PERSON_ID
RESPONSIBLE_PATHOLOGIST_ID PRSNL PERSON_ID
RESPONSIBLE_RESIDENT_ID PRSNL PERSON_ID




Parent Column in PATHOLOGY_CASE (PK) Child Table Name Child Column Name
Children: CASE_ID AP_DC_EVENT CASE_ID
AP_DC_EVENT CORRELATE_CASE_ID
AP_DIGITAL_SLIDE CASE_ID
AP_FT_EVENT CASE_ID
AP_IMAGE_MIGRATED CASE_ID
AP_QA_INFO CASE_ID
CASE_PROVIDER CASE_ID
CASE_REPORT CASE_ID
CASE_SPECIMEN CASE_ID
CYTO_SCREENING_EVENT CASE_ID
FT_TERM_CANDIDATE_LIST REVIEW_CASE_ID
PROCESSING_TASK CASE_ID
REPORT_DETAIL_TASK CASE_ID


PREFIX_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prefix Group
Definition: This reference table contains parameters specific to pathology prefix groups. A group represents a set of sequential numbers, and includes parameters such as the option to reset the numbers yearly. One or more prefixes can be included a single group.
Table Type: REFERENCE





Column Detail - PREFIX_GROUP


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.
GROUP_DESC VARCHAR(40) Y This field contains the description of the accession group.
GROUP_ID DOUBLE N This field contains the foreign key value used to represent the accession group.
GROUP_NAME CHAR(2) Y This field contains the short name (mnemonic) representing the prefix group value.
MANUAL_ASSIGN_IND DOUBLE Y This field contains a flag value documenting whether or not case numbers assigned from this accession group can be manually assigned (manually entered) by the user.
RESET_YEARLY_IND DOUBLE Y This field contains a flag value documenting whether or not case numbers assigned from this accession group should automatically be reset to 1 for the first case of a new year.
SITE_CD DOUBLE N This field contains a reference to the accession site code associated with the accession group.
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 - PREFIX_GROUP


Child Column in PREFIX_GROUP(FK) Parent Table Name Parent Column Name
Parents: GROUP_ID ACCESSION_ASSIGN_POOL ACCESSION_ASSIGNMENT_POOL_ID




Parent Column in PREFIX_GROUP (PK) Child Table Name Child Column Name
Children: GROUP_ID AP_PREFIX GROUP_ID
PATHOLOGY_CASE GROUP_ID


PREFIX_REPORT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prefix Report Reltn
Definition: This reference table contains the associations between report order catalog items and case prefixes. This table also includes parameters defining whether or not the report can be ordered multiple times, primary report designation, and display sequence.
Table Type: REFERENCE





Column Detail - PREFIX_REPORT_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the internal identification code of the report order catalog item. This value could be used to join to information stored in the order catalog table.
DFLT_DIAGNOSTIC_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code representing the report component procedure (discrete task assay) that should default in the code assignment and code review dialogs.
MULT_ALLOWED_IND DOUBLE Y This field contains an indicator documenting whether or not the report can be ordered more than one time for a single case. Final reports, for example, should not be ordered more than one time, while multiple orders for an addendum reports may be valid.
PREFIX_ID DOUBLE N This field contains the foreign key value used to represent the accession prefix value to which reports are associated on the PREFIX_REPORT_R table.
PRIMARY_IND DOUBLE Y This field contains an indicator documenting whether or not the report represents the primary report for a case. The primary report is the report that is always associated with every case assigned the prefix value included in the key to this table.
REPORTING_SEQUENCE DOUBLE Y This field contains a value which determines the report's hierarchical sequence (when compared to other reports) used for report presentation. This field is used when multiple reports are present for the same pathology case.
REPORT_TYPE_CD DOUBLE N The report type to which the prefix report relates.
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 - PREFIX_REPORT_R


Child Column in PREFIX_REPORT_R(FK) Parent Table Name Parent Column Name
Parents: PREFIX_ID AP_PREFIX PREFIX_ID
DFLT_DIAGNOSTIC_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD


PREFIX_RPT_FONT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prefix Report Font Information
Definition: This reference table contains the default text and heading attributes associated with a specific report order catalog item. The attributes stored include options such as font, size, color, and font style.
Table Type: REFERENCE





Column Detail - PREFIX_RPT_FONT_INFO


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the internal identification code of the report order catalog item. This value could be used to join to information stored in the order catalog table.
FONT_ATTRIBUTE_FLAG DOUBLE N This field contains a numeric value representing the font style that has been defined for the report text or for the report heading (specified by the value included in the SECTION_TYPE_FLAG field). Font styles include options such as "0, normal", "1, underline", "2, italic", and "4, bold".
FONT_COLOR DOUBLE N This field contains the RGB (Red Green Blue) color value that has been defined for the report text or for the report heading (specified by the value included in the SECTION_TYPE_FLAG field).
FONT_NAME VARCHAR(32) Y This field contains the font that has been defined for the report text or for the report heading (specified by the value included in the SECTION_TYPE_FLAG field).
FONT_SIZE DOUBLE N This field contains the font size that has been defined for the report text or for the report heading (specified by the value included in the SECTION_TYPE_FLAG field).
PREFIX_ID DOUBLE N This field contains the foreign key value used to identify the accession prefix for which report presentation parameters have been defined. This value could be used to join to prefix information stored on the AP_PREFIX table.
SECTION_TYPE_FLAG DOUBLE N This field contains a numeric field value identifying the type of report parameters included. The value of "1" indicates that the font and presentation parameters are associated with report text; the value "2" indicates that the parameters are associated with required report component headings; the value "3" indicates that the parameters are associated with optional report component headings.
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code of the report section item. This value could be used to join to information stored in the DISCRETE_TASK_ASSAY 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 - PREFIX_RPT_FONT_INFO


Child Column in PREFIX_RPT_FONT_INFO(FK) Parent Table Name Parent Column Name
Parents: PREFIX_ID AP_PREFIX PREFIX_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD