OTHER Feeder

The OTHER Feeder is an inflexible option to add OTHER utilisation.

Please do not use the OTHEREG (OTHER episode generating) extract without significant liaison with CSH support.

To set this up at your site, in addtion, CSH must setup the Extract and Site Module mappings

While there is great flexibility in what you can add to Talons using this feeder, there is little flexibility in how it should look.

Generally data is collected in one or more simple excel files saved as a CSV with every column having a strictly defined format.

The filename must be <Company TLA> <XX>OTHER<[cc]yymm.CSV

where <XX> is a two letter code for the type of data where multiple files are used

[cc]yymm is calendar period (century optional)

The Data muse be in a CSV file format with the following column structure

SITE,SDATE,STIME,DEPT,URNO,PROD,QTY,RDOC,CHRG or SITE,SDATE,STIME,DEPT,URNO,PROD,QTY,RDOC

The first line must contain this header verbatim, this should be the header row (row one starting at Column A) in the excel Spreadsheet used to manage the data
UPPERCASE is preferred
NO EMBEDDED COMMAS IN DATA
The Key word is inflexible.

The table used (tblOtherUtil) has the following structure

[UR] [varchar](20) NOT NULL,

[Service_Date] [datetime] NULL,

[Feeder_Code] [varchar](10) NULL,

[Product_Code] [varchar](30) NULL,

[Quantity_Num] [decimal](24, 4) NULL,

[Charge_Money] [money] NULL,

[Dept_Code] [varchar](20) NULL,

[Mapped_dept_code] [varchar](20) NULL,

[Bill_Code] [varchar](10) NULL,

[RequestingDoctor_Code] [varchar](10) NULL,

[Consultant_Code] [varchar](10) NULL,

however the input data must match the following,

HEADER	DATA TYPE	Excel FORMAT	Access Format	Max length	USAGE
SITE	ALPHANUMERIC	text	text	5	Used to differentiate the CAMPUS, generally use the Campus_TLA of the source of data
SDATE	DATE	DD-MM-YYYY	date/time short date	10	date is DD-MM-CCYY
STIME	TIME	HH:mm[:ss]	date/time Long time	8	time is HH:mm[:ss] where seconds are optional Use 00:00:00 if unknown
DEPT	ALPHANUMERIC	text	text	10	this should be maximum of 10 characters for system reasons and no spaces
URNO	ALPHANUMERIC	text	text	10	max length of 10
PROD	ALPHANUMERIC	text	text	15	product Code, 15 characters Max - the T2 Limit of course
QTY	NUMERIC	Decimal or integer	number single	4 decimals	numeric decimal (max 4 places) or integer, no thousands separator
RDOC	ALPHANUMERIC	text	text	10	Requesting Doctor Code Maximum 10 characters
Charge	NUMERIC	Decimal or integer	number single	2 decimals	optional, a numeric value, no $ please, no thousands separator USE 0 IF NOT KNOWN

Pitfalls

if one does not define URNO as a text column it may convert to Scientific notation.. or lose leading zeros, if doing data entry in Excel, ensure text format and or use excel escape character for left justified text, a single quote prefix
Dates must be just so
times must be just so
All columns must be formatted
The Excel format type General is not a format allowed to be used, date, time, text, number are allowed