QuarterlyGradingPmtInfo - All Domain Fields Populating With Codes Rather Than Descriptions in Export

[JuanitaMiles]

Steps to Reproduce: Reporting Year = 2017 On Failure = Continue On Errors Current User = KCI\Juanita.Miles

The following fields are being populated with the domain code rather than the domain description: QuarterlyGradingPmtInfo.LAND_USE_BF QuarterlyGradingPmtInfo.OWNER_STATE QuarterlyGradingPmtInfo.QUARTER QuarterlyGradingPmtInfo.SITE_STATE QuarterlyGradingPmtInfo.WATERSHED8DGT *QuarterlyGradingPmtInfo.LAND_USE_AF should most likely be added to this list as well, however no values are being populated in this field. (See separate logged issue "QuarterlyGradingPmtInfo - LAND_USE_AF No Values Populating in Export).

Examples of Error: Source (QRT_GRADING_INFO.LAND_USE_BF): MDE Export (QuarterlyGradingPmtInfo.LAND_USE_BF)

Source (QRT_GRADING_INFO.OWNER_STATE): MDE Export (QuarterlyGradingPmtInfo.OWNER_STATE):

[gerrykelly]

@JuanitaMiles @leeensminger Not sure what's happening here. 1) It is correct that the codes being written to the field, that's how it should work (i.e. state fields are only two characters) 2) But if the domain exists in the DB and the domain is applied to the field, you should see the descriptions. 3) And the domains are in the DB and applied from my checking:

I'll work on figuring this out but if you see anything that provides a clue, let me know

[gerrykelly]

@leeensminger @JuanitaMiles @BC89 Let's make this a topic for Friday's meeting. I have tried many things to restore the field-domain-code/description connection and nothing has worked.

[gerrykelly]

@JuanitaMiles @BC89 @leeensminger It looks like this was serendipitously resolved with addressing that erroneous subtype issue in the MDE table.