Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

PC20.1    PC520     PC521     WH130     WH33.5    WH34.1
WH34.2    WH34.3    WH34.4

UPDATED BY

CX04.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CPR-PRACTNR-ID       Alpha 15                                    CX04.1
Practitioner ID      This 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
Last Name            This field contains the last name of
                     the practitioner.

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

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

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

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

CPR-PRACTNR-GRP      Alpha 15                                    CX04.1
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
Address 1            This field contains the first line of
                     address information for the
                     practitioner.

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

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
Phone Business       This 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
Telephone Extension  This field contains the telephone
                     extension number.

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

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

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

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

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

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

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

CPR-PROC-VALIDATE    Alpha 1                                     CX04.1
Proc Validate        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  PC20.1
                                                                 PC520   PC521
                                                                 WH130   WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

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