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.
# | 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 |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 1 | 212 |
Changed | 0 | 0 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.