OMB/OWB Code for Loading Satellites

Yes, it’s finally here!  I’ve got a generator that builds loading code for Satellites.  The only catch is that the Oracle Warehouse Builder: DEDUPLICATOR operator doesn’t like CLOB/LOB/BIN/IMAGE columns, so those have to be processed separately.  I’ll be generating separate loading code for those in the near future.  Keep in mind that you have to VALIDATE the FILTER condition, and the JOINER condition manually because of the CREATE statements, in order to get a proper deployment.  I am going to switch the code generated over to having OMBALTER statements (even though it’s much slower, it will work as well).   I tried issuing OMBVALIDATE MAPPING – but that validated the map successfully, but did *NOT* validate the conditions within the Joiner and Filter.

Source Table Definition:

[code]

CREATE TABLE "STAGE"."AHLTAT_DIAGNOSIS"
(
   "DOC_REF"             NUMBER   CONSTRAINT  "SYS_C0011445" NOT NULL ,
   "CREATETIME"          DATE  NULL ,
   "CREATEUSERNCID"      NUMBER(20)  NULL ,
   "MODIFYUSERNCID"      NUMBER(20)  NULL ,
   "MODIFYTIME"          DATE  NULL ,
   "PRIORITY"            VARCHAR2(50 BYTE)  NULL ,
   "DIAGNOSESCOMMENT"    CLOB  NULL ,
   "EXTENDEDICD9"        VARCHAR2(50 BYTE)  NULL ,
   "SENSITIVITY"         VARCHAR2(50 BYTE)  NULL ,
   "UPDATEDON"           DATE  NULL ,
   "UPDATEDBY"           NUMBER(20)  NULL ,
   "TMIP_STATUS"         NUMBER  NULL ,
   "UPDATEFLAG"          VARCHAR2(1 BYTE)  NULL ,
   "CDR_DATAID"          NUMBER(20)  NULL ,
   "CREATEDON"           DATE  NULL ,
   "CREATEDBY"           NUMBER(20)  NULL ,
   "PREFIX"              VARCHAR2(5 BYTE)  NULL ,
   "CLINICIANNCID"       NUMBER(20)  NULL ,
   "ENCOUNTERNUMBER"     NUMBER(20)  NULL ,
   "UNIT_NUMBER"         NUMBER(10)  NULL ,
   "MEDCINID"            NUMBER(20)  NULL ,
   "DATAID"              NUMBER  NULL ,
   "DIAGNOSISNCID"       NUMBER(20)  NULL ,
   "FACILITYNCID"        NUMBER(20)  NULL ,
   "BILLINGCODENCID"     NUMBER(20)  NULL ,
   "ICD9NCID"            NUMBER  NULL ,
   "SOURCENCID"          NUMBER(20)  NULL ,
   "NEWFOLLOWUP"         VARCHAR2(50 BYTE)  NULL ,
   "POINTOFCAREFACILITYNCID"  NUMBER(20)  NULL ,
   "STATUSNCID"          NUMBER(20)  NULL ,
   "CHRONICITYNCID"      NUMBER(20)  NULL ,
   "NOTEDDATE"           DATE  NULL ,
   "ONSETDATE"           DATE  NULL ,
   "RS_FORCENULL"        VARCHAR2(15 BYTE)  NULL
);

[/code]

Target Table Definition:

[code]

create table VAULT.SAT_AHLTAT_DIAGNOSIS (
   DIAGNOSIS_SQN NUMBER (12) NOT NULL,
   DIAGNOSIS_LDTS DATE NOT NULL,
   DIAGNOSIS_LEDTS DATE,
   DIAGNOSIS_RSRC VARCHAR2 (20) NOT NULL,
   DOC_REF NUMBER,
   DIAGNOSISNCID NUMBER (20) NOT NULL,
   ENCOUNTERNUMBER NUMBER (20),
   UNIT_NUMBER NUMBER (10),
   POINTOFCAREFACILITYNCID NUMBER (20),
   STATUSNCID NUMBER (20),
   NOTEDDATE DATE,
   ONSETDATE DATE,
   CHRONICITYNCID NUMBER (20),
   SOURCENCID NUMBER (20),
   ICD9NCID NUMBER (20),
   NEWFOLLOWUP VARCHAR2 (50 BYTE),
   BILLINGCODENCID NUMBER (20),
   SENSITIVITY VARCHAR2 (50 BYTE),
   PRIORITY VARCHAR2 (50 BYTE),
   EXTENDEDICD9 VARCHAR2 (50 BYTE),
   DIAGNOSESCOMMENT VARCHAR2 (4000 BYTE),
   CREATEUSERNCID NUMBER (20),
   TMIP_STATUS NUMBER,
   RS_FORCENULL VARCHAR2 (15 BYTE),
   DIAGNOSIS_LDTS__3110 DATE,
   CREATETIME DATE,
   MODIFYUSERNCID NUMBER (20),
   MODIFYTIME DATE,
   UPDATEDON DATE,
   UPDATEDBY NUMBER (20),
   UPDATEFLAG VARCHAR2 (1 BYTE),
   CDR_DATAID NUMBER (20),
   CREATEDON DATE,
   CREATEDBY NUMBER (20),
   PREFIX VARCHAR2 (5 BYTE)
) ;

[code]

Hub Table Definition: (parent to satellite)

[code]

create table VAULT.HUB_DIAGNOSIS (
   DIAGNOSIS_SQN NUMBER (12) NOT NULL,
   DIAGNOSIS_LDTS DATE NOT NULL,
   DIAGNOSIS_RSRC VARCHAR2 (20) NOT NULL,
   DIAGNOSIS_DATAID NUMBER NOT NULL
) ;

[/code]

OWB Satellite Load Mapping:

[code]

OMBCREATE MAPPING ‘M_SAT_AHLTAT_AT’
 SET PROPERTIES (DESCRIPTION,BUSINESS_NAME)
 VALUES (‘Dan Linstedt: RapidACE Generated Mapping, Load SAT_AHLTAT_DIAGNOSIS from AHLTAT_DIAGNOSIS’,’M_SAT_AHLTAT_AT’)
 ADD TABLE OPERATOR ‘AHLTAT_DIAGNOSIS’
 BOUND TO TABLE ‘../STAGE/AHLTAT_DIAGNOSIS’
 ADD TABLE OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
 BOUND TO TABLE ‘SAT_AHLTAT_DIAGNOSIS’
 ADD DEDUPLICATOR OPERATOR ‘DD_UNIQUE’
  ADD ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,1)
  ADD ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘PREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,5)
  ADD ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,15)
 ADD EXPRESSION OPERATOR ‘EXP_CHG_DATATYPE’
  ADD ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,12,0,’INGRP1.DIAGNOSIS_SQN’)
  ADD ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,38,0,’INGRP1.DOC_REF’)
  ADD ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.DIAGNOSISNCID’)
  ADD ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.CREATETIME’)
  ADD ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.CREATEUSERNCID’)
  ADD ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.MODIFYUSERNCID’)
  ADD ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.MODIFYTIME’)
  ADD ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,50,’INGRP1.PRIORITY’)
  ADD ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,50,’INGRP1.EXTENDEDICD9’)
  ADD ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,50,’INGRP1.SENSITIVITY’)
  ADD ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.UPDATEDON’)
  ADD ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.UPDATEDBY’)
  ADD ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,38,0,’INGRP1.TMIP_STATUS’)
  ADD ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,1)
  ADD ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,1,’INGRP1.UPDATEFLAG’)
  ADD ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.CDR_DATAID’)
  ADD ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.CREATEDON’)
  ADD ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.CREATEDBY’)
  ADD ATTRIBUTE ‘PREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,5)
  ADD ATTRIBUTE ‘OPREFIX’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,5,’INGRP1.PREFIX’)
  ADD ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.BILLINGCODENCID’)
  ADD ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.ICD9NCID’)
  ADD ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.SOURCENCID’)
  ADD ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,50,’INGRP1.NEWFOLLOWUP’)
  ADD ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.STATUSNCID’)
  ADD ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE,EXPRESSION) VALUES (‘NUMBER’,20,0,’INGRP1.CHRONICITYNCID’)
  ADD ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.NOTEDDATE’)
  ADD ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’INGRP1.ONSETDATE’)
  ADD ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,15)
  ADD ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2′,15,’INGRP1.RS_FORCENULL’)
 ADD LOOKUP OPERATOR ‘LKP_TARGET_KEY’
   SET PROPERTIES (LOOKUP_CONDITION)
   VALUES (‘INGRP1.ODIAGNOSIS_SQN = OUTGRP1.DIAGNOSIS_SQN and OUTGRP1.DIAGNOSIS_LEDTS IS NULL and (DECODE(INGRP1.ODOC_REF,OUTGRP1.DOC_REF,0,1) = 1 or DECODE(INGRP1.ODIAGNOSISNCID,OUTGRP1.DIAGNOSISNCID,0,1) = 1 or DECODE(INGRP1.OCREATETIME,OUTGRP1.CREATETIME,0,1) = 1 or DECODE(INGRP1.OCREATEUSERNCID,OUTGRP1.CREATEUSERNCID,0,1) = 1 or DECODE(INGRP1.OMODIFYUSERNCID,OUTGRP1.MODIFYUSERNCID,0,1) = 1 or DECODE(INGRP1.OMODIFYTIME,OUTGRP1.MODIFYTIME,0,1) = 1 or DECODE(INGRP1.OPRIORITY,OUTGRP1.PRIORITY,0,1) = 1 or DECODE(INGRP1.OEXTENDEDICD9,OUTGRP1.EXTENDEDICD9,0,1) = 1 or DECODE(INGRP1.OSENSITIVITY,OUTGRP1.SENSITIVITY,0,1) = 1 or DECODE(INGRP1.OUPDATEDON,OUTGRP1.UPDATEDON,0,1) = 1 or DECODE(INGRP1.OUPDATEDBY,OUTGRP1.UPDATEDBY,0,1) = 1 or DECODE(INGRP1.OTMIP_STATUS,OUTGRP1.TMIP_STATUS,0,1) = 1 or DECODE(INGRP1.OUPDATEFLAG,OUTGRP1.UPDATEFLAG,0,1) = 1 or DECODE(INGRP1.OCDR_DATAID,OUTGRP1.CDR_DATAID,0,1) = 1 or DECODE(INGRP1.OCREATEDON,OUTGRP1.CREATEDON,0,1) = 1 or DECODE(INGRP1.OCREATEDBY,OUTGRP1.CREATEDBY,0,1) = 1 or DECODE(INGRP1.OPREFIX,OUTGRP1.PREFIX,0,1) = 1 or DECODE(INGRP1.OBILLINGCODENCID,OUTGRP1.BILLINGCODENCID,0,1) = 1 or DECODE(INGRP1.OICD9NCID,OUTGRP1.ICD9NCID,0,1) = 1 or DECODE(INGRP1.OSOURCENCID,OUTGRP1.SOURCENCID,0,1) = 1 or DECODE(INGRP1.ONEWFOLLOWUP,OUTGRP1.NEWFOLLOWUP,0,1) = 1 or DECODE(INGRP1.OSTATUSNCID,OUTGRP1.STATUSNCID,0,1) = 1 or DECODE(INGRP1.OCHRONICITYNCID,OUTGRP1.CHRONICITYNCID,0,1) = 1 or DECODE(INGRP1.ONOTEDDATE,OUTGRP1.NOTEDDATE,0,1) = 1 or DECODE(INGRP1.OONSETDATE,OUTGRP1.ONSETDATE,0,1) = 1 or DECODE(INGRP1.ORS_FORCENULL,OUTGRP1.RS_FORCENULL,0,1) = 1)’)
 BOUND TO TABLE ‘SAT_AHLTAT_DIAGNOSIS’
  ADD ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,1)
  ADD ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OPREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,5)
  ADD ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,15)
 ADD FILTER OPERATOR ‘FIL_EXISTING_RECS’
   SET PROPERTIES (FILTER_CONDITION)
   VALUES (‘INOUTGRP1.DIAGNOSIS_SQN IS NULL’)
  ADD ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,1)
  ADD ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OPREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,5)
  ADD ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,15)
 ADD CONSTANT OPERATOR ‘CNST_LDTS_RSRC’
  ADD ATTRIBUTE ‘DIAGNOSIS_LDTS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘CNST_LDTS_RSRC’
    SET PROPERTIES (DATATYPE,EXPRESSION) VALUES (‘DATE’,’SYSDATE()’)
  ADD ATTRIBUTE ‘DIAGNOSIS_RSRC’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘CNST_LDTS_RSRC’
    SET PROPERTIES (DATATYPE,LENGTH,EXPRESSION) VALUES (‘VARCHAR2’,20,'[OMBToSettableString ‘AHLTAT_DIAGNOSIS’]’)
 ADD JOINER OPERATOR ‘JNR_ALL_HUBS’
   SET PROPERTIES (JOIN_CONDITION)
   VALUES (‘INGRP1.DATAID = INGRP2.DIAGNOSIS_DATAID’)
  ADD ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INGRP2’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,12,0)
  ADD ATTRIBUTE ‘DIAGNOSIS_DATAID’ OF GROUP ‘INGRP2’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,1)
  ADD ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘PREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,5)
  ADD ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,38,0)
  ADD ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,50)
  ADD ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,PRECISION,SCALE) VALUES (‘NUMBER’,20,0)
  ADD ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE) VALUES (‘DATE’)
  ADD ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
    SET PROPERTIES (DATATYPE,LENGTH) VALUES (‘VARCHAR2’,15)
 ADD TABLE OPERATOR ‘HUB_DIAGNOSIS’
 BOUND TO TABLE ‘HUB_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
     TO ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_LDTS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘CNST_LDTS_RSRC’
     TO ATTRIBUTE ‘DIAGNOSIS_LDTS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_RSRC’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘CNST_LDTS_RSRC’
     TO ATTRIBUTE ‘DIAGNOSIS_RSRC’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘HUB_DIAGNOSIS’
     TO ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INGRP2’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘HUB_DIAGNOSIS’
     TO ATTRIBUTE ‘DIAGNOSIS_DATAID’ OF GROUP ‘INGRP2’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘DIAGNOSIS_SQN’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘DOC_REF’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ODOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘DOC_REF’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ODIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘DIAGNOSISNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATETIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CREATETIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CREATEUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘MODIFYUSERNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OMODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘MODIFYTIME’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘PRIORITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OPRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘PRIORITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OEXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘EXTENDEDICD9’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OSENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘SENSITIVITY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘UPDATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘UPDATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OTMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘TMIP_STATUS’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OUPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘UPDATEFLAG’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CDR_DATAID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CREATEDON’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CREATEDBY’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘PREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘PREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘PREFIX’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘PREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘PREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘PREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OPREFIX’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OPREFIX’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OPREFIX’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OPREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OPREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘PREFIX’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OBILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘BILLINGCODENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘ICD9NCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OSOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘SOURCENCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ONEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘NEWFOLLOWUP’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OSTATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘STATUSNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OCHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘CHRONICITYNCID’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ONOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘NOTEDDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘OONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘ONSETDATE’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
  ADD CONNECTION FROM ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘AHLTAT_DIAGNOSIS’
     TO ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
  ADD CONNECTION FROM ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘JNR_ALL_HUBS’
     TO ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
  ADD CONNECTION FROM ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘DD_UNIQUE’
     TO ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
  ADD CONNECTION FROM ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘INGRP1’ OF OPERATOR ‘LKP_TARGET_KEY’
  ADD CONNECTION FROM ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘OUTGRP1’ OF OPERATOR ‘EXP_CHG_DATATYPE’
     TO ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
  ADD CONNECTION FROM ATTRIBUTE ‘ORS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘FIL_EXISTING_RECS’
     TO ATTRIBUTE ‘RS_FORCENULL’ OF GROUP ‘INOUTGRP1’ OF OPERATOR ‘SAT_AHLTAT_DIAGNOSIS’
[/code]

Next up: generating END-DATE code for Satellites.   In order to load this piece, you’ll need the SOURCE table and TARGET Tables which I have not provided here.

Cheers,
Dan L

Tags: , , , ,

No comments yet.

Leave a Reply

*