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.

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
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
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
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
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
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
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 1CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more

Indexes (7)

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

IndexKeysFlagsConditionUsed in
CXPSET1COMPANY, REQ-LOCATION, CASE, SEQPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CXPSET2COMPANY, REQ-LOCATION, PROC-TYPE, PROC-CODE, CASE, SEQCX50.1
CXPSET3COMPANY, REQ-LOCATION, PRACTNR-ID, CASE, SEQCX225
CXPSET4COMPANY, REQ-LOCATION, PREF-DESCRIPT, CASE, SEQCX50.1
CXPSET5COMPANY, PRACTNR-ID, REQ-LOCATION, CASE, SEQCX225
CXPSET6ATN-OBJ-IDKeyChange, SubsetWhere ATN-OBJ-ID != Zeroes
CXPSET7COMPANY, REQ-LOCATION, PREF-CODE, CASE, SEQCX50.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CccaseheadCXCASEHEADRequiredCXP-COMPANYCXH-COMPANY, CXP-REQ-LOCATIONCXH-REQ-LOCATION, CXP-CASECXH-CASE
CcpracprocCXPRACPROCRequiredCXP-COMPANYCPP-COMPANY, CXP-PRACTNR-IDCPP-PRACTNR-ID, CXP-PROC-TYPECPP-PROC-TYPE, CXP-PROC-CODECPP-PROC-CODE
CxprocedrCXPROCEDRRequiredCXP-PROC-TYPECPC-PROC-TYPE, CXP-PROC-CODECPC-PROC-CODE
Gen Pref TempCXPREFTEMPRequiredCXP-COMPANYCPT-COMPANY, CXP-REQ-LOCATIONCPT-REQ-LOCATION, CXP-PREF-CODECPT-PREF-CODE, CXP-PROC-TYPECPT-PROC-TYPE, CXP-PROC-CODECPT-PROC-CODE, SpacesCPT-PRACTNR-ID
Prac Pref TempCXPREFTEMPRequiredCXP-COMPANYCPT-COMPANY, CXP-REQ-LOCATIONCPT-REQ-LOCATION, CXP-PREF-CODECPT-PREF-CODE, CXP-PROC-TYPECPT-PROC-TYPE, CXP-PROC-CODECPT-PROC-CODE, CXP-PRACTNR-IDCPT-PRACTNR-ID
PractitionerCXPRACTNRRequiredCXP-PRACTNR-IDCPR-PRACTNR-ID

One to many (5) — child tables

RelationTableRulesConditionField map
CcprefdiagCXPREFDIAGDelete CascadesCXP-COMPANYCPD-COMPANY, CXP-REQ-LOCATIONCPD-REQ-LOCATION, CXP-CASECPD-CASE, CXP-SEQCPD-SEQ, CPD-DIAG-TYPE, CPD-DIAG-CODE
CxprefitemCXPREFITEMDelete CascadesCXP-COMPANYCPI-COMPANY, CXP-REQ-LOCATIONCPI-REQ-LOCATION, CXP-CASECPI-CASE, CXP-SEQCPI-SEQ, CPI-LINE-NBR
CxprefjobsCXPREFJOBSDelete CascadesCXP-COMPANYCPJ-COMPANY, CXP-REQ-LOCATIONCPJ-REQ-LOCATION, CXP-CASECPJ-CASE, CXP-SEQCPJ-SEQ, CPJ-JOB-CODE, CPJ-SCHEDULE, CPJ-PAY-GRADE, CPJ-PRFJOB-SEQ
ItemhistoryCXITEMHISTCXP-COMPANYCIH-COMPANY, CXP-REQ-LOCATIONCIH-REQ-LOCATION, CXP-CASECIH-CASE, CXP-SEQCIH-SEQ, CIH-LINE-NBR, CIH-REASON-CODE, CIH-REASON-TYPE
LaborhistoryCXLABRHISTCXP-COMPANYCLH-COMPANY, CXP-REQ-LOCATIONCLH-REQ-LOCATION, CXP-CASECLH-CASE, CXP-SEQCLH-SEQ, CLH-JOB-CODE, CLH-SCHEDULE, CLH-PAY-GRADE, CLH-PRFJOB-SEQ

Programs

Updated by (36)

Referenced by (183)