RECONCILIATION_INFO table

This table contains the details of the reconciliation on various service instances.

Column Name Description Data type
RECONID* An identifier that identifies a reconciliation uniquely. References RECONCILIATION(RECONID). Character (255)
ACCOUNTID ID of any entry (for example, an account ID in case of an account reconciliation). Character (255)
POLICYCOMPLIANCESTATUS Policy Compliance Status of each reconciled account. Character (20)
USERNAME Name of the user. Character (255)
OPERATION The operation for the entry of this service instance. The values are codes that represent various operations. Following are the possible values and codes.

  • For account reconciliation:
    • NO: New Orphan
    • NL: New Local
    • MA: Modified Account
    • RL: Removed Local
    • FP: Failed Policy
    • SA: Suspended Account
    • DA: De-provisioned Account

  • For DSML reconciliation:
    • AP: Add Person
    • MP: Modify Person
    • FAP: Failed Add Person
    • FMP: Failed Modify Person
    • UP: Unchanged Person
    • PAP: Pending Add Person
    • PMP: Pending Modify Person
Character (20)
REMARKS Contains the reason for deprovisioning or suspension and the list of attributes in case of modified accounts. Character (1000)
HANDLE1 Only for HR Feed service when workflow is used. The process ID of the workflow request that processed this person entry. -1 for none. Numeric

* Indicates that the column is required and not null.

1 Indicates the column is added in release 4.6 Express .

Parent topic: Reports tables