CXPTMPITEM

Template Items

The Template Items file contains the items that are included in a preference template. The information in this record is used to provide default item information in Preference Items file records when adding preference templates to a case. Use CX05.1 (Preference Template) to add or delete items from a preference template.

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 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTI-COMPANY
Element: Company
Numeric 4
This field contains the company number.
CTI-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 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.
CTI-PREF-CODE
Element: Proc Code
Alpha 8
This field contains the Preference List Code.
CTI-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.
CTI-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.
CTI-PRACTNR-ID
Element: Practnr Id
Alpha 15
This field contains the practitioner ID. Form CX04.1 (Practitioner) is used to define practitioner IDs.
CTI-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
CTI-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the item description. This value defaults from the item master for inventoried (I) or non-inventory-tracked (N) type items and must be added manually for all other types.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
I = Inventoried Item
N = Non-Stock Item
S = Service Item
X = Special Item
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-SERVICE-CODE
Element: Service Code
Alpha 1
CTI-QUANTITY
Element: Quantity
Signed 13.4
This field contains the requested quantity to be picked. This field defaults to one (1) if no value is entered.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-ISSUE-COST
Element: Intl Amt
Signed 18.2
This field contains either a system-generated or a user-defined cost. Defaults: For inventoried (I) type items, the Case Carts system defaults the issue cost from the Inventory Control system costing routine. For non-inventory tracked (N, X, or S) type items, the Case Carts system defaults the cost from the Purchase Order system unit cost default routine. You can override the defaulted costs by making a line change.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-FROM-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-FROM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-CHARGE-NBR
Element: Charge Nbr
Alpha 10
The number used by the patient billing system to charge patients for items used.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-CHARGEABLE-FL
Element: All Flag
Alpha 1
This field indicates whether the item is a patient chargeable item. Select Yes if the item is a patient chargeable item.
Y = Yes
N = No
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-PRICE
Element: Intl Amt
Signed 18.2
This field contains the amount that the patient will be charged for the item.
CTI-REV-CENTER
Element: Rev Center
Alpha 5
The revenue center is the department or accounting unit to be credited by the reimbursement.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
CTI-POST-ITEM-FL
Element: Post Item Fl
Alpha 1
This field indicates whether or not the item is used in the procedure (an intraoperative item) or is a postoperative or preoperative item.
1 = Intra-Op
2 = Post-Op
3 = Pre-Op
CTI-POST-DAY
Element: Day
Numeric 2
This field defines the day of the patient visit when the item is to be used. A value of zero indicates the day of the procedure. When used with the Care Days field, this value indicates the day to start picking care items.
00
99
CTI-PATIENT-CLASS
Element: Patient Class
Alpha 1
This provides for a category of patient.
I = Inpatient
O = Outpatient
CTI-REPEAT-FL
Element: All Flag
Alpha 1
This field is reserved for a future release of the Case Carts system.
Y = Yes
N = No
CTI-NBR-DAYS
Element: Nbr Days
Numeric 2
Care days are the total number of days a preoperative or postoperative item will be used on the case, starting with the usage day. The day of the procedure is considered usage day 0. See note below. The Care Days * Units Per Day must equal the Quantity if the Item Usage flag is set. Defaults: None. Note: For example, if the patient stay consists of day one for both surgery and the use of intraoperative and postoperative items, the number of care days is 0. In another example, if the patient stay consists of two days, day one for the procedure (designated as usage day 0) and day two for postoperative care, the number of care days is 1. In another example if an item is not used on a day in the middle of a patient stay, you must create two lines for the item. That is, first define the care days for the item, up to the day of nonusage. Next, add a new line for the same item. Assume the day of nonusage as a new usage day 0 and define the care days for the new line as the total number of remaining care days for the item. Use the following fields together: Item Usage, Usage Day, Care Days, and Units Per Day.
CTI-UNITS-PER-DAY
Element: Units Per Day
Numeric 3
This value defines the number of item units to be used per care day. Use this field with the Item Usage flag. Be aware that you do not use this field with Care Days and Units Per Day fields.
CTI-PICK-FL
Element: Pick Fl
Alpha 1
This field indicates in which system to run the pick list program. Important: Your selection affects more than just printing the pick list. Your decision also affects whether shipment records will be created so that items are picked for the correct case by shipment number. The shipment records also exist for further processing. See note below. For inventoried (I) type items, you must select 1. For non-inventory-tracked (N, X, or S) type items, you can select 1, 2, or 3. For printing no pick lists, select 3. Note: You must run the pick list program (WH130 (Pick List Print)) in the Warehouse system to have the system create shipment records. (Later, when you run CX100 (Pick List Print), the shipment number created will appear on the CX100 pick list. The shipment number helps you match picked items with a case procedure.) Additionally, once the shipment records are created, shipping feedback (in WH32.1 (Shipping Feedback by Shipment)), and reduction of stock on hand and deletion of demand records by shipment release (in WH190 (Shipment Release)) can proceed.
1 = Pick through Warehouse system
2 = Pick through Case Cart system
3 = Do not pick
CTI-ACCT-CATEGORY
Element: Acct 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.
CTI-ACTIVITY
Element: Activity
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.
CTI-ATN-OBJ-ID
Element: Obj Id
Numeric 12
This field contains a system-assigned identifier that provides access to data in related files.
CTI-STORAGE-LOC
Element: Bin
Alpha 7
This field contains the storage location identifier.
CTI-STOCKLESS-FL
Element: All Flag
Alpha 1
This flag indicates whether or not the item is a stockless item. Note: Use of this field is reserved for a future release.
Y = Yes
N = No
CTI-AGREEMENT-REF
Element: Agreement Ref
Alpha 30
CTI-COST-CD
Element: Cost Cd
Alpha 1
This field contains the unit cost origin code.
E = Entered
L = Last Cost
C = Contract
T = Catalog/Quote
B = Blanket
P = Last PO Created
CTI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
CTI-CREATE-PO-CD
Element: Create Po Cd
Alpha 1
This code indicates whether this inventory item is to be purchased by a purchase order instead of picked from inventory. N = No, pick from inventory. Y = Yes, create purchase order.
CTI-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
CTI-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
This field defines whether or not the item is taxable.
Y = Yes
N = No
CTI-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
CTI-CERT-REQ-FL
Element: Cert Req Fl
Alpha 1
This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the purchase order when the purchase order line is created. Select No if Certification not required. Select Yes if Certification required.
Y = Yes
N = No
CTI-INSP-REQ-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
CTI-COST-OPTION
Element: Cost Option
Alpha 1

1 = Cost Required
2 = No Charge
3 = Vendor Determined
CTI-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user-defined code that indicates the manufacturer of an item.
CTI-MANUF-DIVISION
Element: Manuf Division
Alpha 4
This field contains a user-defined code that indicates which division of a manufacturer is tied to an item.
CTI-MANUF-NBR
Element: Manuf Nbr
Alpha 35
This is the identifier that the manufacturer has assigned to an item.
CTI-LEADTIME-DAYS
Element: Leadtime Days
Numeric 3
This value (in days) indicates whether the allocation for the item should be done immediately or at some future date. (For example, if a purchase order must be created for the item, the leadtime must allow time to create the order, send it, and receive the item.) The future date for allocation is calculated using this value. If blank, the value defaults from the lead-time days defined on the Main tab of the template.
CTI-PUT-OUT-FL
Element: Put Out Fl
Numeric 3
This field will show up on the printed pick list and preference list to show how many of an item needs to opened for the procedure. This will help in reducing waste and returns. For example, if the item quantity is 4 but the practitioner wants only 2 opened, this value would be 2.
CTI-USE-IDENTIFIER
Element: Use Identifier
Alpha 1
CTI-CONSIGNMENT-FL
Element: Consignment Fl
Alpha 1


CXPTMPITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTISET1 COMPANY
REQ-LOCATION
PREF-CODE
PROC-TYPE
PROC-CODE
PRACTNR-ID
LINE-NBR
CTISET2 COMPANY
REQ-LOCATION
ITEM
PREF-CODE
PROC-TYPE
PROC-CODE
PRACTNR-ID
LINE-NBR
...
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


CXPTMPITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
From Location ICLOCATION Required
When CTI-FROM-LOCATION !=Spaces
CTI-COMPANY->ICL-COMPANY
CTI-FROM-LOCATION->ICL-LOCATION
Ic Company ICCOMPANY Required
CTI-COMPANY->ICC-COMPANY
Item ITEMMAST Not Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
CTI-ITEM->ITE-ITEM
Item Location ITEMLOC Not Required
Valid When CTI-FROM-LOCATION !=Spaces
CTI-COMPANY->ITL-COMPANY
CTI-FROM-LOCATION->ITL-LOCATION
CTI-ITEM->ITL-ITEM
Vendor APVENMAST Required
When CTI-VENDOR !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
CTI-VENDOR->VEN-VENDOR
Vendor Group APCOMPANY Required
CTI-COMPANY->CPY-COMPANY


File created: Wed Jun 08 20:48:32 2016

Home
Contact Us



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