Hygiene Report
The <APPLICATION_NAME>.APP_PUBLIC.HYGIENE_REPORT table will be populated with the record of the USPS Hygiene reports, including CASS (Coding Accuracy Support System) and NCOA (National Change of Address).
| FIELD ORDER | FIELD NAME | FIELD TYPE | DESCRIPTION | VALID VALUES |
|---|---|---|---|---|
| 1 | REQUEST_ID | VARCHAR | Unique identifier for the batch or job | |
| 2 | REPORT_TYPE | VARCHAR | Type of report generated | SOA: Canada SERP Statement Of Accuracy report, used to get discounted mailing rates at Canada Post3553: US Postal Service CASS report, used to get discounted mailing rates at US Postal ServiceNCOA: US NCOA report for receiving additional discount mailing rates at US Postal ServiceCANCOA Combined: Canadian Change of Address report for Canada Postal discount |
| 3 | DATE_CREATED | VARCHAR | Timestamp of the last update | |
| 4 | REPORT | Detailed report content |