Column reference: Past Campaign Details report
This topic lists the columns available in the Admin Console UI and the exported file for the Past Campaign Details report.
| Column header (UI) | Column header (in exported file) | Column description |
|---|---|---|
| Campaign id | campaign.id | Unique identifier of the campaign. You can find this in the System Log or from the URL on the campaign's page. |
| Campaign description | campaign.description | Description of the campaign |
| Campaign name | campaign.name | Name of the campaign |
| User | reviewItem.principalUserFullName | Name of the user reviewed |
| User Id | reviewItem.principalUserd | Unique identifier of the user reviewed |
| User email | reviewItem.principalUserEmail | Email address of the user reviewed |
| Resource type | reviewItem.resourceType |
Values indicate the type of resource reviewed:
|
| Resource name | reviewItem.resourceName | Name of the app or group reviewed |
| Resource global name | reviewItem.resourceGlobalName | Okta global name of the app or group reviewed. This could be the official OIN name of the app or the app type. For example, OpenID Connect Client. |
| Resource id | reviewItem.resourceId | Unique identifier of the app or group reviewed |
| Entitlement | reviewItem.entitlementName | Name of the entitlement reviewed. This value is available only if the app being reviewed has entitlements and entitlements are included in the resource scope for the campaign. |
| Reviewer | reviewItem.reviewerFullName | Full name of the user who made the certification decision |
| Reviewer email | reviewItem.reviewerEmail | Email address of the user who made the certification decision |
| Original reviewer | reviewItem.originalReviewerFullName | Full name of the user or the group originally assigned to review access and make the certification decision |
| Original reviewer email | reviewItem.originalReviewerUserEmail | Email address of the user who was originally assigned to review access and make the certification decision |
| Original reviewer id | reviewItem.originalReviewerId | Unique identifier of the user or the group originally assigned to review access and make the certification decision |
| Reviewer reassigned | reviewItem.reviewerReassigned | Yes or No values indicate whether the reassign action was taken by the original reviewer |
| Reviewer delegated | reviewItem.delegated | Yes or No values indicate whether the review item was delegated and the delegate made an approve/revoke decision |
| Certification | reviewItem.certification |
Values indicate the decision made by the reviewer:
|
| Certified | reviewItem.certified | Date when the certification decision was made. This value isn't populated if the reviewer doesn't make a decision. However, remediation may still have occurred based on campaign settings. |
| Business justification | reviewItem.businessJustification | Justification entered by the reviewer with their certification decision |
| Remediation status | reviewItem.remediationStatus |
Values indicate the result of remediation action taken by Okta:
|
| Attempted remediation | reviewItem.attemptedRemediation |
Values indicate the action taken by the system in an attempt to remediate certification decision:
|
| Date Revoked* | reviewItem.revoked | Date when the revoke action was attempted |
| Campaign started* | campaign.started | Date the associated campaign was started |
| Campaign ended* | campaign.ended | Date the associated campaign was ended |
| Reviewer user id | reviewItem.reviewerUserId | Unique identifier of the user who made the certification decision |
| Level 1 reviewer | reviewItem.level1ReviewerFullName | Name of user or group assigned as the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 user id | reviewItem.level1ReviewerUserId | Unique identifier of the user or group assigned as the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 reviewer email | reviewItem.level1ReviewerEmail | Email address of the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 original reviewer id | reviewItem.level1originalReviewerId | Unique identifier of the user or group originally assigned as the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 original reviewer | reviewItem.level1originalReviewerFullName | Name of the user or group originally assigned as the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 original reviewer email | reviewItem.level1originalReviewerEmail | Email address of the Level 1 original reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 decision | reviewItem.level1ReviewerDecision | Certification decision made by the Level 1 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 1 business justification | reviewItem.level1ReviewerBusinessJustification | Justification entered by the Level 1 reviewer with their decision. This is populated only in campaigns with multilevel reviews. |
| Level 2 reviewer | reviewItem.level2ReviewerFullName | Name of the user or group assigned as the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 user id | reviewItem.level2ReviewerUserId | Name of the user or group assigned as the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 reviewer email | reviewItem.level2ReviewerEmail | Email address of the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 original reviewer id | reviewItem.level2originalReviewerId | Unique identifier of the user or group assigned as the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 original reviewer | reviewItem.level2originalReviewerFullName | Name of the user or group originally assigned as the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 original reviewer email | reviewItem.level2originalReviewerEmail | Email address of the user or group assigned as the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 decision | reviewItem.level2ReviewerDecision | Certification decision made by the Level 2 reviewer. This is populated only in campaigns with multilevel reviews. |
| Level 2 business justification | reviewItem.level2ReviewerBusinessJustification | Justification entered by the Level 2 reviewer with their certification decision. This is populated only in campaigns with multilevel reviews. |
| Entitlement type | reviewItem.entitlementType | Indicates if it's an entitlement or an entitlement bundle that was reviewed. |
| Entitlement value id | reviewItem.entitlementId | Unique identifier of the entitlement value of the review |
| SOD rule conflicts | reviewItem.sodRuleConflict | Names of separation of duty rules violated by the entitlement that was reviewed |
| Assignment method | reviewItem.AssignmentMethod |
Value indicates the method used to assign access:
|
* The date and time values associated with campaign's launch and close and access revocation are included in the exported file by default.