CXPRACTNR – Case Cart Practitioners

System
Case Carts (CX)
Prefix
CPR
Primary key
PRACTNR-ID
Fields
20
Updated by
3 programs
Referenced by
43 programs

CXPRACTNR is the Case Cart Practitioners table in Lawson Case Carts (prefix CPR). It is indexed by PRACTNR-ID (CPRSET1); alternate indexes: CPRSET2 and CPRSET3. It is related 1:M to CXPRACPROC and CXPRACASST. It is updated by CX04.1, CX506 and CX507 and referenced by CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX205 and 35 more. The table has 20 fields, 3 indexes and 2 documented relations.

About CXPRACTNR

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.

Fields (20)

Column = COBOL field name without the CPR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CPR-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID. This value must be unique for each practitioner in the Case Carts system.CX04.1, CX506, CX507
#CPR-LAST-NAME SET2
LAST_NAME		Alpha 30 (Lower Case)This field contains the last name of the practitioner.CX04.1, CX506, CX507
#CPR-FIRST-NAME SET2
FIRST_NAME		Alpha 15 (Lower Case)This field contains the first name of the practitioner.CX04.1, CX506, CX507
#CPR-MIDDLE-INIT SET2
MIDDLE_INIT		Alpha 1This field contains the middle initial of the practitioner.CX04.1, CX506, CX507
#CPR-LICENSE-NBR
LICENSE_NBR		Alpha 15This field contains the practitioner license number for the practitioner.CX04.1, CX506, CX507
#CPR-LICENSE-EXPR
LICENSE_EXPR		Numeric 8 (yyyymmdd)This field contains the expiration date for the practitioner license.CX04.1, CX506, CX507
#CPR-PRACTNR-GRP SET3
PRACTNR_GRP		Alpha 15This 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.CX04.1, CX506, CX507
#CPR-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information for the practitioner.CX04.1, CX506, CX507
#CPR-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.CX04.1, CX506, CX507
#CPR-PHONE-PREFIX
PHONE_PREFIX		Alpha 6This field contains the telephone number country code.CX04.1, CX506, CX507
#CPR-PHONE-BUSINESS
PHONE_BUSINESS		Alpha 15This 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.CX04.1, CX506, CX507
#CPR-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.CX04.1, CX506, CX507
#CPR-FAX-PREFIX
FAX_PREFIX		Alpha 6This field contains the fax number prefix.CX04.1, CX506, CX507
#CPR-FAX-NUM
FAX_NUM		Alpha 15This field contains the fax number.CX04.1, CX506, CX507
#CPR-FAX-EXT
FAX_EXT		Alpha 5This field contains the practitioner fax number extension.CX04.1, CX506, CX507
#CPR-BEEPER-PREFIX
BEEPER_PREFIX		Alpha 6This field contains the beeper dialup prefix.CX04.1, CX506, CX507
#CPR-BEEPER
BEEPER		Alpha 15This field contains the beeper dialup number.CX04.1, CX506, CX507
#CPR-BEEPER-EXT
BEEPER_EXT		Alpha 5This field contains the beeper dialup extension number.CX04.1, CX506, CX507
#CPR-PRAC-SPECIALTY
PRAC_SPECIALTY		Alpha 25This field shows the practitioner specialty.CX04.1, CX506, CX507
#CPR-PROC-VALIDATE
PROC_VALIDATE		Alpha 1This 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
CX04.1, CX506, CX507

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CPRSET1
  1. PRACTNR-ID
PrimaryCX04.1, CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5 +22 more (list truncated in source)
CPRSET2
  1. LAST-NAME
  2. FIRST-NAME
  3. MIDDLE-INIT
  4. PRACTNR-ID
KeyChange—
CPRSET3
  1. PRACTNR-GRP
  2. PRACTNR-ID
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CXPRACPROCCXPRACASSTCXPRACTNR

One to many (2) — child tables

RelationTableRulesConditionField map
CcpracprocCXPRACPROC
CPR-PRACTNR-ID→CPP-PRACTNR-ID (CPPSET2)
—→CPP-COMPANY
—→CPP-PROC-TYPE
—→CPP-PROC-CODE
PracassistantsCXPRACASST
CPR-PRACTNR-ID→CPA-PRACTNR-ID
—→CPA-PA-LAST-NAME
—→CPA-PA-FIRST-NAME
—→CPA-PA-MIDDLE-INIT

Programs

Updated by (3)

Referenced by (43)