CXCASEPREF – Case Cart Preferences

System
Case Carts (CX)
Prefix
CXP
Primary key
COMPANY, REQ-LOCATION, CASE, SEQ
Fields
39
Updated by
36 programs
Referenced by
183 programs

CXCASEPREF is the Case Cart Preferences table in Lawson Case Carts (prefix CXP). It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ (CXPSET1); alternate indexes: CXPSET2, CXPSET3, CXPSET4, CXPSET5, CXPSET6 and CXPSET7. It is related 1:1 to CXCASEHEAD, CXPRACPROC, CXPROCEDR, CXPREFTEMP and CXPRACTNR and 1:M to CXPREFDIAG, CXPREFITEM, CXPREFJOBS, CXITEMHIST and CXLABRHIST. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 28 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 175 more. The table has 39 fields, 7 indexes and 11 documented relations.

About CXCASEPREF

The Case Cart Preferences file contains header records for case preference lists. The header information consists of data for a specific procedure for a case. Use CX20.1 (Case Build) or CX506 (HL7 Schedules Import Interface) to create records in this file. In CX20.1, when you add a preference template to a case, the Case Carts system adds the applicable preference template data to this file. To delete a record from this file, use CX20.1, select the Delete line action for the procedure to delete, and select the Change form action. If you import cases using CX506, the Case Carts system automatically assigns this information based on the procedure code imported from the outside scheduling system. A different practitioner can be assigned to each procedure within a case. Additional files store other case preference data. The Preference Items file contains items, the Preference Diagnostics file contains diagnostic codes, and Attachment files in the Environment contain comments.

Fields (39)

Column = COBOL field name without the CXP- 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
#CXP-COMPANY PK
COMPANY		Numeric 4This field contains the company number. Valid entries: Any Case Carts system company, defined in CX01.1 (Healthcare Company) and with an equivalent Inventory Control company in IC01.1 (Company).CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-REQ-LOCATION PK
REQ_LOCATION		Alpha 5This 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 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.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-CASE PK
CASE		Alpha 15This field contains the unique identifier for the case. A case identifier is used in the Case Carts system to associate specific tasks, practitioners, preference lists, and other information with a particular treatment course. This treatment course may consist of one or more procedures. The case number can be used to interface with an outside scheduling system.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PREF-CODE SET7
PREF_CODE		Alpha 8This field contains a Preference Code for a preference template defined in CX05.1 (Preference Template). The preference code is one of the key fields that define a preference template. You might decide to define a preference code as a procedure category found in a procedure code catalog issued by the government, insurer, or regulatory body. Based on such an approach, you might define a preference code as ANESTH for Anesthesia-related procedures. For another example, you might define RESP for Respiratory-related procedures.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-SEQ PK
SEQ		Numeric 3This field contains the record sequence number for a procedure assigned to the case.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PROC-TYPE SET2
PROC_TYPE		Alpha 8The procedure type is the first of two fields that uniquely identify a procedure. The procedure type can identify the code set to which the procedure code belongs. For example, you can use one of the following codes: - CPT-4 for a code in the Current Procedural Terminology listing compiled by the American Medical Association -HCPCS for a code in HCFA's (Health Care Financing Administration's) Common Procedure Coding System, or - A code defined for your organization's own procedures listing. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the procedure type assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PROC-CODE SET2
PROC_CODE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the Procedure Code assigned to a procedure on a preference template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PRACTNR-ID SET3 SET5
PRACTNR_ID		Alpha 15This field contains the practitioner ID. This value must be unique for each practitioner in the Case Carts system. This value defaults from the Preference Template file. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the practitioner ID assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX240, CX30.1 +29 more
#CXP-PREF-DESCRIPT SET4
PREF_DESCRIPT		Alpha 15This field contains a short description for the procedure that may contain a more generic short description as an alternative to the standard procedure description. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the Preference Description assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-LAST-LINE-NBR
LAST_LINE_NBR		Numeric 6This field contains the number of the last line item added to the case. The number is used to determine the number when the next line is added to the case. This value is automatically updated as you add case lines.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PROC-DESC
PROC_DESC		Alpha 250 (Lower Case)This field contains the procedure description. Until a case status changes to 4 for Charges Passed or 5 for No Charges, this value displays from the Procedures file. After a case is finished (status 4 or 5), this value cannot be changed here.CXCP.1
#CXP-CLINICAL-CST
CLINICAL_CST		Signed 18.2This field contains the user-defined clinical costs for a preference. This is a user-defined subtotal that is part of the Total Procedure Cost. The clinical costs can be any costs not included in distribution, supplies, and burden costs. These latter costs along with the clinical costs make up the Total Procedure Cost. When you add a case using CX20.1 (Case Build), this value defaults from the appropriate record of the Preference Template file. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the clinical costs on the applicable template and then delete and re-add the template to the case. The second way is to type a new value (if blank) or type over the existing value in the Clinical Cost field. The Clinical Cost field appears in the Procedure Cost tab of CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Procedure Cost tab of CX20.2 (Case Detail), the Case Carts Analyzer, or a file editor.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-DIST-CST
DIST_CST		Signed 18.2This field contains the user-defined total distribution costs for the case procedure. Distribution costs are a subtotal of the Total Procedure Cost. The subtotal represents costs not included in costs for clinical resources, supplies, and burden. This value defaults from the Preference Template file when you add a preference template to a case. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the clinical costs on the applicable template and then delete and re-add the template to the case. The second way is to type a new value (if blank) or type over the existing value in the Clinical Cost field. The Clinical Cost field appears in the Procedure Cost tab of CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Procedure Cost tab of CX20.2 (Case Detail), the Case Carts Analyzer, or a file editor.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-SUPPLY-CST
SUPPLY_CST		Signed 18.2This field contains the user-defined total supply costs for the case procedure. Supplies are items assigned to a case. This value defaults from the Preference Template file when you add a preference template to a case. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the extended supply costs on the applicable template and then delete and re-add the template to the case. The second way is to type a new value (if blank) or type over the value in the Cost field for items to be changed. The Cost field appears in the Items tab, Detail detail tab of CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Procedure Cost tab of CX20.2 (Case Detail), the Case Carts Analyzer, or a file editor.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-TOTAL-CST
TOTAL_CST		Signed 18.2This field contains the total of all costs (clinical, distribution, supply, and burden) recorded for the case procedure in the Case Carts system. This value defaults from the Preference Template file when you add a preference template to a case. This value is updated each time any cost-related element is changed on a case by adding, deleting, changing quantity, and so on. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the cost-related data on the applicable template and then delete and re-add the template to the case. The second way is to type a new value (if blank) or type over the value in the applicable cost-related data in CX20.2 (Case Detail) for items to be changed. In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Procedure Cost tab of CX20.2 (Case Detail), the Case Carts Analyzer, or a file editor.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-TOTAL-BURDEN
TOTAL_BURDEN		Signed 18.2This field contains the total burden costs for the case procedure. This value defaults from the Preference Template file when you add a preference template to a case. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the burden cost-related data on the applicable template and then delete and re-add the template to the case. The second way is to type a new value (if blank) or type over the value in the applicable burden cost-related data in CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Procedure Cost tab of CX20.2 (Case Detail), the Case Carts Analyzer, or a file editor. To view individual Burden codes on a case preference, choose the Burden tab in CX20.2 (Case Detail).CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-NORMAL-TIME
NORMAL_TIME		Numeric 4This field defines the typical (normal) time taken to perform a specific procedure. This value defaults from the Preference Template file when you add a preference template to a case. Use CX05.1 (Preference Template) to change the normal time assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-EST-PROC-TIME
EST_PROC_TIME		Numeric 4This field contains the estimated time to complete the procedure. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the estimated procedure time assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-PROCEDURE-TIME
PROCEDURE_TIME		Numeric 4This field contains the actual time to complete the procedure. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the procedure time assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This field contains a valid account category as defined in the Activity Management system. This value defaults from the Preference Template file when you add a preference template to a case. Use CX05.1 (Preference Template) to change the account category assigned to a procedure on a template. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-ACTIVITY
ACTIVITY		Alpha 15This field contains a valid activity code of the Activity Management system. This value defaults from the Preference Template file when you add a preference template to a case. Use CX05.1 (Preference Template) to change the activity assigned to a procedure on a template. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-ATN-OBJ-ID SET6
ATN_OBJ_ID		Numeric 12This field contains a system-assigned identifier that provides access to data in related files. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the value assigned to a procedure on a template. Note: Use of this field is reserved for a future release.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-DATE-COMPLETED
DATE_COMPLETED		Numeric 8 (yyyymmdd)This field contains the date the case was completed. This value defaults from the Preference Template file when you add a preference template to a case. This value cannot be changed on a case. Use CX05.1 (Preference Template) to change the date assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-LST-PRFJOB-SEQ
LST_PRFJOB_SEQ		Numeric 3This field contains the record sequence number assigned to the burden code on the template. This value is automatically updated as you add case burden codes. This value defaults from the Preference Template file when you add a preference template to a case. Use CX05.1 (Preference Template) to change the Prf Job Seq assigned to a procedure on a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-STATUS
STATUS		Numeric 1This field contains the procedure transaction status.
  • 1 Created
  • 2 Complete
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-STOCKLESS-FL
STOCKLESS_FL		Alpha 1Select Yes to indicate that the item is a stockless item. Note: Use of this field is reserved for a future release.
  • Y Yes
  • N No
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-DEL-TO-LOC
DEL_TO_LOC		Alpha 5This field defines the deliver-to location.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-HR-RATE-TOTAL
HR_RATE_TOTAL		Signed 18.2This field defines the hourly rate total.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-OT-RATE-TOTAL
OT_RATE_TOTAL		Signed 18.2This field defines the other rate total. This is a system-maintained subtotal, consisting of the total for Unit, Flat Fee, Rental Hourly, and Daily Rental types, used to calculate the total procedure cost. The Case Carts system logic also updates the other rate total in the Case Cart Preferences file.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-CX-START-TIME
CX_START_TIME		Numeric 4This field contains the time when the procedure starts.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-START-DATE
START_DATE		Numeric 8 (yyyymmdd)This field contains the date when the procedure starts.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-LAST-CHG-DATE
LAST_CHG_DATE		Numeric 8 (yyyymmdd)This date indicates the last date when changes were made.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-LAST-CHG-TIME
LAST_CHG_TIME		Numeric 4This field contains the time of the last change to the case.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-OPERATOR-ID
OPERATOR_ID		Alpha 10This field is used to store the login id of the person who entered the record.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-AM-PM-FLAG
AM_PM_FLAG		Alpha 2This field indicates whether the start time is for the morning or for the afternoon or evening.
  • AM Morning
  • PM Afternoon or Evening
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
#CXP-LEADTIME-DAYS
LEADTIME_DAYS		Numeric 3This field contains the leadtime (in days) required to allocate inventory items. If the preference template has a leadtime defined, the value defaults to the case preference. Otherwise, the case company default leadtime defaults.—
#CXP-COMPLETED-TIME
COMPLETED_TIME		Numeric 4This field contains the completion time for the procedure.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
#CXP-COMPL-AM-PM
COMPL_AM_PM		Alpha 2This field indicates whether the time is for the morning or for the afternoon or evening.
  • AM AM
  • PM PM
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
#CXP-FLAT-FEE-FL
FLAT_FEE_FL		Alpha 1—CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more

Indexes (7)

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
CXPSET1
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. SEQ
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CXPSET2
  1. COMPANY
  2. REQ-LOCATION
  3. PROC-TYPE
  4. PROC-CODE
  5. CASE
  6. SEQ
CX50.1
CXPSET3
  1. COMPANY
  2. REQ-LOCATION
  3. PRACTNR-ID
  4. CASE
  5. SEQ
CX225
CXPSET4
  1. COMPANY
  2. REQ-LOCATION
  3. PREF-DESCRIPT
  4. CASE
  5. SEQ
CX50.1
CXPSET5
  1. COMPANY
  2. PRACTNR-ID
  3. REQ-LOCATION
  4. CASE
  5. SEQ
CX225
CXPSET6
  1. ATN-OBJ-ID
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—
CXPSET7
  1. COMPANY
  2. REQ-LOCATION
  3. PREF-CODE
  4. CASE
  5. SEQ
CX50.1

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CccaseheadCXCASEHEADRequired
CXP-COMPANY→CXH-COMPANY
CXP-REQ-LOCATION→CXH-REQ-LOCATION
CXP-CASE→CXH-CASE
CcpracprocCXPRACPROCRequired
CXP-COMPANY→CPP-COMPANY
CXP-PRACTNR-ID→CPP-PRACTNR-ID
CXP-PROC-TYPE→CPP-PROC-TYPE
CXP-PROC-CODE→CPP-PROC-CODE
CxprocedrCXPROCEDRRequired
CXP-PROC-TYPE→CPC-PROC-TYPE
CXP-PROC-CODE→CPC-PROC-CODE
Gen Pref TempCXPREFTEMPRequired
CXP-COMPANY→CPT-COMPANY
CXP-REQ-LOCATION→CPT-REQ-LOCATION
CXP-PREF-CODE→CPT-PREF-CODE
CXP-PROC-TYPE→CPT-PROC-TYPE
CXP-PROC-CODE→CPT-PROC-CODE
Spaces→CPT-PRACTNR-ID
Prac Pref TempCXPREFTEMPRequired
CXP-COMPANY→CPT-COMPANY
CXP-REQ-LOCATION→CPT-REQ-LOCATION
CXP-PREF-CODE→CPT-PREF-CODE
CXP-PROC-TYPE→CPT-PROC-TYPE
CXP-PROC-CODE→CPT-PROC-CODE
CXP-PRACTNR-ID→CPT-PRACTNR-ID
PractitionerCXPRACTNRRequired
CXP-PRACTNR-ID→CPR-PRACTNR-ID

One to many (5) — child tables

RelationTableRulesConditionField map
CcprefdiagCXPREFDIAGDelete Cascades
CXP-COMPANY→CPD-COMPANY
CXP-REQ-LOCATION→CPD-REQ-LOCATION
CXP-CASE→CPD-CASE
CXP-SEQ→CPD-SEQ
—→CPD-DIAG-TYPE
—→CPD-DIAG-CODE
CxprefitemCXPREFITEMDelete Cascades
CXP-COMPANY→CPI-COMPANY
CXP-REQ-LOCATION→CPI-REQ-LOCATION
CXP-CASE→CPI-CASE
CXP-SEQ→CPI-SEQ
—→CPI-LINE-NBR
CxprefjobsCXPREFJOBSDelete Cascades
CXP-COMPANY→CPJ-COMPANY
CXP-REQ-LOCATION→CPJ-REQ-LOCATION
CXP-CASE→CPJ-CASE
CXP-SEQ→CPJ-SEQ
—→CPJ-JOB-CODE
—→CPJ-SCHEDULE
—→CPJ-PAY-GRADE
—→CPJ-PRFJOB-SEQ
ItemhistoryCXITEMHIST
CXP-COMPANY→CIH-COMPANY
CXP-REQ-LOCATION→CIH-REQ-LOCATION
CXP-CASE→CIH-CASE
CXP-SEQ→CIH-SEQ
—→CIH-LINE-NBR
—→CIH-REASON-CODE
—→CIH-REASON-TYPE
LaborhistoryCXLABRHIST
CXP-COMPANY→CLH-COMPANY
CXP-REQ-LOCATION→CLH-REQ-LOCATION
CXP-CASE→CLH-CASE
CXP-SEQ→CLH-SEQ
—→CLH-JOB-CODE
—→CLH-SCHEDULE
—→CLH-PAY-GRADE
—→CLH-PRFJOB-SEQ

Programs

Updated by (36)

Referenced by (183)