REMOTE_RESOURCES_RECON

REMOTE_RESOURCES_RECON_QUERIES table

The REMOTE_RESOURCES_RECON_QUERIES table stores reconciliation queries associated with a reconciliation unit.
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.
Parent topic: Services tables

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