REMOTE_RESOURCES_RECONS table

The REMOTE_RESOURCES_RECONS table stores the reconciliation units associated with a resource provider.

Column Name	Description	Data type
PROVIDER_ID*	Unique ID for each resource provider. References RESOURCE_PROVIDERS (PROVIDER_ID). Primary key.	Character (20)
RECON_ID*	Unique ID for each reconciliation unit. Primary key.	Numeric
DAY_OF_MONTH	Day of month the reconciliation is scheduled to run.	Numeric
MONTH_NUM	Month the reconciliation is scheduled to run.	Numeric
DAY_OF_WEEK	Day of week the reconciliation is scheduled to run.	Numeric
HOUR_NUM	Hour of day the reconciliation is scheduled to run.	Numeric
MINUTE_NUM	Minute of hour the reconciliation is scheduled to run.	Numeric
MAX_DURATION	This value overrides the MAX_RECON_DURATION value in the table.	Numeric
LOCK_SERVICE	Indicates whether to lock the service during a reconciliation. Values include: 0 – Do not lock the service during reconciliation. 1 – Lock the service during reconciliatio. Default: .	Numeric
RECON_NAME1	Name of the reconciliation.	Character (300)
DESCRIPTION1	Description of the reconciliation.	Character (300)

^* Indicates the column is required and not null.

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

Parent topic: Services tables