Power Sourcing Source and Output Files

Before uploading the source (input) file, ensure it meets the following requirements:

  • The file format is either tab delimited text or Excel

  • The file size is no more than 10 megabytes

  • A header row is included and does not contain special characters

  • A Vendor Name column is included and does not exceed 100 characters

  • A Vendor Part Number column is included and does not exceed 50 characters

  • The file contains no more than 250,000 rows, excluding the header row

The output file contains a list of items that were matched to curated items. All data attributes are included in this file. To see the status of the sourced item based on the Power Sourcing job, open the output file and look at the Source Type column. Options are: 

  • Curated – Data was available and the Power Sourcing job ran successfully

  • Error – An error occurred during the Power Sourcing job

  • Not Curated – No match was found for the vendor name and vendor part number

  • Missing Value – The vendor name or vendor part number was missing from the source file

Power Sourcing Output File Column Definitions

The following table contains the column definitions for items found in the Output File.

  • Items in Yellow text cannot be turned off, and cannot be reordered.

    Note: Items with an asterisk will have additional information available soon.

Power Sourcing Output Header Source information Description
Curation Status GHX

GHX data validation and enhancement status of completeness.

Example Data:

Curated, In Progress, Missing Value, Not Available
Source Type Data Connect

Provider Source of the data.

Example Data:

IM, POH, CTR
Buyer Part # PCAT

Workday Item Identifier of part number searched.

Example Data:

(alpha-numeric)
Preferred Contract # CCX

Matched Client Contract ID from CCX of part number searched.

Example Data:

(alpha-numeric)
Duplicate Description Indicator GHX

Duplicate descriptions for two buyer part numbers.

Example Data: Yes
Provider Item Status Provider PCAT (IM)

Status from the PCAT/IM of the provider item; Active/Inactive.

Example Data:

A/I
Vendor Name GHX

Validated Supplier Name.

Example Data:

Abbott Nutrition

Vendor Part #

GHX

Validated Supplier Part #.

Example Data:

55253
Vendor Item Status GHX

Supplier item status.

Example Data:

Available/Not Distributed

Manufacturer Name

GHX

Validated Manufacturer Name.

Example Data:

Abbott Nutrition
Manufacturer Part # GHX

Validated Manufacturer Part #.

Example Data:

55253

Manufacturer Description

GHX

Manufacturer provided description (not always populated); No GHX standardization applied.

Example Data:

ELECARE JR UNFL 14.1OZ PWD 6CT
Manufacturer Discontinued Date GHX

Manufacturer provided; mainly from GUDID.

Example Data:

(date format)

Manufacturer Item Status

GHX

Manufacturer's item status.

Example Data:

Active/Discontinued
GHX UOM1-5 GHX

Supplier UOM; up to 5.

Example Data:

CA

GHX QOE1-5

GHX

Quantity of each related to Supplier UOM; up to 5.

Example Data:

6
GHX Description GHX

Validated and enhanced GHX description.

Example Data:

FORMULA amino acid medium-chain triglyceride SUPPLEMENTAL can powder Pediatric 30 cal/oz 14.1 oz malabsorption maldigestion short bowel syndrome eosinophilic gi disorder

GHX Noun

GHX

Validated noun describing the product.

Example Data:

FORMULA
GHX Type GHX

Validated type describing the product.

Example Data:

SUPPLEMENTAL

Manufacturer Brand Name

GHX

Validated Manufacturer's brandname describing the product.

Example Data:

Kleenex
Primary Description Data Connect Configuration

Generated description per configuration in the Data Connect Content Workbench.

Example Data:

Formula Amino Acd Medium-chain

Secondary Description

Data Connect Configuration

Generated description per configuration in the Data Connect Content Workbench.

Example Data:

Formula Amino Acd Medium-chain
Tertiary Description Data Connect Configuration

Generated description per configuration in the Data Connect Content Workbench.

Example Data:

Formula Amino Acd Medium-chain
UNSPSC Version Data Connect Configuration

UNSPSC version per configuration in the Data Connect Content Workbench.

Example Data:

250901

UNSPSC Code

GHX

UNSPSC commodity code for category.

Example Data:

42231804
UNSPSC Commodity GHX

Commodity category description.

Example Data:

Pediatric disease specific supplemental formulas or bars or puddings

UNSPSC Class

GHX

Class category description.

Example Data:

Formulas and products for nutritional support
UNSPSC Family GHX

Family category description.

Example Data:

Clinical nutrition

UNSPSC Segment

GHX

Segment category description.

Example Data:

Medical Equipment and Accessories and Supplies
Lumere Product Name GHX

A single product or product line that shares common key FDA-related product facts, peer-reviewed literature, or adverse event information.

Example Data:

Masters HP Series Mitral Valve

Lumere Product Group

GHX

A collection of functionally similar products that are used to achieve the same clinical or functional outcome.

Example Data:

Mechanical prosthetic mitral valves
Lumere Category GHX

A collection of device groups that fall under the same clinical umbrellas and are typically source together.

Example Data:

Valve replacement and repair

HCPCS Code*

GHX

HCPCS code defined by CMS; assigned by GHX.

Example Data:

C1876
HCPCS Status* GHX

Status describing if product is billable, non billable or not coded; assigned by GHX.

Example Data:

Coded/No Code/Non Billable

HCPCS Description*

GHX

HCPCS code description defined by CMS.

Example Data:

Stent, noncoated/noncovered, with delivery system
Revenue Code* GHX

Revenue codes are typically based on the Healthcare Common Procedure Coding System (HCPCS) Level II codes, which are alphanumeric codes used for reporting supplies, services, and equipment; assigned by GHX

Example Data:

0278

Primary Issuing Agency

GUDID/GDSN

The source of the device identifier.

Example Data:

GS1/HBICC
Primary DI GUDID/GDSN

Primary Device Identifier (GTIN or HIBCC); An identifier that is the primary lookup for a medical device. The primary DI will be located on the label of the base package (the lowest package level if a medical device containing a full UDI). For medical devices without packaging, the primary DI number and full UDI may be on the device itself. Not always populated.

Example Data:

8717648175633

Primary DI UOM

GHX

GHX uses relevant sources to assign a UOM for Primary DI. This is not provided by GUDID.

Example Data:

BX
Primary Device Count GUDID/GDSN

Number of medical devices in the base package (the lowest package level of a medical device containing a full UDI).

Example Data:

10

Unit of Use DI

GUDID/GDSN

Unit of Use Device Identifier Number. Does not appear on device label. Can be used by hospital staff and materials management to associate the use of a single device with a patient when the UDI is found on a higher level of packaging (e.g, on a box of 100 blood collection tubes). Not always populated.

Example Data:

8717648175632
Unit Of Use UOM GUDID/GDSN

GHX uses relevant sources to assign a UOM for Unit of Use DI. This is not provided by GUDID.

Example Data:

EA

Secondary Issuing Agency

GUDID/GDSN

The source of the device identifier

Example Data:

GS1/HIBCC
Secondary DI GUDID/GDSN The optional device identifier that may be an alternate look up for the Primary DI. A secondary DI comes from a different issuing agency than the Primary DI. Rarely populated.

Package DI 1 thru 5

GUDID/GDSN

The device identifier (DI) assigned to a device package (a fixed quantity of a particular version or model of a device). Different levels of packaging have different DIs. Not always populated.
Package DI 1 thru 5 Contains DI GUDID/GDSN The Primary DI for the base package or the Package DI for any lower-level package configuration contained within a given package configuration.

Package DI 1 thru 5 UOM

GHX

Text to describe the outer packaging of the product and enables users to understand higher level packaging configurations. (Box, Case, Carton) GHX uses relevant sources to assign unit of measure. UOM in this field is only applicable when a package Device Identifier is present.
Package DI 1 thru 5 QOE GHX The number of packages with the same Primary DI or Package DI within a given packaging configuration. GHX uses relevant sources to assign quantity of each. QOE in this field is only applicable when a package Device Identifier is present.

Contains Latex*

GHX

Validated indicator; answers the question "contains latex?" Y/N
Is Sterile* GHX Whether the device was originally packaged to be free from viable microorganisms. Validated indicator; answers the question "is Sterile?" Y/N

Requires Sterilization

GUDID/GDSN

Whether the device requires sterilization before use on a patient. Answers the question "Requires Sterilization?" Y/N
Sterilization Method GUDID/GDSN

Sterilization Method(s) recommended prior to use.

Example Data:

Moist heat or steam sterilization

Is Implantable*

GHX

Validated indicator; answers the question "is implantable?" Y/N
Was Reprocessed* GHX Answers the question "was reprocessed?" Y/N

Is For Single Use

GHX

Whether the device is intended for one use or on a single patient during a single procedure. Validated indicator; answers the question "Is for Single use?"Y/N
Contains Human Tissue GUDID Whether the product contains or consists of human cells or tissues that are intended for implantation, transplantation, infusion, or transfer into a human recipient. Pass thru information from GS1; answers the question "contains human tissue?" Y/N

Is Hazardous Material

GHX

Validated indicator; answers the question "contains hazardous material?" Y/N
MRI Safety Code GUDID/GDSN

What information the labeling contains about whether a device is compatible with magnetic resonance imaging (MRI) procedures. Indicates the MRI Safety Information, if any, that is present in the device labeling.

Example Data:

MR Unsafe/Labeling does not contain MRI Safety Information

Image URL

GHX

URL that renders an image of the product.