REMOTE_RESOURCES_RECON_QUERIES table

The REMOTE_RESOURCES_RECON_QUERIES table stores reconciliation queries associated with a reconciliation unit.

Table 1. `REMOTE_RESOURCES_RECON_QUERIES` table
Column Name	Description	Data type
`PROVIDER_ID`^*	Unique ID for each resource provider. References `REMOTE_RESOURCES_RECONS` (`PROVIDER_ID`). Primary key.	Character (20)
`RECON_ID`^*	Unique ID for each reconciliation unit. References `REMOTE_RESOURCES_RECONS` (`RECON_ID`). Primary key.	Numeric
`QUERY_ID`^*	Unique ID for each reconciliation query. Primary key.	Numeric
`RECON_FILTER`	Filter associated with the reconciliation query.	Character (4000)
`RECON_BASE`	Search base associated with the reconciliation query.	Character (4000)
`MAX_DURATION`	Not used.	Numeric
`MAX_ENTRIES`	Not used.	Numeric
`ATTRIBUTES`	Attributes returned during a reconciliation request.	Long Character
`SUPPORT_DATA_ONLY`¹	Indication whether reconciliation only retrieves supporting data. (0/null = normal, 1 = supporting data only recon).	Numeric

^* Indicates the column is required and not null.

¹ Indicates the column or the value is added in release 5.0.