13_26-004C_ATT_F-2_Sentry_Mapping.pdf

RFQQ DOH26-004C Sentry to SDWIS

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

4 SentryProd Well WellDWAINId varchar 6 Ask What is this? Does it need to be mapped?

12 SentryProd SDWISVioQ PwsId varchar 10 Extract from SDWISFed 13 SentryProd SDWISVioQ FacilityId int 4 Extract from SDWISFed 14 SentryProd SDWISVioQ SrcRootId int 4 Extract from SDWISFed 15 SentryProd SDWISVioQ WSSrcNum varchar 10 Extract from SDWISFed 16 SentryProd SDWISVioQ DistrRootId int 4 Extract from SDWISFed 17 SentryProd SDWISVioQ ViolationId int 4 Extract from SDWISFed 18 SentryProd SDWISVioQ VioTypeCode varchar 10 Extract from SDWISFed 19 SentryProd SDWISVioQ ContaminantCode varchar 10 Extract from SDWISFed 20 SentryProd SDWISVioQ IncidentDate datetime 8 Extract from SDWISFed 21 SentryProd SDWISVioQ CPBegDate datetime 8 Extract from SDWISFed 22 SentryProd SDWISVioQ CPEndDate datetime 8 Extract from SDWISFed 23 SentryProd SDWISVioQ RTCDate datetime 8 Extract from SDWISFed 24 SentryProd SDWISVioQ TestPanelCode varchar 10 Extract from SDWISFed 25 SentryProd SDWISVioQ AnalyteDOHNum varchar 4 Extract from SDWISFed 26 SentryProd SDWISVioQ AnaResult decimal 9 Extract from SDWISFed 27 SentryProd SDWISVioQ UOM varchar 10 Extract from SDWISFed 28 SentryProd SDWISVioQ MajorVioInd varchar 5 Extract from SDWISFed 29 SentryProd SDWISVioQ UndObjectId int 4 Extract from SDWISFed 30 SentryProd SDWISVioQ UndDataType varchar 10 Extract from SDWISFed 31 SentryProd SDWISVioQ PNUnderVioId int 4 Extract from SDWISFed 32 SentryProd SDWISVioQ SvrtyIndCount int 4 Extract from SDWISFed 33 SentryProd SDWISVioQ Region varchar 10 Extract from SDWISFed 34 SentryProd SDWISVioQ County varchar 35 Extract from SDWISFed 35 SentryProd SDWISVioQ SentryVioType varchar 10 Extract from SDWISFed 36 SentryProd SDWISVioQ SDWISRule varchar 10 Extract from SDWISFed 37 SentryProd SDWISVioQ EnfActionCode varchar 10 Extract from SDWISFed 38 SentryProd SDWISVioQ DOHProgramId int 4 Extract from SDWISFed 39 SentryProd SDWISVioQ LCR90Lead90th decimal 9 Extract from SDWISFed 40 SentryProd SDWISVioQ LCR90Copper90th decimal 9 Extract from SDWISFed 41 SentryProd SDWISVioQ FirstReported date 3 Extract from SDWISFed 42 SentryProd SDWISVioQ LastReported date 3 Extract from SDWISFed 43 SentryProd SDWISVioQ ODWSDWISTblName varchar 50 Extract from SDWISFed 44 SentryProd NoWaiverAnalyte NoWaiverAnalyteId int 4 45 SentryProd NoWaiverAnalyte NWASrcRootId decimal 5 46 SentryProd NoWaiverAnalyte NWASamId int 4 47 SentryProd NoWaiverAnalyte NWAResultId int 4 48 SentryProd NoWaiverAnalyte NWAAnalyteDOHNum varchar 4 50 SentryProd NoWaiverAnalyte UpdateUserId int 4 51 SentryProd NoWaiverAnalyte NWAParentSrcRootId decimal 5 67 SentryProd ObjectiveRule ObjRuleId int 4 68 SentryProd ObjectiveRule ObjRuleObjectiveId int 4 69 SentryProd ObjectiveRule ObjRuleAppRuleId int 4 71 SentryProd ObjectiveRule UpdateUserId int 4 72 SentryProd SNC SNCId int 4

DOH26-004C RFQQ

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 1 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

73 SentryProd SNC SNCLERootId int 4 74 SentryProd SNC SNCSrcRootId decimal 5 75 SentryProd SNC SNCDistrRootId decimal 5 76 SentryProd SNC SNCTestPanelId int 4 77 SentryProd SNC SNCAnalyteId int 4 78 SentryProd SNC SNCTypeId int 4 79 SentryProd SNC SNCTierCat varchar 10 80 SentryProd SNC SNCBeginDate datetime 8 81 SentryProd SNC SNCEndDate datetime 8 82 SentryProd SNC SNCERTCDate datetime 8 83 SentryProd SNC SNCStatusId int 4 84 SentryProd SNC SNCStatusEffDate datetime 8 85 SentryProd SNC SNCNewFlag varchar 1 86 SentryProd SNC SNCDOHProgramId int 4 87 SentryProd SNC SNCRiskLevelCat varchar 10 88 SentryProd SNC SNCPNTierLevelCat varchar 10 89 SentryProd SNC SNCEntryUserId int 4 90 SentryProd SNC SNCEntryDate datetime 8 91 SentryProd SNC SNCComment varchar 1000 93 SentryProd SNC UpdateUserId int 4 94 SentryProd SNC SNCCalcBeginDate datetime 8 95 SentryProd SNC SNCCalcSNCTypeId int 4 96 SentryProd SNC SNCBeginDateOvrdn char 1 97 SentryProd SNC SNCTypeOvrdn char 1 98 SentryProd SNC SNCOvrdRsnComment varchar 1000 145 SentryProd SusceptibilityRatingCriteria SusceptibilityRatingCriteriaId int 4 146 SentryProd SusceptibilityRatingCriteria SRCSrcTypeId int 4 147 SentryProd SusceptibilityRatingCriteria SRCNitrateLBoundGTQty decimal 9 148 SentryProd SusceptibilityRatingCriteria SRCNitrateUBoundLEQty decimal 9 149 SentryProd SusceptibilityRatingCriteria SRCVOCConditionsCat varchar 1 150 SentryProd SusceptibilityRatingCriteria SRCSOCConditionsInd varchar 1 151 SentryProd SusceptibilityRatingCriteria SRCConfinedInd varchar 1 152 SentryProd SusceptibilityRatingCriteria SRCFlowingLBoundGTQty decimal 5 153 SentryProd SusceptibilityRatingCriteria SRCFlowingUBoundLEQty decimal 5 154 SentryProd SusceptibilityRatingCriteria SRCWellLogInd varchar 1 155 SentryProd SusceptibilityRatingCriteria SRCAdequateSurfaceSealInd varchar 1 156 SentryProd SusceptibilityRatingCriteria SRCWellDepthLBoundGTQty decimal 5 157 SentryProd SusceptibilityRatingCriteria SRCWellDepthUBoundLEQty decimal 5 158 SentryProd SusceptibilityRatingCriteria SRCWellDepthOpenIntervalCatGTQty int 4 159 SentryProd SusceptibilityRatingCriteria SRCWellDepthOpenIntervalCatLEQty int 4 160 SentryProd SusceptibilityRatingCriteria SRCSusceptCat varchar 1 161 SentryProd SusceptibilityRatingCriteria SRCSuscepQualifierCat varchar 1 162 SentryProd SusceptibilityRatingCriteria SRCSuscepRvwReqInd varchar 1 164 SentryProd SusceptibilityRatingCriteria UpdateUserId int 4 188 SentryProd WSDistribution WSDistrCalcResConnCnt decimal 5 295 SentryProd RuleReason RuleReasonId int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 2 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

296 SentryProd RuleReason RRAppRuleId int 4 297 SentryProd RuleReason RRTreatReasonId int 4 299 SentryProd RuleReason UpdateUSerId int 4 318 SentryProd WSPlantObjRuleReason WSPORRId int 4 319 SentryProd WSPlantObjRuleReason WSPORRWSPlantObjRuleId int 4 320 SentryProd WSPlantObjRuleReason WSPORRRuleReasonId int 4 322 SentryProd WSPlantObjRuleReason UpdateUserId int 4 D_USERID_CODE 364 SentryProd OpPermitCriteria OpPermitCriteriaId int 4 365 SentryProd OpPermitCriteria OpPermitCritLERootId int 4 366 SentryProd OpPermitCriteria OpPermitCritSHOSFOIssuedInd varchar 1 367 SentryProd OpPermitCriteria OpPermitCritWSIsSNCInd varchar 1 368 SentryProd OpPermitCriteria OpPermitCritMaxSvcExceededInd varchar 1 369 SentryProd OpPermitCriteria OpPermitCritWSPlanComplianceInd varchar 1 370 SentryProd OpPermitCriteria OpPermitCritEffDate datetime 8 371 SentryProd OpPermitCriteria OpPermitCritEndDate datetime 8 373 SentryProd OpPermitCriteria UpdateUserId int 4 374 SentryProd OpPermitCriteria OpPermitCritActiveSDOInd varchar 1 375 SentryProd OpPermitCriteria OpPermitCritSDOCompInd varchar 1 376 SentryProd OpPermitCriteria OpPermitCritActiveSAGOrBCAInd varchar 1 377 SentryProd OpPermitCriteria OpPermitCritSAGBCACompInd varchar 1 378 SentryProd OpPermitCriteria OpPermitCritDesignAppvInd varchar 1 379 SentryProd OpPermitCriteria OpPermitCritSubmitWSPNotifInd varchar 1 388 SentryProd OtherAddress OtherAddrObjectId int 4 ask 389 SentryProd OtherAddress OtherAddrFromInd char 1 ask 400 SentryProd GWSourceType UpdateUserId int 4 401 SentryProd DocumentType DocTypeId int 4 402 SentryProd DocumentType DocTypeCode varchar 15 403 SentryProd DocumentType DocTypeName varchar 35 404 SentryProd DocumentType DocTypeCatId int 4 425 SentryProd LECommentFocus LECmtFocusID int 4 426 SentryProd LECommentFocus LECmtFocusCode varchar 10 427 SentryProd LECommentFocus LECmtFocusName varchar 35 430 SentryProd LECommentFocus UpdateUserId int 4 431 SentryProd SDWISVioDiffs EPAVIOId varchar 20 432 SentryProd SDWISVioDiffs PwsId varchar 10 433 SentryProd SDWISVioDiffs FacilityId int 4 434 SentryProd SDWISVioDiffs SrcRootId int 4 435 SentryProd SDWISVioDiffs WSSrcNum varchar 10 436 SentryProd SDWISVioDiffs DistrRootId int 4 437 SentryProd SDWISVioDiffs ViolationId int 4 438 SentryProd SDWISVioDiffs VioTypeCode varchar 10 439 SentryProd SDWISVioDiffs ContaminantCode varchar 10 440 SentryProd SDWISVioDiffs IncidentDate datetime 8 441 SentryProd SDWISVioDiffs CPBegDate datetime 8 442 SentryProd SDWISVioDiffs CPEndDate datetime 8 443 SentryProd SDWISVioDiffs RTCDate datetime 8

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 3 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

444 SentryProd SDWISVioDiffs TestPanelCode varchar 10 445 SentryProd SDWISVioDiffs AnalyteDOHNum varchar 4 446 SentryProd SDWISVioDiffs AnaResult decimal 9 447 SentryProd SDWISVioDiffs UOM varchar 10 448 SentryProd SDWISVioDiffs MajorVioInd varchar 5 449 SentryProd SDWISVioDiffs UndObjectId int 4 450 SentryProd SDWISVioDiffs UndDataType varchar 10 451 SentryProd SDWISVioDiffs PNUnderVioId int 4 452 SentryProd SDWISVioDiffs SvrtyIndCount int 4 453 SentryProd SDWISVioDiffs Region varchar 10 454 SentryProd SDWISVioDiffs County varchar 35 455 SentryProd SDWISVioDiffs SentryVioType varchar 10 456 SentryProd SDWISVioDiffs SDWISRule varchar 10 457 SentryProd SDWISVioDiffs EnfActionCode varchar 10 458 SentryProd SDWISVioDiffs DOHProgramId int 4 459 SentryProd SDWISVioDiffs LCR90Lead90th decimal 9 460 SentryProd SDWISVioDiffs LCR90Copper90th decimal 9 461 SentryProd SDWISVioDiffs FirstReported date 3 462 SentryProd SDWISVioDiffs LastReported date 3 463 SentryProd SDWISVioDiffs ODWSDWISTblName varchar 50 469 SentryProd LECommentSource LECmtSrcID int 4 470 SentryProd LECommentSource LECmtSrcCode varchar 10 471 SentryProd LECommentSource LECmtSrcName varchar 35 500 SentryProd VulnerabilityRatingCriteria VRCId int 4 501 SentryProd VulnerabilityRatingCriteria VRCAnalyteGroupId int 4 502 SentryProd VulnerabilityRatingCriteria VRCSusceptCat varchar 1 503 SentryProd VulnerabilityRatingCriteria VRCDetailContaminantInvntryInd varchar 1 504 SentryProd VulnerabilityRatingCriteria VRCPestRiskCat varchar 1 505 SentryProd VulnerabilityRatingCriteria VRCSOCConditions varchar 1 506 SentryProd VulnerabilityRatingCriteria VRCVOCConditions varchar 1 507 SentryProd VulnerabilityRatingCriteria VRCIOCCriteria varchar 1 508 SentryProd VulnerabilityRatingCriteria VRCVulnCat varchar 1 509 SentryProd VulnerabilityRatingCriteria VRCReviewRequiredInd varchar 1 511 SentryProd VulnerabilityRatingCriteria UpdateUserId int 4 551 SentryProd DocumentTypeDocDate DocTypeDocDateId int 4 552 SentryProd DocumentTypeDocDate DocTypeId int 4 553 SentryProd DocumentTypeDocDate DateTypeId int 4 554 SentryProd DocumentTypeDocDate DocTypeDocDateSeq int 4 585 SentryProd DocumentStatus SortOrder int 4 590 SentryProd WSOpPermit WSOpPermitId int 4 591 SentryProd WSOpPermit WSOpPermitLERootId int 4 592 SentryProd WSOpPermit WSOpPermitCategoryCat varchar 10 593 SentryProd WSOpPermit WSOpPermitStatusCat varchar 1 594 SentryProd WSOpPermit WSOpPermitEffDate datetime 8 595 SentryProd WSOpPermit WSOpPermitEndDate datetime 8 596 SentryProd WSOpPermit WSOpPermitYear varchar 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 4 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

597 SentryProd WSOpPermit WSOpPermitComments varchar 255 598 SentryProd WSOpPermit WSOpPermitInvoiceId int 4 599 SentryProd WSOpPermit WSOpPermitColorEffDate datetime 8 600 SentryProd WSOpPermit WSOpPermitColorEndDate datetime 8 601 SentryProd WSOpPermit WSOpPermitOverrideCat varchar 10 602 SentryProd WSOpPermit WSOpPermitOverrideComments varchar 255 603 SentryProd WSOpPermit WSOpPermitOverrideYear varchar 4 604 SentryProd WSOpPermit WSOpPermitOverrideEffDate datetime 8 605 SentryProd WSOpPermit WSOpPermitOverrideEndDate datetime 8 607 SentryProd WSOpPermit UpdateUserId int 4 612 SentryProd AdjustmentReason AdjustReasonId int 4 613 SentryProd AdjustmentReason AdjustReasonCode varchar 10 614 SentryProd AdjustmentReason AdjustReasonName varchar 35 635 SentryProd DocumentTypeDocStatus DocTypeDocStatusId int 4 636 SentryProd DocumentTypeDocStatus DocTypeId int 4 637 SentryProd DocumentTypeDocStatus DocStatusId int 4 646 SentryProd Objective ObjectiveId int 4 647 SentryProd Objective ObjectiveCode varchar 10 648 SentryProd Objective ObjectiveName varchar 35 651 SentryProd Objective UpdateUserId int 4 659 SentryProd OpPermitRatingCriteria OpPermitRatingCriteriaId int 4 660 SentryProd OpPermitRatingCriteria OpPermitRatCritSHOSFOIssuedInd varchar 1 661 SentryProd OpPermitRatingCriteria OpPermitRatCritWSIsSNCInd varchar 1 662 SentryProd OpPermitRatingCriteria OpPermitRatCritMaxSvcExceededInd varchar 1 663 SentryProd OpPermitRatingCriteria OpPermitRatCritWSPlanComplianceInd varchar 1 664 SentryProd OpPermitRatingCriteria OpPermitRatCritCategoryCat varchar 10 665 SentryProd OpPermitRatingCriteria OpPermitRatCritPrecedenceNum numeric 5 667 SentryProd OpPermitRatingCriteria UpdateUserId int 4 668 SentryProd OpPermitRatingCriteria OpPermitRatCritActiveSDOInd varchar 1 669 SentryProd OpPermitRatingCriteria OpPermitRatCritSDOCompInd varchar 1 670 SentryProd OpPermitRatingCriteria OpPermitRatCritActiveSAGOrBCAInd varchar 1 671 SentryProd OpPermitRatingCriteria OpPermitRatCritSAGBCACompInd varchar 1 672 SentryProd OpPermitRatingCriteria OpPermitRatCritDesignAppvInd varchar 1 673 SentryProd OpPermitRatingCriteria OpPermitRatCritSubmitWSPNotifInd varchar 1 674 SentryProd QualifiedSanitarySurveyor QSSId int 4 Y Track any of this in legal entities?

675 SentryProd QualifiedSanitarySurveyor QSSIndvLERootId int 4 Y Track any of this in legal entities?

676 SentryProd QualifiedSanitarySurveyor QSSNum varchar 3 Y Track any of this in legal entities?

677 SentryProd QualifiedSanitarySurveyor QSSStatusCat varchar 10 Y Track any of this in legal entities?

678 SentryProd QualifiedSanitarySurveyor QSSStatusEffDate datetime 8 Y Track any of this in legal entities?

679 SentryProd QualifiedSanitarySurveyor QSSAssociatedOrgName varchar 35 Y Track any of this in legal entities?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 5 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

680 SentryProd QualifiedSanitarySurveyor QSSUBINumber varchar 25 Y Track any of this in legal entities?

681 SentryProd QualifiedSanitarySurveyor QSSLastJointInspectionDate datetime 8 Y Track any of this in legal entities?

682 SentryProd QualifiedSanitarySurveyor QSSApplicationDate datetime 8 Y Track any of this in legal entities?

683 SentryProd QualifiedSanitarySurveyor QSSApplicationStatusCat varchar 10 Y Track any of this in legal entities?

684 SentryProd QualifiedSanitarySurveyor QSSApprovalDate datetime 8 Y Track any of this in legal entities?

685 SentryProd QualifiedSanitarySurveyor QSSPrintCert datetime 8 Y Track any of this in legal entities?

687 SentryProd QualifiedSanitarySurveyor UpdateUserId int 4 Y Track any of this in legal entities?

688 SentryProd QualifiedSanitarySurveyor QSSGroupBApprovalInd varchar 1 Y Track any of this in legal entities?

689 SentryProd QualifiedSanitarySurveyor QSSIsVendorInd varchar 1 Y Track any of this in legal entities?

705 SentryProd ObjectType ObjectTypeId int 4 706 SentryProd ObjectType ObjectTypeCode varchar 25 707 SentryProd ObjectType ObjectTypeName varchar 35 710 SentryProd ObjectType UpdateUserId int 4 712 SentryProd SVRatings SVRSrcRootId decimal 5 713 SentryProd SVRatings SVRDate datetime 8 714 SentryProd SVRatings PriorSVRatingsId int 4 715 SentryProd SVRatings SVRAntSusceptCat varchar 1 716 SentryProd SVRatings SVRAntSusceptQualifierCat varchar 15 717 SentryProd SVRatings SVRSusceptCat varchar 1 718 SentryProd SVRatings SVRSusceptQualifierCat varchar 15 719 SentryProd SVRatings SVRSusceptStatusCat varchar 1 720 SentryProd SVRatings SVRSusceptRvwReqInd varchar 1 721 SentryProd SVRatings SVRSusceptOvrRsnCat varchar 1 722 SentryProd SVRatings SVRAntIOCVulnCat varchar 1 723 SentryProd SVRatings SVRIOCVulnCat varchar 1 724 SentryProd SVRatings SVRIOCVulnStatusCat varchar 1 725 SentryProd SVRatings SVRIOCVulnRvwReqInd varchar 1 726 SentryProd SVRatings SVRIOCVulnOvrRsnCat varchar 1 727 SentryProd SVRatings SVRAntVOCVulnCat varchar 1 728 SentryProd SVRatings SVRVOCVulnCat varchar 1 729 SentryProd SVRatings SVRVOCVulnStatusCat varchar 1 730 SentryProd SVRatings SVRVOCVulnRvwReqInd varchar 1 731 SentryProd SVRatings SVRVOCVulnOvrRsnCat varchar 1 732 SentryProd SVRatings SVRAntSOCVulnCat varchar 1 733 SentryProd SVRatings SVRSOCVulnCat varchar 1 734 SentryProd SVRatings SVRSOCVulnStatusCat varchar 1 735 SentryProd SVRatings SVRSOCVulnRvwReqInd varchar 1

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 6 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

736 SentryProd SVRatings SVRSOCVulnOvrRsnCat varchar 1 737 SentryProd SVRatings SVRAntRadVulnCat varchar 1 738 SentryProd SVRatings SVRRadVulnCat varchar 1 739 SentryProd SVRatings SVRRadVulnStatusCat varchar 1 740 SentryProd SVRatings SVRRadVulnRvwReqInd varchar 1 741 SentryProd SVRatings SVRRadVulnOvrRsnCat varchar 1 742 SentryProd SVRatings SVRAntMicroVulnCat varchar 1 743 SentryProd SVRatings SVRMicroVulnCat varchar 1 744 SentryProd SVRatings SVRMicroVulnStatusCat varchar 1 745 SentryProd SVRatings SVRMicroVulnRvwReqInd varchar 1 746 SentryProd SVRatings SVRMicroVulnOvrRsnCat varchar 1 747 SentryProd SVRatings SVRRatingsCmt varchar 700 749 SentryProd SVRatings UpdateUserId int 4 750 SentryProd SVRatings SVRAntPestRiskCodeWRIA varchar 1 751 SentryProd SVRatings SVRAntPestRiskCodeLandUse varchar 1 752 SentryProd SVRatings SVRAntPestRiskCodeWellDepth varchar 1 753 SentryProd SVRatings SVRAntPestRiskCodeNitrate varchar 1 754 SentryProd SVRatings RadAlphaIM char 1 755 SentryProd SVRatings Rad228IM char 1 762 SentryProd WSSR WSSamRqmtId int 4 763 SentryProd WSSR WSSamRqmtTestPanelId int 4 764 SentryProd WSSR WSSamRqmtWSDistRootId decimal 5 765 SentryProd WSSR WSSamRqmtSrcRootId decimal 5 766 SentryProd WSSR WSSamRqmtDOHWSNum varchar 10 767 SentryProd WSSR WSSamRqmtBeginDate datetime 8 768 SentryProd WSSR WSSamRqmtEndDate datetime 8 769 SentryProd WSSR WSSamRqmtPeriodMonthCnt decimal 5 771 SentryProd WSSR UpdateUserId int 4 772 SentryProd WSSR WSSamRqmtLERootId int 4 773 SentryProd WSSR WSSamRqmtMonitorSchedAdjustId int 4 774 SentryProd WSSR WSSamRqmtMonLevelId int 4 775 SentryProd WSSR WSSamRqmtBasisId int 4 776 SentryProd WSSR WSSamRqmtAnalyteId int 4 777 SentryProd WSSR WSSamRqmtActEndDate datetime 8 778 SentryProd WSSR WSSamRqmtWaiverTypeCat varchar 2 779 SentryProd WSSR WSSamRqmtWaiverStatusCode varchar 2 780 SentryProd WSSR WSSamRqmtWaiverAmt decimal 5 781 SentryProd WSSR WSSamRqmtWaiverInvoiceId int 4 782 SentryProd WSSR WSSamRqmtSamCnt decimal 5 783 SentryProd WSSR WSSamRqmtActCnt decimal 5 784 SentryProd WSSR EntryDateTime datetime 8 785 SentryProd WSSR EntryUserId int 4 786 SentryProd WSSR WSSrcNum varchar 2 787 SentryProd WSSR Processed char 1 814 SentryProd Document DocId int 4 815 SentryProd Document DocTypeId int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 7 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

816 SentryProd Document DocEntityId int 4 817 SentryProd Document DocSubEntityNum varchar 10 818 SentryProd Document DocIdent varchar 10 819 SentryProd Document DocStatusId int 4 820 SentryProd Document DocEntityTypeId int 4 821 SentryProd Document DocSubEntityTypeId int 4 822 SentryProd Document DocCmt varchar 254 824 SentryProd Document UpdateUserId int 4 842 SentryProd RegulatoryType RegulatoryTypeId int 4 843 SentryProd RegulatoryType RegulatoryTypeCode varchar 10 844 SentryProd RegulatoryType RegulatoryTypeName varchar 35 847 SentryProd RegulatoryType UpdateUserId int 4 865 SentryProd Basis BasisId int 4 866 SentryProd Basis BasisCode varchar 10 867 SentryProd Basis BasisName varchar 35 868 SentryProd Basis BasisPrecedenceNum numeric 5 871 SentryProd Basis UpdateUserId int 4 878 SentryProd DocumentDate DocumentDateId int 4 879 SentryProd DocumentDate DocDateDocId int 4 880 SentryProd DocumentDate DocDateDateTypeId int 4 881 SentryProd DocumentDate DocDateDate datetime 8 882 SentryProd DocumentDate DocDateComment varchar 50 886 SentryProd QSSLicenseType QSSLicTypeCode varchar 10 887 SentryProd QSSLicenseType QSSLicTypeName varchar 50 925 SentryProd RnC18 RId int 4 926 SentryProd RnC18 PwsID nvarchar 510 927 SentryProd RnC18 PwsID sysname 510 928 SentryProd RnC18 SrcNum nvarchar 510 929 SentryProd RnC18 SrcNum sysname 510 930 SentryProd RnC18 TestPanel nvarchar 510 931 SentryProd RnC18 TestPanel sysname 510 932 SentryProd RnC18 AnaNum nvarchar 510 933 SentryProd RnC18 AnaNum sysname 510 934 SentryProd RnC18 ML nvarchar 510 935 SentryProd RnC18 ML sysname 510 936 SentryProd RnC18 LERootId int 4 937 SentryProd RnC18 SrcRootId decimal 5 938 SentryProd RnC18 TestPanelId int 4 939 SentryProd RnC18 AnalyteId int 4 940 SentryProd RnC18 Processed char 1 941 SentryProd RnC18 SamId int 4 948 SentryProd DispositionType DispositionTypeId int 4 949 SentryProd DispositionType DispositionTypeIncidentTypeId int 4 950 SentryProd DispositionType DispositionTypeCode varchar 10 951 SentryProd DispositionType DispositionTypeName varchar 35 954 SentryProd DispositionType UpdateUserId int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 8 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

986 SentryProd OpPermitCriteriaMessage OpPermitCritMsgId int 4 987 SentryProd OpPermitCriteriaMessage OpPermitCritColumnName varchar 100 988 SentryProd OpPermitCriteriaMessage OpPermitCritValue varchar 10 989 SentryProd OpPermitCriteriaMessage OpPermitCritMsgText varchar 300 991 SentryProd OpPermitCriteriaMessage UpdateUserId int 4 998 SentryProd PlanDocument PlanDocumentId int 4 Ask 999 SentryProd PlanDocument PlanDocPlanDetailId int 4 Ask 1000 SentryProd PlanDocument PlanDocDocId int 4 Ask 1001 SentryProd PlanDocument PlanDocWSPtoWSSMPInd varchar 1 Ask 1002 SentryProd PlanDocument PlanDocStdSpecsInd varchar 1 Ask 1003 SentryProd PlanDocument PlanDocAltReviewInd varchar 1 Ask 1004 SentryProd PlanDocument PlanDocUmbrellaInd varchar 1 Ask 1005 SentryProd PlanDocument PlanDocPriorityDate datetime 8 Ask 1006 SentryProd PlanDocument PlanDocPrePlanDate datetime 8 Ask 1007 SentryProd PlanDocument PlanDocSubLogNumber varchar 10 Ask 1009 SentryProd PlanDocument UpdateUserId int 4 Ask 1034 SentryProd IncidentAction IncidentActionID int 4 1035 SentryProd IncidentAction IncidentActionIncidentId int 4 1036 SentryProd IncidentAction IncidentActionTypeId int 4 1037 SentryProd IncidentAction IncidentActionStatusId int 4 1038 SentryProd IncidentAction IncidentActionDueDate datetime 8 1039 SentryProd IncidentAction IncidentActionDoneDate datetime 8 1041 SentryProd IncidentAction UpdateUserId int 4 1063 SentryProd LCR90thPercent LCR90LeadHigh decimal 9 1065 SentryProd LCR90thPercent LCR90CopperHigh decimal 9 1066 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustId int 4 1067 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustLERootId int 4 1068 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustMonLevelId int 4 1069 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustBasisId int 4 1070 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustAnalyteId int 4 1071 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustTestPanelId int 4 1072 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustSrcRootId decimal 5 1073 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustDistrRootId decimal 5 1074 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustmentStatusId int 4 1075 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustBeginDate datetime 8 1076 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustEndDate datetime 8 1077 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustPeriodMonthCnt decimal 5 1078 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustSamCnt decimal 5 1079 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustReasonId int 4 1080 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustReasonDesc varchar 1000 1081 SentryProd MonitoringScheduleAdjustment MonitorSchedAdjustUserId int 4 1083 SentryProd MonitoringScheduleAdjustment UpdateUserId int 4 1101 SentryProd SourceCommentType SrcCmtTypeId int 4 1102 SentryProd SourceCommentType SrcCmtTypeCode varchar 10 1103 SentryProd SourceCommentType SrcCmtTypeName varchar 35 1106 SentryProd SourceCommentType UpdateUserId int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 9 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1134 SentryProd SourceRoot SrcRootId decimal 5 1136 SentryProd SourceRoot UpdateUserId int 4 1137 SentryProd SourceRoot SrcRootSrcMergeInd varchar 1 1205 SentryProd PlanDetail PlanDetailId int 4 Ask 1206 SentryProd PlanDetail PlanDtlTypeCat varchar 5 Ask 1207 SentryProd PlanDetail PlanDtlEntityDOHNum varchar 10 Ask 1208 SentryProd PlanDetail PlanDtlPriorityWSInd varchar 1 Ask 1209 SentryProd PlanDetail PlanDtlUTCRegulatedWSInd varchar 1 Ask 1210 SentryProd PlanDetail PlanDtlCWSSAInd varchar 1 Ask 1212 SentryProd PlanDetail UpdateUserId int 4 Ask 1235 SentryProd OperCertification OperCertId int 4 1236 SentryProd OperCertification OperCertOperId int 4 1238 SentryProd OperCertification OperCertIsGrandfatherInd varchar 1 1239 SentryProd OperCertification OperCertNum varchar 15 1240 SentryProd OperCertification OperCertEffDate datetime 8 1241 SentryProd OperCertification OperCertEndDate datetime 8 1242 SentryProd OperCertification OperCertComment varchar 255 1244 SentryProd OperCertification UpdateUserId int 4 1264 SentryProd FLSampleInjectionPoint FLSampleId int 4 1265 SentryProd FLSampleInjectionPoint FIPId int 4 1323 SentryProd PlanHistory PlanHistoryId int 4 Ask 1324 SentryProd PlanHistory PlanHistPlanDetailId int 4 Ask 1325 SentryProd PlanHistory PlanHistDOHEngLERootID int 4 Ask 1326 SentryProd PlanHistory PlanHistDOHPlannerLERootId int 4 Ask 1327 SentryProd PlanHistory PlanHistEffDate datetime 8 Ask 1329 SentryProd PlanHistory UpdateUserId int 4 Ask 1343 SentryProd ProgramSeverityIncident ProgramSeverityIncidentId int 4 1344 SentryProd ProgramSeverityIncident PSIDOHProgramId int 4 1345 SentryProd ProgramSeverityIncident PSIIncidentTypeId int 4 1346 SentryProd ProgramSeverityIncident PSIIncidentSeverityId int 4 1349 SentryProd ProgramSeverityIncident UpdateUserId int 4 1356 SentryProd PlanReview PlanReviewId int 4 Ask 1357 SentryProd PlanReview PlanRvwDraftDue datetime 8 Ask 1358 SentryProd PlanReview PlanRvwInReview datetime 8 Ask 1359 SentryProd PlanReview PlanRvwPlannerReview datetime 8 Ask 1360 SentryProd PlanReview PlanRvwInCmntsOut datetime 8 Ask 1361 SentryProd PlanReview PlanRvwExtLetter datetime 8 Ask 1362 SentryProd PlanReview PlanRvwCmnts varchar 50 Ask 1364 SentryProd PlanReview UpdateUserId int 4 Ask 1365 SentryProd PlanReview PlanRvwPlanDocId int 4 Ask 1417 SentryProd WSOpPermitInvoiceComment WSOPInvoiceCommentId int 4 1418 SentryProd WSOpPermitInvoiceComment WSOPInvoiceCommentLERootId int 4 1419 SentryProd WSOpPermitInvoiceComment WSOPInvoiceCommentText varchar 4096 1421 SentryProd WSOpPermitInvoiceComment UpdateUserId int 4 1422 SentryProd ProgramIncidentActionType ProgramIncidentActionTypeId int 4 1423 SentryProd ProgramIncidentActionType PIAIncidentStatusId int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 10 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1424 SentryProd ProgramIncidentActionType PIAProgramSeverityIncidentId int 4 1425 SentryProd ProgramIncidentActionType PIAActionTypeId int 4 1426 SentryProd ProgramIncidentActionType PIAPartyInd varchar 1 1429 SentryProd ProgramIncidentActionType UpdateUserId int 4 1451 SentryProd WSMerge WSMergeId int 4 1452 SentryProd WSMerge WSMergeReceivingDOHNum varchar 10 1453 SentryProd WSMerge WSMergeMergingDOHNum varchar 10 1454 SentryProd WSMerge WSMergeDate datetime 8 1455 SentryProd WSMerge WSMergeStatusInd varchar 10 1457 SentryProd WSMerge WSMergeTypeInd varchar 10 1458 SentryProd WSMerge UpdateUserId int 4 1511 SentryProd CountyTestPanel CountyTestPanelId int 4 1512 SentryProd CountyTestPanel CntyOrgLEId int 4 1513 SentryProd CountyTestPanel TestPanelId int 4 1515 SentryProd CountyTestPanel UpdateUserId int 4 1521 SentryProd RegionalRisk RegionalRiskId int 4 1522 SentryProd RegionalRisk RegionalRiskSASId int 4 1523 SentryProd RegionalRisk RegionalRiskRRTypeId int 4 1524 SentryProd RegionalRisk RegionalRisk6monthInd varchar 1 1525 SentryProd RegionalRisk RegionalRisk1yearInd varchar 1 1526 SentryProd RegionalRisk RegionalRisk5yearInd varchar 1 1527 SentryProd RegionalRisk RegionalRisk10yearInd varchar 1 1528 SentryProd RegionalRisk RegionalRiskUnkownTimeInd varchar 1 1530 SentryProd RegionalRisk UpdateUserId int 4 1539 SentryProd WSAnalyteRandC WSAnalyteRandCId int 4 1540 SentryProd WSAnalyteRandC WSAnalyteRandCLERootId int 4 1541 SentryProd WSAnalyteRandC WSAnalyteRandCSamId int 4 1542 SentryProd WSAnalyteRandC WSAnalyteRandCAnalyteId int 4 1543 SentryProd WSAnalyteRandC WSAnalyteRandCTestPanelId int 4 1544 SentryProd WSAnalyteRandC WSAnalyteRandCSrcRootId decimal 5 1545 SentryProd WSAnalyteRandC WSAnalyteRandCDistrRootId decimal 5 1546 SentryProd WSAnalyteRandC WSAnalyteRandCStatusId int 4 1547 SentryProd WSAnalyteRandC WSAnalyteRandCEffDate datetime 8 1548 SentryProd WSAnalyteRandC WSAnalyteRandCEffEndDate datetime 8 1550 SentryProd WSAnalyteRandC UpdateUserId int 4 1558 SentryProd FumigantHighRiskTownshipSectionRange FumRiskTSRId int 4 1559 SentryProd FumigantHighRiskTownshipSectionRange FumRiskTSRCountyCode varchar 2 1560 SentryProd FumigantHighRiskTownshipSectionRange FumRiskTSRSectionNum varchar 4 1561 SentryProd FumigantHighRiskTownshipSectionRange FumRiskTSRTwpNum varchar 2 1562 SentryProd FumigantHighRiskTownshipSectionRange FumRiskTSRRangeNum varchar 3 1564 SentryProd FumigantHighRiskTownshipSectionRange UpdateUserId int 4 1581 SentryProd Analyte AnalyteDOHNum varchar 4 ask 1582 SentryProd Analyte AnalyteName varchar 35 ask 1583 SentryProd Analyte AnalyteUOMId int 4 ask 1584 SentryProd Analyte AnalyteEffDate datetime 8 ask 1585 SentryProd Analyte AnalyteEndDate datetime 8 ask

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 11 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1587 SentryProd Analyte AnalyteCASNum varchar 8 ask 1591 SentryProd ComplianceActionType CompActionTypeId int 4 1592 SentryProd ComplianceActionType CompActionTypeCode varchar 10 1593 SentryProd ComplianceActionType CompActionTypeName varchar 35 1594 SentryProd ComplianceActionType CompActionTypeListSeq int 4 1595 SentryProd ComplianceActionType CompActionTypeNextNum decimal 5 1598 SentryProd ComplianceActionType UpdateUserId int 4 1599 SentryProd ComplianceActionType CompActionTypeNextNumYear varchar 4 1600 SentryProd ComplianceActionType EPAEnfActionCode varchar 10 1616 SentryProd CountyPesticideRiskCode PRCId int 4 1617 SentryProd CountyPesticideRiskCode PRCCntyOrgLEId int 4 1618 SentryProd CountyPesticideRiskCode PRCHerbRiskCode char 1 1619 SentryProd CountyPesticideRiskCode PRCPestRiskCode char 1 1620 SentryProd CountyPesticideRiskCode PRCPestVulnRiskCat char 1 1623 SentryProd CountyPesticideRiskCode UpdateUserId int 4 1658 SentryProd WSRandCStatus WSRandCStatusId int 4 1659 SentryProd WSRandCStatus WSRandCStatusCode varchar 10 1660 SentryProd WSRandCStatus WSRandCStatusName varchar 35 1663 SentryProd WSRandCStatus UpdateUserId int 4 1674 SentryProd FLWSComment UpdateUserId int 4 1675 SentryProd GWSourceSubType GWSrcSubTypeId int 4 1676 SentryProd GWSourceSubType GWSrcTypeId int 4 1681 SentryProd GWSourceSubType UpdateUserId int 4 1682 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritId int 4 1683 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritSrcTypeId int 4 1684 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritSusceptCat varchar 1 1685 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritVulnCat varchar 1 1686 SentryProd SOCWaiverCriteriaHistoric SOCWaiverTestPanelReqdInd varchar 1 1687 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritSOCVulnConditionsCat varchar 1 1688 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritPrevSOCWaiverInd varchar 1 1689 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritWaiverTypeCat varchar 2 1690 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritMonRqmtSamCnt decimal 5 1691 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritMonRqmtYearCnt decimal 5 1692 SentryProd SOCWaiverCriteriaHistoric SOCWaiverCritMonRqmtRvwReqdInd varchar 1 1731 SentryProd LEComment LECmtSrcID int 4 Ask Should we add these details to the comment?

1732 SentryProd LEComment LECmtFocusID int 4 Ask Should we add these details to the comment?

1733 SentryProd LEComment LECmtDateTime datetime 8 Ask Should we add these details to the comment?

1734 SentryProd LEComment LECmtAuthorName varchar 35 Ask Should we add these details to the comment?

1738 SentryProd SOCWaiverCriteria SOCWaiverCritId int 4 1739 SentryProd SOCWaiverCriteria SOCWaiverCritInitMonInd char 1 1740 SentryProd SOCWaiverCriteria SOCWaiverCritVulnCat char 1 1741 SentryProd SOCWaiverCriteria SOCWaiverCritSamLBoundGTCnt int 4

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 12 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1742 SentryProd SOCWaiverCriteria SOCWaiverCritSamUBoundLECnt int 4 1743 SentryProd SOCWaiverCriteria SOCWaiverTestPanelReqdInd char 1 1744 SentryProd SOCWaiverCriteria SOCWaiverCritWaiverTypeCat varchar 2 1745 SentryProd SOCWaiverCriteria SOCWaiverCritMonRqmtSamCnt int 4 1746 SentryProd SOCWaiverCriteria SOCWaiverCritMonRqmtYearCnt int 4 1747 SentryProd SOCWaiverCriteria SOCWaiverCritMonRqmtRvwReqdInd char 1 1748 SentryProd ComplianceActionStatus CompActionStatusId int 4 1749 SentryProd ComplianceActionStatus CompActionStatusCode varchar 10 1750 SentryProd ComplianceActionStatus CompActionStatusName varchar 35 1751 SentryProd ComplianceActionStatus CompActionStatusListSeq int 4 1754 SentryProd ComplianceActionStatus UpdateUserId int 4 1764 SentryProd WRIATestPanel WRIATestPanelId int 4 1765 SentryProd WRIATestPanel WRIATestPanelWSWRIAId int 4 1766 SentryProd WRIATestPanel WRIATestPanelTestPanelId int 4 1768 SentryProd WRIATestPanel UpdateUserId int 4 1780 SentryProd FLSample UpdateUserId int 4 1781 SentryProd FLSample FlappKey int 4 Ask How is this used?

1802 SentryProd SusceptibilityAssessmentSurvey SASId int 4 Y How used? Where could this go in

SDWIS?

1803 SentryProd SusceptibilityAssessmentSurvey SASSrcRootId decimal 5 Y How used? Where could this go in

SDWIS?

1804 SentryProd SusceptibilityAssessmentSurvey SASWellOwnerMgrName varchar 35 Y How used? Where could this go in

SDWIS?

1805 SentryProd SusceptibilityAssessmentSurvey SASSrcName varchar 35 Y How used? Where could this go in

SDWIS?

1806 SentryProd SusceptibilityAssessmentSurvey SASWellTagNum varchar 6 Y How used? Where could this go in

SDWIS?

1807 SentryProd SusceptibilityAssessmentSurvey SASConnCnt decimal 5 Y How used? Where could this go in

SDWIS?

1808 SentryProd SusceptibilityAssessmentSurvey SASPopCnt decimal 5 Y How used? Where could this go in

SDWIS?

1809 SentryProd SusceptibilityAssessmentSurvey SASSrcQtrSecCode varchar 5 Y How used? Where could this go in

SDWIS?

1810 SentryProd SusceptibilityAssessmentSurvey SASSrcSectionNum varchar 4 Y How used? Where could this go in

SDWIS?

1811 SentryProd SusceptibilityAssessmentSurvey SASSrcTwpNum varchar 2 Y How used? Where could this go in

SDWIS?

1812 SentryProd SusceptibilityAssessmentSurvey SASSrcRangeNum varchar 3 Y How used? Where could this go in

SDWIS?

1813 SentryProd SusceptibilityAssessmentSurvey SASSrcCoordLatQty decimal 9 Y How used? Where could this go in

SDWIS?

1814 SentryProd SusceptibilityAssessmentSurvey SASSrcCoordLongQty decimal 9 Y How used? Where could this go in

SDWIS?

1815 SentryProd SusceptibilityAssessmentSurvey SASSrcCoordMthdCat varchar 1 Y How used? Where could this go in

SDWIS?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 13 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1816 SentryProd SusceptibilityAssessmentSurvey SASSrcConstrDate datetime 8 Y How used? Where could this go in

SDWIS?

1817 SentryProd SusceptibilityAssessmentSurvey SASSrcReconstrDate datetime 8 Y How used? Where could this go in

SDWIS?

1818 SentryProd SusceptibilityAssessmentSurvey SASWellDrillerName varchar 35 Y How used? Where could this go in

SDWIS?

1819 SentryProd SusceptibilityAssessmentSurvey SASWellType varchar 2 Y How used? Where could this go in

SDWIS?

1820 SentryProd SusceptibilityAssessmentSurvey SASWellReportAvailInd varchar 1 Y How used? Where could this go in

SDWIS?

1821 SentryProd SusceptibilityAssessmentSurvey SASSrcAveragePumpRateQty decimal 5 Y How used? Where could this go in

SDWIS?

1822 SentryProd SusceptibilityAssessmentSurvey SASSrcDisinfectionTreatInd varchar 1 Y How used? Where could this go in

SDWIS?

1823 SentryProd SusceptibilityAssessmentSurvey SASSrcFiltrationTreatInd varchar 1 Y How used? Where could this go in

SDWIS?

1824 SentryProd SusceptibilityAssessmentSurvey SASSrcCarbonFilterTreatInd varchar 1 Y How used? Where could this go in

SDWIS?

1825 SentryProd SusceptibilityAssessmentSurvey SASSrcAirStripperTreatInd varchar 1 Y How used? Where could this go in

SDWIS?

1826 SentryProd SusceptibilityAssessmentSurvey SASSrcOtherTreatInd varchar 1 Y How used? Where could this go in

SDWIS?

1827 SentryProd SusceptibilityAssessmentSurvey SASSrcTreatUnknownInd varchar 1 Y How used? Where could this go in

SDWIS?

1828 SentryProd SusceptibilityAssessmentSurvey SASSrcResidualChlorineInd varchar 1 Y How used? Where could this go in

SDWIS?

1829 SentryProd SusceptibilityAssessmentSurvey SASSrcResidualChlorineQty decimal 9 Y How used? Where could this go in

SDWIS?

1830 SentryProd SusceptibilityAssessmentSurvey SASWellDepthToGWCat varchar 1 Y How used? Where could this go in

SDWIS?

1831 SentryProd SusceptibilityAssessmentSurvey SASWellDepthMeasMthdCat varchar 1 Y How used? Where could this go in

SDWIS?

1832 SentryProd SusceptibilityAssessmentSurvey SASFWSSurfaceImpoundInd varchar 1 Y How used? Where could this go in

SDWIS?

1833 SentryProd SusceptibilityAssessmentSurvey SASWellheadElevQty decimal 5 Y How used? Where could this go in

SDWIS?

1834 SentryProd SusceptibilityAssessmentSurvey SASSrcElevMeasMethodCat varchar 1 Y How used? Where could this go in

SDWIS?

1835 SentryProd SusceptibilityAssessmentSurvey SASWellConfiningLayerLogInd varchar 1 Y How used? Where could this go in

SDWIS?

1836 SentryProd SusceptibilityAssessmentSurvey SASDepthToGW20ftInd varchar 1 Y How used? Where could this go in

SDWIS?

1837 SentryProd SusceptibilityAssessmentSurvey SASSrcSanitarySetbackCat varchar 1 Y How used? Where could this go in

SDWIS?

1838 SentryProd SusceptibilityAssessmentSurvey SASWellheadConstrCat varchar 2 Y How used? Where could this go in

SDWIS?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 14 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1839 SentryProd SusceptibilityAssessmentSurvey SASWellheadSurfaceSealCat varchar 1 Y How used? Where could this go in

SDWIS?

1840 SentryProd SusceptibilityAssessmentSurvey SASSrcAnnualRainfallCat decimal 5 Y How used? Where could this go in

SDWIS?

1841 SentryProd SusceptibilityAssessmentSurvey SASSrcAnnualGalQty decimal 9 Y How used? Where could this go in

SDWIS?

1842 SentryProd SusceptibilityAssessmentSurvey SASSrcAnnualGalMthdCat varchar 5 Y How used? Where could this go in

SDWIS?

1843 SentryProd SusceptibilityAssessmentSurvey SASSrcTimeofTravelModelCat varchar 1 Y How used? Where could this go in

SDWIS?

1844 SentryProd SusceptibilityAssessmentSurvey SASSrc6MoTimeofTravelQty decimal 5 Y How used? Where could this go in

SDWIS?

1845 SentryProd SusceptibilityAssessmentSurvey SASSrc1YrTimeofTravelQty decimal 5 Y How used? Where could this go in

SDWIS?

1846 SentryProd SusceptibilityAssessmentSurvey SASSrc5YrTimeofTravelQty decimal 5 Y How used? Where could this go in

SDWIS?

1847 SentryProd SusceptibilityAssessmentSurvey SASSrc10YrTimeofTravelQty decimal 5 Y How used? Where could this go in

SDWIS?

1848 SentryProd SusceptibilityAssessmentSurvey SASWellOpenIntervalLengthQty decimal 5 Y How used? Where could this go in

SDWIS?

1849 SentryProd SusceptibilityAssessmentSurvey SASSrcSurfaceWIn6MoTTInd varchar 1 Y How used? Where could this go in

SDWIS?

1850 SentryProd SusceptibilityAssessmentSurvey SASSrcStormWWasteWIn6MoTTInd varchar 1 Y How used? Where could this go in

SDWIS?

1851 SentryProd SusceptibilityAssessmentSurvey SASSrcNitrateLevelCat varchar 1 Y How used? Where could this go in

SDWIS?

1852 SentryProd SusceptibilityAssessmentSurvey SASSrcVOCCat varchar 1 Y How used? Where could this go in

SDWIS?

1853 SentryProd SusceptibilityAssessmentSurvey SASSrcEDBDBCPCat varchar 1 Y How used? Where could this go in

SDWIS?

1854 SentryProd SusceptibilityAssessmentSurvey SASSrcSOCCat varchar 1 Y How used? Where could this go in

SDWIS?

1855 SentryProd SusceptibilityAssessmentSurvey SASSrcColiDetectCat varchar 1 Y How used? Where could this go in

SDWIS?

1856 SentryProd SusceptibilityAssessmentSurvey SASDistrColiDetectCat varchar 1 Y How used? Where could this go in

SDWIS?

1857 SentryProd SusceptibilityAssessmentSurvey SASSrcColiSamRecordAvailInd varchar 1 Y How used? Where could this go in

SDWIS?

1858 SentryProd SusceptibilityAssessmentSurvey SASSrcHydroBoundryIn10yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1859 SentryProd SusceptibilityAssessmentSurvey SASSrcFractGeolCat varchar 1 Y How used? Where could this go in

SDWIS?

1860 SentryProd SusceptibilityAssessmentSurvey SASSrcSandGravelCat varchar 1 Y How used? Where could this go in

SDWIS?

1861 SentryProd SusceptibilityAssessmentSurvey SASSrcHiFlowAquiferCat varchar 1 Y How used? Where could this go in

SDWIS?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 15 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1862 SentryProd SusceptibilityAssessmentSurvey SASSrcHiCapWellsCat varchar 1 Y How used? Where could this go in

SDWIS?

1863 SentryProd SusceptibilityAssessmentSurvey SASSrcHiCapWells6moTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1864 SentryProd SusceptibilityAssessmentSurvey SASSrcHiCapWells1yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1865 SentryProd SusceptibilityAssessmentSurvey SASSrcHiCapWells5yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1866 SentryProd SusceptibilityAssessmentSurvey SASSrcHiCapWells10yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1867 SentryProd SusceptibilityAssessmentSurvey SASSrcRechargeWells1yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1868 SentryProd SusceptibilityAssessmentSurvey SASSrcRechargeWells5yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1869 SentryProd SusceptibilityAssessmentSurvey SASSrcRechargeWells10yrTTCat varchar 1 Y How used? Where could this go in

SDWIS?

1870 SentryProd SusceptibilityAssessmentSurvey SASSubmitYear varchar 4 Y How used? Where could this go in

SDWIS?

1871 SentryProd SusceptibilityAssessmentSurvey SASMapInd varchar 1 Y How used? Where could this go in

SDWIS?

1872 SentryProd SusceptibilityAssessmentSurvey SASTTMapInd varchar 1 Y How used? Where could this go in

SDWIS?

1873 SentryProd SusceptibilityAssessmentSurvey SASEntryDate datetime 8 Y How used? Where could this go in

SDWIS?

1874 SentryProd SusceptibilityAssessmentSurvey SASEditDate datetime 8 Y How used? Where could this go in

SDWIS?

1875 SentryProd SusceptibilityAssessmentSurvey SASSrcRegionalRiskUpdateDate datetime 8 Y How used? Where could this go in

SDWIS?

1876 SentryProd SusceptibilityAssessmentSurvey SASSrcSanitarySetbackCmt varchar 700 Y How used? Where could this go in

SDWIS?

1877 SentryProd SusceptibilityAssessmentSurvey SASSrcStormWasteWaterCmt varchar 700 Y How used? Where could this go in

SDWIS?

1878 SentryProd SusceptibilityAssessmentSurvey SASWellheadConstrCmt varchar 700 Y How used? Where could this go in

SDWIS?

1879 SentryProd SusceptibilityAssessmentSurvey SASSrcSOCDetectCmt varchar 700 Y How used? Where could this go in

SDWIS?

1880 SentryProd SusceptibilityAssessmentSurvey SASSrcRegionalRiskCmt varchar 700 Y How used? Where could this go in

SDWIS?

1881 SentryProd SusceptibilityAssessmentSurvey SASSrcHydroGeoCmt varchar 700 Y How used? Where could this go in

SDWIS?

1882 SentryProd SusceptibilityAssessmentSurvey SASGeneralCmt varchar 700 Y How used? Where could this go in

SDWIS?

1883 SentryProd SusceptibilityAssessmentSurvey SASLandUseCat varchar 1 Y How used? Where could this go in

SDWIS?

1884 SentryProd SusceptibilityAssessmentSurvey SASSrcCritSrfcWtrChkLstInd varchar 1 Y How used? Where could this go in

SDWIS?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 16 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1885 SentryProd SusceptibilityAssessmentSurvey UpdateUserId int 4 Y How used? Where could this go in

SDWIS?

1891 SentryProd SanitarySurveyor EA char 1 Y May be able to add to TINLGENT record somewhere

1892 SentryProd SanitarySurveyor NW char 1 Y May be able to add to TINLGENT record somewhere

1893 SentryProd SanitarySurveyor SW char 1 Y May be able to add to TINLGENT record somewhere

1894 SentryProd SanitarySurveyor TPS char 1 Y May be able to add to TINLGENT record somewhere

1895 SentryProd SanitarySurveyor DOH char 1 Y May be able to add to TINLGENT record somewhere

1908 SentryProd FLResult Control char 10 Is this a calculation? Values are Unknown, In, Out

1912 SentryProd FLResult UpdateUserId int 4 1913 SentryProd FLResult FlappKey int 4 1914 SentryProd FLResult OperTolerance varchar 10 1915 SentryProd FLResult OffMeasure varchar 10 1921 SentryProd SNCType SNCTypeId int 4 1922 SentryProd SNCType SNCTypeCode varchar 10 1923 SentryProd SNCType SNCTypeName varchar 35 1924 SentryProd SNCType SNCTypeListSeq int 4 1925 SentryProd SNCType SNCTypeProcessCat varchar 1 1928 SentryProd SNCType UpdateUserId int 4 1936 SentryProd RegionalRiskType RRTypeId int 4 1937 SentryProd RegionalRiskType RRTypeCode varchar 10 1938 SentryProd RegionalRiskType RRTypeName varchar 35 1941 SentryProd RegionalRiskType UpdateUserId int 4 1972 SentryProd TestPanel TestPanelId int 4 1973 SentryProd TestPanel TestPanelCode varchar 10 1974 SentryProd TestPanel TestPanelName varchar 35 1975 SentryProd TestPanel AnalyteGroupId int 4 1976 SentryProd TestPanel TestPanelEffDate datetime 8 1977 SentryProd TestPanel TestPanelEndDate datetime 8 1978 SentryProd TestPanel DefaultSamCompId int 4 1979 SentryProd TestPanel DefaultSamTypeId int 4 1980 SentryProd TestPanel DefaultSamPurposeId int 4 1981 SentryProd TestPanel DefaultSamCollModeId int 4 1983 SentryProd TestPanel UpdateUserId int 4 1984 SentryProd TestPanel TestPanelDOHProgramId int 4 1992 SentryProd AssignedSurvey OutstndPerfBegDate datetime 8 Y possibly use for WS Indicator for outstanding performers?

Attachment F-2: Remaining Sentry Fields to be Mapped to SDWIS State. v2. 05/27/2026. Page 17 of 29

A B C D E F G H I J K

COLUMN

_ID

SCHEMA_NA

ME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LEN

GTH

SDWIS

Table

SDWIS column Ask Notes/Questions WA Response

1993 SentryProd AssignedSurvey OutstndPerfEndDate datetime 8 Y possibly use for WS Indicator for outstanding performers?

2037 SentryProd SNCStatus SNCStatusId int 4 2038 SentryProd SNCStatus SNCStatusCode varchar 10 2039 SentryProd SNCStatus SNCStatusName varchar 35 2040 SentryProd SNCStatus SNCStatusListSeq int 4 2043 SentryProd SNCStatus UpdateUserId int 4 2044 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritId int 4 2045 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritSrcTypeId int 4 2046 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritSusceptCat varchar 1 2047 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritVulnCat varchar 1 2048 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritSOCVulnConditionsCat varchar 1 2049 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritSrfcWtrChkLstInd varchar 1 2050 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritDetailContaminantInvntryInd varchar 1

2051 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritPrevSOCUseWaiverInd varchar 1 2052 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritUseWaiverTypeCat varchar 2 2053 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritMonRqmtSamCnt decimal 5 2054 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritMonRqmtYearCnt decimal 5 2055 SentryProd SOCUseWaiverCriteria SOCUseWaiverCritMonRqmtRvwReqdInd varchar 1 2063 SentryProd AnalyteActionLevel AnalyteActionLevelId int 4 2064 SentryProd AnalyteActionLevel AnalyteId int 4 2065…