Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXPRACTNR


                             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

PC520     PC521     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

UPDATED BY

CX04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

CPR-MIDDLE-INIT        Alpha 1                                   CX04.1
Element: Middle InitialThis field contains the middle initial
                       of the practitioner.

CPR-LICENSE-NBR        Alpha 15                                  CX04.1
Element: License Nbr   This field contains the practitioner
                       license number for the practitioner.

CPR-LICENSE-EXPR       Numeric 8  (yyyymmdd)                     CX04.1
Element: Date          This field contains the expiration date
                       for the practitioner license.

CPR-PRACTNR-GRP        Alpha 15                                  CX04.1
Element: Practnr Grp   This field defines the group to which
                       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
Element: Address 1     This field contains the first line of
                       address information for the
                       practitioner.

CPR-ADDR2              Alpha 30  (Lower Case)                    CX04.1
Element: Address 1

CPR-PHONE-PREFIX       Alpha 6                                   CX04.1
Telephone Country      This field contains the telephone
Code                   number country code.

CPR-PHONE-BUSINESS     Alpha 15                                  CX04.1
Element: Telephone NumbThis field contains the practitioner
                       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
Element: Telephone ExteThis field contains the telephone
                       extension number.

CPR-FAX-PREFIX         Alpha 6                                   CX04.1
Telephone Country      This field contains the fax number
Code                   prefix.

CPR-FAX-NUM            Alpha 15                                  CX04.1
Element: Telephone NumbThis field contains the fax number.

CPR-FAX-EXT            Alpha 5                                   CX04.1
Element: Telephone ExteThis field contains the practitioner
                       fax number extension.

CPR-BEEPER-PREFIX      Alpha 6                                   CX04.1
Telephone Country      This field contains the beeper dialup
Code                   prefix.

CPR-BEEPER             Alpha 15                                  CX04.1
Element: Telephone NumbThis field contains the beeper dialup
                       number.

CPR-BEEPER-EXT         Alpha 5                                   CX04.1
Element: Telephone ExteThis field contains the beeper dialup
                       extension number.

CPR-PRAC-SPECIALTY     Alpha 25                                  CX04.1
Element: Prac SpecialtyThis field shows the practitioner
                       specialty.

CPR-PROC-VALIDATE      Alpha 1                                   CX04.1
Element: All Flag      This field controls which items you can
                       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                                             CX04.1  PC520
                                                                 PC521   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

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

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

                         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