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 |