Table Detail Report

CYTO_ENDOCERV_ALPHA_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Endocervical Alpha Reltn
Definition: This reference table contains the classification of every alpha response code associated with the presence or absence of the endocervical component for gynecologic cytology reports.
Table Type: REFERENCE





Column Detail - CYTO_ENDOCERV_ALPHA_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the internal identification code associated with the cytology report for which endocervical cell parameters are defined. This value could be used to join to the order catalog tables, if desired.
ENDOCERV_IND DOUBLE N This field contains a flag value documenting the collection technique evaluation (determined by the presence or absence of endocervical cells) associated with the associated alpha response code value.
NOMENCLATURE_ID DOUBLE N This field contains the internal identification code associated with the nomenclature response documenting the collection technique evaluation (determined by the presence of endocervical cells). This value could be used to join to the NOMENCLATURE table.
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the discrete task within the cytology report which represents the collection technique evaluation report component (determined by the presence or absence of endocervical cells).
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_ENDOCERV_ALPHA_R


Child Column in CYTO_ENDOCERV_ALPHA_R(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD CYTO_REPORT_CONTROL CATALOG_CD
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


CYTO_REPORT_CONTROL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Report Control
Definition: This reference table contains the classification of the report component procedures included within a cytology report. Inclusion on this table is required for a report to be resulted or verified using the result entry application specific for cytology.
Table Type: REFERENCE





Column Detail - CYTO_REPORT_CONTROL


Column Name Type Null? Definition
ACTION_TASK_ASSAY_CD DOUBLE N Contains the internal identification code associated with the discrete task within the cytology report which represents the follow-upaction report component.
ADEQUACY_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the discrete task within the cytology report which represents the statement of microscopic adequacy coded response report component.
ADEQ_REASON_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the discrete task within the cytology report which represents the limited/unsatisfactory reason coded response report component.
CATALOG_CD DOUBLE N The field contains the internal identification code associated with the cytology report for which cytology report parameters are defined. This field uniquely defines a row included n the CYTO_REPORT_CONTROL reference table.
CLIN_INFO_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the discrete task within the cytology report which represents the clinical information report component.
DIAGNOSIS_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code associated with the discrete task within the cytology report which represents the diagnosis coded response report component.
ENDOCERV_TASK_ASSAY_CD DOUBLE N This field contains the internal ID code associated with the discrete task within the cytology report which represents the evaluation of collection technique based on the presence/absence of endocervical cells coded response report component.
REPORT_TYPE_FLAG DOUBLE Y This field contains a flag value indicating if the report represents a gynecologic cytology report or a non-gynecologic cytology 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_REPORT_CONTROL


Child Column in CYTO_REPORT_CONTROL(FK) Parent Table Name Parent Column Name
Parents: ACTION_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
ADEQUACY_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
ADEQ_REASON_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CLIN_INFO_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
DIAGNOSIS_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
ENDOCERV_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CATALOG_CD ORDER_CATALOG CATALOG_CD




Parent Column in CYTO_REPORT_CONTROL (PK) Child Table Name Child Column Name
Children: CATALOG_CD CYTO_ADEQUACY_ALPHA_R CATALOG_CD
CYTO_ENDOCERV_ALPHA_R CATALOG_CD


CYTO_SCREENING_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Screening Event
Definition: This activity table contains parameters associated with the process of entering screening and rescreening results for cytology cases. Parameters such as the screener ID, screening date and time, adequacy flag, endocervical flag are included.
Table Type: ACTIVITY





Column Detail - CYTO_SCREENING_EVENT


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y This field indicates the event action (Initial screener, rescreener, or verifier). This field is currently not being used.
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.
ADEQUACY_FLAG DOUBLE Y This field contains a flag value documenting the microscopic evaluation of specimen adequacy assigned to the case at the time the screening event was written to the CYTO_SCREENING_EVENT table.
CASE_ID DOUBLE N This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table.
DIAGNOSTIC_CATEGORY_CD DOUBLE N This field contains the internal identification code associated with the diagnostic category assigned to the cytology case at the time the screening event was written to the CYTO_SCREENING_EVENT table. Diagnostic categories are stored on codeset 1314.
ENDOCERV_IND DOUBLE Y This field contains a flag value documenting the evaluation of collection technique (based on the presence/absence of endocervical cells) that was assigned to the case at the time the screening event was written to the CYTO_SCREENING_EVENT table.
EVENT_ID DOUBLE N This field is used in conjunction with the value stored in the VALID_FROM_DT_TM field to join to result information stored in OCF.
INITIAL_SCREENER_IND DOUBLE Y This field contains an indicator designating whether the screening event represents an initial screening activity (versus a rescreening activity).
NOMENCLATURE_ID DOUBLE N This field contains the internal identification code associated with the diagnosis alpha response (nomenclature) value assigned to the report at the time the screening event was written to the CYTO_SCREENING_EVENT table.
REFERENCE_RANGE_FACTOR_ID DOUBLE N This field contains the foreign key value used to join to the table storing the reference range (alpha response values, in this example) information for the diagnosis alpha response report component.
REVIEW_REASON_FLAG DOUBLE Y This field contains a flag value documenting how a rescreening event was selected (user-specified versus system-specified). If the rescreening event was system-specified, the flag value also documents the reason the report was selected for rescreening.
SCREENER_ID DOUBLE N This field contains the internal identification code of the user who was the screener (or rescreener) for this screening event. This value could be used to join to personnel information on the PRSNL or PERSON tables.
SCREEN_DT_TM DATETIME Y This field contains the date and time the screening event occurred.
SEQUENCE DOUBLE N This field documents the screening event sequence (for the same case). The initial screener's screening event would be sequenced first, and the first rescreener's screening event would be sequenced second, for example.
SERVICE_RESOURCE_CD DOUBLE N The service resource to which the case was assigned when the screening event was initiated.
SPECIMEN_GROUPING_CD DOUBLE N This field is not used at this time.
SPLIT_IND DOUBLE Y This field is not used at this time.
STANDARD_RPT_ID DOUBLE N This field is used to store the internal identification of the standard report (if any) used to enter report information for the case associated with the screening event.
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.
VALID_FROM_DT_TM DATETIME Y This field is used in conjunction with the value stored in the EVENT_ID field to join to result information stored in OCF.
VERIFY_IND DOUBLE Y This field contains a flag documenting whether or not the screening event record is associated with a perform result event or a verify result event.



Relationship Detail - CYTO_SCREENING_EVENT


Child Column in CYTO_SCREENING_EVENT(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID ALPHA_RESPONSES NOMENCLATURE_ID
REFERENCE_RANGE_FACTOR_ID ALPHA_RESPONSES REFERENCE_RANGE_FACTOR_ID
STANDARD_RPT_ID CYTO_STANDARD_RPT STANDARD_RPT_ID
CASE_ID PATHOLOGY_CASE CASE_ID


CYTO_SCREENING_LIMITS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Screening Limits
Definition: This reference table contains user-specific parameters with regards to slide limits (# of slides per day) associated with the reporting of cytology cases. Once a user's daily limit is reached, no additional cytology reports can be verified by the user.
Table Type: REFERENCE





Column Detail - CYTO_SCREENING_LIMITS


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.
COMMENTS VARCHAR(200) Y This field contains any comments entered when a cytotechnologist's screening limits were reviewed.
PRSNL_ID DOUBLE N This field uniquely identifies the cytotechnologist for whom screening limits have been defined or reviewed. This value could be used to join to other tables, such as the PRSNL, PERSON, and CYTO_SCREENING_SECURITY, for example.
REQUEUE_FLAG DOUBLE N Indicates whether requeue will happen when maximum slide count is reached. 0 - User can still verify the report without showing the requeue dialog; 1 - Requeue dialog will be shown when maximum slide limit is reached. User will not able verify the report.0 and 1:1: Requeue dialog will be shown when maximum slide limit is reached. User will not able verify the report.0: User can still verify the report without showing the requeue dialog.
REVIEWED_DT_TM DATETIME Y This field contains the date the time the review event occurred.
REVIEWER_ID DOUBLE N This field contains the internal identification code associated with the user who is documented as the reviewer for the cytotechnologist's screening limit parameters. This ID could be used to join to the PRSNL or PERSON tables.
SCREENING_HOURS DOUBLE Y This field contains the standard number of screening hours that have been established for the cytotechnologist.
SEQUENCE DOUBLE N This field documents the record sequence available for the cytotechnologist. The initial limit definition would be represented as the first sequence, the first review would be represented as the second sequence, etc.
SLIDE_LIMIT DOUBLE Y This field contains the maximum number of slides that may be screened or rescreened during a single day for the cytotechologist.
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 - CYTO_SCREENING_LIMITS


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


CYTO_SCREENING_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cytology Screening Security
Definition: This reference table contains user-specific parameters with regards to required rescreening percentages (and associated parameters) and a verification security level associated with cytology reports.
Table Type: REFERENCE





Column Detail - CYTO_SCREENING_SECURITY


Column Name Type Null? Definition
ABNORMAL_PERCENTAGE DOUBLE Y This field documents the % of gyn cytology cases associated with patients with abnormal gyn history (from the total of those cases that could have been verified by the user based on verification security) that will be selected for required rescreening.
ABNORMAL_REQUEUE_FLAG DOUBLE Y This field contains a flag value indicating whether or not requeueing will be invoked for cases selected for required rescreening based on a previous abnormal flag. If invoked, this flag documents whether the requeueing is manual or automatic.
ABNORMAL_REQUEUE_RANK DOUBLE Y This field documents the ranking associated with the previous abnormal flag. This ranking determines which flag (if multiple are present for the patient) takes precedence when evaluating whether or not required rescreening should be invoked.
ABNORMAL_SERVICE_RESOURCE_CD DOUBLE N This field documents the service resource which should be used during the requeueing process. The association of a service resource with requeueing parameters is optional based on the requeue flag specified.
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.
ATYPICAL_PERCENTAGE DOUBLE Y This field documents the % of gyn cytology cases associated with patients with atypical gyn history (from the total of those cases that could have been verified by the user based on verification security) that will be selected for required rescreening.
ATYPICAL_REQUEUE_FLAG DOUBLE Y This field contains a flag value indicating whether or not requeueing will be invoked for cases selected for required rescreening based on a previous atypical flag. If invoked, this flag documents whether the requeueing is manual or automatic.
ATYPICAL_REQUEUE_RANK DOUBLE Y This field documents the ranking associated with the previous atypical flag. This ranking determines which flag (if multiple are present for the patient) takes precedence when evaluating whether or not required rescreening should be invoked.
ATYPICAL_SERVICE_RESOURCE_CD DOUBLE N This field documents the service resource which should be used during the requeueing process. The association of a service resource with requeueing parameters is optional based on the requeue flag specified.
AUTO_OVERSCREENER_IND DOUBLE Y This field is not used at this time.
CHR_PERCENTAGE DOUBLE Y This field documents the % of gyn cases associated with patients flagged as clinically high risk (from the total of those cases that could have been verified by the user based on verification security) that will be selected for required rescreening.
CHR_REQUEUE_FLAG DOUBLE Y This field contains a flag value indicating whether or not requeueing will be invoked for cases selected for required rescreening based on a high risk flag. If invoked, this flag documents whether the requeueing is manual or automatic.
CHR_REQUEUE_RANK DOUBLE Y This field documents the ranking associated with the high risk flag. This ranking determines which flag (if multiple are present for the patient) takes precedence when evaluating whether or not required rescreening should be invoked.
CHR_SERVICE_RESOURCE_CD DOUBLE N This field documents the service resource which should be used during the requeueing process. The association of a service resource with requeueing parameters is optional based on the requeue flag specified.
COMMENTS VARCHAR(200) Y This field contains any comments entered when a cytotechnologist's screening security was reviewed.
NORMAL_PERCENTAGE DOUBLE Y This field documents the % of gyn cases associated with patients with normal or no gyn history (from the total of those cases that could have been verified by the user based on verification security) that will be selected for required rescreening.
NORMAL_REQUEUE_FLAG DOUBLE Y This field contains a flag value indicating whether or not requeueing will be invoked for cases selected for required rescreening based on a previous normal flag. If invoked, this flag documents whether the requeueing is manual or automatic.
NORMAL_REQUEUE_RANK DOUBLE Y This field documents the ranking associated with the previous normal flag. This ranking determines which flag (if multiple are present for the patient) takes precedence when evaluating whether or not required rescreening should be invoked.
NORMAL_SERVICE_RESOURCE_CD DOUBLE N This field documents the service resource which should be used during the requeueing process. The association of a service resource with requeueing parameters is optional based on the requeue flag specified.
OVER_REQUEUE_FLAG DOUBLE Y This field is not used at this time.
OVER_SERVICE_RESOURCE_CD DOUBLE N This field is not used at this time.
PRSNL_ID DOUBLE N This field uniquely identifies the cytotechnologist for whom screening security has been defined or reviewed. This value could be used to join to other tables, such as the PRSNL, PERSON, and CYTO_SCREENING_LIMITS, for example.
REVIEWED_DT_TM DATETIME Y This field contains the date the time the review event occurred.
REVIEWER_ID DOUBLE N This field contains the internal identification code associated with the user who is documented as the reviewer for the cytotechnologist's screening security and requeueing parameters. This ID could be used to join to the PRSNL or PERSON tables.
SEQUENCE DOUBLE N This field documents the record sequence available for the cytotechnologist. The initial limit definition would be represented as the first sequence, the first review would be represented as the second sequence, etc.
UNSAT_PERCENTAGE DOUBLE Y This field documents the % of gyn cases with a diagnosis of unsatisfactory that will be selected for required rescreening.
UNSAT_REQUEUE_FLAG DOUBLE Y This field contains a flag value indicating whether or not requeueing will be invoked for cases selected for required rescreening based on a unsatisfactory flag. If invoked, this flag documents whether the requeueing is manual or automatic.
UNSAT_SERVICE_RESOURCE_CD DOUBLE N This field documents the service resource which should be used during the requeueing process. The association of a service resource with requeueing parameters is optional based on the requeue flag specified.
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.
VERIFY_LEVEL DOUBLE Y This field documents the verification level, specific for the verification of cytology reports, that has been established for the cytotechnologist.



Relationship Detail - CYTO_SCREENING_SECURITY


Child Column in CYTO_SCREENING_SECURITY(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
ABNORMAL_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
ATYPICAL_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
CHR_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
NORMAL_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
OVER_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
UNSAT_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD