CXPREFTEMP – Preference Template
- System
- Case Carts (CX)
- Prefix
CPT- Primary key
COMPANY,REQ-LOCATION,PREF-CODE,PROC-TYPE,PROC-CODE,PRACTNR-ID- Fields
- 28
- Updated by
- 4 programs
- Referenced by
- 38 programs
CXPREFTEMP is the Preference Template table in Lawson Case Carts (prefix CPT). It is indexed by COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID (CPTSET1); alternate indexes: CPTSET2, CPTSET3, CPTSET4, CPTSET5 and CPTSET6. It is related 1:1 to CXPRACPROC, CXCOMPANY, CXPREFTEMP, CXPRACTNR, CXPROCEDR and RQLOC and 1:M to CXPTMPDIAG, CXPTMPITEM and CXTMPJOBS. It is updated by CX05.1, CX05.2, CX805 and CXMC.1 and referenced by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX205, CX207, CX220 and 30 more. The table has 28 fields, 6 indexes and 10 documented relations.
About CXPREFTEMP
The Preference Template file contains the header record for preference templates. This information is basic information related to preference templates. In addition to the information contained in this record, a preference template also has items (contained in the Template Items file), diagnostic codes (contained in Template Diagnostics file) and comments. The information in this record is used to provide default information for Case Cart Preference file records when preference templates are added to a case. A preference template record must be used to add a preference list to a case. There are two types of preference templates: general and practitioner- specific. Use CX05.1 (Preference Template) to add or delete individual records in this file.
Fields (28)
Column = COBOL field name without the CPT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CPT-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number. | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-REQ-LOCATION PKREQ_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. | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-PREF-CODE PKPREF_CODE | Alpha 8 | This field contains the template preference-list code. The code is assigned to cases in CX20.1 (Case Build). The code is used with other key fields to uniquely identify a template. Key fields include Company, Requesting Location, Practitioner ID (except for generic templates), Preference Code, Procedure Type, and Procedure Code. The code can be used to classify multiple procedures. For example, the code can be an abbreviation for a section of the CPT catalog, such as ANEST for Anesthesia or RESP for Respiratory. You could use the same preference code with varying key fields to define different templates for procedures in the same classification of the preference code. The code is assigned to cases in the Preference Code field of CX20.1 (Case Build). | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-PRACTNR-ID PKPRACTNR_ID | Alpha 15 | This field contains the practitioner ID. If this field contains a value, this template becomes a practitioner-specific template. A blank means a generic template. | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-PROC-TYPE PKPROC_TYPE | 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. | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-PROC-CODE PKPROC_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. | CX05.1, CX05.2, CX805, CXMC.1 |
CPT-PREF-DESCRIPTPREF_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. | CX05.1, CX05.2, CX805 |
CPT-LAST-CHG-TIMELAST_CHG_TIME | Numeric 4 | This field defines the time of the last change. | CX05.1, CX05.2, CX805 |
CPT-LAST-CHG-DATELAST_CHG_DATE | Numeric 8 (yyyymmdd) | This field defines the date of the last change. | CX05.1, CX05.2, CX805 |
CPT-OPERATOR-IDOPERATOR_ID | Alpha 10 | This field is used to store the login id of the person who entered the record. | CX05.1, CX05.2, CX805 |
CPT-LAST-LINE-NBRLAST_LINE_NBR | Numeric 6 | This field contains the line number. | CX05.1, CX05.2, CX805 |
CPT-CLINICAL-CSTCLINICAL_CST | Signed 18.2 | This field contains the user-defined sum of all clinical costs for the procedure on the preference template. This is a user-defined subtotal of the Total Procedure Cost. The clinical costs represent costs not included in subtotals for distribution, supplies, and burden. This value is added manually and viewed in this field in CX05.1 (Preference Template). Note: You can view this value, using one of the following features: the Cost tab of CX05.1 (Preference Template), the Case Carts Analyzer, or a file editor. | CX05.1, CX05.2, CX805 |
CPT-DIST-CSTDIST_CST | Signed 18.2 | This field contains the user-defined distribution costs for the procedure. This value is the sum of the distribution costs for the preference assigned to the template. This value is updated manually and viewed in this field in CX05.1 (Preference Template). Note: You can view this value, using one of the following features: the Cost tab of CX05.1 (Preference Template), the Case Carts Analyzer, or a file editor. | CX05.1, CX05.2, CX805 |
CPT-SUPPLY-CSTSUPPLY_CST | Signed 18.2 | This field contains the user-defined supply costs for the procedure. This value is the sum of the extended item costs for the preference assigned to the template. Use CX05.1 (Preference Template) to update item costs and thereby automatically update this total. Note: You can view this value, using one of the following features: the Cost tab of CX05.1 (Preference Template), the Case Carts Analyzer, or a file editor. | CX05.1, CX05.2, CX805 |
CPT-TOTAL-CSTTOTAL_CST | Signed 18.2 | This field contains the total of all costs for the procedure. The costs included are for clinical and distribution resources, supplies (items), and burden for jobs and nonsalaried resources. This value is updated each time an element is changed by adding, deleting, changing quantity, and so on. Note: You can view this value, using one of the following features: the Cost tab of CX05.1 (Preference Template), the Case Carts Analyzer, or a file editor. | CX05.1, CX05.2, CX805 |
CPT-TOTAL-BURDENTOTAL_BURDEN | Signed 18.2 | This field contains the total burden costs associated with preference template burden codes. A burden is a resource with a measurable cost assigned to a case. The measurable cost can be an indirect cost, assigned to but not directly related to a case. Examples of burden are salaries, equipment, services, and other such as costs for capital depreciation or building management. This value is the sum of the extended burden costs for the preference template. When you add a burden code to the template, this total automatically increases. You can define this value directly or indirectly. Use CX05.1 (Preference Template) to update template burden costs directly and thereby automatically update this total. Use CX15.1 (Burden) to update nonsalary burden code (or salary burden codes as well if you do not use the Human Resources interface) and then add the updated burden code to the template. Before you run CX504 (HR Labor Import) and before you then add the latest burden codes to the preference template, make sure the job code costs are accurately defined in the Human Resources system. Note: Costs default to the Salary Range fields of CX15.1 (Burden) based on the Salary Range field definition in CX01.1 (Company). | CX05.1, CX05.2, CX805 |
CPT-NORMAL-TIMENORMAL_TIME | Numeric 4 | This field contains the typical (normal) time taken to perform a specific procedure. | CX05.1, CX05.2, CX805 |
CPT-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | This field contains a valid account category as defined in the Activity Management system. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release. | CX05.1, CX05.2, CX805 |
CPT-ACTIVITYACTIVITY | Alpha 15 | This field contains a valid activity code as defined in the Activity Management system. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release. | CX05.1, CX05.2, CX805 |
CPT-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | — |
CPT-ATN-OBJ-IDATN_OBJ_ID | Numeric 12 | This field contains a system-assigned identifier that provides access to data in related files. | CX05.1, CX05.2, CX805 |
CPT-LST-TMPJOB-SEQLST_TMPJOB_SEQ | Numeric 3 | This field contains the record sequence number. | CX05.1, CX05.2, CX805 |
CPT-STOCKLESS-FLSTOCKLESS_FL | Alpha 1 | This flag indicates whether any item on the procedure can be considered stockless. Note: Use of this field is reserved for a future release.
| CX05.1, CX05.2, CX805 |
CPT-HR-RATE-TOTALHR_RATE_TOTAL | Signed 18.2 | This field defines the hourly rate total. | CX05.1, CX05.2, CX805 |
CPT-OT-RATE-TOTALOT_RATE_TOTAL | Signed 18.2 | This field defines the overtime rate total. | CX05.1, CX05.2, CX805 |
CPT-LEADTIME-DAYSLEADTIME_DAYS | Numeric 3 | This field contains the leadtime (in days). This value indicates whether to allocate the item immediately or at some future date. The Case Carts system calculates the future date using this field. | — |
CPT-TEMPLATE-TYPETEMPLATE_TYPE | Derived | This code is used to differentiate a template for the case cart module from a template set up by the Requisition system. | — |
CPT-FLAT-FEE-FLFLAT_FEE_FL | Alpha 1 | — | CX05.1, CX05.2, CX805 |
Indexes (6)
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 |
|---|---|---|---|---|
CPTSET1 | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID | Primary | CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX205 +22 more (list truncated in source) | |
CPTSET2 | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID | Subset | Where PRACTNR-ID = Spaces | CX220 |
CPTSET3 | COMPANY, REQ-LOCATION, PROC-TYPE, PROC-CODE, PRACTNR-ID | KeyChange | CX05.1, CX05.2, CX207, CX805 | |
CPTSET4 | COMPANY, REQ-LOCATION, PREF-DESCRIPT, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID | KeyChange | CX05.1, CX05.2, CX805 | |
CPTSET5 | ATN-OBJ-ID | KeyChange, Subset | Where ATN-OBJ-ID != Zeroes | — |
CPTSET6 | COMPANY, REQ-LOCATION, PROC-CODE, PROC-TYPE, PREF-CODE, PRACTNR-ID | CX220 |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ccprocproc | CXPRACPROC | Required | When CPT-PRACTNR-ID != Spaces | CPT-COMPANY → CPP-COMPANY, CPT-PRACTNR-ID → CPP-PRACTNR-ID, CPT-PROC-TYPE → CPP-PROC-TYPE, CPT-PROC-CODE → CPP-PROC-CODE |
| Cxcompany | CXCOMPANY | Required | CPT-COMPANY → CXC-COMPANY | |
| Generictemp | CXPREFTEMP | Required | When CPT-PRACTNR-ID = Spaces | CPT-COMPANY → CPT-COMPANY, CPT-REQ-LOCATION → CPT-REQ-LOCATION, CPT-PROC-TYPE → CPT-PROC-TYPE, CPT-PROC-CODE → CPT-PROC-CODE, Spaces → CPT-PRACTNR-ID |
| Practemp | CXPREFTEMP | Required | When CPT-PRACTNR-ID != Spaces | CPT-COMPANY → CPT-COMPANY, CPT-REQ-LOCATION → CPT-REQ-LOCATION, CPT-PROC-TYPE → CPT-PROC-TYPE, CPT-PROC-CODE → CPT-PROC-CODE, CPT-PRACTNR-ID → CPT-PRACTNR-ID |
| Practitioner | CXPRACTNR | Required | When CPT-PRACTNR-ID != Spaces | CPT-PRACTNR-ID → CPR-PRACTNR-ID |
| Procedure Type | CXPROCEDR | Required | CPT-PROC-TYPE → CPC-PROC-TYPE, CPT-PROC-CODE → CPC-PROC-CODE | |
| Req Loc | RQLOC | Required | CPT-COMPANY → RQL-COMPANY, CPT-REQ-LOCATION → RQL-REQ-LOCATION |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cxptmpdiag | CXPTMPDIAG | Delete Cascades | CPT-COMPANY → CTD-COMPANY, CPT-REQ-LOCATION → CTD-REQ-LOCATION, CPT-PREF-CODE → CTD-PREF-CODE, CPT-PROC-TYPE → CTD-PROC-TYPE, CPT-PROC-CODE → CTD-PROC-CODE, CPT-PRACTNR-ID → CTD-PRACTNR-ID, CTD-DIAG-TYPE, CTD-DIAG-CODE | |
| Cxptmpitem | CXPTMPITEM | Delete Cascades | CPT-COMPANY → CTI-COMPANY, CPT-REQ-LOCATION → CTI-REQ-LOCATION, CPT-PREF-CODE → CTI-PREF-CODE, CPT-PROC-TYPE → CTI-PROC-TYPE, CPT-PROC-CODE → CTI-PROC-CODE, CPT-PRACTNR-ID → CTI-PRACTNR-ID, CTI-LINE-NBR | |
| Cxtmpjobs | CXTMPJOBS | Delete Cascades | CPT-COMPANY → CTJ-COMPANY, CPT-REQ-LOCATION → CTJ-REQ-LOCATION, CPT-PREF-CODE → CTJ-PREF-CODE, CPT-PROC-TYPE → CTJ-PROC-TYPE, CPT-PROC-CODE → CTJ-PROC-CODE, CPT-PRACTNR-ID → CTJ-PRACTNR-ID, CTJ-JOB-CODE, CTJ-SCHEDULE, CTJ-PAY-GRADE, CTJ-TMPJOB-SEQ |
Programs
Updated by (4)
- CX05.1 Preference Template
- CX05.2 Preference Template Diagnostics
- CX805 Template Card Conversion
- CXMC.1 Case cart mimic
Referenced by (38)
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX205 Preference Template Items
- CX207 Preference List Value
- 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