[Gnumed-devel] psql complains when trying to insert into ref.billables

[Busser, Jim]

INSERT INTO ref.billable
( code,
  term,
  fk_data_source,
  comment,
  amount,
  currency
)
  SELECT fee_item, description, 12, '', CAST(amount as numeric)/100, 'u0024' 
FROM staging.fee_teleplan
;


yields:

ERROR:  record "new" has no field "row_version"
CONTEXT:  PL/pgSQL function "ft_ins_billable" line 2 at assignment


more information:

SELECT fee_item, description, 12, '', CAST(amount as numeric)/100, 'u0024' FROM 
staging.fee_teleplan;


yields


 fee_item |                    description                     | ?column? | 
?column? |       ?column?       | ?column? 
----------+----------------------------------------------------+----------+----------+----------------------+----------
 00010    | INJECTION, INTRAMUSCULAR                           |       12 |     
     |  10.2000000000000000 | u0024
 00011    | INJECTION, INTRAVENOUS                             |       12 |     
     |  12.0400000000000000 | u0024
 00012    | INJECTION, VENEPUNCTURE                            |       12 |     
     |   5.6200000000000000 | u0024
 00013    | INJECTION, INTRA-ARTERIAL                          |       12 |     
     |  15.1000000000000000 | u0024
 00014    | INJECTION, INTRA-ARTICULAR - HIP                   |       12 |     
     |  24.0500000000000000 | u0024
 00015    | INJECTION, INTRA-ARTICULAR - ALL OTHER JOINTS      |       12 |     
     |  16.0000000000000000 | u0024
 00016    | INJECTION, INTRATHECAL                             |       12 |     
     |  32.1700000000000000 | u0024
 00017    | INSERTION OF CENTRAL VENOUS PRESSURE CATHETER      |       12 |     
     |  23.3200000000000000 | u0024
 00034    | INJECTION SUBCUTANEOUS                             |       12 |     
     |  10.2000000000000000 | u0024
 00043    | ANTICOAGULATION THERAPY                            |       12 |     
     |   6.5800000000000000 | u0024
 00081    | EMERGENCY BEDSIDE CARE                             |       12 |     
     |  99.6100000000000000 | u0024
 00083    | CRISIS INTERVENTION                                |       12 |     
     |  99.6100000000000000 | u0024
 00084    | ACCOMPANYING PATIENTS                              |       12 |     
     | 209.3500000000000000 | u0024
 00305    | VISIT, EMERGENCY, INT. MED.                        |       12 |     
     | 112.2400000000000000 | u0024
 00306    | DIRECTIVE CARE, INTERNAL MEDICINE                  |       12 |     
     |  46.0900000000000000 | u0024
 00307    | VISIT, OFFICE, INT. MED.                           |       12 |     
     |  48.1400000000000000 | u0024
 00308    | VISIT, HOSPITAL, INT. MED.                         |       12 |     
     |  28.3700000000000000 | u0024
 00309    | VISIT, HOME, INT. MED.                             |       12 |     
     |  50.6500000000000000 | u0024
 00310    | CONSULTATION, INT. MED.                            |       12 |     
     | 161.0900000000000000 | u0024
 00311    | GIM - COMPLEX CONSULTATION - 3 MEDICAL CONDITIONS  |       12 |     
     | 243.0700000000000000 | u0024
 00312    | CONSULTATION, LIMITED, INT. MED.                   |       12 |     
     |  79.4100000000000000 | u0024
 00313    | COUNSELLING GROUP - INTERNAL MED - 1ST FULL HOUR   |       12 |     
     | 110.7100000000000000 | u0024
 00314    | INTERNAL MEDICINE PROLONGED VISIT FOR COUNSELLING  |       12 |     
     |  54.0600000000000000 | u0024
 00315    | COUNSELLING GROUP -INTERNAL MED -2ND HR PER 1/2 HR |       12 |     
     |  55.3200000000000000 | u0024
 00319    | CENTRAL CATHETER INSERTION - TPN                   |       12 |     
     |  55.4600000000000000 | u0024
 00755    | ARTERY PUNCTURE                                    |       12 |     
     |   6.2500000000000000 | u0024
 00757    | ASPIRATION OTHER JOINTS                            |       12 |     
     |  11.4200000000000000 | u0024
 00759    | PARACENTESIS (THORACIC)OR TRANSTRACHIAL ASPIRATION |       12 |     
     |  21.6700000000000000 | u0024
 00760    | PARACENTESIS ABDOMINAL                             |       12 |     
     |  24.6400000000000000 | u0024
 00761    | BURSA OR CYST - PUNCTURE PROCEDURE                 |       12 |     
     |  13.9200000000000000 | u0024
 00811    | JOINT INJECTION, ASPIRATION OR ARTHOGRAM           |       12 |     
     |  50.7700000000000000 | u0024
 32270    | TELEHEALTH CONSULTATION - INTERNAL MEDICINE        |       12 |     
     | 161.0900000000000000 | u0024
 32271    | TELEHEALTH COMPLEX CONSULTATION-INTERNAL MEDICINE  |       12 |     
     | 243.0700000000000000 | u0024
 32272    | TELEHEALTH REPEAT OR LIMITED CONSULT-INTERNAL MED  |       12 |     
     |  79.4100000000000000 | u0024
 32276    | TELEHEALTH DIRECTIVE CARE - INTERNAL MEDICINE      |       12 |     
     |  46.0900000000000000 | u0024
 32277    | TELEHEALTH SUBSEQUENT OFFICE VISIT - INTERNAL MED  |       12 |     
     |  48.1400000000000000 | u0024
 32278    | TELEHEALTH SUBSEQUENT HOSPITAL VISIT-INTERNAL MED  |       12 |     
     |  28.3700000000000000 | u0024
 32307    | SUB F/U OFF VISIT, COMPLEX PAT-3 MEDICAL COND GIM  |       12 |     
     | 120.0000000000000000 | u0024
 32308    | SUB HOSP VISIT, COMPLEX PAT-3 MEDICAL COND GIM     |       12 |     
     |  83.0000000000000000 | u0024
 32312    | COMPLEX CONSULTATION - 2 MEDICAL CONDITIONS GIM    |       12 |     
     | 195.0000000000000000 | u0024
 32317    | SUB F/U OFF VISIT, COMPLEX PAT-2 MEDICAL COND GIM  |       12 |     
     |  70.0000000000000000 | u0024
 32318    | SUB HOSP VISIT, COMPLEX PATIENT-2 MEDICAL COND GIM |       12 |     
     |  50.0000000000000000 | u0024


-- Jim