RECONCILIATION table

RECONCILIATION table
This table contains the summary of the information for reconciliation on various service instances. The table contains an entry for all completed reconciliations on various service instances.
Column Name Description Data type

RECONID^* An identifier that identifies a reconciliation uniquely. Primary key. Character (255)

SERVICEDN^* The DN of the service for which this entry is recorded. Character (2000)

PROCESSEDACCOUNTS^* The number of processed accounts that exists for this service instance during the last run of reconciliation. Numeric

LOCALACCOUNTS^* Total number of new local accounts created. It does not include the newly created orphan accounts for this service. Numeric

TIMUSERACCOUNTS^* The number of processed accounts that belongs to users in ISIM. Numeric

POLICYVIOLATIONS^* The number of policy violations found for accounts on this service during reconciliation. This value includes accounts where one or more attribute values are found to be different from the local account. Any attribute value of the account is not compliant with the governing provisioning policies. It does not include accounts where the attribute values of the local and remote accounts are the same, even if the values are noncompliant. Numeric

STARTED^* Time when the reconciliation started. Date

COMPLETED^* Time when the reconciliation completed. Date

ACTIVITY_ID¹ Unique identifier of the activity. Numeric

^* Indicates the column is required and not null.
¹ Indicates the column is added in release 4.6 Express .
Parent topic: Reports tables

Column Name	Description	Data type
RECONID^*	An identifier that identifies a reconciliation uniquely. Primary key.	Character (255)
SERVICEDN^*	The DN of the service for which this entry is recorded.	Character (2000)
PROCESSEDACCOUNTS^*	The number of processed accounts that exists for this service instance during the last run of reconciliation.	Numeric
LOCALACCOUNTS^*	Total number of new local accounts created. It does not include the newly created orphan accounts for this service.	Numeric
TIMUSERACCOUNTS^*	The number of processed accounts that belongs to users in ISIM.	Numeric
POLICYVIOLATIONS^*	The number of policy violations found for accounts on this service during reconciliation. This value includes accounts where one or more attribute values are found to be different from the local account. Any attribute value of the account is not compliant with the governing provisioning policies. It does not include accounts where the attribute values of the local and remote accounts are the same, even if the values are noncompliant.	Numeric
STARTED^*	Time when the reconciliation started.	Date
COMPLETED^*	Time when the reconciliation completed.	Date
ACTIVITY_ID¹	Unique identifier of the activity.	Numeric