9879. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 6/20/2018 10:05:58 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

9879.1 Files compared

# Location File Last Modified
1 CCRS.zip\CCRS\ccra-2.5.0.zip\ccra-2.5.0-1582193c50aced3fa6ab803711ab119c7d5c9158\artifacts\Build_2\Sprint_4\docs CCRA Data Transformation Mapping_20180316.xlsx Mon Apr 9 15:28:51 2018 UTC
2 CCRS.zip\CCRS\ccra-2.5.0.zip\ccra-2.5.0-1582193c50aced3fa6ab803711ab119c7d5c9158\artifacts\Build_2\Sprint_4\docs CCRA Data Transformation Mapping_20180316.xlsx Fri Jun 15 15:06:12 2018 UTC

9879.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 1 212
Changed 0 0
Inserted 0 0
Removed 0 0

9879.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

9879.4 Active regular expressions

No regular expressions were active.

9879.5 Comparison detail

  1   SHEET: CCR A Transfor mation Map pings
  2   Multiple O bjects,Dat a Descript ion,CCRA O bject Refe rence,CCRS  Object Re ference,DA S Object R eference,H SRM Object  Reference ,ES (Eligi bility Sys tem) Objec t Referenc e,
  3   Patient IC N,CCRA.Ref erral.Pati ent.ICN,CC RS.Referra l.Patient. ICN,DAS.CC NContractR eferral.Ve teran.ICN, User.PAWai tingList.W LPAPMIDR.P APMIRowId. PAPERID,
  4   Patient's  Last Name, CCRA.Refer ral.Patien t.LastName ,CCRS.Refe rral.Patie nt.LastNam e,DAS.CCNC ontractRef erral.Vete ran.LName, User.PAWai tingList.W LPAPMIDR.P APMIRowId. PAPERSurNa me,
  5   Patient's  First Name ,CCRA.Refe rral.Patie nt.FirstNa me,CCRS.Re ferral.Pat ient.First Name,DAS.C CNContract Referral.V eteran.FNa me,User.PA WaitingLis t.WLPAPMID R.PAPMIRow Id.PAPERNa me,
  6   Patient's  Middle Nam e,CCRA.Ref erral.Pati ent.MName, DAS.CCNCon tractRefer ral.Vetera n.Mname,Us er.PAWaiti ngList.WLP APMIDR.PAP MIRowId.PA PERName2,
  7   Patient's  Gender,CCR A.Referral .Patient.G ender,CCRS .Referral. Patient.Ge nder,User. PAWaitingL ist.WLPAPM IDR.PAPMIR owId.PAPER BirthGende rDR.CTSEXG ender,
  8   Patient's  Date of Bi rth,CCRA.R eferral.Pa tient.DOB, CCRS.Refer ral.Patien t.DOB,DAS. CCNContrac tReferral. Veteran.DO B,User.PAW aitingList .WLPAPMIDR .PAPMIRowI d.PAPERDob ,
  9   Patient's  SSN,CCRA.R eferral.Pa tient.SSN, CCRS.Refer ral.Patien t.SSN,DAS. CCNContrac tReferral. Veteran.SS N,WLPAPMID R.PAPMIRow Id.PAPERID ,
  10   Patient's  Home Addre ss - Stree t ,CCRA.Re ferral.Pat ient.HomeA ddress.Add resss1,DAS .CCNContra ctReferral .Veteran.H omeAddress .Address1,
  11   Patient's  Home Addre ss - Stree t 2,CCRA.R eferral.Pa tient.Home Address.Ad dresss2,DA S.CCNContr actReferra l.Veteran. HomeAddres s.Address2 ,
  12   Patient's  Home Addre ss - City, CCRA.Refer ral.Patien t.HomeAddr ess.City,D AS.CCNCont ractReferr al.Veteran .HomeAddre ss.City,
  13   Patient's  Home Addre ss - State ,CCRA.Refe rral.Patie nt.HomeAdd ress.State ,DAS.CCNCo ntractRefe rral.Veter an.HomeAdd ress.State ,
  14   Patient's  Home Addre ss - ZipCo de,CCRA.Re ferral.Pat ient.HomeA ddress.Zip Code,DAS.C CNContract Referral.V eteran.Hom eAddress.Z ipCode,
  15   Patient's  Home Addre ss - Count ry,CCRA.Re ferral.Pat ient.HomeA ddress.Cou ntry,DAS.C CNContract Referral.V eteran.Hom eAddress.C ountry,
  16   Current di agnosis of  the patie nt's condi tion,CCRA. Referral.D iagnosis,C CRS.Referr al.Diagnos is,User.PA WaitingLis t.WLICDDR. MRCIDDesc,
  17   Referral N umber - un ique, syst em (HSRM)  generated  number,CCR A.Referral .ReferralN umber,CCRS .Referral. ReferralNu mber,DAS.C CNContract Referral.R eferralId,  ,
  18   Consult ID  (from Vis tA),CCRA.R eferral.Co nsultID,CC RS.Referra l.ConsultI D,User.PAW aitingList .WLReferra lUniqueId,
  19   The date w hen the re ferral was  raised,CC RA.Referra l.Referral Date,CCRS. Referral.R eferralDat e,User.PAW ailtingLis t.WLDateRe fLetter,
  20   The date w hen this r eferral ex pires.,CCR A.Referral .ReferralE xpirationD ate,CCRS.R eferral.Re ferralExpi rationDate ,DAS.CCNCo ntractRefe rral.Refer ralToDate, User.PAWai tlingList. WLRefExpir yDate,
  21   The validi ty period  of this re ferral,CCR A.Referral .Period,CC RS.Referra l.Period,U ser.PAWail tingList.W LReferralP eriodDr.RE FPERDesc,
  22   Whether th e service  requested  is inpatie nt or outp atient,CCR A.Referral .ReferralC ategory,CC RS.Referra l.Referral Category,U ser.PAWait lingList.W LEpisSubTy peDR.SUBTD esc,
  23   The reason  the servi ce has bee n requeste d,CCRA.Ref erral.Medi calNecessi ty,CCRS.Re ferral.Med icalNecess ity,User.P AWailtingL ist.WLPres entComplai nt,
  24   How and Wh ere the re ferral was  entered i nto Referr al Manager ,CCRA.Refe rral.Sourc eOfReferra l,CCRS.Ref erral.Sour ceOfReferr al,User.PA WaitlingLi st.WLSourc eOfAdditDR .SADDDesc,
  25   The status  of the re ferral,CCC RA.Referra l.Referral Status,CCC RS.Referra l.Referral Status,Use r.PAWaitin gList.WLWa itListStat usDR.WLSDe sc,
  26   The reason  for the r eferral's  return,CCR A.Referral .ReferralR eturnReaso n,CCRS.Ref erral.Refe rralReturn Reason,Use r.PAWailti ngList.WLR efStatusRe asonDR.REF STREADesc,
  27   The servic e being re quested by  this refe rral,CCRA. Referral.S erviceRequ ested,CCRS .Referral. ServiceReq uested,Use r.PAWaitin gList.WLSt ateProcDR. SPPPDesc,
  28   The hospit al that or iginated t he referra l,CCRA.Ref erral.Refe rringFacil ity,CCRS.R eferral.Re ferringFac ility,DAS. CCNContrac tReferral. CCNFacilit y,User.PAW aitingList .WLRefDepH ospDR.HOSP Desc,
  29   The provid er at the  referring  hospital t hat origin ated the r eferral,CC RA.Referra l.Referrin gProvider, CCRS.Refer ral.Referr ingProvide r,DAS.CCNC ontractRef erral.CCNP rovider,Us er.PAWaiti ngList.WLR efDocDR.RE FDDesc,
  30   The specia lty at the  referring  hospital  that origi nated the  referral,C CRA.Referr al.Referri ngSpecialt y,CCRS.Ref erral.Refe rringSpeci alty,User. PAWaitingL ist.WLRefD epDR.CTLoc .CTLOCDesc ,
  31   The treati ng facilit y to which  this refe rral has b een alloca ted,CCRA.R eferral.Tr eatingFaci lity,CCRS. Referral.T reatingFac ility,User .PAWaiting List.WLHos pitalDR.HO SPDesc,
  32   The care p rovider wh o will be  providing  the reques ted servic e,CCRA.Ref erral.Trea tingProvid er,CCRS.Re ferral.Tre atingProvi der,User.P AWaitingLi st.WLDocto rDR.CTPCPD esc,
  33   The specia lty at the  treating  facility t hat will p rovide thi s service, CCRA.Refer ral.Treati ngSpecialt y,CCRS.Ref erral.Trea tingSpecia lty,User.P AWaitlingL ist.WLCTLO CDR.CTLOCD esc,
  34   The date o f the Pati ent's sche duled appo intment,CC RA.Referra l.Appointm entDate,DA S.CCNContr actReferra l.Appointm entDate,Us er.PAWaiti ngList.WLA pptDate,
  35   The date t reatment s tarted,CCR A.Referral .Treatment StartDate, DAS.CCNCon tractRefer ral.CareIn dicatedDat e  / DAS.C CNContract Referral.R eferralFro mDate,User .PAWaitlin gList.WLTr eatmentSta rtDate,
  36   The referr als' prefe rred provi der.,CCRA. Referral.P referredPr ovider,DAS .CCNContra ctReferral .Preferred Provider,
  37   The organi zation the  is taking  primary r esponsibil ity for pa ying,CCRA. Referral.P rimaryPayo r,CCRS.Ref erral.Prim aryPayor,D AS.CCNCont ractReferr al.Primary Payor,
  38   The paymen t plan of  the primar y payor,CC RA.Referra l.PrimaryP ayorPlan,C CRS.Referr al.Primary PayorPlan,
  39   The organi zation the  is taking  secondary  responsib ility for  paying,CCR A.Referral .Secondary Payor,CCRS .Referral. SecondaryP ayor,DAS.C CNContract Referral.S econdaryPa yor,
  40   The paymen t plan of  the second ary payor, CCRA.Refer ral.Second aryPayorPl an,CCRS.Re ferral.Sec ondaryPayo rPlan,
  41   The CCN ne twork to w hich this  referral h as been fo rwarded or  "Not Allo cated",CCR A.Referral .Network,C CRS.Referr al.Network ,User.PAWa itingList. WLWaitList TypeDR.WLT Desc,
  42   The CCN ne twork Code  to which  this refer ral has be en forward ed or "Not  Allocated ",CCRA.Ref erral.Netw orkCode,CC RS.Referra l.Network, DAS.CCNCon tractRefer ral.CCNNet work,User. PAWaitingL ist.WLWait ListTypeDR .WLTCode,
  43   Other Insu rance Info rmation: T BD,CCRA.Re ferral.Oth erInsuranc eInfo,DAS. CCNContrac tReferral. OtheHealth rInsurance Info,
  44   The name o f the orde ring offic er,CCRA.Re ferral.Ord eringOffic erName,DAS .CCNContra ctReferral .OrderingO fficerName ,
  45   The date t he Referra l was last  updated,C CRA.Referr al.Referra lLastUpdat eDate,CCRS .Referral. ReferralLa stUpdateDa te,User.PA WaitingLis t.WLUpdate Date,
  46   The Paymen t Authorit y Code,CCR A.Referral .PaymentAu thorityCod e,CCRS.Ref erral.Paym entAuthori tyCode,Use r.PAWaitin gList.WLPr ogramFundi ngDR.PFSCo de,
  47   The Paymen t Authorit y Descript ion,CCRA.R eferral.Pa ymentAutho rityDesc,C CRS.Referr al.Payment AuthorityD esc,User.P AWaitingLi st.WLProgr amFundingD R.PFSDesc,
  48   The CLIN C ode,CCRA.R eferral.CL INCode,CCR S.Referral .CLINCode, User.PAWai tingList.W LCareTypeD R.CARETYPC ode,
  49   The CLIN D escription ,CCRA.Refe rral.CLIND esc,CCRS.R eferral.CL INDesc,Use r.PAWaitin gList.WLCa reTypeDR.C ARETYPDesc ,
  50  
  51   Y,Transact on History  - Transac tion Date, CCRA.Refer ral.Transa ctionHisto ry.Transac tionDate,C CRS.Referr al.Transac tionHistor y.Transact ionDate,Us er.PAWaiti ngList.Chi ldPAWaitin gListTrans action.TRA NSDate,
  52   Y,Transact ion Histor y - Effect ive Date,C CRA.Referr al.Transac tionHistor y.Effectiv eDate,CCRS .Referral. Transactio nHistory.E ffectiveDa te,User.PA WaitingLis t.ChildPAW aitingList Transactio n.TRANSDat eEffective ,
  53   Y,Transact ion Histor y - Reason  Descripti on,CCRA.Re ferral.Tra nsactionHi story.Reas on,CCRS.Re ferral.Tra nsactionHi story.Reas on,User.PA WaitingLis t.ChildPAW aitingList Transactio n.TRANSRea sonForChan geDR.WLRCD esc,
  54   Y,Transact ion Histor y - Status ,CCRA.Refe rral.Trans actionHist ory.Status ,CCRS.Refe rral.Trans actionHist ory.Status ,User.PAWa itingList. ChildPAWai tingListTr ansaction. TRANSStatu sDRs.WLSDe sc,
  55  
  56   Eligibilty  - Priorit y Enrollme nt Group,C CRA.Referr al.CoPayme ntStatus.P riorityEnr ollmentGro up,CCRS.Re ferral.CoP aymentStat us.Priorit yEnrollmen tGroup,qus tionnaire. QUSXXES.QQ 1,sch.enro llmentDete rminationI nfo.priori tyGroup,
  57   Eligibilty   - Curren t Means Te st,CCRA.Re ferral.CoP aymentStat us.Current MeansTest, CCRS.Refer ral.CoPaym entStatus. CurrentMea nsTest,qus tionnaire. QUSXXES.QQ 2,
  58   Eligibilty  - Agent O range Expo sure Indic ator,CCRA. Referral.C oPaymentSt atus.Agent OrangeExpo sureIndica tor,CCRS.R eferral.Co PaymentSta tus.AgentO rangeExpos ureIndicat or,qustion naire.QUSX XES.QQ3,sc h.specialF actorsInfo .agentOran geInd,
  59   Eligibilty  - Combat  Veteran El igibilty I ndicator,C CRA.Referr al.CoPayme ntStatus.C ombatVeter anEligibil ityIndicat or,CCRS.Re ferral.CoP aymentStat us.CombatV eteranElig ibilityInd icator,qus tionnaire. QUSXXES.QQ 4,sch.mili taryServic eInfo.comb atVeteranE ligibility EndDate,
  60   Eligibilty  - Combat  Veteran En d Date,CCR A.Referral .CoPayment Status.Com batVeteran EndDate,CC RS.Referra l.CoPaymen tStatus.Co mbatVetera nEndDate,q ustionnair e.QUSXXES. QQ5,sch.mi litaryServ iceInfo.co mbatVetera nEligibili tyEndDate,
  61   Eligibilty  - Project  112 SHAD  Indicator, CCRA.Refer ral.CoPaym entStatus. Project112 SHADIndica tor,CCRS.R eferral.Co PaymentSta tus.Projec t112SHADIn dicator,qu stionnaire .QUSXXES.Q Q6,sch.mil itaryServi ceInfo.sha dIndicator ,
  62   Eligibilty  - Southwe st Asian I ndicator,C CRA.Referr al.CoPayme ntStatus.S outwestAsi aIndicator ,CCRS.Refe rral.CoPay mentStatus .SoutwestA siaIndicat or,qustion naire.QUSX XES.QQ7,sc h.military ServiceInf o.envConta minatesInd ,
  63   Eligibilty  - Ionizin g Radiatio n Indicato r,CCRA.Ref erral.CoPa ymentStatu s.Ionizing RadiationI ndicator,C CRS.Referr al.CoPayme ntStatus.I onizingRad iationIndi cator,qust ionnaire.Q USXXES.QQ8 ,sch.milit aryService Info.radia tionExposu reInd,
  64   Eligibilty  - Camp Le jeune Indi cator,CCRA .Referral. CoPaymentS tatus.Camp LejeuneInd icator,CCR S.Referral .CoPayment Status.Cam pLejeuneIn dicator,qu stionnaire .QUSXXES.Q Q9,sch.mil itaryServi ceInfo.cam pLejueneIn d,
  65  
  66   Y,Eligibil ty - Servi ce Connect  Descripti on,CCRA.Re ferral.Ser viceConnec tedInfo.Se rviceConne ctedCondit ion,CCRS.R eferral.Se rviceConne ctedInfo.S erviceConn ectedCondi tion,qusti onnaire.QU SXXES.Chil dQTAB1DR.Q TAB1Q10,sc h.ratedDis abilityInf o.disabili ty,
  67   Y,Eligibil ty - Servi ce Connect  Percentag e,CCRA.Ref erral.Serv iceConnect edInfo.Ser viceConnec tedPercent age,CCRS.R eferral.Se rviceConne ctedInfo.S erviceConn ectedPerce ntage,qust ionnaire.Q USXXES.Chi ldQTAB1DR. QTAB1Q11,s ch.ratedDi sabilityIn fo.percent age,
  68   Y,Eligibil ty - Servi ce Connect ed Indicat or,CCRA.Re ferral.Ser viceConnec tedInfo.Se rviceConne cted,CCRS. Referral.S erviceConn ectedInfo. ServiceCon nected,qus tionnaire. QUSXXES.Ch ildQTAB1DR .QTAB1Q12, sch.ratedD isabilityI nfo.servic eConnected ,
  69  
  70   Eligibilit y - Milita ry Sexual  Trauma - D eterminati on Facilit y,CCRA.Ref erral.Mili tarySexual Trauma.Det ermination Facility,C CRS.Referr al.Militar ySexualTra uma.Determ inationFac ility,qust ionnaire.Q USXXES.QQ1 3,sch.mili tarySexual TraumaInfo .determina tionFacili ty,
  71   Eligibilit y - Milita ry Sexual  Trauma - S tatus,CCRA .Referral. MilitarySe xualTrauma .Status,CC RS.Referra l.Military SexualTrau ma.Status, qustionnai re.QUSXXES .QQ14,sch. militarySe xualTrauma Info.statu s,
  72   Eligibilit y - Milita ry Sexual  Trauma - s tatusChang eDate,CCRA .Referral. MilitarySe xualTrauma .StatusCha ngeDate,CC RS.Referra l.Military SexualTrau ma.StatusC hangeDate, qustionnai re.QUSXXES .QQ15,sch. militarySe xualTrauma Info.statu sChangeDat e,
  73  
  74   Eligibilty  - Nose/Th roat Radiu m Info - D eterminati on Facilit y,CCRA.Ref erral.Nose ThroatRadi umInfo.Det ermination Facility,C CRS.Referr al.NoseThr oatRadiumI nfo.Determ inationFac ility,qust ionnaire.Q USXXES.QQ1 6,sch.nose ThroatRadi umInfo.det ermination Facility,
  75   Eligibilty  - Nose/Th roat Radiu m Info - D iagnosed w ith Cancer  indicator ,CCRA.Refe rral.NoseT hroatRadiu mInfo.Diag nosedWithC ancer,CCRS .Referral. NoseThroat RadiumInfo .Diagnosed WithCancer ,qustionna ire.QUSXXE S.QQ17,sch .noseThroa tRadiumInf o.diagnose dWithCance r,
  76   Eligibilty  - Nose/Th roat Radiu m Info - D iagnosis V erificatio n Date,CCR A.Referral .NoseThroa tRadiumInf o.Diagnosi sVerifiedD ate,CCRS.R eferral.No seThroatRa diumInfo.D iagnosisVe rifiedDate ,qustionna ire.QUSXXE S.QQ18,sch .noseThroa tRadiumInf o.diagnosi sVerifiedD ate,
  77   Eligibilty  - Nose/Th roat Radiu m Info - F rom Aviato r Service  before 195 5,CCRA.Ref erral.Nose ThroatRadi umInfo.Fro mAviatorSe rviceBefor e1955,CCRS .Referral. NoseThroat RadiumInfo .FromAviat orServiceB efore1955, qustionnai re.QUSXXES .QQ19,sch. noseThroat RadiumInfo .fromAviat orServiceB efore1955,
  78   Eligibilty  - Nose/Th roat Radiu m Info - F rom Submar iner Servi ce before  1965,CCRA. Referral.N oseThroatR adiumInfo. FromSubmar inerServic eBefore196 5,CCRS.Ref erral.Nose ThroatRadi umInfo.Fro mSubmarine rServiceBe fore1965,q ustionnair e.QUSXXES. QQ20,sch.n oseThroatR adiumInfo. fromSubmar inerServic eBefore196 5,
  79   Eligibilty  - Nose/Th roat Radiu m Info - R eceiving T reatment i ndicator,C CRA.Referr al.NoseThr oatRadiumI nfo.Receiv ingTreatme nt,CCRS.Re ferral.Nos eThroatRad iumInfo.Re ceivingTre atment,qus tionnaire. QUSXXES.QQ 21,sch.nos eThroatRad iumInfo.re ceivingTre atment,
  80   Eligibilty  - Nose/Th roat Radiu m Info - V erfication  Date,CCRA .Referral. NoseThroat RadiumInfo .Verificat ionDate,CC RS.Referra l.NoseThro atRadiumIn fo.Verific ationDate, qustionnai re.QUSXXES .QQ22,sch. noseThroat RadiumInfo .verificat ionDate,
  81   Eligibilty  - Nose/Th roat Radiu m Info - V erfication  Facility, CCRA.Refer ral.NoseTh roatRadium Info.Verif icationFac ility,CCRS .Referral. NoseThroat RadiumInfo .Verificat ionFacilit y,qustionn aire.QUSXX ES.QQ23,sc h.noseThro atRadiumIn fo.verific ationFacil ity,
  82   Eligibilty  - Nose/Th roat Radiu m Info - V erfication  Method,CC RA.Referra l.NoseThro atRadiumIn fo.Verific ationMetho d,CCRS.Ref erral.Nose ThroatRadi umInfo.Ver ificationM ethod,qust ionnaire.Q USXXES.QQ2 4,sch.nose ThroatRadi umInfo.ver ificationm ethod,
  83   Y,The prea uthorizati on number  against wh ich the re ferral ser vice was a pproved,CC RA.Referra l.PreAutho rization.P reAuthoriz ationNumbe r,CCRS.Ref erral.PreA uthorizati on.PreAuth orizationN umber,DAS. CCNContrac tReferral. PreAuthori zation.Pre Authorizat ionNumber, User.PAWai tlingList. WLPackageD etDR.DETPa rRef.PACKN umber,
  84   Y,A short  descriptio n of the p reauthoriz ation (SEO C Name),CC RA.Referra l.PreAutho rization.D escription ,CCRS.Refe rral.PreAu thorizatio n.Descript ion,DAS.CC NContractR eferral.Pr eAuthoriza tion.Descr iption,Use r.PAWaitli ngList.WLP ackageDetD R.DETParRe f.PACKDesc ,
  85   Y,The reas on why the  patient h as been pr eauthorize d for this  service,C CRA.Referr al.PreAuth orization. Reason,CCR S.Referral .PreAuthor ization.Re ason,DAS.C CNContract Referral.P reAuthoriz ation.Reas on,User.PA WaitlingLi st.WLPacka geDetDR.DE TParRef.PA CKReasonDR .PACKREADe sc,
  86   Y,The stat us of the  preauthori zation,CCR A.Referral .PreAuthor ization.St atus,CCRS. Referral.P reAuthoriz ation.Stat us,DAS.CCN ContractRe ferral.Pre Authorizat ion.Status ,User.PAWa itlingList .WLPackage DetDR.DETP arRef.PACK StatusDR.P ACKSTDesc,
  87   Y,The date  from whic h this pre authorizat ion is val id (SEOC E ffective S tart Date) ,CCRA.Refe rral.PreAu thorizatio n.DateFrom ,CCRS.Refe rral.PreAu thorizatio n.DateFrom ,DAS.CCNCo ntractRefe rral.PreAu thorizatio n.DateFrom ,User.PAWa itlingList .WLPackage DetDR.DETP arRef.PACK EffectiveD ateFrom,
  88   Y,The date  until whi ch this pr eauthoriza tion is va lid (SEOC  Effective  End Date), CCRA.Refer ral.PreAut horization .DateTo,CC RS.Referra l.PreAutho rization.D ateTo,DAS. CCNContrac tReferral. PreAuthori zation.Dat eTo,User.P AWaitlingL ist.WLPack ageDetDR.D ETParRef.P ACKEffecti veDateTo,
  89   Y,Addition al comment s,CCRA.Ref erral.PreA uthorizati on.Comment s,CCRS.Ref erral.PreA uthorizati on.Comment s,DAS.CCNC ontractRef erral.PreA uthorizati on.Comment s,User.PAW aitlingLis t.WLPackag eDetDR.DET ParRef.PAC KComments,
  90   Y,Is the P rimary SEO C indicato r,CCRA.Ref erral.PreA uthorizati on.Primary Indicator, CCRS.Refer ral.PreAut horization .PrimaryIn dicator,DA S.CCNContr actReferra l.PreAutho rization.P rimaryIndi cator,
  91   Y,Number o f Visits/S ervices al lowed for  the Servic e,CCRA.Ref erral.PreA uthorizati on.Details .LimitQty, CCRS.Refer ral.PreAut horization .Details.L imitQty,DA S.CCNContr actReferra l.PreAutho rization.D etails.Lim itQty,User .PAWaitlin gList.WLPa ckageDetDR .ChildPAPe rsonPackag eDet.DETLi mitQty,
  92  
  93   Y,Order Se t Name,CCR A.Referral .PreAuthor ization.De tails.Orde rSets.Code ,CCRS.Refe rral.PreAu thorizatio n.Details. OrderSets. Code,DAS.C CNContract Referral.P reAuthoriz ation.Deta ils.OrderS ets.Code,U ser.PAWait lingList.W LPackageDe tDR.ChildP APersonPac kageDet.DE TARCOSDR.A RCOSCode,
  94   Y,Order Se t Desc ,CC RA.Referra l.PreAutho rization.D etails.Ord erSets.Des c,CCRS.Ref erral.PreA uthorizati on.Details .OrderSets .Desc,DAS. CCNContrac tReferral. PreAuthori zation.Det ails.Order Sets.Desc, User.PAWai tlingList. WLPackageD etDR.Child PAPersonPa ckageDet.D ETARCOSDR. ARCOSDesc,
  95  
  96   Y,Effectiv e Date of  the Allowe d procedur es,CCRA.Re ferral.Pre Authorizat ion.Detail s.OrderSet s.OrderSet Dates.Date From,CCRS. Referral.P reAuthoriz ation.Deta ils.OrderS ets.OrderS etDates.Da teFrom,DAS .CCNContra ctReferral .PreAuthor ization.De tails.Orde rSets.Orde rSetDates. DateFrom,U ser.PAWait lingList.W LPackageDe tDR.ChildP APersonPac kageDet.DE TARCOSDR.C hildARCOrd SetDate.DA TEDateFrom ,
  97   Y,Expirati on Date of  the Allow ed procedu rs,CCRA.Re ferral.Pre Authorizat ion.Detail s.OrderSet s.OrderSet Dates.Date To,CCRS.Re ferral.Pre Authorizat ion.Detail s.OrderSet s.OrderSet Dates.Date To,DAS.CCN ContractRe ferral.Pre Authorizat ion.Detail s.OrderSet s.OrderSet Dates.Date To,User.PA WaitlingLi st.WLPacka geDetDR.Ch ildPAPerso nPackageDe t.DETARCOS DR.ChildAR COrdSetDat e.DATEDate To,
  98  
  99   Y,Procedur e Code - C PT Codes,  ICD-9, ICD -10, etc., CCRA.Refer ral.PreAut horization .Details.O rderSets.O rderSetDat es.OrderSe tItem.Proc edureCode, CCRS.Refer ral.PreAut horization .Details.O rderSets.O rderSetDat es.OrderSe tItem.Proc edureCode, User.PAWai tlingList. WLPackageD etDR.Child PAPersonPa ckageDet.D ETARCOSDR. ChildARCOr dSetDate.C hildARCOrd SetDateIte m.ITMARCIM DR.ARCIMCo de,
  100  
  101  
  102  
  103  
  104  
  105  
  106