CXPREFDIAG – Preference Diagnostics

System: Case Carts (CX)
Prefix: CPD
Primary key: COMPANY, REQ-LOCATION, CASE, SEQ, DIAG-TYPE, DIAG-CODE
Fields: 13
Updated by: 37 programs
Referenced by: 1 program

CXPREFDIAG is the Preference Diagnostics table in Lawson Case Carts (prefix CPD). It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ, DIAG-TYPE, DIAG-CODE (CPDSET1); alternate indexes: CPDSET2 and CPDSET3. It is related 1:1 to CXCASEPREF and CXDIAGNOST. It is updated by CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 and 29 more and referenced by CX235. The table has 13 fields, 3 indexes and 2 documented relations.

About CXPREFDIAG

The Preference Diagnostics file contains the diagnostic codes associated with a case preference list. These codes define the diagnosis for each preference list. The Case Carts system uses this file to store diagnostic codes defined for a case preference. This file contains all diagnostics originating from any preference templates assigned to a case plus updates made to the case diagnostic data. Use CX20.3 (Preference List Diagnosis Edit) to assign or update a diagnosis on a preference list. Also, use CX20.3 to delete records from the preference list (and thereby from this file). You cannot delete diagnostic codes when the case status is 4 (Charges Passed) or 5 (No Charges).

Fields (13)

Column = COBOL field name without the CPD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CPD-COMPANY` PK COMPANY	Numeric 4	This field contains the company number.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	This field contains the location requisitioning items and to be charged for the items. This location can be an inventory or noninventory location. This value appears as the to location on pick lists printed when you run CX100 (Pick List Print) and WH130 (Pick List Print). Valid values are A requesting location defined in RQ01.1 (Requesting Location) for the specified healthcare company.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-CASE` PK CASE	Alpha 15	This field contains the unique identifier for the case. A case is a record of the practitioners, preference lists, and associated information assigned to a specific patient visit. The Case Carts system uses this number to interface with an outside scheduling system.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-SEQ` PK SEQ	Numeric 3	This field contains the record sequence number.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-DIAG-TYPE` PK DIAG_TYPE	Alpha 8	The diagnostic type is the first of two fields that uniquely identify a diagnosis. The diagnostic type may be used to define different systems of diagnosis identification.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-DIAG-CODE` PK DIAG_CODE	Alpha 6	The diagnostic code is the second of two fields that uniquely identify a diagnosis. The diagnostic code is an identifier for a specific diagnosis within a diagnostic type.	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-DIAG-DESC` DIAG_DESC	Alpha 250 (Lower Case)	—	—
`CPD-RELATIVE-WGHTS` RELATIVE_WGHTS	Signed 8.4	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-GEOMETRIC-LOS` GEOMETRIC_LOS	Signed 5.2	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-ARITHMETIC-LOS` ARITHMETIC_LOS	Signed 5.2	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-OUTLIER` OUTLIER	Numeric 2	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-BASE-RATE` BASE_RATE	Signed 18.2	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more
`CPD-DISCOUNT` DISCOUNT	Percent 2.0 (Percent)	—	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX30.1 +29 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`CPDSET1`	`COMPANY`, `REQ-LOCATION`, `CASE`, `SEQ`, `DIAG-TYPE`, `DIAG-CODE`	Primary	CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5, CX220, CX235 +22 more (list truncated in source)
`CPDSET2`	`COMPANY`, `REQ-LOCATION`, `DIAG-TYPE`, `DIAG-CODE`, `CASE`, `SEQ`		—
`CPDSET3`	`COMPANY`, `DIAG-TYPE`, `DIAG-CODE`, `REQ-LOCATION`, `SEQ`, `CASE`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cccasepref	CXCASEPREF	Required		`CPD-COMPANY` → `CXP-COMPANY (CXPSET1)`, `CPD-REQ-LOCATION` → `CXP-REQ-LOCATION`, `CPD-CASE` → `CXP-CASE`, `CPD-SEQ` → `CXP-SEQ`
Ccdiagnost	CXDIAGNOST	Required		`CPD-DIAG-TYPE` → `CDI-DIAG-TYPE`, `CPD-DIAG-CODE` → `CDI-DIAG-CODE`

Programs

Updated by (37)

CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.3 Case Diagnostics
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CXCP.1 Copy preference to case
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.5 Additional Shipment Information
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program

Referenced by (1)

CX235 Procedure Cost versus Diagnosis Related Group