Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXPRACPROC


                            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    OE114     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

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

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

CPP-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 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
Element: Procedure CodeType 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  OE114
          PRACTNR-ID    Practitioner Procedures file records in  WH130   WH132
          PROC-TYPE     Company, Practitioner ID, Procedure      WH190   WH222
          PROC-CODE     Type, and Procedure Code order.          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

CPPSET2   PRACTNR-ID    This index is used to access
          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  (CPRSET1)

Ccprocedr      CXPROCEDR    Required

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

Iccompany      ICCOMPANY    Required

                            CPP-COMPANY       -> ICC-COMPANY