Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             CXPRACTNR FILE

                        Case Cart Practitioners

The Case Cart Practitioners file contains practitioner information. The
system uses this file to validate the practitioner ID and retrieve
practitioner data when you assign a practitioner to a template or case. Use
CX04.1 (Practitioner) to build this file or to delete practitioner records
from this file.

REFERENCED BY

BL92.1    CX05.1    CX05.2    CX100     CX20.1    CX20.2
CX20.4    CX20.5    CX205     CX207     CX220     CX225
CX240     CX30.1    CX300     CX805     CXA2.1    PC520
PC521     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    CX506     CX507

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CPR-PRACTNR-ID       Alpha 15                                    CX04.1  CX506
Practitioner ID      This field contains the practitioner        CX507
                     ID. This value must be unique for each
                     practitioner in the Case Carts system.

CPR-LAST-NAME        Alpha 30  (Lower Case)                      CX04.1  CX506
Last Name            This field contains the last name of        CX507
                     the practitioner.

CPR-FIRST-NAME       Alpha 15  (Lower Case)                      CX04.1  CX506
First Name           This field contains the first name of       CX507
                     the practitioner.

CPR-MIDDLE-INIT      Alpha 1                                     CX04.1  CX506
Middle Initial       This field contains the middle initial      CX507
                     of the practitioner.

CPR-LICENSE-NBR      Alpha 15                                    CX04.1  CX506
License Number       This field contains the practitioner        CX507
                     license number for the practitioner.

CPR-LICENSE-EXPR     Numeric 8  (yyyymmdd)                       CX04.1  CX506
License Expiration   This field contains the expiration date     CX507
Date                 for the practitioner license.

CPR-PRACTNR-GRP      Alpha 15                                    CX04.1  CX506
Practitioner Group   This field defines the group to which       CX507
                     the practitioner belongs. Groups are
                     user defined.

                     Groups allow searching or reporting by
                     a classification such as a group
                     practice, specialty (cardiology,
                     obstetrics, and so on), inpatient,
                     outpatient, emergency, and so on.

CPR-ADDR1            Alpha 30  (Lower Case)                      CX04.1  CX506
Address 1            This field contains the first line of       CX507
                     address information for the
                     practitioner.

CPR-ADDR2            Alpha 30  (Lower Case)                      CX04.1  CX506
Address 2            This field contains the second line of      CX507
                     address information.

CPR-PHONE-PREFIX     Alpha 6                                     CX04.1  CX506
Phone Prefix         This field contains the telephone           CX507
                     number country code.

CPR-PHONE-BUSINESS   Alpha 15                                    CX04.1  CX506
Phone Business       This field contains the practitioner        CX507
                     business phone number.

                     For example, the area code plus the
                     7-digit business phone number. You may
                     use separator characters, such as
                     hyphens, slashes, or parentheses.

CPR-PHONE-EXT        Alpha 5                                     CX04.1  CX506
Phone Extension      This field contains the telephone           CX507
                     extension number.

CPR-FAX-PREFIX       Alpha 6                                     CX04.1  CX506
Fax Prefix           This field contains the fax number          CX507
                     prefix.

CPR-FAX-NUM          Alpha 15                                    CX04.1  CX506
Fax Number           This field contains the fax number.         CX507

CPR-FAX-EXT          Alpha 5                                     CX04.1  CX506
Fax Extension        This field contains the practitioner        CX507
                     fax number extension.

CPR-BEEPER-PREFIX    Alpha 6                                     CX04.1  CX506
Beeper Prefix        This field contains the beeper dialup       CX507
                     prefix.

CPR-BEEPER           Alpha 15                                    CX04.1  CX506
Beeper Number        This field contains the beeper dialup       CX507
                     number.

CPR-BEEPER-EXT       Alpha 5                                     CX04.1  CX506
Beeper Extension     This field contains the beeper dialup       CX507
                     extension number.

CPR-PRAC-SPECIALTY   Alpha 25                                    CX04.1  CX506
Practitioner         This field shows the practitioner           CX507
Specialty            specialty.

CPR-PROC-VALIDATE    Alpha 1                                     CX04.1  CX506
Procedure - Validate This field controls which items you can     CX507
                     assigned to practitioner-specific
                     templates.

                     Select Yes to limit the procedures you
                     can add to practitioner-specific
                     templates. In such cases, the Case Carts
                     system validates procedures added to
                     templates against the procedures listed
                     in the Procedures tab on the
                     Practitioner form.

                     Select No to allow assignment of any
                     procedure to a practitioner-specific
                     template for the practitioner.
                     N = No
                     Y = Yes

                         CXPRACTNR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CPRSET1   PRACTNR-ID                                             BL92.1  CX04.1
                                                                 CX05.1  CX05.2
                                                                 CX100   CX20.1
                                                                 CX20.2  CX20.4
                                                                 CX20.5  CX205
                                                                 CX207   CX220
                                                                 CX225   CX240
                                                                 CX30.1  CX300
                                                                 CX506   CX507
                                                                 CX805   CXA2.1
                                                                 PC520   PC521
                                                                 OE114   WH130
                                                                 WH132   WH190
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 ...

CPRSET2   LAST-NAME     KeyChange
          FIRST-NAME
          MIDDLE-INIT
          PRACTNR-ID

CPRSET3   PRACTNR-GRP   This index is used by CX207 (Preference
                        List Comparison) to find all
                        practitioners of one group.
                        KeyChange, Duplicates

                         CXPRACTNR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ccpracproc     CXPRACPROC

                            CPR-PRACTNR-ID    -> CPP-PRACTNR-ID  (CPPSET2)
                                                 CPP-COMPANY
                                                 CPP-PROC-TYPE
                                                 CPP-PROC-CODE

Pracassistants CXPRACASST

                            CPR-PRACTNR-ID    -> CPA-PRACTNR-ID
                                                 CPA-PA-LAST-NAME
                                                 CPA-PA-FIRST-NAME
                                                 CPA-PA-MIDDLE-INIT