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 |