CXCASEPREF

Case Cart Preferences

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.

REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX230 CX235 CX240 CX50.1 CX55.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1
WH20.2 WH20.7 CX225


UPDATED BY
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 WH130 WH132
WH190 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXP-COMPANY
Element: Company
Numeric 4
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-REQ-LOCATION
Element: 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 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-CASE
Element: Case
Alpha 15
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PREF-CODE
Element: Proc Code
Alpha 8
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-SEQ
Element: Seq
Numeric 3
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROC-TYPE
Element: Proc Code
Alpha 8
The 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROC-CODE
Element: Proc Code
Alpha 8
The 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PRACTNR-ID
Element: Practnr Id
Alpha 15
This 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
CX300 CX506
CXCP.1 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-PREF-DESCRIPT
Element: Pref Descript
Alpha 15
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROC-DESC
Element: Diag 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
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-DIST-CST
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-SUPPLY-CST
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-TOTAL-CST
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-TOTAL-BURDEN
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-NORMAL-TIME
Element: Actual Time
Numeric 4
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-EST-PROC-TIME
Element: Actual Time
Numeric 4
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROCEDURE-TIME
Element: Actual Time
Numeric 4
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-ACCT-CATEGORY
Element: Acct Category
Alpha 5
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-ACTIVITY
Element: Activity
Alpha 15
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-ATN-OBJ-ID
Element: Obj Id
Numeric 12
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-DATE-COMPLETED
Element: 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LST-PRFJOB-SEQ
Element: Seq
Numeric 3
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-STATUS
Element: Status
Numeric 1
This field contains the procedure transaction status.
1 = Created
2 = Complete
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-STOCKLESS-FL
Element: All Flag
Alpha 1
Select 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-DEL-TO-LOC
Element: Location
Alpha 5
This field defines the deliver-to location.
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-HR-RATE-TOTAL
Element: Intl Amt
Signed 18.2
This field defines the hourly rate total.
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-OT-RATE-TOTAL
Element: Intl Amt
Signed 18.2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-CX-START-TIME
Element: Actual Time
Numeric 4
This field contains the time when the procedure starts.
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-START-DATE
Element: 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LAST-CHG-DATE
Element: 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LAST-CHG-TIME
Element: Actual Time
Numeric 4
This field contains the time of the last change to the case.
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-OPERATOR-ID
Element: Operator
Alpha 10
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-AM-PM-FLAG
Element: Am Pm Flag
Alpha 2
This 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
CX506 CXCP.1
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LEADTIME-DAYS
Element: Leadtime Days
Numeric 3
This 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
Element: Actual Time
Numeric 4
This field contains the completion time for the procedure.
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-COMPL-AM-PM
Element: Compl Am Pm
Alpha 2
This 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
CX506 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-FLAT-FEE-FL
Element: Flat Fee Fl
Alpha 1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830


CXCASEPREF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXPSET1 COMPANY
REQ-LOCATION
CASE
SEQ
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.3 CX20.4
CX20.5 CX220
CX230 CX235
CX240 CX30.1
CXPSET2 COMPANY
REQ-LOCATION
PROC-TYPE
PROC-CODE
CASE
SEQ
CX50.1
CXPSET3 COMPANY
REQ-LOCATION
PRACTNR-ID
CASE
SEQ
CX225
CXPSET4 COMPANY
REQ-LOCATION
PREF-DESCRIPT
CASE
SEQ
CX50.1
CXPSET5 COMPANY
PRACTNR-ID
REQ-LOCATION
CASE
SEQ
CX225
CXPSET6 ATN-OBJ-ID
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes
CXPSET7 COMPANY
REQ-LOCATION
PREF-CODE
CASE
SEQ
CX50.1


CXCASEPREF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cccasehead CXCASEHEAD Required
CXP-COMPANY->CXH-COMPANY
CXP-REQ-LOCATION->CXH-REQ-LOCATION
CXP-CASE->CXH-CASE
Ccpracproc CXPRACPROC Required
CXP-COMPANY->CPP-COMPANY
CXP-PRACTNR-ID->CPP-PRACTNR-ID
CXP-PROC-TYPE->CPP-PROC-TYPE
CXP-PROC-CODE->CPP-PROC-CODE
Cxprocedr CXPROCEDR Required
CXP-PROC-TYPE->CPC-PROC-TYPE
CXP-PROC-CODE->CPC-PROC-CODE
Gen Pref Temp CXPREFTEMP Required
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 Temp CXPREFTEMP Required
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
Practitioner CXPRACTNR Required
CXP-PRACTNR-ID->CPR-PRACTNR-ID


CXCASEPREF FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ccprefdiag CXPREFDIAG Delete 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
Cxprefitem CXPREFITEM Delete Cascades
CXP-COMPANY->CPI-COMPANY
CXP-REQ-LOCATION->CPI-REQ-LOCATION
CXP-CASE->CPI-CASE
CXP-SEQ->CPI-SEQ
  CPI-LINE-NBR
Cxprefjobs CXPREFJOBS Delete 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
Itemhistory CXITEMHIST
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
Laborhistory CXLABRHIST
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


File created: Thu Jun 09 02:12:50 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.