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.

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
LAST_NAME		Alpha 30 (Lower Case)This field contains the last name of the practitioner.CX04.1, CX506, CX507
CPR-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)This field contains the first name of the practitioner.CX04.1, CX506, CX507
CPR-MIDDLE-INIT
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CPRSET1PRACTNR-IDPrimaryCX04.1, CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5 +22 more (list truncated in source)
CPRSET2LAST-NAME, FIRST-NAME, MIDDLE-INIT, PRACTNR-IDKeyChange—
CPRSET3PRACTNR-GRP, PRACTNR-IDKeyChange—

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
CcpracprocCXPRACPROCCPR-PRACTNR-ID → CPP-PRACTNR-ID (CPPSET2), → CPP-COMPANY, → CPP-PROC-TYPE, → CPP-PROC-CODE
PracassistantsCXPRACASSTCPR-PRACTNR-ID → CPA-PRACTNR-ID, → CPA-PA-LAST-NAME, → CPA-PA-FIRST-NAME, → CPA-PA-MIDDLE-INIT

Programs

Updated by (3)

Referenced by (43)