Format for Importing the.CSV Files
Overview
This appendix explains about the format of.csv files that can be imported for the various features of the CPC solution.
The topics in this appendix includes:
File Format for Locations
The location details can be imported into Admin View using a.csv file that has been provided to you. The sample import location csv file format details are provided in the following table:
Table A-1 Import Location File Format Details (location-iec-mapping-export.csv file)
|
|
Facility Id |
Id for the facility. |
Facility Description |
Description for the facility. |
Building Id |
Id for the building. |
Building Description |
Description for the building. |
Floor Id |
Id for the hospital floor. |
Floor Description |
Description for the hospital floor. |
Department Id |
Id for the hospital department. |
Department Description |
Description for the hospital department. |
Room Id |
Id for the hospital room. |
Room Description |
Description for the hospital room. |
Bed Id |
Id for the hospital bed. |
Bed Description |
Description for the hospital bed. |
Extension Id |
Extension Id |
Extension Description |
Description for the extension. |
RB Location Id |
Location Id for RB. |
RTLS Location Id |
Location Id for RTLS. |
Location Type |
Location type. For example, PATIENT_ROOM |
Device Serial Number |
Serial Number of the IEC device. |
Directory Number |
Directory number. |
File Format for Relaxation Videos
The video metadata is imported into Admin View using a.csv file that has been provided to you. The sample relaxation video csv file format details are provided in the following table:
Table A-2 Relaxation Video File Format Details (HealingHealth_Sample.csv file)
|
|
File Name |
The video file name that is stored in Apache. |
Common Key |
Name of the relaxation video which appears in Nurse Dashboard and Admin UI. |
Language |
Language of the video. For example, English. |
Title |
Title of the video. For example, Shoulder (AC) Arthritis. |
Gender |
Gender of the patient who can watch the video. |
Min Age |
Minimum age of the patient to watch the video. |
Max Age |
Maximum age of the patient to watch the video. |
Condition |
Condition of the patient. For example, general. |
Description |
Description of the video. For example, Orthopedics, Primary Care, Rheumatology, Senior Health. |
File Format for Education Videos
The video metadata is imported into Admin View using a.csv file that has been provided to you. The sample education video.csv file format details are provided in the following table:
Table A-3 Education Video File Format Details (Education.csv file)
|
|
SKU |
A product and service identification code. |
Title |
Title of the video. For example, Shoulder (AC) Arthritis. |
Native Language Title |
Name with respect to the local language of the video. For example, Spanish and English. |
LangName |
Language. For example, English or Spanish. |
Min Age |
Minimum age of the patient to watch the video. |
Max Age |
Maximum age of the patient to watch the video. |
Age Groups |
Age group of the patient to watch the video. For example, adult, senior, and so on. |
Blurb |
A short description of the video. For example, Presents an overview of the condition, including clear illustrations of shoulder anatomy and mechanics. Patient interview enhances presentation. -Causes and symptoms -Associated injuries -Testing and diagnosis -Treatment options -Recovery and self care. |
First Paragraph |
Introduction paragraph of the video. |
Body Parts |
Main content for the video. |
Duration |
Duration of the video. |
Gender |
Gender of the patient who can watch the video. |
Keywords |
Key words of the video which are used in the Video App for searching specific videos to be listed from the configured Apache server. For example, osteoarthritis, acromioclavicular, cartilage, AC joint, shoulder, arthritis. |
New or Updated |
Indicates whether it is a new video or the updated one. |
Released Or Updated Year |
The year of the video release or update. |
Specialities |
Video catering into the specialty such as, Orthopedics, Primary Care, Rheumatology, Senior Health. |
CPT |
Current Procedural Terminology (CPT) code. |
HCPCS |
The Healthcare Common Procedure Coding System (HCPCS). |
ICD9 |
Standard list of six-character alphanumeric codes to describe diagnoses. |
ICD10CM |
Standard list of six-character alphanumeric codes to describe diagnoses. |
ICD10PCS |
Medical classification used for procedural codes that track various health interventions taken by medical professionals. |
LOINC |
Logical Observation Identifiers Names and Codes (LOINC) is a database and universal standard for identifying medical laboratory observations. |
MeSH |
The National Library of Medicines. |
NDCList |
Identifies the labeler, product, and trade package size. |
RxNorm |
A catalog of the standard names given to clinical drugs and drug delivery devices |
SNOMED |
A standardized, multilingual vocabulary of clinical terminology. |
File Format for Channel Subscription
The channel subscription details can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-4 Channel Subscription File Format Details (channelguide.csv File)
|
|
Channel Guide Name |
Name of the channel guide. Currently, we support only one default channel guide, PME_CHANNEL_GUIDE. |
Zip Code |
Zip Code |
City |
Name of the City |
Provider Id |
Service Provider ID. |
Provider Name |
Service provider name. |
Type of Service |
Type of service. Currently, we support only one default type of service, Satellite. |
Provider Channel Id |
Channel ID of the provider |
Channel Number |
Channel number |
Channel Name |
Name of the channel |
Channel Full Name |
Full name of the channel |
Logo Path |
Currently the following log paths are supported:
- Custom channel logo path URL = nuxeo image title
- Service provider logo path URL
|
UDP Stream |
Streaming URL |
Age |
Age category |
Locale |
Language |
Departments |
Comma separated departments. |
File Format for Custom Channel Program Airings
The custom channel program airings can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-5 Custom Channel Program Airings File Format Details (ChannelScheduled-mapping-import.csv File)
|
|
Provider Id |
Service Provider ID. |
Channel Number |
Channel Number from the service provider. |
Program Id |
ID of the program. |
Program Title |
Title of the program. |
Program Duration |
Duration of the program. |
Program Airing Time |
Telecast time of the program. |
File Format for Custom Channel Program Details
The custom channel program details can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-6 Custom Channel Program Details File Format (ProgramDetails.csv File)
|
|
Provider Id |
Service Provider ID. |
Program Id |
ID of the program. |
Program Title |
Title of the program. |
Description |
Description of the program. |
Image |
Program Image. |
File Format for Food Menu
The food menu details can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-7 Food Menu File Format Details (FoodMenu_enUS.csv File)
|
|
Id |
This is the Id which is getting called from CPC CMS. |
Service |
By default, the service is displayed as FoodMenu. |
Module |
By default, the module is displayed as FoodMenu. |
ResourceId |
Displays to indicate whether the menu is for dinner, breakfast, and so on. |
Locale |
Displays en_US to indicate that the food menu displays in English. |
ResouceText |
Displays to indicate whether the menu is for dinner, breakfast, and so on. |
File Format for Messages
The messages can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-8 Messages File Format Details (predefinedmessages_enUS.csv File)
|
|
RECORD_NUMBER |
Serial number of the message. |
PREDEFINED_MESSAGEID |
This is the predefined message ID. When you add a new message, message ID gets generated automatically. |
PREDEFINED_MESSAGETEXT |
This is the predefined message text which will be displayed for the Patient View. |
UNITID |
This is the Department ID. |
AGE |
Age of the patient who can view the predefined message. |
GENDER |
Gender of the patient who can view the predefined message. |
File Format for FAQs
The FAQs can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-9 FAQs File Format Details (faqs_enUS.csv File)
|
|
RECORD_NUMBER |
Serial number of the FAQ. |
QUESTIONID |
ID of the FAQ. |
QUESTIONTEXT |
Question text. |
ANSWER |
Answer text for the question. |
UNITID |
Department ID. |
AGE |
Age of the patient who can view the FAQ. |
GENDER |
Gender of the patient who can view the FAQ. |
File Format for Requests
The requests can be imported into Admin View using a.csv file that has been provided to you. The sample.csv file format details are provided in the following table:
Table A-10 Requests File Format Details (frequests_enUS.csv File)
|
|
RECORD_NUMBER |
Serial number of the FAQ. |
TASKID |
ID for the request. |
TASK_DESCRIPTION |
Description for the task. |
ICON_URL |
URL for the icon. |
UNITID |
Department ID. |
AGE |
Age of the patient who can raise the request. |
GENDER |
Gender of the patient who can raise the request. |