Download:
pdf |
pdfMCBS WVS - Technical Notes
33
AC20AC28A1Asked
AC20-AC28A1 already asked =
ACCS.MDSPCLTY ^= EMPTY on ACCS where ACCS.ACCSRND = current round.
31
AC6AAsked
AC6A already asked =
ACCS.EWAITUNT ^= EMPTY on ACCS where ACCS.ACCSRND = current round.
32
AC9AC16AAsked
AC9-AC16A already asked =
ACCS.OPDREAS ^= EMPTY on ACCS where ACCS.ACCSRND = current round.
333
AddressCollectedFutureProxy
Address has been collected in the current or previous round for person selected as Future Proxy =
tblADDRESS.STAddr1 ^= EMPTY on tblADDRESS where ((tblADDRESS.AddressRnd = current or previous
round) & tblADDRESS.AddrRost = current round tblCL.FProxNum).
294
AddressCurrentContact1
First Contact's current Address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
tblCL.CONTNUM1 on tblCL where tblCL.CLRnd = current round & tblADDRESS.AddressRnd = current round).
295
AddressCurrentContact2
Second Contact's current Address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
tblCL.CONTNUM2 on tblCL where tblCL.CLRnd = current round & tblADDRESS.AddressRnd = current round).
281
AddressCurrentMail
SP's current round mailing address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'MAIL' & tblADDRESS.AddressDetail = 'MAIL' & tblADDRESS.AddressRnd = current round).
288
AddressCurrentProxy
Proxy's current Address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
MRES.RROSTNUM & tblADDRESS.AddressRnd = current round).
286
AddressCurrentSP
SP's current round home address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'SP' & tblADDRESS.AddressDetail = 'SP' & tblADDRESS.AddrRost = '01' & tblADDRESS.AddressRnd =
current round).
320
AddressCurrentVacHome
SP's current Vacation Home Address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'SecondHome'' and tblADDRESS.AddressDetail = 'SecondHome' & tblADDRESS.AddressRnd = current round).
27-Mar-09
Page 1 of 44
MCBS WVS - Technical Notes
313
AddressPrevCollectedProxy
Address has been collected for the Proxy =
tblADDRESS.STAddr1 ^= EMPTY on tblADDRESS where (tblADDRESS.AddressRnd = previous round &
tblADDRESS.AddrRost = MRES.RROSTNUM).
314
AddressPrevCollectedSP
Address has been collected for the SP =
tblADDRESS.STAddr1 ^= EMPTY on tblADDRESS where (tblADDRESS.AddressRnd = previous round &
tblADDRESS.AddressType = 'SP' & tblADDRESS.AddressDetail = 'SP' & tblADDRESS.AddrRost = '01').
292
AddressPreviousContact1
First Contact previous round address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
tblCL.CONTNUM1 on tblCL where tblCL.CLRnd = previous round & tblADDRESS.AddressRnd = previous
round).
293
AddressPreviousContact2
Second Contact previous round address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
tblCL.CONTNUM2 on tblCL where tblCL.CLRnd = previous round & tblADDRESS.AddressRnd = previous
round).
287
AddressPreviousProxy
Proxy's previous round address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
MRES.RROSTNUM & tblADDRESS.AddressRnd = previous round).
426
AddressPreviousSP
SP's previous round home address =
STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType = 'SP' &
tblADDRESS.AddressDetail = 'SP' & tblADDRESS.AddrRost = '01' & tblADDRESS.AddressRnd = previous
round).
280
AddressPrevMailCollected
Mailing Address was collected for SP in the previous round =
tblADDRESS.STAddr1 ^= empty on tblADDRESS where (tblADDRESS.AddressType = 'MAIL' and
tblADDRESS.AddressDetail = 'MAIL' and tblADDRESS.AddressRnd = previous round).
318
AddressPrevMailing
SP's previous round mailing address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'MAIL' and tblADDRESS.AddressDetail = 'MAIL' & tblADDRESS.AddressRnd = previous round).
27-Mar-09
Page 2 of 44
MCBS WVS - Technical Notes
319
AddressPrevVacHome
SP's previous Vacaction Home Address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'SecondHome'' and tblADDRESS.AddressDetail = 'SecondHome' & tblADDRESS.AddressRnd = previous
round).
214
AdultLiveWithSP
There is an adult age 15 or older living with the SP in the current round other than the spouse =
There is an ENUM where (ENUM.ENUMRND=current round & ENUM.NOTHHRSN=empty &
ENUM.ENUMROST^= 01 & ENUM.HHPREL^= 2/Spouse & ENUM.HHPAGE >= 15).
228
AllowedToStay
Whether or not SP is allowed to continue living in home if substantial care is needed is unknown =
HOUS.STAYPUT = DK on HOUS where HOUS.HOUSRND = (current round - 3).
340
AllStateWithMHMO
If there are Medicare Managed Care plans (Medicare Advantage plans) in SP's state =
All States have at least one Medicare Advantage Plan.
203
AlterationNotComplete
SP reported an alteration that was not complete at the time of the previous round interview =
There is an EVNT where EVNTTYPE = 'OM' and EVNT.OMETYPE = 7/Alteration and EVNT.OMSTATUS =
1/AlterationNotComplete and EVNT.EVNTDFLG ^=1/Yes.
189
AmountEqualDK
Previous round PM Amount was asked and did not equal DK =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND =
previous round & PMRO.AMTUNIT ^= EMPTY & (PMRO.AMTUNIT ^= DK & PMRO.AMTNUM ^= DK)).
230
AmountRemaining
Amount Remaining =
COST.AREMAING.
93
AnyPlansCurrentRnd
SP reported being covered by any plans during the current round =
There is PLAN & PLRO where (PLRO.PLROPLAN = PLAN.PLANNUM & PLRO.PLRORND = current round &
(PLRO.COVTIME ^= empty or PLRO.COVANYTIM = 1/Yes)).
Exclude Deleted Plans. See T.N. 52.
384
AnyPlansNotMedicare
SP covered by plan in current round other than Medicare =
There is a PLAN where PLAN.PLANTYPE^=1/Medicare & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
& PLRO.PLRORND=current round & (COVTIME^=empty or COVANYTM=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
27-Mar-09
Page 3 of 44
MCBS WVS - Technical Notes
BreakoffDate
The date of the most recent breakoff =
MRES.MRESEDAT on MRES where MRES.MRESRND = current round.
ChargeBundlesEntered
One or more charge bundle previously entered in ST section =
HRND.EVERSTMT = 1/Yes on HRND where HRND.HRNDRND = current round.
CMSBirthDate
CMS birth date for SP =
BASE.SPDOBMM, BASE.SPDOBDD, BASE.SPDOBYY.
102
CMSGender
CMS gender =
BASE.SPSEX.
325
Contact1LivesSP
First Contact person reported in the previous round lives with the SP in the current round =
There is an ENUM where ((ENUM.ENUMROST= tblCL.CONTNUM1 on tblCL where tblCL.CLRnd=previous
round) and (ENUM.ENUMRND = current round and ENUM.NOTHHRSN = empty)).
306
Contact1Name
The First Contact's name =
ROST.ROSTFNAM + ROST.ROSTLNAM on ROST where ROST.ROSTNUM = tblCL.CONTNUM1 on tblCL
where tblCL.CLRnd= current round.
323
Contact1PrevRound
First Contact reported in the previous round =
tbl.CONTNUM1 on tblCL where tblCL.CLRnd = previous round. Contact's name is ROST.ROSTFNAM +
ROST.ROSTLNAM stored on ROST where ROST.ROSTNUM = previous round tbl.CONTNUM1
327
Contact1ProxyPrevRound
Proxy is the First Contact person reported in the previous round =
MRES.RROSTNUM = tblCL.CONTNUM1 on tblCL where tblCL.CLRnd = previous round.
326
Contact2LivesSP
Second Contact person reported in the previous round lives with the SP in the current round =
There is an ENUM where ((ENUM.ENUMROST=tblCL.CONTNUM2 on tblCL where tblCL.CLRnd=previous
round) and (ENUM.ENUMRND = current round and ENUM.NOTHHRSN = empty)).
307
Contact2Name
The Second Contact's name =
ROST.ROSTFNAM + ROST.ROSTLNAM on ROST where ROST.ROSTNUM = tblCL.CONTNUM2 on tblCL
where tblCL.CLRnd= current round.
97
243
21
27-Mar-09
Page 4 of 44
MCBS WVS - Technical Notes
324
Contact2PrevRound
Second Contact reported in the previous round =
tbl.CONTNUM2 on tblCL where tblCL.CLRnd = previous round. Contact's name is ROST.ROSTFNAM +
ROST.ROSTLNAM stored on ROST where ROST.ROSTNUM = previous round tbl.CONTNUM2.
328
Contact2ProxyPrevRound
Proxy is the Second Contact person reported in the previous round =
MRES.RROSTNUM = tblCL.CONTNUM2 on tblCL where tblCL.CLRnd = previous round.
322
ContactsCollectedPrevRound
Contact Persons reported in the previous round =
tbl.CONTNUM1 ^= empty on tblCL where tblCL.CLRnd = previous round.
ContinuingSample
Continuing Sample SP =
MRES.INTTYPE ^=3/NewFromSupplement on MRES where MRES.MRESRND = current round.
268
CoPaymentCollected
CoPayment was collected for Charge Bundle =
For this COST, there is a CORO where (CORO.COROCOST = COST.COSTNUM & CORO.CORORND =
current round & CORO.TOTALTYP = 2/CoPayment).
If administering CPS, check most recent CORO where CORO.TOTALTYP ^= empty.
271
COST2RoundsOld
Charges first collected 2 rounds previous to current round =
COST.COSTRNDC = (current round - 2).
425
COSTRound50
Charges first collected in R50 =
COST.EXMCR50 = 1/Yes.
114
CoverageStartDate
Health Insurance Plan coverage start date =
PLRO.COVBEGMM / PLRO.COVBEGDD / PLRO.COVBEGYY.
Check PLRO where PLRO.PLROPLAN = PLAN.PLANNUM and PLRO.PLRORND = round # checking.
115
CoverageStopDate
Health Insurance Plan coverage stop date =
PLRO.COVENDMM / PLRO.COVENDDD / PLRO.COVENDYY.
Check PLRO where PLRO.PLROPLAN = PLAN.PLANNUM and PLRO.PLRORND = round # checking.
30
27-Mar-09
Page 5 of 44
MCBS WVS - Technical Notes
275
CPSReason
CPS Reasons stored by CPS REASON NUMBER on CORO.CPSREASN:
= 1/NSExpectStatement
= 2/NSNoPayms
= 3/STNoPayms
= 4/NSPaymsLessTotalCharge
= 5/STPaymsLessAmtRemain
= 6/SPPaidExpectREIM
= 7/SPPaidREIMDK
= 8/NSExpectStatementDP
161
CurrAskAboutFriends
If currently asking about home health friends or family =
Coming from HH18 loop.
250
CurrentChargeBundles
Current Round Charge Bundles entered in Statement Series =
There is a COST where COST.COSTRNDC = current round and COST.COSTTYPE = 1/ST.
276
CurrentMedicaid
SP currently covered by Medicaid =
There is a PLAN where PLANTYPE=2/Medicaid & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & (PLRO.COVTIME = 1/WholeTime or PLRO.COVNOW = 1/Yes)).
Exclude Deleted Plans. See T.N. 52.
CurrentPrivatePlan
SP currently covered by a Private HI plan =
There is a PLAN where PLANTYPE=4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
CurrMedManageCarePlan Change to 65.
SP currently in Medicare Managed Care Plan (Medicare Advantage plan) =
There is a PLAN where PLAN.PLANTYPE=5/MHMO & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
CurrRndForm
The current round form for the PM =
For this PM EVNT, there is PMRO where (PMRO.PMROEVNT= EVNT.EVNTNUM & PMRO.PMRORND =
current round).
Form = PMRO.PMFORM.
Other Specify Form = PMRO.PMFORMOS.
3
29
185
27-Mar-09
Page 6 of 44
MCBS WVS - Technical Notes
DeceasedInst
SP deceased or institutionalized =
MRES.SPALIVE=2/AliveAndInstitute or 3/Deceased on MRES where MRES.MRESRND = current round.
117
DeletedDM
Deleted Discount Membership plans that are not valid for displays or checks =
Any DMEM where (DMEM.LOSEDMFG ^= EMPTY) is a deleted DM.
252
DeletedOSOPs
Deleted OSOPs that are not valid for displays or checks =
Any OSOP where (OSOP.OSOPHIDE=1/Yes or OSOP.LOSEOSFG ^=EMPTY) is a deleted OSOP.
DeletedPlans
Deleted plans that are not valid for displays or checks =
Any PLAN where (PLAN.PLANDFLG=1/Yes or PLAN.MHMODFLG=1/Yes or PLAN.PLANHIDE=1/Yes or
PLAN.LOSEPLFG ^=EMPTY) is a deleted PLAN.
220
DKDwelling
The Type of Dwelling reported in the previous year was unknown =
(HOUS.DWELLING = DK or RF) on HOUS where HOUS.HOUSRND = (current round - 3).
224
DKHousing
Type of Housing reported in the previous year is unknown =
(HOUS.HOUSTYPE = DK or RF) on HOUS where HOUS.HOUSRND = (current round - 3).
DMCurrentRnd
SP reported having a Discount Membership plan anytime during the current round =
There is a DMEM and DMRO where (DMRO.DMRODMEM = DMEM.DMEMNUM and DMRO.DMRORND =
current round and DMRO.DMHAVE = 1/Yes).
Exclude Deleted DM's. See T.N. 117.
DMName
Discount Membership Name = DMEM.DMNAMEX.
37
DMPreviousRnd
SP had a Discount Membership plan during the previous round =
There is a DMEM and a DMRO where (DMRO.DMRODMEM = DMEM.DMEMNUM and DMRO.DMRORND =
previous round and DMRO.DMHAVE = 1/Yes).
Exclude Deleted DM's. See T.N. 117.
34
ENHouseHold
Persons already identified as living in the household in the current round =
For this ROST, there is an ENUM where (ENUM.ENUMROST=ROST.ROSTNUM and
ENUM.ENUMRND=current round and ENUM.NOTHHRSN=empty).
125
ENS10Asked
Person has not received ENS10 =
For this ENUM, there is ROST where (ROST.ROSTNUM = ENUM.ENUMROST and ROST.ENSFLAG = empty).
8
52
38
118
27-Mar-09
Page 7 of 44
MCBS WVS - Technical Notes
138
ERtoIPStay
SP had an emergency room visit in the current round that resulted in the SP being admitted to hospital =
There is an EVNT where EVNT.EVNTDFLG^=1/Yes and EVNT.EVNTRNDC=current round and
EVNT.EVNTTYPE='ER' and EVNT.ERADMIT=1/Yes and EVNT.EVUTSFLG ^=1/Yes.
235
Event2RoundsOld
Event collected 2 rounds prior to the current round =
NEED TO REVIEW CODE.
266
EventAssocHMO
Event is associated with a Managed Care Plan =
For this EVNT, ((PROV.HMOASSOC = 1/Yes on PROV where PROV.PROVNUM = EVNT.EVNTPROV) or
(EVNT.HMOREFER=1/Yes) or (PMRO.PMSATHMO=1/Yes on PMRO where
(PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND=current round))).
435
EventNotOM
Event Type is not an Other Medical expense event =
EVNT.EVNTTYPE ^= 'OM'.
257
EventsInChargeBundle
Events included in this charge bundle =
For this COST, there is an XCEV where (XCEV.XCEVCOST = COST.COSTNUM & XCEV.DELLINK ^= 1/Yes &
XCEV.XCEVEVNT = EVNT.EVNTNUM of EVNT linked to charge bundle).
217
EVOSTEXT
EVOSTEXT is stored in EVOS.EVOSTEXT in Cheshire database, however, it will be temporarily copied
to/collected on EVNT for data collection. EVNT.EVOSTEXT is copied from/to EVOS.EVOSTEXT during data
transformation.
19
ExitNotSkip
If SP is in the Exit Sample and previous round interview not skipped =
MRES.INTTYPE=8/ExitInterviewHadPrev on MRES where MRES.MRESRND = current round.
16
ExitSample
SP is in the Exit Sample =
(MRES.INTTYPE = 8/ExitInterviewHadPrev or 9/ExitInterviewSkipPrev) on MRES where MRES.MRESRND =
current round.
20
ExitSkip
If SP is in the Exit Sample and previous round interview was skipped =
MRES.INTTYPE=9/ExitInterviewSkipPrev on MRES where MRES.MRESRND = current round.
11
FacInterview
Previous round was a facility interview =
(MRES.INTTYPE=2/NewFromFacility or
MRES.INTTYPE=5/LastRndFacSum or
MRES.INTTYPE=6/LastRndFacBase) on MRES where MRES.MRESRND = current round.
27-Mar-09
Page 8 of 44
MCBS WVS - Technical Notes
98
FallRound
If the remainder of (Current round divided by 3) = 1, then it is a Fall round.
375
First15PMs
This PM is one of the first 15 medicines being asked about in PM =
PM16A1 - TOTALPMASK < 15.
126
FirstCommunity
If this is SP's first community interview =
(MRES.INTTYPE=2/NewFromFacility or
MRES.INTTYPE=3/NewFromSupplement) on MRES where MRES.MRESRND = current round.
48
FirstUtilization
Ulization being collected for the first time =
(MRES.INTTYPE = 7/SupSmp1stTimeUtil or
MRES.INTTYPE = 10/SumSmp1stTimeUtilSkipped or
MRES.INTTYPE = 2/NewFromFacility) on MRES where MRES.MRESRND = current round.
10
FirstUtilizationNotFac
Utilization being collected for the first time in this round and previous round was not facility interview =
(MRES.INTTYPE=7/SupSmp1stTimeUtil or MRES.NTTYPE=10/SupSmp1stTimeUtilSkipped) on MRES where
MRES.MRESRND = current round.
193
FormEqualDK
Previous round PM Form was asked and did not equal DK =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND =
previous round & PMRO.PMFORM ^= EMPTY & PMRO.PMFORM ^= DK).
334
FutureProxyName
Future Proxy Name =
There is a ROST where (ROST.ROSTNUM = tblCL.FProxNum on tblCL where tblCL.CLRnd = current round.
Future Proxy Name = ROST.ROSTFNAM + ROST.ROSTLNAM.
400
HFAlzheimers
SP has ever reported Alzheimer’s disease in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCALZMER = 1/Yes.
406
HFAmpute
SP has ever reported an absence or loss of arm or leg in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCAMPUTE = 1/Yes.
392
HFAngina
SP has ever reported having hardening angina pectoris or coronary heart disease in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCCHD = 1/Yes.
393
HFCongHeartFailure
SP has ever reported having congestive heart failure in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCCFAIL = 1/Yes.
27-Mar-09
Page 9 of 44
MCBS WVS - Technical Notes
401
HFDementia
SP has ever reported having dementia in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCDEMENT = 1/Yes.
404
HFEmphysema
SP has ever reported having emphysema, asthma, or COPD in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCEMPHYS = 1/Yes.
390
HFHardenArtery
SP has ever reported having hardening of the arteries in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCARTERY = 1/Yes.
395
HFHeartRhythm
SP has ever reported having problems with the rhythm of the heart in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCRHYTHM = 1/Yes.
394
HFHeartValve
SP has ever reported having problems with the valves of the heart in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCCVALVE = 1/Yes.
391
HFHypertension
SP reported having hypertension in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCHBP = 1/Yes.
419
HFNowSmokesPrev
SP was asked if he/she now smokes cigarettes, cigars, or pipe tobacco in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.SMOKNOW ^= empty.
402
HFOsteoporosis
SP has ever reported having osteoporosis in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCOSTEOP = 1/Yes.
407
HFOsteoporosisCurrOrPrev
SP has ever reported having osteoporosis in the current round or in a previous round =
There is a HEST where HEST.HESTRND <= current round and HEST.OCOSTEOP = 1/Yes.
399
HFOtherArthritis
SP has ever reported having arthritis other than rheumatoid arthritis in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCARTH = 1/Yes.
396
HFOtherHeart
SP has ever reported having any other heart condition in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCOTHHRT = 1/Yes.
405
HFParalysis
SP has ever reported having complete or partial paralysis in a previous round round =
There is a HEST where HEST.HESTRND < current round and HEST.OCPPARAL = 1/Yes.
27-Mar-09
Page 10 of 44
MCBS WVS - Technical Notes
403
HFParkinsons
SP has ever reported having Parkinson’s disease in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCPARKIN = 1/Yes.
388
HFPneumoniaShot
SP has ever reported having a pneumonia shot in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.PNEUSHOT = 1/Yes.
385
HFProstateSurg
SP has ever reported having prostate surgery in a previous round =
There is a HEST where HEST.HESTRND < current round and (HEST.PROSSURG = 1/Yes or
HEST.PROSRMVD = 1/Yes).
387
HFProstateSurgCurrOrPrev
If SP has ever reported having prostate surgery in the current round or in a previous round =
(HEST.PROSSURG = /1Yes or HEST.PROSRMVD = 1/Yes ) on HEST where (HEST.HESTRND <= current
round).
397
HFRheumArthritis
SP has ever reported having rheumatoid arthritis in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCARTHRH = 1/Yes.
398
HFSkinCancer
SP has ever reported having skin cancer in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCCSKIN = 1/Yes.
386
HFSkippedPrevYear
SP skipped the previous year interview =
There is no HEST where HEST.HESTRND = (current round - 3).
389
HFSmokedPrev
SP was asked if he/she ever smoked cigarettes, cigars, or pipe tobacco in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.EVERSMOK ^= empty.
412
HFTumorGrowth
SP has ever reported having had a tumor, growth or cancer in a previous round =
There is a HEST where HEST.HESTRND < current round and HEST.OCCANCER = 1/Yes.
338
HHCurrentRnd
Person is in the household in the current round =
For this ROST, there is an ENUM where (ENUM.ENUMROST = ROST.ROSTNUM & ENUM.ENUMRND =
current round & ENUM.NOTHHRSN = empty).
163
HHCurrentRound
If SP reported a Home Health visit in the current round =
There is an EVNT & HERO where (HERO.HEROEVNT=EVNT.EVNTNUM & HERO.HERORND=current round
& HERO.HERODFLG ^=1/Yes and (HERO.OTHMEALS^= empty or HERO.HELPUNIT^=empty)).
27-Mar-09
Page 11 of 44
MCBS WVS - Technical Notes
174
HHFriendPrevRnd
SP received Home Health care from friend/relative during previous round =
There is an EVNT where EVNT.EVNTTYPE='HF' & HERO where (HERO.HEROEVNT=EVNTNUM &
HERORND=previous round & HERO.HERODFLG ^=1/Yes & (HERO.OTHMEALS^= empty or
HERO.HELPUNIT^=empty)).
157
HHFriendRelative
Home Health provider is a friend or relative =
PROV.HHFTYPE = 1/Friend or 2/Relative.
105
HHMemberAge
Household member's age =
There is a ROST & ENUM where (ENUM.ENUMROST = ROST.ROSTNUM & ENUM.ENUMRND = current
round).
HH Member's age = ENUM.HHPAGE.
164
HHProfAskedAbout
If SP reported a Home Health Professional in Home Health Summary =
There is an EVNT & HERO where (HERO.HEROEVNT = EVNT.EVNTNUM & HERO.HERORND = current
round & HERO.HERODFLG ^= 1/Yes & HERO.PROFPROB = 1/Yes).
173
HHProfPrevRnd
SP received care from Home Health professional during previous round =
There is an EVNT where EVNT.EVNTTYPE='HP' & HERO where (HERO.HEROEVNT=EVNTNUM &
HERORND=previous round & HERO.HERODFLG ^=1/Yes & (HERO.OTHMEALS^= empty or
HERO.HELPUNIT^=empty)).
158
HHProvGovtChurch
Type of Home Health Provider is a local government, church or community organization =
PROV.HHPLACE = 9/LocalGovernment or 10/Church.
160
HHProviderCurrRnd
Provider has provided HH care in current round =
For this PROV, there is an EVNT where (EVNT.EVNTPROV=PROV.PROVNUM) & a HERO where
(HERO.HEROEVNT=EVNT.EVNTNUM & HERO.HERORND=currend round & HERO.HERODFLG^=1/Yes &
(OTHMEALS ^= empty or HELPUNIT^=empty)).
162
HHProvWorkForSelf
Home Health Provider works for self =
For this PROV, there is an EVNT where (EVNT.EVNTPROV=PROV.PROVNUM) & a HERO where
(HERO.HEROEVNT=EVNT.EVNTNUM & HERO.HERORND=currend round & HERO.HERODFLG^=1/Yes &
(HERO.WORKSFOR=2/WorksForSelf, DK, or RF)).
HI34NotAsked
HI34 has not been asked =
HRND.OTHNHCOV = empty on HRND where HRND.HRNDRND = current round.
90
27-Mar-09
Page 12 of 44
MCBS WVS - Technical Notes
89
HI34NotYes
SP has never reported having insurance that pays just for nursing home or long term care =
HRND.OTHNHCOV = 1/Yes on HRND where HRND.HRNDRND < current round.
91
HI35NotAsked
HI35 has not been asked =
HRND.PRVOCOV = empty on HRND where HRND.HRNDRND=current round.
HI36NotYes
SP did not report receiving health care services through V.A.in the previous round =
HRND.VACOVER ^= 1/Yes on HRND where HRND.HRNDRND=previous round.
HIMC24NeverAsked
The number of years the SP was covered by a managed care plan has never been collected =
BASE.HIMC24FL ^= 1/Yes.
106
HIPlanName
Health Insurance Plan Roster is stored on PLAN.
Plan name = PLAN.PLNAME.
92
HIT11NotYes
SP did not report receiving health care servces from M.T.F in the previous round =
HRND.MTFCOVER^=1/Yes on HRND where HRND.HRNDRND=previous round.
116
HouseholdPrevRnd
Persons who lived in the household at the time of the previous round interview =
There is a ROST & ENUM where (ENUM.ENUMROST = ROST.ROSTNUM & ENUM.ENUMRND = previous
round & ENUM.NOTHHRSN = empty).
211
IAAssetProbeYes
At least one Asset probe at IA23A or IA23B probe was answered "Yes" =
(IRAPROBE, SAVPROVE, BONDPROB, INSPROBE, PROPPROB, CARPROBE, or ASTPROBE = 1/Yes) on
INCO where INCO.INCORND = current round.
210
IAIncomeProbeYes
At least one IA probe at IA1A, IA1B, IA1C, or IA13 is "Yes"=
(SSRRPROB, SSIPROBE, DISAPROB, PENPROBE, JOBPROBE, WELPROBE, RELPROBE, IRAWD,
STOKPROB, LUMPPROB, ESTPROBE, PROPRENT, or OTHPROBE = 1/Yes) on INCO where
INCO.INCORND = current round.
279
InCurrentChargeBundle
Event included in a current round charge bundle =
For this EVNT, there is an XCEV where (XCEV.XCEVEVNT = EVNT.EVNTNUM and XCEV.XCEVCOST =
COST.COSTNUM for this charge bundle & XCEV.XCEVRNDC = current round and XCEV.DELLINK ^= 1/Yes).
132
87
27-Mar-09
Page 13 of 44
MCBS WVS - Technical Notes
259
InsurancePlan
SP covered by Insurance plan other than Medicare during current round =
PLAN where (PLANTYPE = 2/Medicaid, 3/PublicPlan, or 4/PrivatePlan) & PLRO where
(PLROPLAN=PLAN.PLANNUM & PLRORND=current round & COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
361
IPS1orIP1AAsked
IPS1 or IP1A asked in the current round =
(SP was still in a hospital at the time of the previous round interview) or (SP had an emergency room visit in the
current round that resulted in the SP being admitted to hospital).
225
KnowHousing
Type of Housing was reported last time it was asked =
There is a HOUS where HOUS.HOUSTYPE = 1/Yes on the most recent HOUS where HOUS.HOUSTYPE ^=
empty.
421
KNSPNotAware800Line
Whether or not SP is aware of the 1-800-MEDICARE line is unknown =
There is no KNOW where KNOW.KNOWRND < current round and KNOW.KREELINE ^= EMPTY.
422
KNSPNotCall800Line
SP did not report calling 1-800-MEDICARE to get information about Medicare in any previous round =
There is no KNOW where KNOW.KNOWRND < current round and KNOW.KCPHINFO = 1/Yes.
420
KNSPNotCheckWebsite
SP did not report visiting or accessing the official website for Medicare in any previous round =
There is no KNOW where KNOW.KNOWRND < current round and KNOW.KVSITWEB = 1/Yes.
44
LastDMServices
The last time DM4 - DMRO.DMSERVIC was asked for the Discount Membership plan in a previous round is
stored on the most recent DMRO where (DMRO.DMRODMEM= DMEM.DMEMNUM and DMRO.DMSERVIC ^=
EMPTY).
45
LastIntFacility
SP's last interview was in a facility =
MRES.INTTYPE = 2/NewFromFacility, 5/LastRndFacSum, or 6/LastRndFacBase on MRES where
MRES.MRESRND = current round.
104
LastMaritalStatus
SP's last marital status is stored on the most recent HRND where (HRND.HRNDRND < current round and
HRND.SPMARSTA ^= empty).
133
LastStatus
When it's a restart interview, the last SPAISTATUS is stored on LASTSTATUS at BOX IN1 and is used to
compare the status of the SP collected before the breakoff to the current status of the SP.
27-Mar-09
Page 14 of 44
MCBS WVS - Technical Notes
LoadedMHMO
Loaded CMS Medicare Managed Care plan (Medicare Advantage plan) =
There is a PLAN where PLAN.PLANTYPE=5/MHMO and PLAN.MHMOLRND = current round.
Plan name = PLAN.PLNAME.
ManagedCarePlan
SP covered by a Managed Care Plan anytime during
current round =
There is a PLRO.PLROPLAN=PLAN.PLANUM & PLRO.PLRORND=current round &
((PLRO.PPRVHMO=1/Yes) or (PLAN.PLANTYPE = 5/MHMO & PLRO.COVANYTM=1/Yes) or
(PLRO.MCAIDHMO=1/Yes)). See T.N. 52.
150
MCaidAnyTimePrevRnd
SP covered by Medicaid anytime during previous round =
There is a PLAN where PLAN.PLANTYPE=2/Medicaid & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=previous round & PLRO.COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
159
MealsNoOtherServices
HH Provider is a Meal program that did not provide services besides meals =
For this PROV, there is an EVNT where (EVNT.EVNTPROV=PROVNUM) & a HERO where
(HERO.HEROEVNT=EVNTNUM & HERO.HERORND=current round & (HERODFLG^=1/Yes & OTHMEALS =
2/No,DK,RF)).
MedicaidCurrentPrevRnd
Medicaid "current" at the time of the previous round interview =
There is a PLAN where PLAN.PLANTYPE=2/Medicaid and PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRORND=previous round & (COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
358
MedicaidNotCurrent
There is no "current" Medicaid Plan =
If there is PLAN where PLAN.PLANTYPE=2/Medicaid, there is no PLRO where
(PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND = current round & (COVTIME = 1/WholeTime or
COVNOW = 1/Yes)).
Exclude Deleted Plans. See T.N. 52.
263
MedicaidSOP
Medicaid already on SOP roster =
There is a TSOP where TSOP.TSOPPTYP=2/Medicaid.
244
MedicareID
SP's Medicare ID =
Original ID stored on BASE.MCARENUM.
An updated ID may be stored on HRND.NEWMCRRB. Need to look at all HRND records.
50
2
67
27-Mar-09
Page 15 of 44
MCBS WVS - Technical Notes
142
MedicareOnlyPrevRnd
SP only covered by Medicare in previous round =
If there is a PLAN where PLANTYPE ^=1/Medicare, there is no PLRO where
(PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=prev. round & (COVTIME^= empty or
COVANYTM=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
149
MHMOAnyTimePrevRnd
SP covered by Medicare Managed Care plan (Medicare Advantage plan) plan anytime during previous round=
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=previous
round & COVANYTM=1Yes).
Exclude Deleted Plans. See T.N. 52.
381
MHMOAnytimeWithoutRx
SP covered by Medicare Managed Care (Medicare Advantage Plan) without RX during curr. rnd=
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM &
PLRORND=curr.round & COVANYTM=1/Yes & MHMORX^=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
65
MHMOCurrent
SP has a current Medicare Managed Care plan (Medicare Advantage plan) =
There is a PLAN where PLAN.PLANTYPE=5/MHMO & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
51
MHMOCurrPrevRnd
Medicare Managed Care plan (Medicare Advantage plan) "current" at time of previous round interview =
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=previous
round & COVCURNT=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
344
MHMOCurrWithRx
SP has "current" Medicare Managed care plan (Medicare Advantage plan) with RX coverage=
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=current
round & COVCURNT=1/Yes & MHMORX=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
143
MHMOLoadedCMS
Medicare Managed Care plan (Medicare Advantage plan) loaded by CMS =
There is PLAN where PLAN.PLANTYPE=5/MHMO and PLAN.MHMOLRND ^= empty.
27-Mar-09
Page 16 of 44
MCBS WVS - Technical Notes
356
MHMONotCurrent
There is no "current" Medicare Managed Care plan (Medicare Advantage plan) =
If there is a PLAN where PLANTYPE = 5/MHMO, there is no PLRO where (PLROPLAN=PLANNUM &
PLRORND=current round and COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
372
MHMORxAnytime
SP had Medicare Managed Care plan (Medicare Advantage plan) with RX coverage during curr.rnd=
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=curr.rnd
& COVANYTM=1/Yes & MHMORX=1/Yes)). Exclude Deleted Plans. See T.N.52.
370
MHMORxPastYear
SP report Medicare Managed Care plan (Medicare Advantage plan) with RX coverage in past year=
There is a PLAN where PLANTYPE = 5/MHMO & PLRO where (PLROPLAN=PLANNUM &
PLRORND>=(current round - 2) & MHMORX=1/Yes).
Exclude Deleted Plans. See T.N. 52.
MIP
Main insured person (MIP) for this PLAN =
PLAN.PLMIPNUM.
MIP name = ROST.ROSTFNAM + ROST.ROSTLNAM on ROST where ROST.ROSTNUM = PLAN.PLMIPNUM.
208
MIPPrevRnd
Main insured person (MIP) for this PLAN from previous round =
PLAN.PLMIPNUM.
MIP name = ROST.ROSTFNAM + ROST.ROSTLNAM on ROST where ROST.ROSTNUM = PLAN.PLMIPNUM.
124
MissingDOB
Person missing any part of date of birth at the time of previous round interview =
Fort this ROST, there is an ENUM where (ENUM.ENUMROST=ROST.ROSTNUM & ENUM.ENUMRND=prev.
round & ((EHHDOBMM=DK or RF) or (EHHDOBDD=DK or RF) or (EHHDOBYY = DK or RF))).
221
MovePrevYR
SP moved in the previous year =
(HRND.SPMOVED = 1/Yes or HRND.ADDRMOVE = 1/Yes) on HRND where HRND.HRNDRND > (current
round - 3).
351
MPDPAnytimeCurrRnd
SP covered by an MPDP plan anytime during current round =
There is a PLAN where PLAN.PLANTYPE=7/MPDP & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.COVANYTM=1/Yes).
Exclude Deleted Plans. See T.N. 52.
82
27-Mar-09
Page 17 of 44
MCBS WVS - Technical Notes
380
MPDPAnytimePrevRnd
SP covered by an MPDP plan anytime during previous round =
There is a PLAN where PLAN.PLANTYPE=7/MPDP & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=previous round & PLRO.COVANYTM=1/Yes).
Exclude Deleted Plans. See T.N. 52.
368
MPDPBenefitStatement
Statement Charge Bundle is a Medicare Prescription Drug Benefit Statement =
COST.STATTYPE = 8/MPDPBenefit.
342
MPDPCurrent
SP has a "current" Medicare Prescription Drug plan =
There is a PLAN where PLAN.PLANTYPE=7/MPDP & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
343
MPDPCurrPrevRnd
Medicare Prescription Drug plan "current" at time of previous round interview=
There is a PLAN where PLAN.PLANTYPE=7/MPDP & PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=previous round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
357
MPDPNotCurrent
There is no "current" MPDP =
If there is a PLAN were PLAN.PLANTYPE = 7/MPDP, there is no PLRO where
(PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND = current round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
168
MPUtilizationCheck
SP reported utilization during the current round [up to MP section] =
DU1-DUPROBE, ER1-ERPROBE, IP1-IPPROBE, OP1-OPPROBE, IU-IUPROBE, HH1-HHPRPROF, HH18HHPRFRND, MP1-MPPRMDOC, MP18-MPPRPRAC, MP26-MPPRMENT, MP34-MPPRTHER, or MP42MPPRPERS=1/Yes.
190
NeedNumOfPurchases
PM reported in the current round utilization that does not have number of purchases entered =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND =
current round & PMRO.GETNUM = empty & PMRO.PMRODFLG ^= 1/Yes).
NeverEnrollMHMO
SP never enrolled in Medicare Managed Care plan(Medicare Advantage plan) =
There is no PLAN where PLAN.PLANTYPE = 5/MHMO.
Exclude Deleted Plans. See T.N. 52.
60
27-Mar-09
Page 18 of 44
MCBS WVS - Technical Notes
261
NeverInsurancePlan
SP never had a health insurance plan other than Medicare or Tricare =
There is no PLAN where (PLAN.PLANTYPE = 2/Medicaid, 3/PublicPlan, or 4/PrivatePlan).
Exclude Deleted Plans. See T.N. 52.
341
NeverMedicarePresDrugPlan
No Medicare Prescription Drug plan ever reported in any round =
There is no PLAN where PLAN.PLANTYPE = 7/MPDP.
Exclude Deleted Plans. See T.N. 52.
262
NeverTricare
SP never had a Tricare plan =
There is no PLAN where PLAN.PLANTYPE = 6/Tricare.
Exclude Deleted Plans. See T.N. 52.
NewFromFacility
SP is new from facility (i.e. all previous round interviews were in a facility) =
MRES.INTTYPE=2/NewFromFacility on MRES where MRES.MRESRND = current round.
249
NoFallSupps
SP did not receive the SC section in the previous year =
BASE.HSRNDSKP = 1/Yes.
219
NoHA
SP did not receive the HA section in the previous year =
There is no HOUS where HOUS.HOUSRND = (current round – 3).
120
NonHHPersons
Persons already identified as living in the household or as no longer living in the household will have a current
round ENUM where ENUM.ENUMROST=person's ROST.ROSTNUM and ENUM.ENUMRND=current round.
All other person's will not have a current round ENUM.
337
NotHHPrevRnd
Person was not in the Household in the previous round =
For this ROST, there is no ENUM where (ENUM.ENUMROST = ROST.ROSTNUM & ENUM.ENUMRND =
previous round & ENUM.NOTHHRSN = empty).
232
NothingPaid
Nothing paid or Respondent does not know if anything has been paid =
CORO.TCHGPAID = 2/No or DK on CORO where (CORO.COROCOST = this COST.COSTNUM and
CORO.CORORND = current round).
367
NSChargeBundle
Charge Bundle is a No Statement Charge Bundle =
COST.COSTTYPE = 2/NS.
25
27-Mar-09
Page 19 of 44
MCBS WVS - Technical Notes
436
NSChargeDataCollected
If charge data was collected in NS for this NS charge bundle =
COST.NSEXMCMAIL = 2/No or NULL (not asked).
437
NSLinkedOneEvent
NS charge bundle linked to only one event =
There is only one XCEV where XCEV.XCEVCOST = COST.COSTNUM for this charge bundle and
XCEV.XCEVRNDC = current round and XCEV.DELLINK ^= 1/Yes.
440
NSPMEvent
If event linked to NS charge bundle is a PM event (there will only be one event) =
EVNT.EVNTTYPE = 'PM'.
415
NSPMPurchases
The number of PM purchases reported in current round PM=
For PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND = current
round & PMRO.PMRODFLG ^= 1/Yes).
Number of PM purchases = PMRO.GETNUM.
414
NSPMSPurchases
The number of PM purchases reported in current round PMS=
For PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND =
previous round & PMRO.PMSUMFLG = 1/Yes & PMRO.PMRODFLG ^= 1/Yes).
Number of PM purchases = PMRO.GETNUM.
182
NumberOfPurchases
The number of purchases for PM or OM =
For the OM or PM EVNT, there is PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND =
current round).
Number of purchases = PMRO.GETNUM.
136
NumberRepeatVisits
Number of Repeat Visits =
EVNT.RVTIMES.
204
NumOMPurchases
Number of OM purchases in current round =
For this OM EVNT, there is a PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND =
current round.)
Number of purchases = PMRO.GETNUM.
247
OMPurchases
Other Medical Expense Item is Ostomy Supplies, Incontinence Supplies, or Bandages =
EVNT.OTHRTYPE = 5/OstomySupplies, 6/IncontinenceSupplies, or 7/Bandages.
27-Mar-09
Page 20 of 44
MCBS WVS - Technical Notes
242
OMRental
Other Medical Expense Item is Rented =
EVNT.RENTPROB = 2/Rent.
267
OnlyMedicare
SP does not have plan other than Medicare =
There is no PLAN where PLAN.PLANTYPE ^=1/Medicare.
Exclude Deleted Plans. See T.N. 52.
416
OnlyMedicareCurrRnd
SP does not have plan besides Medicare in current round =
If there is PLAN where PLANTYPE ^=1/Medicare, there is no PLRO where (PLRO.PLROPLAN=PLANNUM &
PLRO.PLRORND=curr. round & (COVTIME^=empty or COVANYTM=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
229
ORPBefore
Event date is before Survey Reference Period =
NEED TO REVIEW CODE. WHAT ABOUT IP STAYS.
246
ORPEvent
Existing Event Date is outside survery reference period =
EVNT.EVORPFLAG = 1/ORP.
New event is Out of the Survey Reference Period =
See general specifications for Date check logic for determing ORP events.
438
OtherNSPMEvents
To check for other current round PM events not linked to a current round charge bundle, use logic at BOX
NSBEG to identify other PM events that still need to be asked about in NS.
439
OtherNSVisits
To check for other events for this Provider not linked to a current round charge bundle, use logic at BOX
NSBEG to identify other events that still need to be asked about in NS. EVNT.EVNTPROV must match this
EVNT.EVNTPROV.
198
OtherOMSupplies
Other Medical Expense Item is Supplies =
EVNT.OTHRTYPE = 5/OstomySupplies, 6/IncontinenceSupplies, or 7/Bandages.
350
OverlapERIPOPStay
Event date overlaps an existing IP stay or Event date matches an existing ER or OP event date =
See general specifications for detailed date logic check.
172
OverlapIPstay
Event date overlaps an existing IP stay =
See general specifications for detailed database logic check.
27-Mar-09
Page 21 of 44
MCBS WVS - Technical Notes
432
PDAutoEnrollCurPln
If SP has reported being automatically enrolled in the "current" Medicare Prescription Drug Plan =
PDRX.PDAUTENR = /1Yes where HEST.HESTRND = current round.
431
PDAutoEnrollPrev
If SP has reported being automatically enrolled in a Medicare Prescription Drug Plan in any previous round =
PDRX.PDEVROLL = /1Yes where HEST.HESTRND < current round.
433
PDComparePlans
If respondent did not compare Medicare Prescription Drug Plans = PD.PDCOMPRE = 1/ Yes where
HEST.HESTRND = current round.
121
PersonAlreadyNotHH
Persons already identified as no longer living in the household in the current round =
There is a ROST & ENUM where (ENUM.ENUMROST= ROST.ROSTNUM and ENUM.ENUMRND=current
round and ENUM.NOTHHRSN ^= empty).
227
PersonalServices
SP had access to at least one personal service at HA12 =
(HOUS.MEALPROB = 1/Yes or HOUS.MAIDPROB = 1/Yes or HOUS.WASHPROB = 1/Yes or
HOUS.HELPPROB = 1/Yes or HOUS.TRANPROB = 1/Yes or HOUS.RECPROB = 1/Yes) on HOUS where
HOUS.HOUSRND=current round.
330
PersonContactCurrentRound
Person is already identified as a contact in the current round =
Person's ROST.ROSTNUM = tblCL.CONTNUM1 or tblCL.CONTNUM2 on tblCL where tblCL.CLRnd = current
round.
110
PersonHelper
Person identified as a Helper to SP =
For this ROST, there is a HLPR where (HLPR.HLPRROST = ROST.ROSTNUM and HLPR.HLPRRND=current
round ).
329
PersonInHHCurrentRound
Person is already identified as living in the household in the current round =
For this ROST, there is an ENUM where (ENUM.ENUMROST = ROST.ROSTNUM and ENUM.ENUMRND =
current round and ENUM.NOTHHRSN = empty).
377
PersoninHHCurrRnd
At least one person lives with the SP in the current round =
There is at least one ROST & ENUM where (ENUM.ENUMROST = ROST.ROSTNUM & ENUM.ENUMROST ^=
'01' & ENUM.ENUMRND = current round & ENUM.NOTHHRSN=empty).
352
PersonIsDeceased
Persons identified as being deceased =
There is a ROST & ENUM where (ENUM.ENUMROST=ROST.ROSTNUM & ENUM.ENUMRND=any round &
ENUM.NOTHHRSN = 1/Deceased).
27-Mar-09
Page 22 of 44
MCBS WVS - Technical Notes
PersonIsProxy
Person selected from Person roster is proxy =
For this ROST, MRES.RROSTNUM = ROST.ROSTNUM on MRES where MRES.MRESRND = current round.
113
PersonName
The Person Roster is stored on ROST.
The persons' name = ROST.ROSTFNAM + ROST.ROSTLNAM.
The person's relationship to SP = ROST.ROSTREL, ROST.ROSTREOS.
119
PersonNewInHH
Person is a new Household member in the current round =
Person was not a household member in the previous round and was selected at ENS4 as a household member
in the current round. See T.N.s 337 and 338.
429
Phone1CurrentSP
SP's current round primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='1').
427
Phone1PreviousSP
SP's previous round primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' & tblPHONE.PhoneRnd = previous round &
tblPHONE.PhoneInstance='1').
430
Phone2CurrentSP
SP's current round secondary phone number =tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' & tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01'
& tblPHONE.PhoneRnd = current round & tblPHONE.PhoneInstance='2').
428
Phone2PreviousSP
SP's previous round secondary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' & tblPHONE.PhoneRnd = previous round &
tblPHONE.PhoneInstance='2').
285
PhonePrevBestCollected
A phone number for arranging the next interview has been collected =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = previous round and
tblPHONE.PhoneType = 'BEST' and tblPHONE.PhoneDetail = 'BEST'.
321
PhonePreviousBest
Previous best phone number for arranging the next interview =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where tblPHONE.PhoneRnd = previous
round and tblPHONE.PhoneType = 'BEST' and tblPHONE.PhoneDetail = 'BEST'.
7
27-Mar-09
Page 23 of 44
MCBS WVS - Technical Notes
312
PhonePrevNextInterview
Previously reported phone number that is best for arranging the next interview =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where tblPHONE.PhoneRnd = previous
round and tblPHONE.PhoneType = 'BEST' and tblPHONE.PhoneDetail = 'BEST'.
332
PhonePrevVacHome
Previous Vacation Home phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where tblPHONE.PhoneRnd = previous
round & tblPHONE.PhoneType = 'SecondHome' & tblPHONE.PhoneDetail = 'SecondHome' &
tblPHONE.PhoneInstance='1';
302
PhonePrimaryContact1
The First Contact's Primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost = current round
tblCL.CONTNUM1 and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '1').
304
PhonePrimaryContact2
The Second Contact's Primary phone number =
blPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost = current round
tblCL.CONTNUM2 and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '1').
300
PhonePrimaryProxy
Proxy's current round Primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost =
MRES.RROSTNUM and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '1').
282
PhonePrimarySP
SP's current primary phone information =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance = '1').
296
PhonePrimCollectedContact1
A Primary Phone number was collected for the First Contact =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = current round tblCL.CONTNUM1 and tblPHONE.PhoneInstance = '1';
297
PhonePrimCollectedContact2
A Primary Phone number was collected for the Second Contact =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = current round tblCL.CONTNUM2 and tblPHONE.PhoneInstance = '1';
284
PhonePrimCollectedProxy
A Primary Phone number was collected for Proxy =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = MRES.RROSTNUM and tblPHONE.PhoneInstance = '1';
27-Mar-09
Page 24 of 44
MCBS WVS - Technical Notes
291
PhonePrimCollectedSP
A Primary Phone number was collected for SP =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneType = 'SP' & tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' &
tblPHONE.PhoneInstance = '1';
335
PhonePrimFutureProxy
The Future Proxy's Primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where tblPHONE.PhoneRnd = current round
and tblPHONE.PhoneRost = tblCL.FProxNum on tblCL where tblCL.CLRnd = current round, and
tblPHONE.PhoneInstance = '1';
310
PhoneSecCollectedContact1
A Secondary Phone number was collected for the First Contact =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = current round tblCL.CONTNUM1 and tblPHONE.PhoneInstance = '2';
311
PhoneSecCollectedContact2
A Secondary Phone number was collected for the Second Contact =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = current round tblCL.CONTNUM2 and tblPHONE.PhoneInstance = '2';
308
PhoneSecCollectedProxy
A Secondary Phone number was collected for Proxy =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round and
tblPHONE.PhoneRost = MRES.RROSTNUM and tblPHONE.PhoneInstance = '2';
309
PhoneSecCollectedSP
A Secondary Phone number was collected for SP =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneType = 'SP' & tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' &
tblPHONE.PhoneInstance = '2';
336
PhoneSecFutureProxy
The Future Proxy's Secondary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where tblPHONE.PhoneRnd = current round
and tblPHONE.PhoneRost = tblCL.FProxNum on tblCL where tblCL.CLRnd = current round, and
tblPHONE.PhoneInstance = '2';
303
PhoneSecondaryContact1
The First Contact's Secondary phone number =
blPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost = current round
tblCL.CONTNUM1 and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '2').
27-Mar-09
Page 25 of 44
MCBS WVS - Technical Notes
305
PhoneSecondaryContact2
The Second Contact's Secondary phone number =
blPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost = current round
tblCL.CONTNUM2 and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '2').
301
PhoneSecondaryProxy
Proxy's current round Secondary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.AddrRost =
MRES.RROSTNUM and tblPHONE.AddressRnd = current round and tblPHONE.PhoneInstance = '2').
283
PhoneSecondarySP
SP's current secondary phone information =
tblPHONE.TPHONAREA, PHONEXCH, PHONLOCL on tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost = '01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance = '2').
331
PhoneVacHomeCollected
If a phone number has been collected for SP's Vacation Home=
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE where tblPHONE.PhoneRnd = previous round &
tblPHONE.PhoneType = 'SecondHome' & tblPHONE.PhoneDetail = 'SecondHome' &
tblPHONE.PhoneInstance='1';
187
PillsSuppPatches
PM form is stored on PMRO where PMRO.PMRORND = round # checking and PMRO.PMROEVNT =
EVNT.EVNTNUM of PM being asked about:
Pills: PMRO.PMFORM = 1/Pills
Suppositories: PMRO.PMFORM = 5/Suppositories.
Patches: PMRO.PMFORM=10/Patches.
145
PlanCoveredPrevRnd
SP covered by PLAN anytime during prev.round =
There is a PLAN where PLAN.PLANTYPE ^= 1/Medicare & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
& PLRO.PLRORND=prev. round & (PLRO.COVTIME ^= empty or PLRO.COVANYTM=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
144
PlanCurrPrevRnd
Plan was "current" at the time of prev. round interview =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & (COVTIME=1/WholeTime or COVNOW=1/Yes or COVCURNT=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
27-Mar-09
Page 26 of 44
MCBS WVS - Technical Notes
PlanIsCurrent
If plan is "current" =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current
round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes or PLRO.COVCURNT=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
107
PlanIsMCaidHMO
SP is covered by a Medicaid Managed Care Plan during the current round =
There is a PLAN where PLAN.PLANTYPE=2/Medicaid & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.MCAIDHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
111
PlanIsMCareHMO
SP is covered by a Medicare Managed Care Plan (Medicare Advantage plan) during the current round =
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=current
round & COVANYTM=1/Yes).
Exclude Deleted Plans. See T.N. 52.
112
PlanIsPrivateHMO
SP is covered by a Private Managed Care Plan during the current round =
There is a PLAN where PLAN.PLANTYPE=4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
& PLRO.PLRORND=current round & PLRO.PPRVHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
PlanTypes
Medicare: PLANTYPE=1/Medicare.
Medicaid: PLANTYPE=2/Medicaid.
Medicare Advantage: PLANTYPE=5/MHMO.
Tricare: PLANTYPE=6/Tricare.
Public: PLANTYPE=3/PublicPlan.
Private: PLANTYPE=4/PrivatePlan.
Medicare Prescription Drug: PLANTYPE=7/MPDP.
131
PMBottleProbe
Prescription Medicine Bottle probe has been asked in the current round =
GETPMMEDS=1/Yes.
180
PMCondition
Condition reported for the PM =
For this PM EVNT, there is an XCON where (XCON.XCONEVNT=EVNT.EVNTNUM) and (XCON.XCONCOND
= COND.CONDNUM of condition linked to PM EVNT).
Condition Name = COND.CONDTION.
95
53
27-Mar-09
Page 27 of 44
MCBS WVS - Technical Notes
177
PMCurrentUtilization
SP reported PMs in the current round utilization =
There is an EVNT & PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND = current
round & PMRO.PMROTYPE = 'PM' and PMRO.PMRODFLG ^= 1/Yes).
Medicine Name = EVNT.PMEDNAME.
178
PMCurrRnd
SP reported PM purchase(s) in current round =
There is an EVNT & PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND=current round
& PMRO.PMROTYPE='PM' & PMRO.PMRODFLG^=1/Yes & (GETNUM > 0 or GETNUM = DK or RF)).
Medicine Name=EVNT.PMEDNAME.
417
PMDrugCoverageCurrRnd
SP had PM drug coverage current round =
There is a PLAN & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current round &
(MCDRXCOV=1/Yes or TRIRXCOV=1/Yes or PUBRXCOV=1/Yes or PRVRXCOV=1/Yes or MHMORX=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
371
PMLinkedChargeBundle
There is a PM Event linked to charge bundle =
For this COST, there is an XCEV where (XCEV.XCEVCOST=COST.COSTNUM & XCEV.DELLINK^=1/Yes &
XCEV.XCEVEVNT=EVNT.EVNTNUM for EVNT where (EVNT.EVNTTYPE=PM & EVNT.EVNTDFLG^=1/Yes)).
441
PMOftenSometimes
AT LEAST ONE RESPONSE AT PM6AB = 1/OFTEN OR 2/SOMETIMES =
PM6AB - RXNOFILL = 1/OFTEN OR 1/SOMETIMES, OR
PM6AB - RXDELAY = 1/OFTEN OR 1/SOMETIMES, OR
PM6AB - RXSKIP = 1/OFTEN OR 1/SOMETIMES, OR
PM6AB - RXDOSE = 1/OFTEN OR 1/SOMETIMES.
176
PMPrevRnd
SP reported PM purchase(s) in previous round =
There is an EVNT & PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM & PMRO.PMRORND=previous
round & PMRO.PMROTYPE='PM' & PMRO.PMRODFLG^=1/Yes & (GETNUM>0 or GETNUM = DK or RF)).
Medicine Name=EVNT.PMEDNAME.
353
PrevDrivingDirections
Driving directions reported in the previous round =
IRQS.IRDRIVEVB ^= empty on IRQS where IRQS.IRQSRND = previous round.
IRQS.IRDRIVEVB is stored in multiple VB fields in Cheshire, IRQS.IRDRIVE1 through IRQS.IRDRIVE9.
27-Mar-09
Page 28 of 44
MCBS WVS - Technical Notes
196
PrevManagedCarePlan
SP covered by a Managed Care Plan anytime during previous round =
There is a PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=prev. round &
((PLRO.PPRVHMO=1/Yes) or (PLAN.PLANTYPE = 5/MHMO & PLRO.COVANYTM=1/Yes) or
(PLRO.MCAIDHMO=1/Yes)). See T.N. 52.
194
PrevNumOfPurchases
The number of purchases for a PM in the previous round =
For this PM EVNT, there is PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM & PMRO.PMRORND =
previous round.)
Number of purchases = PMRO.GETNUM.
PrevResp
SP was the respondent in the previous round =
MRES.PREVSPPR=1/SP on MRES where MRES.MRESRND = current round.
13
Proxy was respondent in previous round =
MRES.PREVSPPR=2/Proxy on MRES where MRES.MRESRND = current round.
14
PrevRespProxy
Proxy was respondent in previous round =
MRES.PREVSPPR=2/Proxy on MRES where MRES.MRESRND = current round.
188
PrevRndAmount
The previous round amount for the PM =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT = EVNT.EVNTNUM and PMRO.PMRORND =
previous round).
PM amount = PMRO.AMTUNIT, PMRO.AMTUNOS, PMRO.AMTNUM.
156
PrevRndFallRnd
Previous round interview was a Fall Round =
If the remainder of (Previous round divided by 3) = 1, then it was a Fall round.
181
PrevRndForm
Previous round form for PM =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT= EVNT.EVNTNUM and PMRO.PMRORND =
previous round).
PM form = PMRO.PMFORM, PMRO.PMFORMOS.
183
PrevRndStrength
Previous round strength for PM =
For this PM EVNT, there is a PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM &
PMRO.PMRORND=previous round).
Strength =STRNUNIT, STRNUNOS, STRNNUM, STRNPER
If compound, 2nd strength= STRNUNI2, STRNUNO2, STRNNUM2, STRNPER2.
27-Mar-09
Page 29 of 44
MCBS WVS - Technical Notes
289
PrevVacHomeCollected
Vacation Home has been collected for SP =
tblADDRESS.STAddr1 ^= empty on tblADDRESS where (tblADDRESS.AddressRnd = previous round &
tblADDRESS.AddressType = 'SecondHome' & tblADDRESS.AddressDetail = 'SecondHome').
153
PrivateAnyTimePrevRnd
SP covered by Private plan anytime during previous round =
There is a PLAN where PLAN.PLANTYPE=4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
and PLRO.PLRORND=previous round & PLRO.COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
81
PrivateCurrentPrevRnd
Private plan "current" at the time of previous round interview =
There is a PLAN where PLAN.PLANTYPE=4/PrivatePlan & PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRORND=prev. round & (COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
83
PrivateNew
Private Plan is new =
PLAN.PLANTYPE=4/PrivatePlan and PLAN.PLANRNDC = current round and PLAN.PLANSUMM ^= 1/Yes.
Exclude Deleted Plans. See T.N. 52.
PrivateNotCurrent
There is no "current" Private Plan =
If there is PLAN where PLAN.PLANTYPE = 4/PrivatePlan, there is no PLRO where
(PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current round & (COVTIME=1/WholeTime or
COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
84
PrivateRestarted
Private Plan has been restarted =
For this PLAN, there is no PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND = previous
round & (COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
362
PrivHMOAnytime
SP covered by Private Managed Care Plan anytime during current round =
There is a PLAN where PLANTYPE=4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=current round & PLRO.PPRVHMO=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
360
27-Mar-09
Page 30 of 44
MCBS WVS - Technical Notes
364
PrivHMOAnytimePrevrnd
SP covered by a Private Managed Care Plan anytime during prev. round =
There is a PLAN where PLANTYPE = 4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=previous round & PLRO.PPRVHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
354
PrivPlanCurrWithRx
SP has a "current" Private Plan with RX coverage =
There is a PLAN where PLANTYPE=4/PrivatePlan & PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRORND=current round & (COVTIME=1/WholeTime or COVNOW=1/Yes) & PRVRXCOV=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
129
ProviderAssocHMO
Provider is associated with a Managed Care plan =
PROV.HMOASSOC=1/Yes.
128
ProviderHMOUnknown
If Provider is associated with a Managed Care plan is unknown =
PROV.HMOASSOC=empty.
175
ProviderMealProgram
Type of Home Health Provider Organization is a Meal Program =
PROV.HHPLACE=2/MealProgram.
171
ProviderMedicalDoctor
Provider Specialty is a Medical Doctor =
PROV.PROVSPEC=2/MedicalDoctor
169
ProviderMedicalPlace
Provider is a Medical Place =
Provider selected following MP50 Probe, MPPRPLAC = 1/Yes.
109
ProviderName
Provider Roster is stored on PROV.
Provider Name = PROV.PROVNAME.
245
ProviderNotHHEvent
Provider not associated with Home Health Event =
For this PROV, there is no EVNT where (EVNT.EVNTPROV=PROV.PROVNUM & (EVNT.EVNTTYPE = 'HP' or
'HF') & EVNT.EVNTDFLG ^= 1/Yes).
130
ProviderNotHMO
Provider is not associated with a Managed Care plan =
PROV.HMOASSOC=2/No, DK, or RF.
27-Mar-09
Page 31 of 44
MCBS WVS - Technical Notes
170
ProviderSpecCollected
Provider Specialty has already been collected =
PROV.PROVSPEC ^= EMPTY.
Provider Specialty has not been collected =
PROV.PROVSPEC = EMPTY.
127
ProviderVAUnknown
If Provider is associated with V.A. is unknown =
PROV.VAPLACE = empty.
382
ProvSpecCheck
Provider Specialty listed in BOX MP2C =
PROV.PROVSPEC =1/Dentist, 2/MedicalDoctor, 16/Optometrist, 17/Osteopath, 18/Paramedic,
20/PhysicianAssistant, 21/Podiatrist, 91/Other, DK or RF.
If PROV.PROVSPEC is collected at MP2A if not already reported.
ProxyAddressDuplicate
Proxy's previous round address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddrRost =
MRES.RROSTNUM & tblADDRESS.AddressRnd = previous round).
ProxyHHPrevRnd
Proxy lived in the household at the time of the previous round interview =
For ROST where ROST.ROSTNUM=MRES.RROSTNUM, there is a ENUM where (ENUM.ENUMROST =
ROST.ROSTNUM & ENUM.ENUMRND = previous round & ENUM.NOTHHRSN = empty).
18
ProxyINHousehold
Proxy lives with SP in the current round =
For this ROST where ROST.ROSTNUM=MRES.RROSTNUM, there is an ENUM where
(ENUM.ENUMROST=ROST.ROSTNUM & ENUM.ENUMRND=current round & ENUM.NOTHHRSN=empty).
15
ProxyName
Proxy's name and relationship =
Stored on ROST where ROST.ROSTNUM=MRES.RROSTNUM.
First Name: ROST.ROSTFNAM
Last Name: ROST.ROSTLNAM
Relationship: ROST.ROSTREL.
If ROST.ROSTREL=91/OtherRelative or 92/OtherNon-Relative, Relationship=ROST.ROSTREOS.
PSEvent
SP still expects charges for a rental item entered in a previous round =
There is an EVNT where EVNT.EVNTDFLG ^= 1/Yes & (EVNT.EVNTTYPE = 'OM') & (EVNT.RENTSTILL
=2/No, DK or RF) and (EVNT.RENTENDR < current round) & (EVNT.RBUYCOST = 1/StillCollectCost).
17
122
278
27-Mar-09
Page 32 of 44
MCBS WVS - Technical Notes
152
PublicAnyTimePrevRnd
SP covered by Public plan anytime during previous round =
There is a PLAN where PLAN.PLANTYPE=3/PublicPlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
& PLRO.PLRORND=previous round & PLRO.COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
80
PublicCurrentPrevRnd
Public plan "current" at the time of previous round interview =
There is a PLAN where PLAN.PLANTYPE=3/PublicPlan & PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRORND=previous round & (COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
85
PublicNew
Public Plan is new =
PLAN.PLANTYPE=3/PublicPlan and PLAN.PLANRNDC = current round and PLAN.PLANSUMM ^= 1/Yes.
Exclude Deleted Plans. See T.N. 52.
PublicNotCurrent
There is no "current" Public Plan =
If there is a PLAN where PLAN.PLANTYPE = 3/PublicPlan, there is no PLRO where
(PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current round & (COVTIME=1/WholeTime or
COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
86
PublicRestarted
Public Plan has been restarted =
For this PLAN, there is no PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND = previous
round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
222
RecentDwelling
SP's most recent Type of Dwelling collected =
HA1-DWELLING if HA1 asked in current round.
Otherwise, the most recent type of dwelling collected will be the most recent HOUS record where
HOUS.DWELLING ^= empty.
223
RecentHousing
SP's most recent Type of Housing collected =
HA10-HCOMUNTY if HA10 asked in current round. Otherwise, the most recent type of community collected
will be the most recent HOUS record where HOUS.HCOMUNTY ^= empty.
359
27-Mar-09
Page 33 of 44
MCBS WVS - Technical Notes
24
RecentRespondent
SP was most recent respondent =
MRES.SPPROXY=1/SP on MRES where MRES.MRESRND = current round.
Proxy was most recent respondent = MRES.SPPROXY=2/Proxy on MRES where MRES.MRESRND = current
round.
MRES.RROSTNUM = ROST.ROSTNUM of respondent.
135
4
RepeatVisitEvent
If Event entered as a Repeat Visit =
EVNT.VISTTYPE=2/RepeatVisit.
Respondent
On MRES where MRES.MRESRND = current round:
A Proxy interview (respondent is a proxy) =
MRES.SPPROXY=2/Proxy.
MRES.RROSTNUM=ROST.ROSTNUM of respondent.
An SP interview (respondent is the SP) =
MRES.SPPROXY=1/SP.
MRES.RROSTNUM='01'.
RestartInterview
If this is a restart interview =
MRES.EVRESTRT=1/Yes on MRES where MRES.MRESRND = current round.
434
RXPD18Yes
If respondent answered "YES" to more than one question at RXPD18 =
More than one of the following fields = 1/Yes:
RXPD18 - PDOPTPRE
RXPD18 - PDOPTDUC
RXPD18 - PDOPTFOR
RXPD18 - PDOPTVEN
RXPD18 - PDOPTREC
RXPD18 - PDOPTGAP
RXPD18 - PDOPTPAY
43
SameResp
When it's a restart interview, the last respondent #, RROSTNUM, is stored on LASTRESP at BOX IN1 and is
used to compare the respondent information collected before the last breakoff to the current respondent
information.
42
27-Mar-09
Page 34 of 44
MCBS WVS - Technical Notes
166
SomeoneWorksForProv
If someone works for this Provider =
PROV.SUBPROV ^= empty.
374
SOPDmem
Source of Payment is a Discount Membership Plan =
TSOP.TSOPISHI = 8/DM.
253
SOPIsMHMO
Source Of Payment is a Medicare Managed Care Plan (Medicare Advantage plan) =
TSOP.TSOPISHI = 7/MHMO.
339
SOPIsOSOP
Source of Payment is an "Other Source of Payment" =
TSOP.TSOPISHI = 4/NotHIPlanVA, 5/MilitaryPlanNotVA, or 6/NotSPsPlan.
248
SOPPlan
Source of Payment is a HI Plan =
Medicaid: TSOP.TSOPISHI=1/Medicaid
Public: TSOP.TSOPISHI=2/PublicPlan
Private: TSOP.TSOPISHI=3/PrivatePlan
MHMO: TSOP.TSOPISHI=7/MHMO
Tricare: TSOP.TSOPISHI=9/Tricare.
MPDP: TSOP.TSOPISHI=10/MedicarePartD
103
SPAge
SP's AGE is calculated based on SP's ROST.HHDOBMM, ROST.HHDOBDD, ROST.HHDOBYY and TODAY
and is stored on ENUM.HHPAGE where ENUM.ENUMRND = current round and ENUM.ENUMROST = 01.
101
SPDateofBirth
SP's Date of Birth is stored on ROST where ROST.ROSTNUM='01'.
Month: ROST.HHDOBMM
Day: ROST.HHDOBDD
Year: ROST.HHDOBYY
274
SPDateOfDeath
SP's Date of Death =
On MRES where MRES.MRESRND = current round:
Month = MRES.SPDIEMM
Day = MRES.SPDIEDD
Year = MRES.SPDIEYY
27-Mar-09
Page 35 of 44
MCBS WVS - Technical Notes
273
SPDateOfInstitute
SP's Date of Institutionalization =
On MRES where MRES.MRESRND = current round:
Month = MRES.SPINSTMM
Day = MRES.SPINSTDD
Year = MRES.SPINSTYY
SPDeceased
SP is deceased =
MRES.SPALIVE=3/Deceased on MRES where MRES.MRESRND = current round.
SPFamilyPayment
SP/Family Payment =
For this COST, there is PAYM where (PAYM.PAYMCOST = COST.COSTNUM & PAYM.PAYMTYPE =
1/SPFamily & PAYM.PAYMDFLG^-1/Yes).
SP/family payment = PAYM.PAYMAMT.
SPFemale
SP is female =
ROST.ROSTSEX=2/Female on ROST where ROST.ROSTNUM='01'.
26
SPHadERVisit
SP had ER visit in current round or 2 previous rounds =
There is an EVNT where (EVNT.EVNTTYPE=ER and EVNT.EVNTDFLG^=1/Yes and EVNT.EVNTRNDC >=
current round - 2).
46
SPHadMHMO
SP was covered by Medicare Managed Care plan (Medicare Advantage plan) anytime during current round =
There is a PLAN where PLANTYPE=5/MHMO & PLRO where (PLROPLAN=PLANNUM & PLRORND=current
round & COVANYTM=1/Yes).
Exclude Deleted Plans. See T.N. 52.
28
SPHadMPVisit
SP had MP visit current round or 2 prev.rounds =
There is an EVNT where ((EVNTRNDC>=(current round - 2)) & EVNTTYPE=MP & EVNTDFLG^=1/Yes &
MPIPSTAY ^=1/Yes & ((MPTYPE = 1/MedicalDoctor) or (PROV.PROVSPEC=2/MedicalDoctor on PROV where
PROVNUM=EVNTNUM))).
27
SPHadOPVisit
SP had OP visit in current round or 2 previous rounds =
There is an EVNT where (EVNT.EVNTTYPE=OP and EVNT.EVNTDFLG^=1/Yes and EVNT.EVNTRNDC >=
current round - 2).
41
234
6
27-Mar-09
Page 36 of 44
MCBS WVS - Technical Notes
47
SPHadPrivatePlan
SP was covered by a Private plan anytime during current round =
There is a PLAN where PLAN.PLANTYPE=4/PrivatePlan & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM
& PLRO.PLRORND=current round & PLRO.COVTIME ^= empty).
Exclude Deleted Plans. See T.N. 52.
40
SPInstitute
SP is institutionalized =
MRES.SPALIVE=2/AliveAndInstitute on MRES where MRES.MRESRND = current round.
SPInterviewType
SP'S Interview Type = MRES.INTTYPE:
1/StandardHadPrev
2/NewFromFacility
3/NewFromSupplement
4/StandardSkippedPrev
5/LastRndFacSum
6/LastRndFacBase
7/SupSmp1stTimeUtil
8/ExitInterviewHadPrev
9/ExitInterviewSkippedPrev
10/SupSmp1stTimeUtilSkipped
SPMale
SP is male =
ROST.ROSTSEX=1/Male on ROST where ROST.ROSTNUM='01'.
239
SPMarriedFallRnd
SP is married =
IN13 - SPMARSTA = 1/Married. Stored on HRND where HRND.HRNDRND = current round.
*Applicable to Fall Round only.
238
SPMarriedforIA
SP is married (in IA) =
(MRES.INTTYPE =8/ExitInterviewHadPrev & INCO.SPSEINHH = 1/Yes on INCO where
INCO.INCORND=current round) or (there is an ENUM where (ENUM.ENUMRND = current round and
ENUM.NOTHHRSN = empty and ENUM.HHPREL = 2/Spouse)).
SPMoved
Interviewer has updated SP's address =
HRND.SPMOVED ^= Empty on HRND where HRND.HRNDRND = current round.
218
5
23
SP moved = HRND.SPMOVED =1/Yes.
SP not moved = HRND.SPMOVED=2/No.
27-Mar-09
Page 37 of 44
MCBS WVS - Technical Notes
SPName
SP's name =
Stored on ROST where ROST.ROSTNUM='01'.
First Name: ROST.ROSTFNAM
Middle Initials: ROST.ROSTMINI
Last Name: ROST.ROSTLNAM
SPOrAnySourcePaid
SP or any source paid =
For this COST, there is a CORO where (CORO.COROCOST=COST.COSTNUM & CORO.CORORND=current
round & CORO.TCHGPAID = 1/Yes).
SpouseInHH
SP has spouse living in the household =
There is a ROST where ROST.ROSTREL=2/Spouse and ENUM where (ENUM.ENUMROST=
ROST.ROSTNUM and ENUM.ENUMRND=current round and ENUM.NOTHHRSN = empty).
240
SpouseIsRespondent
SP's spouse is the respondent =
There is a ROST where ROST.ROSTREL = 2/Spouse & (ROST.ROSTNUM = MRES.RROSTNUM on MRES
where MRES.MRESRND = current round).
277
SPPrevExpectPayBack
SP previously expected a source to pay back any amount =
For this COST, CORO.EXPPAYBK = 1/Yes on most recent CORO where (CORO.COROCOST =
COST.COSTNUM & CORO.EXPPAYBK ^= empty).
SPPreviousAddress
SP's previous round address =
blADDRESS.STAddr1, STAddr2, City, State, Zipcode on tblADDRESS where (tblADDRESS.AddressType =
'SP' & tblADDRESS.AddressDetail = 'SP' & tblADDRESS.AddrRost = '01' & tblADDRESS.AddressRnd =
previous round).
423
SPReceivedCaretThruVA
SP reported receiving health care services through V.A.in the current or any previous round =
There is an HRND where HRND.HRNDRND = current round and HRND.VACOVER = 1/Yes.
HRND.VACOVER is set at BOX HI20 or collected at HI36.
369
SPReportedMPDP
SP reported an Medicare prescription drug plan =
There is a PLAN where PLAN.PLANTYPE = 7/MPDP.
Exclude Deleted Plans. See T.N. 52.
SPServedArmedForces
SP served in the armed forces =
HOME.SPAFEVER=1/Yes or HOME.SPNGEVER = 1/Yes.
12
231
66
22
78
27-Mar-09
Page 38 of 44
MCBS WVS - Technical Notes
96
SPsSpouse
SP's Spouse =
There is a ROST where ROST.ROSTREL=2/Spouse.
59
SPStatus
SP is Alive and not institutionalized =
MRES.SPALIVE=1/Alive or empty
SP is Alive =
MRES.SPALIVE=1/Alive, 2/AliveAndInstitute, or EMPTY
SP is Institutionalized =
MRES.SPALIVE=2/AliveAndInstitute
SP is Deceased =
MRES.SPALIVE=3/Deceased.
140
SPStillInHosp
SP was reported as still in the hospital (in current round) =
For this EVNT, EVNT.IPSTATUS=1/StillInHospital.
137
SPStillInHospPrevRnd
SP was still in a hospital at the time of the previous round interview =
There is an EVNT where EVNT.EVNTDFLG^=1/Yes and EVNT.EVNTTYPE='IP' and
EVNT.IPSTATUS=1/StillInHospital.
192
SPUsedVA
SP used V.A. Facilities during the current round =
HRND.VACOVER=1/Yes on HRND where HRND.HRNDRND = current round.
195
SPUsedVAPrevRnd
SP used V.A. facilities in previous round =
HRND.VACOVER = 1/Yes on HRND where HRND.HRNDRND = previous round.
141
StandardContSample
SP is in the Standard Continuing Sample =
(MRES.INTTYPE=1/StandardHadPrev or MRES.INTTYPE=4/StandardSkippedPrev) on MRES where
MRES.MRESRND = current round.
68
StateNoMedicaidHMO
SP's state does not offer Medicaid Managed Care plan =
SP's most recent ADDR where ADDR.ADDRNUM="01" has ADDR.STATE = AK, AL, AR, CT, DE, GA, IL, KS,
LA, MA, MD, ME, MI, MO, MS, MT, NC, ND, NH, NM, NV, OH, OK, RI, SC, SD, VA, VT, WA, WV, or WY.
27-Mar-09
Page 39 of 44
MCBS WVS - Technical Notes
49
StateWithMHMO
If there are Medicare Managed Care plans (Medicare Advantage plans) in SP's state =
SP's most recent ADDR where ADDR.ADDRNUM='01' has ADDR.STATE ^= AK, AR, DE, ME, MS, MT, SC,
UT, VT or WY.
366
STChargeBundle
Charge Bundle is a Statement Charge Bundle =
COST.COSTTYPE = 1/ST.
201
StillRentKdnyItem
SP still renting kidney dialysis equipment at the time of the previous round interview =
There is an EVNT where EVNT.EVNTTYPE ='OM' and EVNT.OMETYPE=9/Kidney and EVNT.RENTSTIL =
1/Yes and EVNT.RENTRECR = previous round and EVNT.EVNTDFLG ^= 1/Yes.
199
StillRentOrthItem
SP still renting an orthopedic item at the time of the previous round interview =
There is an EVNT where EVNT.EVNTTYPE ='OM' and EVNT.OMETYPE=3/Orthopedic and EVNT.RENTSTIL =
1/Yes and EVNT.RENTRECR = previous round and EVNT.EVNTDFLG ^= 1/Yes.
202
StillRentOthrItem
SP still renting an other medical equipment at the time of the previous round interview =
There is an EVNT where EVNTTYPE ='OM' and OMETYPE=10/OtherMedicalExpense and EVNT.RENTSTIL =
1/Yes and EVNT.RENTRECR = previous round and EVNT.EVNTDFLG ^= 1/Yes.
200
StillRentOxgnItem
SP still renting oxygen related equipment at the time of the previous round interview =
There is an EVNT where EVNT.EVNTTYPE ='OM' and EVNT.OMETYPE=8/Oxygen and EVNT.RENTSTIL =
1/Yes and EVNT.RENTRECR = previous round and EVNT.EVNTDFLG ^= 1/Yes.
184
StrengthEqualDK
Previous round PM Strength was asked and did not equal DK =
For this PM EVNT, there is PMRO where (PMRO.PMROEVNT=EVNT.EVNTNUM &
PMRO.PMRORND=previous round & PMRO.STRNUNIT ^= EMPTY & (STRNUNIT, STRNUNI2, STRNNUM,
STRNUM2, STRNPER, & STRNPER2 ^= DK)).
100
SummerRound
If the remainder of (Current round divided by 3) = 0, then it is a Summer round.
SuppORD
SP is in the Supplemental Sample =
MRES.INTTYPE=3/NewFromSupplement on MRES where MRES.MRESRND = current round.
SurgicalProcedures
Surgical procedures reported for event =
SURGERY1, SURGERY2, SURGERY3 store up to 3 surgeries for Event being asked about. These fields are
copied to SURG.SURGPROC on a separate SURG where SURG.SURGEVNT = EVNT.EVNTNUM of event
being asked about.
9
139
27-Mar-09
Page 40 of 44
MCBS WVS - Technical Notes
64
ThisMHMOCurrent
This Medicare Managed Care Plan (Medicare Advantage plan) "current" =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current
round & COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
75
ThisMHMOCurrentPrevRnd
This Medicare Managed Care plan (Medicare Advantage plan) was "current" at time of the previous round
interview =
There is a PLRO where (PLROPLAN= this PLANNUM & PLRORND=previous round & COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
74
ThisMHMORestarted
This Medicare Managed Care plan (Medicare Advantage plan) has been restarted =
For this PLAN, there is not a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.COVCURNT=1/Yes ).
Exclude Deleted Plans. See T.N. 52.
ThisMPDPCurrentPrevRnd
This MPDP Plan was "current" at the time of the previous round interview =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.COVCURNT=1/Yes).
Exclude Deleted Plans. See T.N. 52.
71
ThisPlanCurrent
This Plan is "current" =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current
round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
63
ThisPlanCurrentPrevRnd
This Plan was "current" at the time of the previous round interview =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
ThisPlanCurrPrevRnd
This Plan was reported as "current" on prev. round interview date=
For this PLAN, there is PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=prev. round &
(COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
349
148
27-Mar-09
Page 41 of 44
MCBS WVS - Technical Notes
69
ThisPlanMedicaidHMO
SP reported this Medicaid plan was a Medicaid Managed Care plan in previous round =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.MCAIDHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
61
ThisPlanNew
This Plan is new =
PLAN.PLANRNDC = current round and PLAN.PLANSUMM ^= 1/Yes.
Exclude Deleted Plans. See T.N. 52.
ThisPlanNewPrevRnd
This Plan added in HIS and is a new Plan during the previous round reference period =
PLAN.PLANRNDC=current round and PLAN.PLANSUMM = 1/Yes.
Exclude Deleted Plans. See T.N. 52.
70
ThisPlanNotMedicaidHMO
SP reported this Medicaid plan was not a Medicaid Managed Care plan in the previous round =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.MCAIDHMO^=1/Yes).
Exclude Deleted Plans. See T.N. 52.
62
ThisPlanRestarted
This Plan has been restarted =
For this PLAN, there is no PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND = previous
round & (PLRO.COVTIME=1/WholeTime or PLRO.COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
347
ThisPrivPlanHadRx
This Plan had RX coverage during the previous round interview =
For this PLAN, there is PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.PRVRXCOV=1/Yes).
Exclude Deleted Plans. See T.N. 52.
ThisPrivPlanHMO
This private plan is a managed care plan =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=current
round & PLRO.PPRVHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
ThisPrivPlanHMOPrevRnd
This private plan was a managed care plan in the previous round =
For this PLAN, there is a PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM & PLRO.PLRORND=previous
round & PLRO.PPRVHMO=1/Yes).
Exclude Deleted Plans. See T.N. 52.
155
88
209
27-Mar-09
Page 42 of 44
MCBS WVS - Technical Notes
270
TotalCharge
Total Charge =
COST.TOTALAMT.
When collecting Total charge in the current round, Total Charge is first collected in CORO.TOTALCHG on
CORO where CORO.CORORND = current round and CORO.COROCOST = this COST.COSTNUM and then is
copied to COST.TOTALAMT.
269
TotalChargeCollected
Total Charge was collected for Charge Bundle =
For this COST, there is a CORO where (CORO.COROCOST=COST.COSTNUM & CORO.CORORND=current
round & CORO.TOTALTYP=1/TotalCharge).
If administering CPS, check most recent CORO where CORO.TOTALTYP ^= empty.
383
TotalChargeCopayCollected
Total Charge or Copay Collected > 0, DK or RF =
COST.TOTALAMT > 0, DK or RF.
255
TotalPayments
Total of non-missing Payments entered in SOP grid =
For each TSOP where (TSOP.TSOPAMT ^= DK and TSOP.TSOPAMT ^= RF and TSOP.TSOPAMT ^=
EMPTY), then Total Payments = Total Payments + TSOP.TSOPAMT.
413
TotalPurchasesInNS
Total number of purchases being asked about in NS (following BOX NS4) =
XCEV.NUMLINKS on XCEV where XCEV.XCEVEVNT = this EVNT.EVNTNUM and XCEV.XCEVCOST and
COST.COSTNUM for charge bundle being asked about.
151
TricarAnyTimePrevRnd
SP covered by Tricare anytime during the previous round =
There is a PLAN where PLAN.PLANTYPE=6/Tricare & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
PLRO.PLRORND=previous round & PLRO.COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
355
TricareCurrent
There is a "current" Tricare plan =
There is a PLAN where PLAN.PLANTYPE = 6/Tricare & PLRO where (PLRO.PLROPLAN = PLAN.PLANNUM
& PLRORND = current round & (PLRO.COVTIME = 1/WholeTime or PLRO.COVNOW = 1/Yes)).
Exclude Deleted Plans. See T.N. 52.
TricareCurrentPrevRnd
Tricare "current" at the time of the previous round interview =
There is a PLAN where PLAN.PLANTYPE=6/Tricare & PLRO where (PLROPLAN=PLAN.PLANNUM &
PLRORND=previous round and (COVTIME=1/WholeTime or COVNOW=1/Yes)).
Exclude Deleted Plans. See T.N. 52.
72
27-Mar-09
Page 43 of 44
MCBS WVS - Technical Notes
TricareCurrOrPrevRnd
SP was covered by Tricare in the current or previous round =
There is a PLAN where PLAN.PLANTYPE=6/Tricare & PLRO where (PLRO.PLROPLAN=PLAN.PLANNUM &
(PLRO.PLRORND=current round or previous round) & COVTIME^=empty).
Exclude Deleted Plans. See T.N. 52.
258
TricarePlan
SP covered by TRICARE during the current round =
There is a PLAN where PLAN.PLANTYPE = 6/Tricare
& PLRO where (PLRO.PLROPLAN = PLAN.PLANNUM & PLRO.PLRORND = current round &
PLRO.COVTIME^= empty).
Exclude Deleted Plans. See T.N. 52.
264
TricareSOP
Tricare already on SOP roster =
There is a TSOP where TSOP.TSOPPTYP = 6/Tricare.
241
TypeOfEvent
Type of Event =
EVNT.EVNTTYPE.
99
WinterRound
If the remainder of (Current round divided by 3) = 2, then it is a Winter round.
77
27-Mar-09
Page 44 of 44
| File Type | application/pdf |
| File Title | MCBS WVS Technical Notes |
| Author | Sweeney_l |
| File Modified | 2010-03-30 |
| File Created | 2009-03-27 |