Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXPTMPDIAG


                            CXPTMPDIAG FILE

                          Template Diagnostics

The Template Diagnostics file contains the diagnostic code(s) associated with
a preference template.  These records are used to provide default item
information in  Preference Diagnostics file records when preference  lists are
added to a case.

Use CX05.2 (Preference Template Diagnostics), chosen from CX05.1 (Preference
Template), to add or delete records from this file.

Each record in this file is related to one record in the following files
except as noted: Preference Template (CXPREFTEMP), Case Cart Diagnostics
(CXDIAGNOST), and, optionally, one or more records in the Preference
Diagnostics file.

REFERENCED BY

CXCP.1    WH130     WH132     WH190     WH222     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.5
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CTD-COMPANY            Numeric 4
Element: Company       This field contains the company number.

CTD-REQ-LOCATION       Alpha 5
Element: Location Code This field contains the location
                       requisitioning items and to be charged
                       for the items. This location can be an
                       inventory or noninventory location.

                       This value appears as the to location
                       on pick lists printed when you run CX100
                       (Pick List Print) and WH130 (Pick List
                       Print).

                       Valid values are

                       A requesting location defined in RQ01.1
                       (Requesting Location) for the specified
                       healthcare company.

CTD-PREF-CODE          Alpha 8
Element: Procedure CodeThis field contains the Preference Code
                       from the preference template.

CTD-PROC-TYPE          Alpha 8
Element: Procedure CodeThe procedure type is the first of two
                       fields that uniquely identify a
                       procedure. The procedure type can
                       identify the code set to which the
                       procedure code belongs.

                       For example, you can use one of the
                       following codes:
                       - CPT-4  for a code in the Current
                       Procedural Terminology listing compiled
                       by the American Medical Association
                       -HCPCS for a code in HCFA's (Health
                       Care Financing Administration's) Common
                       Procedure Coding System, or
                       - A code defined for your
                       organization's own procedures listing.

CTD-PROC-CODE          Alpha 8
Element: Procedure CodeThe procedure code is the second of two
                       fields that uniquely identify a
                       procedure.  The procedure code is an
                       identifier for a specific procedure
                       within a procedure type.

CTD-PRACTNR-ID         Alpha 15
Element: Practitioner IThis field contains the practitioner ID.

CTD-DIAG-TYPE          Alpha 8
Element: Diag Type     The diagnostic type is the first of two
                       fields that uniquely identify a
                       diagnosis. The diagnostic type can be
                       used to identify the code set to which
                       the diagnostic code belongs. For
                       example, you might assign a type of
                       HCPCS for a code in the Health Care
                       Financing Administration's Common
                       Procedure Coding System.

CTD-DIAG-CODE          Alpha 6
Element: Diag Code     The diagnostic code is the second of
                       two fields used to uniquely identify a
                       diagnosis. The diagnostic code is an
                       identifier for a specific diagnosis
                       within a diagnostic type.

                         CXPTMPDIAG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTDSET1   COMPANY                                                CXCP.1  WH130
          REQ-LOCATION                                           WH132   WH190
          PREF-CODE                                              WH222   WH30.1
          PROC-TYPE                                              WH30.2  WH30.3
          PROC-CODE                                              WH30.4  WH31.1
          PRACTNR-ID                                             WH31.2  WH31.3
          DIAG-TYPE                                              WH31.4  WH32.1
          DIAG-CODE                                              WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CTDSET2   COMPANY
          REQ-LOCATION
          PREF-CODE
          PROC-TYPE
          PROC-CODE
          DIAG-TYPE
          DIAG-CODE
          PRACTNR-ID

CTDSET3   COMPANY       This index is used by CX207 (Preference
          DIAG-TYPE     List Comparison) to search for case
          DIAG-CODE     preference lists by company, requesting
          REQ-LOCATION  location (optional) diagnostic type,
          PRACTNR-ID    diagnostic code, and practitioner ID.
          PROC-TYPE
          PROC-CODE

                         CXPTMPDIAG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ccdiagnost     CXDIAGNOST   Required

                            CTD-DIAG-TYPE       -> CDI-DIAG-TYPE  (CDISET1)
                            CTD-DIAG-CODE       -> CDI-DIAG-CODE

Cxpreftemp     CXPREFTEMP   Required

                            CTD-COMPANY         -> CPT-COMPANY
                            CTD-REQ-LOCATION    -> CPT-REQ-LOCATION
                            CTD-PREF-CODE       -> CPT-PREF-CODE
                            CTD-PROC-TYPE       -> CPT-PROC-TYPE
                            CTD-PROC-CODE       -> CPT-PROC-CODE
                            CTD-PRACTNR-ID      -> CPT-PRACTNR-ID