CASS Stage not validating a few valid address records?

jaksani · Post by **jaksani** » Fri Apr 01, 2011 3:16 am

Hi,

CASS stage not validating a few records.

For Example:
Address Validation Failed:
965 SELLS AVE SW APT 3104 -> Address
ATLANTA GA 30310-1314 -> Area

Address validation Success:
900 REAS FORD RD -> Address
EARLYSVILLE VA 22936-2318 -> Area

Observation in Failure case:
1)Zip4_CASS column has null in Failure case though input record has valid value.
I think this might be the reason for not validating?

If you have any idea please let me know the reason for not validating mentioned record.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 01, 2011 1:40 pm

You have a 9-digit zip in the failed case, so you should have a value in the Zip4_CASS field.

rjdickson · Post by **rjdickson** » Fri Apr 01, 2011 1:53 pm

The output ZIP4 field would be null if the record failed certification.

Using the information from one of your other posts, what are the codes returned from certification? (The DPV and validation codes). Also, what are the returned delivery address lines?

jaksani · Post by **jaksani** » Tue Apr 05, 2011 1:16 am

The codes returned from the certification are :

ADDRVAL_MatchFlag_Cass -> NULL
ADDRVAL_DPVCommFloag_CASS -> NULL
ADDRVAL_DPVCode1_CASS -> 'AA'
ADDRVAL_DPVCode2_CASS-> NULL
ADDRVAL_DPVCode3_CASS -> NULL

DeliveryAddressLine1_CASS -> 965 SELLS AVE SW APT 3104

rjdickson · Post by **rjdickson** » Tue Apr 05, 2011 7:03 am

Having a MtchFlag of null and DPVCod1 of AA is unusual. What were the outputs (like ZIP5_CASS, DeliveryPoint_CASS, CITY_CASS, etc)?

jaksani · Post by **jaksani** » Tue Apr 05, 2011 7:16 am

ZIP5_CASS:30310
DeliveryPoint_CASS:NULL
DeliveryPointChkDigit_CASS:NULL
CarrierRoute_CASS:C019
City_CASS:ATLANTA
State_CASS:GA

rjdickson · Post by **rjdickson** » Tue Apr 05, 2011 7:50 am

Having a CarrierRoute implies that the record certified - and that is confirmed by the 'AA'.

Are you doing any mapping/transformation after the USAC stage, or does the stage go directly to an output file?

jaksani · Post by **jaksani** » Wed Apr 06, 2011 12:16 am

Yes, doing some transformations.
I am just replacing NULL values in dpvmatchflag and dpvcodes with '' and this is just to prepare Returncode and Return Message for the CASS output.

rjdickson · Post by **rjdickson** » Wed Apr 06, 2011 5:26 am

And what is the derivation on the MatchFlag column?

rjdickson · Post by **rjdickson** » Wed Apr 06, 2011 5:28 am

And what is the derivation on the MatchFlag column?

jaksani · Post by **jaksani** » Mon Apr 18, 2011 3:03 am

if (IsNotNull(DSLink1671.DPVMatchFlag_CASS)) Then DSLink1671.DPVMatchFlag_CASS Else ""

The above statement is used for derivation of MatchFlag.

jaksani · Post by **jaksani** » Mon Apr 18, 2011 3:04 am

if (IsNotNull(DSLink1671.DPVMatchFlag_CASS)) Then DSLink1671.DPVMatchFlag_CASS Else ""

The above statement is used for derivation of MatchFlag.