Worksheet information
These tables provide the information and column properties available for each record.
Portal items are added to Department Item if those are already existing in the Item table while portal items are added to Item Location if they are already available in the Item and Department Item tables.
Application: Platform
Master Record Item
| Column Properties | Description | Required |
|---|---|---|
| ITEM_NO (PK) | Item No, Varchar, 32 | Yes |
| ITEM_GROUP (PK) | Item Group, Varchar, 5 | Yes |
| ALT_DESC | Varchar, 120 | No |
| SDI_TRACKING_FL | Numeric, 1 0 – No/Regular, 1 - Serial-tracked at Receipt, 2 – Lot-tracked at Receipt, 3 - Serial-tracked at Issue, 4 - Lot-tracked at Issue, 5 - Lot-Serial-tracked at Receipt, 6 - Lot-Serial-tracked at Issue |
Yes |
| CONSIGNMENT_FL | Char, 1, Y or N | Yes |
| IMPLANT_FL | Char, 1, Y or N | Yes |
| REPLENISHMENT_MODE | Numeric, 1 0 - Do not replenish, 1 - Replenish |
Yes |
| REPLENISH_NOTES | Varchar, 256 | No |
| SDI_UOM | Varchar, 4, POU UOM of the item | Yes |
| MIN_ORDER | Numeric, 13, Minimum order for an item (set in POU DI) | Yes |
| SDI_STATUS | Char,1, A – Active, I - Inactive | Yes |
| ALT_UOM_CF | Numeric (15,5), Conversion factor for alternate UOM, Default to 0 | Yes |
| DUPLICATE_SERIAL_FL | Char, 1, Y – Allow multiple serial numbers, N – Do not allow multiple serial numbers | Yes |
| TRANS_UOM | Varchar, 6, Item’s default transaction UOM | Yes |
| BUY_UOM | Varchar, 6, Item’s default buy UOM | No |
| TRANS_UOM_CF | Numeric (15,5,) Default to 0, Conversion factor for the item’s default transaction UOM | Yes |
| BUY _UOM_CF | Numeric (15,5,) Default to 0, Conversion factor for the item’s default buy UOM | Yes |
| BNT_TRACK_FL | Char, 1, Y or N | Yes |
Note: Upload option is Update.
Facility
| Column Properties | Description | Required |
|---|---|---|
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| FACILITY_DESC | Facility Description, varchar, 256 | No |
| IS_ACTIVE | Char, 1, T – Active Facility, F – Inactive Facility | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
Note: Upload options are Add and Update.
Application: Point of Use Nursing
User Facility Map
| Column Properties | Description | Required |
|---|---|---|
| NAME | Alphanumeric, 80 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
Note: Upload option is Add.
Patient Location
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| ROOM_CODE | Alphanumeric, 80 | Yes |
| BED | Alphanumeric, 80 | No |
| IS_ACTIVE | Char, 1, T or F | Yes |
Note: Upload options are Add and Update.
Revenue Center
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| REV_CTR_CODE | Varchar, 5 | Yes |
| IS_ACTIVE | Char, 1, T or F | Yes |
Note: Upload options are Add and Update.
Revenue Center Item
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| REV_CTR_CODE | Varchar, 5 | Yes |
| ITEM_GROUP | Varchar, 5 | Yes |
| ITEM_NO | Item No, alphanumeric, 32 | Yes |
| PATIENT_PRICE | Numeric 13,2 | No |
| CDM | Varchar, 250 | No |
| IS_CHARGEABLE | Char, 1, T or F | Yes |
Note: Upload options are Add and Update.
Workstation
| Column Properties | Description | Required |
|---|---|---|
| HOSTNAME | Varchar, 256 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| DESCRIPTION | Varchar, 50 | Yes |
| IS_ACTIVE | Char, 1, T or F | Yes |
| IDLE_TIME | Numeric, 18 | No |
| DEFAULT.COMPANY_NO | Company, numeric, 4 | No |
| DEFAULT.REV_CTR_CODE | Varchar, 5 | No |
| IDLE_GLOBAL | Char, 1, T or F, default F | No |
| DEFAULT_PATIENT_SORT | Numeric, 18; Valid values are:
|
Yes |
| ALLOW_REVENUECENTER_SELECT | Char, 1, T or F | No |
Note: Upload options are Add and Update.
Workstation Patient Location
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| ROOM_CODE | Alphanumeric, 80 | Yes |
| BED | Alphanumeric, 80 | No |
| HOSTNAME | Varchar, 256 | Yes |
Note: Upload option is Add.
Workstation Supply Location
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| LOCATION_CODE | Varchar, 20 | Yes |
| HOSTNAME | Varchar, 256 | Yes |
Note: Upload option is Add.
Application: Point of Use Department Inventory
Special Item Record
| Column Properties | Description | Required |
|---|---|---|
| ITEM_GROUP (PK) | Item Group, Varchar, 5 | Yes |
| MFR_CAT_NO | alphanumeric, 50 | Yes |
| MAJOR_CLASS | Varchar, 4 | No |
| MINOR_CLASS | Varchar, 4 | No |
| ALT_DESC | Varchar, 120 | Yes |
| CONSIGNMENT_FL | Char, 1, Y or N | Yes |
| IMPLANT_FL | Char, 1, Y or N | Yes |
| REPLENISHMENT_MODE | Numeric, 1 0 - Do not replenish, 1 - Replenish |
Yes |
| REPLENISH_NOTES | Varchar, 256 | No |
| SDI_UOM | Varchar, 4, POU UOM of the item | Yes |
| MIN_ORDER | Numeric, 13, Minimum order for an item (set in POU DI) | Yes |
| SDI_STATUS | Char,1, A – Active, I - Inactive | Yes |
| REQ_LINE_UOM | Varchar, 4, Special Item - Buy UOM | No |
| ALT_UOM_CF | Numeric (15, 5), Conversion factor for alternate UOM, Default to 0 | Yes |
| DUPLICATE_SERIAL_FL | Char, 1, Y or N | Yes |
| GTIN | alphanumeric, 14 | No |
| UPN_NBR | alphanumeric, 20 | No |
| MFG_CODE (PK) | alphanumeric, 4 | Yes |
| MFG_DIV | alphanumeric, 4, manufacturer division | No |
| TRACKING | Numeric, 1 0 – No/Regular, 3 - Serial-tracked at Issue, 4 - Lot-tracked at Issue, 6 - Lot-Serial-tracked at Issue |
Yes |
| BNT_TRACK_FL | Char, 1, Y or N | No |
Note: Upload options are Add and Update.
Department
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| LOCATION_CODE | Requesting Location, Varchar, 20 | Yes |
| DEPT_CODE | Department Code, Varchar, 20 | Yes |
| DESCRIPTION | Department Description, varchar, 199 | Yes |
| IS_ACTIVE | Char, 1, T – Active Facility, F – Inactive Facility | Yes |
| IS_SHAREABLE | Indicates if the items of the department can be shared to other departments; Char, 1, Y or N | Yes |
Note: Upload options are Add and Update.
Department Location
| Column Properties | Description | Required |
|---|---|---|
| DEPT_CODE (PK) | Department Code, Varchar, 20 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| LOCATION_CODE (PK) | Supply Location Code, Varchar, 20 | Yes |
| DESCRIPTION | Supply Location Description, Procedure Room Description or Bone and Tissue Storage Description, Varchar, 256 | Yes |
| IS_ACTIVE | Char, 1, Y or N | Yes |
| DEPT_LOC_TYPE | Varchar, 25 Valid values are:
|
Yes |
Note: Upload options are Add and Update. If Location
Code is a Supply Location Code, any value specified in the Description field for the Supply
Location Code will be overwritten with the Supply Location’s existing description during Add
or Update.
Department Item
| Column Properties | Description | Required |
|---|---|---|
| DEPT_CODE (PK) | Department Code, Varchar, 20 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| ITEM_GROUP | Varchar, 5 | Yes |
| ITEM_NO (PK) | Item No, Varchar, 32 | Yes |
| CHARGEABLE_FL | Char, 1, Item Chargeability, Y or N | Yes |
| CDM | Varchar, 250 | No |
| HCPC | alphanumeric, 250 | No |
| ITEM_PRICE | Patient Price, numeric, 13,2, default to 0 | Yes |
| STOCK_LOCATION.COMPANY_NO | Company, numeric, 4 | No |
| STOCK_LOCATION.LOCATION_CODE | Varchar, 20, location code when item is stock replenished | No |
| REPLENISHMENT_TYPE | Numeric, 1, 1 – Vendor Replenished, 2 – Stock Replenished | Yes |
| REQ_LINE_UOM | Requisition Unit of Measure, Varchar, 4, | No |
| SDI_UOM | Usage Unit of Measure, Varchar, 4 | No |
| ALT_UOM_CF | Numeric (15, 5), Conversion factor for alternate UOM, Default to 0 | Yes |
| VENDOR_ID | Vendor, alphanumeric, 9 | No |
| VENDOR_LOCATION.COMPANY_NO | Company, numeric, 4 | No |
| VENDOR_LOCATION.LOCATION_CODE | Varchar, 20, purchase from location code when item is vendor replenished | No |
| ACCT_UNIT | Accounting Unit, Varchar, 15 | No |
| ACCT | Account, numeric, 6 | No |
| SUB_ACCT | Sub-account, numeric, 4 | No |
| TRACKING_FL | Numeric, 1 0 – No/Regular, 1 - Serial-tracked at Receipt, 2 – Lot-tracked at Receipt, 3 - Serial-tracked at Issue, 4 - Lot-tracked at Issue, 5 - Lot-Serial-tracked at Receipt, 6 - Lot-Serial-tracked at Issue |
Yes |
| EXPIRATION_AT_RECEIPT | Char, 1, Y or N | Yes |
| EXPIRATION_AT_ISSUE | Char, 1, Y or N | Yes |
Note: Upload options are Add and Update.
Department Location Item
| Column Properties | Description | Required |
|---|---|---|
| DEPT_CODE (PK) | Department Code, Varchar, 20 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| LOCATION_CODE (PK) | Supply Location, Procedure Room or Bone and Tissue, alphanumeric, 20 | Yes |
| ITEM_GROUP | Varchar, 5 | Yes |
| IITEM_NO (PK) | Item No, alphanumeric, 32 | Yes |
| PAR_LEVEL | numeric, 13 | Yes |
| CRITICAL_LEVEL | numeric, 13 | No |
Note: Upload options are Add and Update.
Practitioner
| Column Properties | Description | Required |
|---|---|---|
| EMPLOYEE_ID | alphanumeric, 15 | Yes |
| FIRST_NAME | alphanumeric, 30 | Yes |
| LAST_NAME | alphanumeric, 50 | Yes |
Note: Upload options are Add and Update.
Facility Practitioner Mapping
| Column Properties | Description | Required |
|---|---|---|
| EMPLOYEE_ID (PK) | alphanumeric, 15 | Yes |
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| IS_ACTIVE | Char, 1, Y or N | Yes |
Note: Upload options are Add and Update.
Procedure
| Column Properties | Description | Required |
|---|---|---|
| PROCEDURE_CODE | alphanumeric, 20, can be blank | No |
| DESCRIPTION | alphanumeric, 199 | Yes |
| CHARGE_CODE (PK) | Hospital Charge No., alphanumeric, 250 | Yes |
| IS_ACTIVE | Char, 1, Y or N | Yes |
| CHARGEABLE_FL | Y, if chargeable; N, if non-chargeable | Yes |
Note: Upload options are Add and Update.
Procedure Modifier
| Column Properties | Description | Required |
|---|---|---|
| PROCEDURE_MOD_CODE | Procedure Modifier code, alphanumeric, 250 | Yes |
| PROCEDURE_MOD_DESC | alphanumeric, 199 | Yes |
| IS_ACTIVE | Char, 1, Y or N | Yes |
Note: Upload options are Add and Update.
Procedure Template
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| CHARGE_CODE (PK) | Hospital Charge No., alphanumeric, 250 | Yes |
| EMPLOYEE_ID (PK) | alphanumeric, 15 | No |
| NAME | Alphanumeric,256 | Yes |
| IS_ACTIVE | Char, 1, Y or N | Yes |
Note: Upload options are Add and Update.
Procedure Template Item
| Column Properties | Description | Required |
|---|---|---|
| COMPANY_NO (PK) | Company, numeric, 4 | Yes |
| FACILITY_CODE (PK) | Facility, alphanumeric, 80 | Yes |
| CHARGE_CODE (PK) | Hospital Charge No., alphanumeric, 250 | Yes |
| EMPLOYEE_ID (PK) | alphanumeric, 15 | No |
| ITEM_GROUP | Varchar, 5 | Yes |
| ITEM_NO (PK) | Item No, alphanumeric, 32 | Yes |
| QUANTITY | numeric, default 1 | Yes |
Note: Upload options are Add and Update.