Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            CXPRACPROC FILE

                        Practitioner Procedures

The Practitioner Procedures file contains the valid procedures that a
practitioner may perform at a company or entity. The Case Carts system uses
this file to validate that the practitioner may perform a procedure.
Validation occurs if the Proc Validate field in the Practitioner file equals
Yes when you assign a procedure to the practitioner on a template or case.

You build this file manually using CX04.1 (Practitioner).

Note:  For practitioner records built by CX507 (HL7 Pract and Staff Import),
use CX04.1 (Practitioner) to assign procedures for the procedure validation
feature.

Each Practitioner Procedures record relates to one record in the Case Cart
Practitioners file.

REFERENCED BY

BL92.1    CX05.1    CX05.2    CX100     CX20.1    CX20.2
CX20.4    CX20.5    CX220     CX30.1    CX300     CX506
CX805     OE114     WH130     WH132     WH190     WH222
WH30.1    WH30.2    WH30.3    WH31.1    WH31.2    WH31.3
WH32.1    WH32.2    WH32.3    WH33.5    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

CX04.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CPP-COMPANY          Numeric 4                                   CX04.1
Company              This field contains the company number.

CPP-PRACTNR-ID       Alpha 15                                    CX04.1
Practitioner ID      This field contains the practitioner
                     ID. This value must be unique for each
                     practitioner in the system.

CPP-PROC-TYPE        Alpha 8                                     CX04.1
Procedure Type       The 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 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.

CPP-PROC-CODE        Alpha 8                                     CX04.1
Procedure Code       Type the procedure code of the
                     procedure you want to display.

                     The 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.

                         CXPRACPROC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CPPSET1   COMPANY       This index is used to access             BL92.1  CX04.1
          PRACTNR-ID    Practitioner Procedures file records in  CX05.1  CX05.2
          PROC-TYPE     Company, Practitioner ID, Procedure      CX100   CX20.1
          PROC-CODE     Type, and Procedure Code order.          CX20.2  CX20.4
                                                                 CX20.5  CX220
                                                                 CX30.1  CX300
                                                                 CX506   CX805
                                                                 OE114   WH130
                                                                 WH132   WH190
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.5  WH34.1
                                                                 ...

CPPSET2   PRACTNR-ID    This index is used to access             CX04.1
          COMPANY       Practitioner Procedures file records in
          PROC-TYPE     Practitioner ID, Company, Procedure
          PROC-CODE     Type, and Procedure Code order.

                         CXPRACPROC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ccpractnr      CXPRACTNR    Required

                            CPP-PRACTNR-ID    -> CPR-PRACTNR-ID

Ccprocedr      CXPROCEDR    Required

                            CPP-PROC-TYPE     -> CPC-PROC-TYPE
                            CPP-PROC-CODE     -> CPC-PROC-CODE

Iccompany      ICCOMPANY    Required

                            CPP-COMPANY       -> ICC-COMPANY