CXPRACASST – Case Cart Practitioner Assist

System
Case Carts (CX)
Prefix
CPA
Primary key
PRACTNR-ID, PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT
Fields
12
Updated by
2 programs
Referenced by
0 programs

CXPRACASST is the Case Cart Practitioner Assist table in Lawson Case Carts (prefix CPA). It is indexed by PRACTNR-ID, PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT (CPASET1); alternate indexes: CPASET2. It is updated by CX04.1 and CX507. The table has 12 fields, 2 indexes and 0 documented relations.

About CXPRACASST

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the CPA- 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
#CPA-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID.CX04.1, CX507
#CPA-PA-LAST-NAME PK
PA_LAST_NAME		Alpha 30 (Lower Case)This field contains the assistant last name.CX04.1, CX507
#CPA-PA-FIRST-NAME PK
PA_FIRST_NAME		Alpha 15 (Lower Case)This field contains the assistant first name.CX04.1, CX507
#CPA-PA-MIDDLE-INIT PK
PA_MIDDLE_INIT		Alpha 1This field contains the patient middle initial.CX04.1, CX507
#CPA-PHONE-PREFIX
PHONE_PREFIX		Alpha 6This field contains the telephone number country code.CX04.1, CX507
#CPA-PHONE-BUSINESS
PHONE_BUSINESS		Alpha 15This field contains the business phone number.CX04.1, CX507
#CPA-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.CX04.1, CX507
#CPA-BEEPER-PREFIX
BEEPER_PREFIX		Alpha 6This field contains the beeper dialup prefix.CX04.1, CX507
#CPA-BEEPER
BEEPER		Alpha 15This field contains the beeper dialup number.CX04.1, CX507
#CPA-BEEPER-EXT
BEEPER_EXT		Alpha 5This field contains the beeper dialup extension.CX04.1, CX507
#CPA-PA-SPECIALTY
PA_SPECIALTY		Alpha 25 (Lower Case)This field contains the specialty of the assistant.CX04.1, CX507
#CPA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description.CX04.1, CX507

Indexes (2)

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
CPASET1
  1. PRACTNR-ID
  2. PA-LAST-NAME
  3. PA-FIRST-NAME
  4. PA-MIDDLE-INIT
PrimaryCX04.1, CX507
CPASET2
  1. PA-LAST-NAME
  2. PA-FIRST-NAME
  3. PA-MIDDLE-INIT
  4. PRACTNR-ID
—

Programs

Updated by (2)