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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CPA-PRACTNR-ID PKPRACTNR_ID | Alpha 15 | This field contains the practitioner ID. | CX04.1, CX507 |
CPA-PA-LAST-NAME PKPA_LAST_NAME | Alpha 30 (Lower Case) | This field contains the assistant last name. | CX04.1, CX507 |
CPA-PA-FIRST-NAME PKPA_FIRST_NAME | Alpha 15 (Lower Case) | This field contains the assistant first name. | CX04.1, CX507 |
CPA-PA-MIDDLE-INIT PKPA_MIDDLE_INIT | Alpha 1 | This field contains the patient middle initial. | CX04.1, CX507 |
CPA-PHONE-PREFIXPHONE_PREFIX | Alpha 6 | This field contains the telephone number country code. | CX04.1, CX507 |
CPA-PHONE-BUSINESSPHONE_BUSINESS | Alpha 15 | This field contains the business phone number. | CX04.1, CX507 |
CPA-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | CX04.1, CX507 |
CPA-BEEPER-PREFIXBEEPER_PREFIX | Alpha 6 | This field contains the beeper dialup prefix. | CX04.1, CX507 |
CPA-BEEPERBEEPER | Alpha 15 | This field contains the beeper dialup number. | CX04.1, CX507 |
CPA-BEEPER-EXTBEEPER_EXT | Alpha 5 | This field contains the beeper dialup extension. | CX04.1, CX507 |
CPA-PA-SPECIALTYPA_SPECIALTY | Alpha 25 (Lower Case) | This field contains the specialty of the assistant. | CX04.1, CX507 |
CPA-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the description. | CX04.1, CX507 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CPASET1 | PRACTNR-ID, PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT | Primary | CX04.1, CX507 | |
CPASET2 | PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT, PRACTNR-ID | — |