CXPTMPDIAG – Template Diagnostics

System
Case Carts (CX)
Prefix
CTD
Primary key
COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, DIAG-TYPE, DIAG-CODE
Fields
8
Updated by
4 programs
Referenced by
37 programs

CXPTMPDIAG is the Template Diagnostics table in Lawson Case Carts (prefix CTD). It is indexed by COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, DIAG-TYPE, DIAG-CODE (CTDSET1); alternate indexes: CTDSET2 and CTDSET3. It is related 1:1 to CXDIAGNOST and CXPREFTEMP. It is updated by CX05.1, CX05.2, CX805 and CXMC.1 and referenced by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX207, CX220, CX30.1 and 29 more. The table has 8 fields, 3 indexes and 2 documented relations.

About CXPTMPDIAG

The Template Diagnostics file contains the diagnostic code(s) associated with a preference template. These records are used to provide default item information in Preference Diagnostics file records when preference lists are added to a case. Use CX05.2 (Preference Template Diagnostics), chosen from CX05.1 (Preference Template), to add or delete records from this file. Each record in this file is related to one record in the following files except as noted: Preference Template (CXPREFTEMP), Case Cart Diagnostics (CXDIAGNOST), and, optionally, one or more records in the Preference Diagnostics file.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
CTD-COMPANY PK
COMPANY		Numeric 4This field contains the company number.CX05.1, CX05.2, CX805, CXMC.1
CTD-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 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
CTD-PREF-CODE PK
PREF_CODE		Alpha 8This field contains the Preference Code from the preference template.CX05.1, CX05.2, CX805, CXMC.1
CTD-PROC-TYPE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTD-PROC-CODE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTD-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID.CX05.1, CX05.2, CX805, CXMC.1
CTD-DIAG-TYPE PK
DIAG_TYPE		Alpha 8The diagnostic type is the first of two fields that uniquely identify a diagnosis. The diagnostic type can be used to identify the code set to which the diagnostic code belongs. For example, you might assign a type of HCPCS for a code in the Health Care Financing Administration's Common Procedure Coding System.CX05.1, CX05.2, CX805
CTD-DIAG-CODE PK
DIAG_CODE		Alpha 6The diagnostic code is the second of two fields used to uniquely identify a diagnosis. The diagnostic code is an identifier for a specific diagnosis within a diagnostic type.CX05.1, CX05.2, CX805

Indexes (3)

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

IndexKeysFlagsConditionUsed in
CTDSET1COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, DIAG-TYPE, DIAG-CODEPrimaryCX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX207 +22 more (list truncated in source)
CTDSET2COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, DIAG-TYPE, DIAG-CODE, PRACTNR-ID—
CTDSET3COMPANY, DIAG-TYPE, DIAG-CODE, REQ-LOCATION, PRACTNR-ID, PROC-TYPE, PROC-CODECX207

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CcdiagnostCXDIAGNOSTRequiredCTD-DIAG-TYPE → CDI-DIAG-TYPE, CTD-DIAG-CODE → CDI-DIAG-CODE
CxpreftempCXPREFTEMPRequiredCTD-COMPANY → CPT-COMPANY, CTD-REQ-LOCATION → CPT-REQ-LOCATION, CTD-PREF-CODE → CPT-PREF-CODE, CTD-PROC-TYPE → CPT-PROC-TYPE, CTD-PROC-CODE → CPT-PROC-CODE, CTD-PRACTNR-ID → CPT-PRACTNR-ID

Programs

Updated by (4)

Referenced by (37)