# PeopleFluent Talent Management 24.04
Grid Views

This page lists the views for reportable SmartGrids shipped in the standard configuration of PeopleFluent Talent Management.

<< Return to Initial Data Documentation

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 1: Agency Posts By Requisition Id SmartGrid View (grid based on AgencyInfo Entity)

AgencyInfo Activation Date | Activation Date | AgencyInfoSmartGrid.AgencyInfo Activation Date | DateColumn | agencyGrid_activationDate | false | false | true | true | true | Visible
AgencyInfo Expiration Date | Expiration Date | AgencyInfoSmartGrid.AgencyInfo Expiration Date | DateColumn | agencyGrid_expirationDate | false | false | true | true | true | Visible
AgencyInfo Title | Title | AgencyInfoSmartGrid.AgencyInfo Title | StringColumn | agencyGrid_postedTitle | false | false | true | true | true | Visible
Position Code | Position Code | AgencyInfoSmartGrid.Position Code | StringColumn | Position_Code | false | false | true | true | true | Visible
PositionOpening Id | Requisition ID | AgencyInfoSmartGrid.PositionOpening Id | StringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 2: All Employees All Employees and Contractors SmartGrid View (grid based on HumanResource Entity)

Employee | Name | AdminHumanResourceGrid.Employee | PersonColumn | name | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 3: Benefit History By Employee SmartGrid View (grid based on BenefitHistory Entity)

benefitAmount | Benefit Amount | benefitHistorySmartGrid.benefitAmount | SelectedCurrencyColumn | benefitHist.benefitAmount | false | true | true | true | true | Visible
benefitDescription | Benefit Description | benefitHistorySmartGrid.benefitDescription | StringHoverColumn | benefitHist.benefitDescription | false | false | true | true | true | Visible
currencyCode | Currency Code | benefitHistorySmartGrid.currencyCode | CurrencyTypeColumn | benefitHist.currencyCode | false | false | true | true | true | Visible
personColumn | Name | benefitHistorySmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
planYear | Plan Year | benefitHistorySmartGrid.planYear | IntegerColumn | benefitHist.planYear | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 4: Bonus Histories Default SmartGrid View (grid based on BonusHistory Entity)

bonusAmount | bonusAmount | bonusHistoryDataMapGrid.bonusAmount | BigDecimalColumn | bonusAmount | false | true | true | true | true | Visible
bonusId | bonusId | bonusHistoryDataMapGrid.bonusId | StringColumn | bonusId | false | false | true | true | true | Visible
currencyCode | Currency Code | bonusHistoryDataMapGrid.currencyCode | CurrencyTypeColumn | currencyCode | false | false | true | true | true | Visible
description | Description | bonusHistoryDataMapGrid.description | StringHoverColumn | description | false | false | true | true | true | Visible
hrId | hrId | bonusHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
name | Name | bonusHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
payDate | payDate | bonusHistoryDataMapGrid.payDate | DateColumn | payDate | false | false | true | true | true | Visible
planYear | Plan Year | bonusHistoryDataMapGrid.planYear | IntegerColumn | planYear | true | true | true | true | true | Visible
prorationFactor | Proration Factor | bonusHistoryDataMapGrid.prorationFactor | BigDecimalColumn | prorationFactor | false | true | true | true | true | Visible
sourceSysRefKey | Reference Key | bonusHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 5: Bonus History By Employee SmartGrid View (grid based on BonusHistory Entity)

bonus | Bonus | bonusHistorySmartGrid.bonus | SelectedCurrencyColumn | bonusHistory.bonus | false | true | true | true | true | Visible
currencyCode | Currency Code | bonusHistorySmartGrid.currencyCode | CurrencyTypeColumn | bonusHistory.currencyCode | false | false | true | true | true | Visible
description | Description | bonusHistorySmartGrid.description | StringHoverColumn | bonusHistory.description | false | false | true | true | true | Visible
payDate | Pay Date | bonusHistorySmartGrid.payDate | DateColumn | bonusHistory.payDate | false | false | true | true | true | Visible
personColumn | Name | bonusHistorySmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
playYear | Plan Year | bonusHistorySmartGrid.playYear | IntegerColumn | bonusHistory.planYear | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 6: Bonus Plan Plan Participants SmartGrid View (grid based on IncentivePlanParticipantPayment Entity)

actualAward | Actual Award | incentivePlanParticipPayGrid.actualAward | CurrencyColumn | incentivePlanParticipPay.actualAward | false | true | true | true | true | Read Only
actualAwardPct | Actual Award Pct | incentivePlanParticipPayGrid.actualAwardPct | PercentColumn | incentivePlanParticipPay.actualAwardPct | false | true | true | true | true | Read Only
actualToTargetPct | Actual To Tgt Pct | incentivePlanParticipPayGrid.actualToTargetPct | PercentColumn | incentivePlanParticipPay.actualToTargetPct | false | true | true | true | true | Read Only
alert | Alert | incentivePlanParticipPayGrid.alert | WorksheetAlertColumn | worksheetalertcolumn | true | false | true | true | true | Visible
basisValue | Basis Value | incentivePlanParticipPayGrid.basisValue | CurrencyColumn | incentivePlanParticipPay.basisValue | false | true | true | true | true | Read Only
calculatedAward | Calculated Award | incentivePlanParticipPayGrid.calculatedAward | CurrencyColumn | incentivePlanParticipPay.calculatedAward | false | true | true | true | true | Read Only
calculatedAwardPct | Calculated Award Pct | incentivePlanParticipPayGrid.calculatedAwardPct | PercentColumn | incentivePlanParticipPay.calculatedAwardPct | false | true | true | true | true | Read Only
criteriaValue | Criteria Value | incentivePlanParticipPayGrid.criteriaValue | StringColumn | incentivePlanParticipPay.criteriaValue | false | false | true | true | true | Read Only
fte | FTE | incentivePlanParticipPayGrid.fte | PercentColumn | incentivePlanParticipPay.fte | true | true | true | true | true | Read Only
name | Name | incentivePlanParticipPayGrid.name | PersonColumn | incentivePlanParticipPay.participName | false | false | true | true | true | Visible
payDate | Pay Date | incentivePlanParticipPayGrid.payDate | DateColumn | incentivePlanParticipPay.payDate | false | false | true | true | true | Visible
prorationPct | Proration Factor | incentivePlanParticipPayGrid.prorationPct | PercentColumn | incentivePlanParticipPay.prorationPct | false | true | true | true | true | Read Only
targetAmount | Target Amount | incentivePlanParticipPayGrid.targetAmount | CurrencyColumn | incentivePlanParticipPay.targetAmount | false | true | true | true | true | Read Only
targetPct | Target Pct | incentivePlanParticipPayGrid.targetPct | PercentColumn | incentivePlanParticipPay.targetPct | false | true | true | true | true | Read Only

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 7: Bonus Plan Performance Groups Incentive Plan Perf Groups SmartGrid View (grid based on IncentivePlanPerfGroups Entity)

adjustmentCalcDescI18nKey | Adjustment Calc Decription | incentivePlanPerfGroupsChartableGrid.adjustmentCalcDescI18nKey | TranslatedStringColumn | ipPerfGroupsGrid.adjustmentCalcDescI18nKey | false | false | true | true | true | Visible
adjustmentCalcName | Adjustment Calc Name | incentivePlanPerfGroupsChartableGrid.adjustmentCalcName | StringColumn | ipPerfGroupsGrid.adjustmentCalcName | false | false | true | true | true | Visible
calcType | Goal Type | incentivePlanPerfGroupsChartableGrid.calcType | SystemEnumColumn | ipPerfGroupsGrid.calcType | true | false | true | true | true | Visible
goalName | Goal Name | incentivePlanPerfGroupsChartableGrid.goalName | StringColumn | ipPerfGroupsGrid.goalName | false | false | true | true | true | Visible
goalSsrk | Goal Reference Key | incentivePlanPerfGroupsChartableGrid.goalSsrk | StringColumn | ipPerfGroupsGrid.goalReferenceKey | false | false | true | true | true | Visible
groupValue | Performance Group | incentivePlanPerfGroupsChartableGrid.groupValue | StringColumn | ipPerfGroupsGrid.groupValue | false | false | true | true | true | Visible
modifiedCategoryDesc | Modified Category Description | incentivePlanPerfGroupsChartableGrid.modifiedCategoryDesc | UserEnumValueColumn | ipPerfGroupsGrid.modifiedCategoryDescI18nKey | true | false | true | true | true | Visible
modifiedCategoryName | Modified Category Name | incentivePlanPerfGroupsChartableGrid.modifiedCategoryName | StringColumn | ipPerfGroupsGrid.modifiedCategoryName | false | false | true | true | true | Visible
modifiedGoalName | Modified Goal | incentivePlanPerfGroupsChartableGrid.modifiedGoalName | StringColumn | ipPerfGroupsGrid.modifiedGroupGoalName | false | false | true | true | true | Visible
modifiedGoalSsrk | Modified Goal Reference Key | incentivePlanPerfGroupsChartableGrid.modifiedGoalSsrk | StringColumn | ipPerfGroupsGrid.modifiedGroupGoalReferenceKey | false | false | true | true | true | Visible
name | Bonus Plan Name | incentivePlanPerfGroupsChartableGrid.name | StringColumn | ipPerfGroupsGrid.planName | false | false | true | true | true | Visible
planSsrk | Bonus Plan Reference Key | incentivePlanPerfGroupsChartableGrid.planSsrk | StringColumn | ipPerfGroupsGrid.referenceKey | false | false | true | true | true | Visible
planYear | Bonus Plan Year | incentivePlanPerfGroupsChartableGrid.planYear | IntegerColumn | ipPerfGroupsGrid.planYear | true | true | true | true | true | Visible
sequence | Order | incentivePlanPerfGroupsChartableGrid.sequence | IntegerColumn | ipPerfGroupsGrid.sequence | true | true | true | true | true | Visible
weight | Goal Weight | incentivePlanPerfGroupsChartableGrid.weight | PercentColumn | ipPerfGroupsGrid.weight | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 8: Budget Pools Default SmartGrid View (grid based on WorksheetRunBudgetPoolAggregate Entity)

currencyCode | Currency Code | budgetPoolDataMapGrid.currencyCode | StringColumn | currencyCode | false | false | true | true | true | Visible
ownerHrId | ownerHrId | budgetPoolDataMapGrid.ownerHrId | StringColumn | ownerHrId | false | false | true | true | true | Visible
ownerName | ownerName | budgetPoolDataMapGrid.ownerName | PersonColumn | ownerName | true | false | true | true | true | Visible
parentPoolId | parentPoolId | budgetPoolDataMapGrid.parentPoolId | StringColumn | parentPoolId | false | false | true | true | true | Visible
poolId | poolId | budgetPoolDataMapGrid.poolId | StringColumn | poolId | false | false | true | true | true | Visible
poolName | poolName | budgetPoolDataMapGrid.poolName | StringColumn | poolName | false | false | true | true | true | Visible
rewardCycleId | rewardCycleId | budgetPoolDataMapGrid.rewardCycleId | StringColumn | rewardCycleId | false | false | true | true | true | Visible
rewardCycleName | Reward Cycle Name | budgetPoolDataMapGrid.rewardCycleName | StringColumn | rewardCycleName | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 9: Calibration Summary All Calibration Sessions SmartGrid View (grid based on CalibrationPlacement Entity)

calibBoxName | Calibration Box Name | calibrationPlacementSummaryGrid.calibBoxName | TranslatedStringColumn | rankingGrid.template.calibBoxName | true | false | true | true | true | Visible
Comments | Calibration Comment | calibrationPlacementSummaryGrid.Comments | StringHoverColumn | rankingGrid.template.comments | false | false | true | true | true | Visible
EmployeeMiniProfileNoContextMenus | Name | calibrationPlacementSummaryGrid.EmployeeMiniProfileNoContextMenus | PersonColumn | name | true | false | true | true | true | Visible
horizAxisLabel | Calibration Template X Axis Label | calibrationPlacementSummaryGrid.horizAxisLabel | TranslatedStringColumn | rankingGrid.template.horizAxisLabel | true | false | true | true | true | Visible
horizAxisValueDisplayName | Calibration Template X Axis Value | calibrationPlacementSummaryGrid.horizAxisValueDisplayName | TranslatedStringColumn | rankingGrid.template.horizAxisValue | false | false | false | false | true | Visible
Ranking | Calibration Ranking | calibrationPlacementSummaryGrid.Ranking | StackRankColumn | rankingGrid.template.ranking | true | false | true | true | true | Visible
sessionTitle | Calibration Session Name | calibrationPlacementSummaryGrid.sessionTitle | StringColumn | rankingGrid.calibrationSession.title | false | false | true | true | true | Visible
TemplateDisplayName | Calibration Template Display Name | calibrationPlacementSummaryGrid.TemplateDisplayName | TranslatedStringColumn | rankingGrid.calibrationTemplate.displayName | true | false | true | true | true | Visible
verticalAxisLabel | Calibration Template Y Axis Label | calibrationPlacementSummaryGrid.verticalAxisLabel | TranslatedStringColumn | rankingGrid.template.verticalAxisLabel | true | false | true | true | true | Visible
verticalAxisValueDisplayName | Calibration Template Y Axis Value | calibrationPlacementSummaryGrid.verticalAxisValueDisplayName | TranslatedStringColumn | rankingGrid.template.verticalAxisValue | false | false | false | false | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 10: Candidate Move History By Candidate Name SmartGrid View (grid based on SubmissionMoveHistory Entity)

Candidate Full Name | Candidate Name | SubmissionMoveHistorySmartGrid.Candidate Full Name | PersonColumn | grid.columnHeader.CandidateName | true | false | true | true | true | Visible
createdDate | Moved Date | SubmissionMoveHistorySmartGrid.createdDate | DateColumn | move_date_header | false | false | true | true | true | Visible
fromReqDisplayId | From Requisition Id | SubmissionMoveHistorySmartGrid.fromReqDisplayId | StringColumn | from_move_req_id_header | false | false | true | true | true | Visible
Personal Email | Personal E-mail | SubmissionMoveHistorySmartGrid.Personal Email | ContactInfoColumn | uev.contactsubtype.Personal_E_mail | false | false | true | true | true | Visible
toReqDisplayId | To Requisition Id | SubmissionMoveHistorySmartGrid.toReqDisplayId | StringColumn | to_move_req_id_header | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 11: Candidate Notes By Candidate Name SmartGrid View (grid based on SubmissionNote Entity)

Candidate Full Name | Candidate Name | SubmissionNoteSmartGrid.Candidate Full Name | PersonColumn | grid.columnHeader.CandidateName | true | false | true | true | true | Visible
DisplayID | Requisition ID | SubmissionNoteSmartGrid.DisplayID | LinkedStringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible
note_author | Name | SubmissionNoteSmartGrid.note_author | PersonColumn | name | true | false | true | true | true | Visible
note_createdDate | Created Date | SubmissionNoteSmartGrid.note_createdDate | DateColumn | createdDate | false | false | true | true | true | Visible
note_text | Note | SubmissionNoteSmartGrid.note_text | StringHoverColumn | note.note | false | false | false | false | true | Visible
note_type | Type | SubmissionNoteSmartGrid.note_type | UserEnumValueColumn | type | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 12: Career Aspirations By Employee SmartGrid View (grid based on CareerAspiration Entity)

Aspiration Job Family | Aspiration - Job Family | CareerAspirationGrid.Aspiration Job Family | UserEnumValueColumn | Aspiration_Job_Family | true | false | true | true | true | Visible
Aspiration Job Function | Aspiration - Job Function | CareerAspirationGrid.Aspiration Job Function | UserEnumValueColumn | Aspiration_Job_Function | true | false | true | true | true | Visible
Aspiration Job Title | Aspiration - Job | CareerAspirationGrid.Aspiration Job Title | TranslatedStringColumn | Aspiration_job.JobTitle | true | false | true | true | true | Visible
Aspiration Management Level | Aspiration - Management Level | CareerAspirationGrid.Aspiration Management Level | UserEnumValueColumn | Aspiration_Job_Mgmt_Level | true | false | true | true | true | Visible
comments | Aspiration - Comments | CareerAspirationGrid.comments | StringHoverColumn | Aspiration_Comments | false | false | false | false | true | Visible
identifiedBy | Aspiration - Identified By | CareerAspirationGrid.identifiedBy | PersonColumn | Aspiration_identifiedBy | true | false | true | true | true | Visible
interestLevel | Aspiration - Interest Level | CareerAspirationGrid.interestLevel | UserEnumValueColumn | Aspiration_interestlevel | true | false | true | true | true | Visible
Manager | Manager | CareerAspirationGrid.Manager | PositionManagerColumn | manager.WithMiniProfile | true | false | true | true | true | Visible
Modified Date | Aspiration - Modified Date | CareerAspirationGrid.Modified Date | DateColumn | Aspiration_Modified_Date | false | false | true | true | true | Visible
Name | Name | CareerAspirationGrid.Name | PersonColumn | Aspiration_Name | true | false | true | true | true | Visible
Position Title | Position Title | CareerAspirationGrid.Position Title | StringColumn | positionTitle | true | false | true | true | true | Visible
timing | Aspiration - Timing | CareerAspirationGrid.timing | UserEnumValueColumn | Aspiration_timing | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 13: Competencies Assigned By Employee SmartGrid View (grid based on PerformanceParticipantCompetency Entity)

compDevAction | Associated Development Activities | CompetenciesAssignedGrid.compDevAction | PerformanceCompetencyDevelopmentActionColumn | competenciesAssignedGrid.associatedDevelopmentActivities | false | false | false | false | true | Visible
CompetencyGroupDisplayName | Competency Group | CompetenciesAssignedGrid.CompetencyGroupDisplayName | TranslatedStringColumn | competencyGroup | true | false | true | true | true | Visible
CompetencyName | Competency | CompetenciesAssignedGrid.CompetencyName | TranslatedStringColumn | competencyName | true | false | true | true | true | Visible
ConfidentialPlan | Confidential Plan | CompetenciesAssignedGrid.ConfidentialPlan | YesNoBooleanColumn | confidential_plan | true | false | true | true | true | Visible
Employee | Name | CompetenciesAssignedGrid.Employee | PersonColumn | participant.name | true | false | true | true | true | Visible
isInterimPeriod | Interim | CompetenciesAssignedGrid.isInterimPeriod | BooleanColumn | performance.interimPeriod | true | false | true | true | true | Visible
Job Title | Job Title | CompetenciesAssignedGrid.Job Title | TranslatedStringColumn | performance.job.JobTitle | true | false | true | true | true | Visible
Name | Plan Name | CompetenciesAssignedGrid.Name | TranslatedStringColumn | evaluation.name | true | false | true | true | true | Visible
PlanYear | Year | CompetenciesAssignedGrid.PlanYear | IntegerColumn | evaluation.year | true | true | true | true | true | Visible
ReviewEndDate | Review Period End Date | CompetenciesAssignedGrid.ReviewEndDate | DateColumn | evaluation.end_date | false | false | true | true | true | Visible
ReviewStartDate | Review Period Start Date | CompetenciesAssignedGrid.ReviewStartDate | DateColumn | evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 14: Competency Profile By Employee SmartGrid View (grid based on PublishedCompetencyRating Entity)

Comments | Comments | TeamHRPublishedCompetencyGrid.Comments | StringHoverColumn | competencyProfile.comments | false | false | true | true | true | Visible
CompetencyGroup | Competency Group | TeamHRPublishedCompetencyGrid.CompetencyGroup | TranslatedStringColumn | competencyProfile.competencyGroup | true | false | true | true | true | Visible
CompetencyName | Competency | TeamHRPublishedCompetencyGrid.CompetencyName | TranslatedStringColumn | competencyProfile.competencyName | true | false | true | true | true | Visible
Employee | Name | TeamHRPublishedCompetencyGrid.Employee | PersonColumn | competencyProfile.empName | true | false | true | true | true | Visible
Job Title | Job Title | TeamHRPublishedCompetencyGrid.Job Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
RaterType | Rater Type | TeamHRPublishedCompetencyGrid.RaterType | SystemEnumColumn | competencyProfile.ratingType | true | false | true | true | true | Visible
Rating | Rating - Numeric Value | TeamHRPublishedCompetencyGrid.Rating | RatingScaleValueColumn | competencyProfile.ratingNumeric | true | true | true | true | true | Visible
RatingSource | Rating Source | TeamHRPublishedCompetencyGrid.RatingSource | StringColumn | competencyProfile.ratingSource | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 15: Contact Notes By Contact Name SmartGrid View (grid based on CandidateNote Entity)

Candidate Full Name | Contact Name | CandidateNoteSmartGrid.Candidate Full Name | PersonColumn | candidate.contactName | true | false | true | true | true | Visible
note_author | Name | CandidateNoteSmartGrid.note_author | PersonColumn | name | true | false | true | true | true | Visible
note_createdDate | Created Date | CandidateNoteSmartGrid.note_createdDate | DateColumn | createdDate | false | false | true | true | true | Visible
note_text | Note | CandidateNoteSmartGrid.note_text | StringHoverColumn | note.note | false | false | false | false | true | Visible
note_type | Type | CandidateNoteSmartGrid.note_type | UserEnumValueColumn | type | true | false | true | true | true | Visible
Status | Status | CandidateNoteSmartGrid.Status | SystemEnumColumn | status | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 16: Contacts By Contact Name SmartGrid View (grid based on Candidate Entity)

Candidate Full Name | Contact Name | CandidateSmartGrid.Candidate Full Name | PersonColumn | candidate.contactName | true | false | true | true | true | Visible
Candidate Type | Contact Type | CandidateSmartGrid.Candidate Type | UserEnumValueColumn | Contact_Type | true | false | true | true | true | Visible
Home Country | Country | CandidateSmartGrid.Home Country | PostalAddressContactInfoColumn | country | false | false | true | true | true | Visible
Home Phone | Home Phone | CandidateSmartGrid.Home Phone | ContactInfoColumn | uev.contactsubtype.Home_Phone | false | false | true | true | true | Read Only
Home State | State | CandidateSmartGrid.Home State | PostalAddressContactInfoColumn | state | false | false | true | true | true | Visible
Personal Email | Personal E-mail | CandidateSmartGrid.Personal Email | ContactInfoColumn | uev.contactsubtype.Personal_E_mail | false | false | true | true | true | Visible
Registration Source | Registration Source | CandidateSmartGrid.Registration Source | ListColumn | candidate.registration.source | false | false | false | false | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 17: Delegated Employees By Employee SmartGrid View (grid based on DelegatedParticipant Entity)

Delegatees | Delegatee(s) | DelegationSecurityIdSmartGrid.Delegatees | DelegateesCountColumn | delegatedParticipant.delegatees | false | false | true | false | true | Visible
GlobalPlan | Global Delegation | DelegationSecurityIdSmartGrid.GlobalPlan | BooleanColumn | delegatedParticipant.globalPlan | true | false | true | true | true | Visible
OriginalDelegator | Delegator | DelegationSecurityIdSmartGrid.OriginalDelegator | PersonColumn | delegatedParticipant.originalDelegator | false | false | true | true | true | Visible
Participant | Employee | DelegationSecurityIdSmartGrid.Participant | PersonColumn | delegatedParticipant.participant | true | false | true | true | true | Visible
performancePlanName | Plan Name | DelegationSecurityIdSmartGrid.performancePlanName | TranslatedStringColumn | delegatedParticipant.performancePlan | true | false | true | true | true | Visible
ProcessRole | Process Role | DelegationSecurityIdSmartGrid.ProcessRole | SystemEnumColumn | delegatedParticipant.processRole | true | false | true | true | true | Visible
processType | Process Type | DelegationSecurityIdSmartGrid.processType | SystemEnumColumn | delegatedParticipant.processType | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 18: Delegatees By Employee SmartGrid View (grid based on DelegationDetail Entity)

CreatedBy | Created By | DelegationDetailSecurityIdSmartGrid.CreatedBy | PersonColumn | delegatedParticipan.createdBy | false | false | true | true | true | Visible
CreatedOn | Created On | DelegationDetailSecurityIdSmartGrid.CreatedOn | DateColumn | delegatedParticipan.createdOn | false | false | true | true | true | Visible
Delegatee | Delegatee | DelegationDetailSecurityIdSmartGrid.Delegatee | PersonColumn | delegationDetail.delegatee | false | false | true | true | true | Visible
EndDate | Delegation End Date | DelegationDetailSecurityIdSmartGrid.EndDate | DateColumn | delegationDetailSmartGrid.endDate | false | false | true | true | true | Visible
OriginalDelegator | Delegator | DelegationDetailSecurityIdSmartGrid.OriginalDelegator | PersonColumn | delegatedParticipant.originalDelegator | false | false | true | true | true | Visible
participant | Employee | DelegationDetailSecurityIdSmartGrid.participant | PersonColumn | delegationDetail.employee | false | false | true | true | true | Visible
performancePlanName | Performance Plan | DelegationDetailSecurityIdSmartGrid.performancePlanName | TranslatedStringColumn | delegationDetail.performancePlan | true | false | true | true | true | Visible
processRole | Process Role | DelegationDetailSecurityIdSmartGrid.processRole | SystemEnumColumn | delegationDetail.processRole | true | false | true | true | true | Visible
processType | Process Type | DelegationDetailSecurityIdSmartGrid.processType | SystemEnumColumn | delegationDetail.processType | true | false | true | true | true | Visible
startDate | Delegation Start Date | DelegationDetailSecurityIdSmartGrid.startDate | DateColumn | delegationDetailSmartGrid.startDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 19: Diversity Goals Default SmartGrid View (grid based on DiversityGoal Entity)

Diversity_Asian | Asian | DiversityGoalSmartGrid.Diversity_Asian | BooleanColumn | diversity_goal_asian | true | false | true | true | true | Visible
Diversity_Black | Black | DiversityGoalSmartGrid.Diversity_Black | BooleanColumn | diversity_goal_black | true | false | true | true | true | Visible
Diversity_Female | Female | DiversityGoalSmartGrid.Diversity_Female | BooleanColumn | diversity_goal_female | true | false | true | true | true | Visible
Diversity_HasGoal | Has Goal | DiversityGoalSmartGrid.Diversity_HasGoal | BooleanColumn | diversity_goal_hasGoals | true | false | true | true | true | Visible
Diversity_Hispanic | Hispanic | DiversityGoalSmartGrid.Diversity_Hispanic | BooleanColumn | diversity_goal_hispanic | true | false | true | true | true | Visible
Diversity_Minority | Total Minority | DiversityGoalSmartGrid.Diversity_Minority | BooleanColumn | diversity_goal_minority | true | false | true | true | true | Visible
Diversity_NativeAmerican | Native American | DiversityGoalSmartGrid.Diversity_NativeAmerican | BooleanColumn | diversity_goal_nativeAmerican | true | false | true | true | true | Visible
Diversity_PacificIslander | Pacific Islander | DiversityGoalSmartGrid.Diversity_PacificIslander | BooleanColumn | diversity_goal_pacificIslander | true | false | true | true | true | Visible
Diversity_TwoOrMoreRaces | Multiracial | DiversityGoalSmartGrid.Diversity_TwoOrMoreRaces | BooleanColumn | diversity_goal_twoOrMoreRaces | true | false | true | true | true | Visible
DiversityJobGroup_Code | Job Group Code | DiversityGoalSmartGrid.DiversityJobGroup_Code | StringColumn | diversityJobGroup_code | false | false | true | true | true | Visible
DiversityJobGroup_Name | Job Group Name | DiversityGoalSmartGrid.DiversityJobGroup_Name | StringColumn | diversityJobGroup_displayText | false | false | true | true | true | Visible
DiversityPlan_Code | Plan Code | DiversityGoalSmartGrid.DiversityPlan_Code | StringColumn | diversityPlan_code | false | false | true | true | true | Visible
DiversityPlan_ImportCurrent | Current | DiversityGoalSmartGrid.DiversityPlan_ImportCurrent | BooleanColumn | diversityPlan_import_current | true | false | true | true | true | Visible
DiversityPlan_Name | Plan Name | DiversityGoalSmartGrid.DiversityPlan_Name | StringColumn | diversityPlan_displayText | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 20: Education History By Employee SmartGrid View (grid based on Education Entity)

Degree | Degree | EducationHistoryGrid.Degree | StringColumn | educationHistory.degree | false | false | true | true | true | Visible
Employee | Name | EducationHistoryGrid.Employee | PersonColumn | name | false | false | true | true | true | Visible
endDate | Education End Date | EducationHistoryGrid.endDate | DateColumn | educationHistory.endDate | false | false | true | true | true | Visible
GPA | GPA | EducationHistoryGrid.GPA | StringColumn | educationHistory.gpa | false | false | true | true | true | Visible
major | Major | EducationHistoryGrid.major | StringColumn | educationHistory.major | false | false | true | true | true | Visible
School | School Name | EducationHistoryGrid.School | StringColumn | educationHistory.school | false | false | true | true | true | Visible
schoolType | School Type | EducationHistoryGrid.schoolType | StringColumn | educationHistory.schoolType | false | false | true | true | true | Visible
startDate | Education Start Date | EducationHistoryGrid.startDate | DateColumn | educationHistory.startDate | false | false | true | true | true | Visible
YearGraduated | Year Graduated | EducationHistoryGrid.YearGraduated | StringColumn | educationHistory.yearGraduated | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 21: Eligibility Criteria All Employees and Contractors SmartGrid View (grid based on HumanResource Entity)

EEO Category | Job Category (EEO) | HRSmartGrid.EEO Category | UserEnumValueColumn | gridColumn.job.eeoCategory | true | false | true | true | true | Visible
Employee ID | Employee ID | HRSmartGrid.Employee ID | StringColumn | Employee_ID | false | false | true | true | true | Visible
Job Family | Job Family | HRSmartGrid.Job Family | UserEnumValueColumn | Job_Family | true | false | true | true | true | Visible
Job Title | Job Title | HRSmartGrid.Job Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
Management Level | Management Level | HRSmartGrid.Management Level | UserEnumValueColumn | job_management_level | true | false | true | true | true | Visible
Manager | Manager | HRSmartGrid.Manager | PositionManagerColumn | manager.WithMiniProfile | true | false | true | true | true | Visible
Name | Name | HRSmartGrid.Name | PersonColumn | name | true | false | true | true | true | Visible
Organizations | Organization & Hierarchy | HRSmartGrid.Organizations | OrganizationColumn | requisition.organizationHierarchy | true | false | true | true | true | Visible
Position Title | Position Title | HRSmartGrid.Position Title | StringColumn | positionTitle | true | false | true | true | true | Visible
Salary Grade | Salary Grade | HRSmartGrid.Salary Grade | LinkedStringColumn | salaryGrade | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 22: Employees Default SmartGrid View (grid based on Employee Entity)

adjustedServiceDate | adjustedServiceDate | employeeDataMapGrid.adjustedServiceDate | DateColumn | adjustedServiceDate | false | false | true | true | true | Visible
age | age | employeeDataMapGrid.age | IntegerColumn | age | true | true | true | true | true | Visible
companyEmployeeId | companyEmployeeId | employeeDataMapGrid.companyEmployeeId | StringColumn | companyEmployeeId | false | false | true | true | true | Visible
empActive | empActive | employeeDataMapGrid.empActive | StringColumn | empActive | false | false | true | true | true | Visible
employeeId | employeeId | employeeDataMapGrid.employeeId | StringColumn | employeeId | false | false | true | true | true | Visible
empStatus | empStatus | employeeDataMapGrid.empStatus | StringColumn | empStatus | false | false | true | true | true | Visible
ethnicity | ethnicity | employeeDataMapGrid.ethnicity | StringColumn | ethnicity | false | false | true | true | true | Visible
genderTypeId | genderTypeId | employeeDataMapGrid.genderTypeId | IntegerColumn | genderTypeId | false | false | false | false | true | Visible
genderTypeName | genderTypeName | employeeDataMapGrid.genderTypeName | StringColumn | genderTypeName | false | false | false | false | true | Visible
hrId | hrId | employeeDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
mgrCompanyEmployeeId | mgrCompanyEmployeeId | employeeDataMapGrid.mgrCompanyEmployeeId | PositionManagerIdColumn | mgrCompanyEmployeeId | true | false | true | true | true | Visible
mgrHRId | mgrHRId | employeeDataMapGrid.mgrHRId | PositionManagerHRIdColumn | mgrHRId | false | false | false | false | true | Visible
mgrName | mgrName | employeeDataMapGrid.mgrName | PositionManagerColumn | mgrName | true | false | true | true | true | Visible
name | Name | employeeDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
sourceSysRefKey | Reference Key | employeeDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
startDate | Start Date | employeeDataMapGrid.startDate | DateColumn | startDate | false | false | true | true | true | Visible
timeOfServiceDays | timeOfServiceDays | employeeDataMapGrid.timeOfServiceDays | IntegerColumn | timeOfServiceDays | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 23: Expenses By Requisition Id SmartGrid View (grid based on Expense Entity)

DisplayID | Requisition ID | ExpenseSmartGrid.DisplayID | LinkedStringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible
expense_amount | Expense Amount | ExpenseSmartGrid.expense_amount | BigDecimalColumn | expense_amount | false | true | true | true | true | Visible
expense_amount_type | Expense Type | ExpenseSmartGrid.expense_amount_type | StringColumn | expense_amount_type | false | false | false | false | true | Visible
expense_code | Expense Code | ExpenseSmartGrid.expense_code | UserEnumValueColumn | expense_code | true | false | true | true | true | Visible
expense_description | Expense Description | ExpenseSmartGrid.expense_description | StringHoverColumn | expense_description | false | false | true | true | true | Visible
expense_expenseDate | Expense Date | ExpenseSmartGrid.expense_expenseDate | DateColumn | expense_expenseDate | false | false | true | true | true | Visible
expense_paidTo | Expense Paid To | ExpenseSmartGrid.expense_paidTo | StringColumn | expense_paidTo | false | false | true | true | true | Visible
Hiring Manager Person | Hiring Manager Full Name | ExpenseSmartGrid.Hiring Manager Person | PersonColumn | positionOpeningGrid.HMFullName | true | false | true | true | true | Visible
Lead Recruiter Person | Lead Recruiter Full Name | ExpenseSmartGrid.Lead Recruiter Person | PersonColumn | leadRecruiter.fullName | true | false | true | true | true | Visible
Position Title | Requisition Title | ExpenseSmartGrid.Position Title | StringColumn | requisition.positionTitle | false | false | true | true | true | Visible
Status | Status | ExpenseSmartGrid.Status | SystemEnumColumn | status | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 24: Feedback By Employee SmartGrid View (grid based on Recognition Entity)

associatedCompetency | Feedback Associated Competencies | RecognitionGrid.associatedCompetency | CompetencyCollectionColumn | recognitionNote.associatedCompetency | false | false | true | false | true | Visible
author | Feedback Provider | RecognitionGrid.author | PersonColumn | recognitionNote.author | true | false | true | true | true | Visible
category | Feedback Category | RecognitionGrid.category | UserEnumValueColumn | recognitionNote.category | true | false | true | true | true | Visible
createdDate | Feedback Created Date | RecognitionGrid.createdDate | DateColumn | recognitionNote.createdDate | false | false | true | true | true | Visible
Manager | Manager | RecognitionGrid.Manager | PositionManagerColumn | manager.WithMiniProfile | true | false | true | true | true | Visible
noteSubject | Feedback Subject | RecognitionGrid.noteSubject | LinkedStringColumn | recognitionNote.subject | true | false | true | true | true | Visible
observations | Feedback Observations | RecognitionGrid.observations | StringHoverColumn | recognitionNote.observations | false | false | false | false | true | Visible
Position Title | Position Title | RecognitionGrid.Position Title | StringColumn | positionTitle | true | false | true | true | true | Visible
receiver | Name | RecognitionGrid.receiver | PersonColumn | recognitionNote.receiver | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 25: Goal Alignment to Organizational Goals By Employee SmartGrid View (grid based on AlignedGoal Entity)

Employee | Name | IndividualGoalAlignedToOrgGoalGrid.Employee | PersonColumn | Name | true | false | true | true | true | Visible
goalName | Aligned Organization Goal Name | IndividualGoalAlignedToOrgGoalGrid.goalName | TranslatedStringColumn | organizationGoal.goalName | true | false | true | true | true | Visible
goalTitle | Goal Name | IndividualGoalAlignedToOrgGoalGrid.goalTitle | StringColumn | organization.goal.name | false | false | true | true | true | Visible
goalWeightInt | Goal Weight (%) | IndividualGoalAlignedToOrgGoalGrid.goalWeightInt | IntegerColumn | goal.weight.percent | true | true | true | true | true | Visible
indGoalCategory | Goal Category | IndividualGoalAlignedToOrgGoalGrid.indGoalCategory | UserEnumValueColumn | individual.goal.category | true | false | true | true | true | Visible
Manager | Manager | IndividualGoalAlignedToOrgGoalGrid.Manager | PositionManagerColumn | performance.manager | true | false | true | true | true | Visible
Name | Plan Name | IndividualGoalAlignedToOrgGoalGrid.Name | TranslatedStringColumn | individual.evaluation.name | true | false | true | true | true | Visible
ParticipantTitle | Position Title | IndividualGoalAlignedToOrgGoalGrid.ParticipantTitle | StringColumn | performance.positionTitle | false | false | true | true | true | Visible
performanceGoalProgress | Goal Progress | IndividualGoalAlignedToOrgGoalGrid.performanceGoalProgress | SystemEnumColumn | goal.progress | true | false | true | true | true | Visible
PlanYear | Year | IndividualGoalAlignedToOrgGoalGrid.PlanYear | IntegerColumn | evaluation.year | true | true | true | true | true | Visible
ReviewEndDate | Review Period End Date | IndividualGoalAlignedToOrgGoalGrid.ReviewEndDate | DateColumn | evaluation.end_date | false | false | true | true | true | Visible
ReviewStartDate | Review Period Start Date | IndividualGoalAlignedToOrgGoalGrid.ReviewStartDate | DateColumn | evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 26: Goal Dimensions By Goal Name SmartGrid View (grid based on GoalDimension Entity)

goaldim_achievement | Achievement | goalDimensionGrid.goaldim_achievement | GoalAchievementValueColumn | goaldimsmartgrid_achievement | false | false | false | false | true | Visible
goaldim_actual | Actual Value | goalDimensionGrid.goaldim_actual | GoalMeasurementValueColumn | goaldimsmartgrid_actual | false | false | false | false | true | Visible
goaldim_calendar | Goal Calendar | goalDimensionGrid.goaldim_calendar | StringColumn | goaldimsmartgrid_calendar | true | false | true | true | true | Visible
goaldim_calenddate | Goal Calendar End Date | goalDimensionGrid.goaldim_calenddate | DateColumn | goaldimsmartgrid_calenddate | false | false | true | true | true | Visible
goaldim_calstartdate | Goal Calendar Start Date | goalDimensionGrid.goaldim_calstartdate | DateColumn | goaldimsmartgrid_calstartdate | false | false | true | true | true | Visible
goaldim_dimensionValue | Dimension Value | goalDimensionGrid.goaldim_dimensionValue | GoalDimensionValueColumn | goaldimsmartgrid_dimensionvalue | true | false | true | true | true | Visible
goaldim_goaldisplayName | Goal Display Name | goalDimensionGrid.goaldim_goaldisplayName | TranslatedStringColumn | goaldimsmartgrid_goaldisplayname | true | false | true | true | true | Visible
goaldim_rating | Rating | goalDimensionGrid.goaldim_rating | FloatColumn | goaldimsmartgrid_rating | true | true | true | true | true | Visible
goaldim_stretchtarget | Stretch Target | goalDimensionGrid.goaldim_stretchtarget | GoalMeasurementValueColumn | goaldimsmartgrid_stretchtarget | false | false | false | false | true | Visible
goaldim_target | Base Target Value | goalDimensionGrid.goaldim_target | GoalMeasurementValueColumn | goaldimsmartgrid_target | false | false | false | false | true | Visible
goaldim_thresholdtarget | Threshold Target | goalDimensionGrid.goaldim_thresholdtarget | GoalMeasurementValueColumn | goaldimsmartgrid_threshholdtarget | false | false | false | false | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 27: Goal Measurement Periods By Goal Measurement Periods SmartGrid View (grid based on GoalResult Entity)

goalRatingsPeriod_actual | Actual Value | goalRatingsPeriodGrid.goalRatingsPeriod_actual | GoalMeasurementValueColumn | goaldimsmartgrid_actual | false | false | false | false | true | Visible
goalRatingsPeriod_dimensionValue | Dimension Value | goalRatingsPeriodGrid.goalRatingsPeriod_dimensionValue | GoalResultValueColumn | goaldimsmartgrid_dimensionvalue | true | false | true | true | true | Visible
goalRatingsPeriod_endDate | End Date | goalRatingsPeriodGrid.goalRatingsPeriod_endDate | DateColumn | goalRatingsPeriodSmartGrid_endDate | false | false | true | true | true | Visible
goalRatingsPeriod_goaldisplayName | Goal Display Name | goalRatingsPeriodGrid.goalRatingsPeriod_goaldisplayName | TranslatedStringColumn | goaldimsmartgrid_goaldisplayname | true | false | true | true | true | Visible
goalRatingsPeriod_measureMentValue | Measurement Value | goalRatingsPeriodGrid.goalRatingsPeriod_measureMentValue | StringColumn | goalRatingsPeriodSmartGrid_measurementvalue | true | false | true | true | true | Visible
goalRatingsPeriod_startDate | Start Date | goalRatingsPeriodGrid.goalRatingsPeriod_startDate | DateColumn | goalRatingsPeriodSmartGrid_startDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 28: Goal Rating Details By Category SmartGrid View (grid based on DenormalizedEvaluationData Entity)

eeGoalWeighterRating | Employee Goal Weighted Rating | TeamHRGoalRatingDetailsGrid.eeGoalWeighterRating | RatingCalculationColumn | ee.goal.weight.rating | true | true | true | true | true | Visible
Employee | Name | TeamHRGoalRatingDetailsGrid.Employee | PersonColumn | participant.name | true | false | true | true | true | Visible
employeerating | Employee Goal Rating | TeamHRGoalRatingDetailsGrid.employeerating | RatingScaleValueDisplayNameColumn | goal.employee_rating | true | false | true | true | true | Visible
goalcategory | Goal Category | TeamHRGoalRatingDetailsGrid.goalcategory | UserEnumValueColumn | goal.category | true | false | true | true | true | Visible
goalTitle | Goal Title | TeamHRGoalRatingDetailsGrid.goalTitle | StringColumn | goal.name | false | false | true | true | true | Visible
goalWeightInt | Goal Weight (%) | TeamHRGoalRatingDetailsGrid.goalWeightInt | IntegerColumn | goal.weight.percent | true | true | true | true | true | Visible
Historical_Manger | Manager of Record | TeamHRGoalRatingDetailsGrid.Historical_Manger | PersonColumn | performance.manager.completion | true | false | true | true | true | Visible
isInterimPeriod | Interim | TeamHRGoalRatingDetailsGrid.isInterimPeriod | BooleanColumn | performance.interimPeriod | true | false | true | true | true | Visible
ManagerEmpGap | Goal Rating Gap | TeamHRGoalRatingDetailsGrid.ManagerEmpGap | RatingScaleValueGapColumn | goal.rating.gap | true | true | true | true | true | Visible
managerrating | Manager Goal Rating | TeamHRGoalRatingDetailsGrid.managerrating | RatingScaleValueDisplayNameColumn | goal.manager_rating | true | false | true | true | true | Visible
mgrGoalWeighterRating | Manager Goal Weighted Rating | TeamHRGoalRatingDetailsGrid.mgrGoalWeighterRating | RatingCalculationColumn | mgr.goal.weight.rating | true | true | true | true | true | Visible
Name | Plan Name | TeamHRGoalRatingDetailsGrid.Name | TranslatedStringColumn | evaluation.name | true | false | true | true | true | Visible
ParticipantTitle | Position Title of Record | TeamHRGoalRatingDetailsGrid.ParticipantTitle | StringColumn | performance.positionTitle.completion | false | false | true | true | true | Visible
PlanYear | Year | TeamHRGoalRatingDetailsGrid.PlanYear | IntegerColumn | evaluation.year | true | true | true | true | true | Visible
ReviewEndDate | Review Period End Date | TeamHRGoalRatingDetailsGrid.ReviewEndDate | DateColumn | evaluation.end_date | false | false | true | true | true | Visible
ReviewStartDate | Review Period Start Date | TeamHRGoalRatingDetailsGrid.ReviewStartDate | DateColumn | evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 29: Goal Repository By Dimension SmartGrid View (grid based on Goal Entity)

goal_calendar | Active Calendar | goalRepositoryGrid.goal_calendar | TranslatedStringColumn | goalsmartgrid_calendar | false | false | false | true | true | Visible
goal_description | Description | goalRepositoryGrid.goal_description | TranslatedStringColumn | goalsmartgrid_description | true | false | true | true | true | Visible
goal_dimensioncriteria | Dimension Criteria | goalRepositoryGrid.goal_dimensioncriteria | StringColumn | goalsmartgrid_dimensioncriteria | true | false | true | true | true | Visible
goal_displayName | Display Name | goalRepositoryGrid.goal_displayName | TranslatedStringColumn | goalsmartgrid_displayname | true | false | true | true | true | Visible
goal_year | Year | goalRepositoryGrid.goal_year | IntegerColumn | goalsmartgrid_goalyear | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 30: Inactive People (Succession) Summary SmartGrid View (grid based on EmploymentInstance Entity)

Employee | Name | LastEmploymentInstanceGrid.Employee | LinkablePersonColumn | name | false | false | true | true | true | Visible
Employee Active | Status Category | LastEmploymentInstanceGrid.Employee Active | UserEnumValueColumn | employee.isActive | true | false | true | true | true | Visible
Employee Status | Status | LastEmploymentInstanceGrid.Employee Status | UserEnumValueColumn | employee.status | true | false | true | true | true | Visible
Employment Instance End Date | Employment End Date | LastEmploymentInstanceGrid.Employment Instance End Date | DateColumn | ei_end_date | false | false | true | true | true | Visible
Employment Instance Start Date | Employment Start Date | LastEmploymentInstanceGrid.Employment Instance Start Date | DateColumn | ei_start_date | false | false | true | true | true | Visible
lossImpact | Loss Impact | LastEmploymentInstanceGrid.lossImpact | UserEnumValueColumn | emp_talent_loss_impact | true | false | true | true | true | Visible
Position Title | Position Title | LastEmploymentInstanceGrid.Position Title | StringDerivedColumn | positionTitle | false | false | true | true | true | Visible
Short Name | Organization Short Name | LastEmploymentInstanceGrid.Short Name | StringColumn | organization.shortName | false | false | true | true | true | Visible
Slate Members Count | Successors - Count | LastEmploymentInstanceGrid.Slate Members Count | SlateMemberCountColumn | SlateMembersCount | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 31: Incentive Plan Code History By Employee SmartGrid View (grid based on IncentivePlanCode Entity)

category | Category | incentivePlanCodeSmartGrid.category | UserEnumValueColumn | incentivePlanCodeDetail.category | true | false | true | true | true | Visible
description | Description | incentivePlanCodeSmartGrid.description | StringColumn | incentivePlanCodeDetail.description | false | false | true | true | true | Visible
effectiveDate | Effective Date | incentivePlanCodeSmartGrid.effectiveDate | DateColumn | incentivePlanCodeDetail.effectiveDate | false | false | true | true | true | Visible
personColumn | Name | incentivePlanCodeSmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
planCode | Code | incentivePlanCodeSmartGrid.planCode | StringColumn | incentivePlanCodeDetail.planCode | false | false | true | true | true | Visible
ssrk | Reference Key | incentivePlanCodeSmartGrid.ssrk | StringColumn | incentivePlanCodeDetail.sourceSysRefKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 32: Incentive Plan Codes Default SmartGrid View (grid based on IncentivePlanCode Entity)

category | Category | incentivePlanCodeDataMapGrid.category | StringColumn | category | false | false | true | true | true | Visible
description | Description | incentivePlanCodeDataMapGrid.description | StringColumn | description | false | false | true | true | true | Visible
effectiveDate | Effective Date | incentivePlanCodeDataMapGrid.effectiveDate | DateColumn | effectiveDate | false | false | true | true | true | Visible
endDate | End Date | incentivePlanCodeDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
hrId | hrId | incentivePlanCodeDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
name | Name | incentivePlanCodeDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
planCode | Plan Code | incentivePlanCodeDataMapGrid.planCode | StringColumn | planCode | false | false | true | true | true | Visible
planCodeId | planCodeId | incentivePlanCodeDataMapGrid.planCodeId | StringColumn | planCodeId | false | false | true | true | true | Visible
referenceKey | Reference Key | incentivePlanCodeDataMapGrid.referenceKey | StringColumn | referenceKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 33: Incentive Target History By Employee SmartGrid View (grid based on IncentiveTarget Entity)

category | Category | incentiveTargetSmartGrid.category | UserEnumValueColumn | incentiveTargetDetail.category | true | false | true | true | true | Visible
description | Description | incentiveTargetSmartGrid.description | StringColumn | incentiveTargetDetail.description | false | false | true | true | true | Visible
effectiveDate | Effective Date | incentiveTargetSmartGrid.effectiveDate | DateColumn | incentiveTargetDetail.effectiveDate | false | false | true | true | true | Visible
endDate | End Date | incentiveTargetSmartGrid.endDate | DateColumn | incentiveTargetDetail.endDate | false | false | true | true | true | Visible
Max | Maximum Amount | incentiveTargetSmartGrid.Max | UnitsColumn | incentiveTargetDetail.maxAmt | false | true | true | true | true | Visible
Min | Minimum Amount | incentiveTargetSmartGrid.Min | UnitsColumn | incentiveTargetDetail.minAmt | false | true | true | true | true | Visible
personColumn | Name | incentiveTargetSmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
ssrk | Reference Key | incentiveTargetSmartGrid.ssrk | StringColumn | incentiveTargetDetail.sourceSysRefKey | false | false | true | true | true | Visible
Target | Target Amount | incentiveTargetSmartGrid.Target | UnitsColumn | incentiveTargetDetail.targetAmt | false | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 34: Incentive Targets Default SmartGrid View (grid based on IncentiveTarget Entity)

category | Category | incentiveTargetDataMapGrid.category | StringColumn | category | false | false | true | true | true | Visible
description | Description | incentiveTargetDataMapGrid.description | StringColumn | description | false | false | true | true | true | Visible
effectiveDate | Effective Date | incentiveTargetDataMapGrid.effectiveDate | DateColumn | effectiveDate | false | false | true | true | true | Visible
endDate | End Date | incentiveTargetDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
hrId | hrId | incentiveTargetDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
maxAmt | maxAmt | incentiveTargetDataMapGrid.maxAmt | BigDecimalColumn | maxAmt | false | true | true | true | true | Visible
minAmt | minAmt | incentiveTargetDataMapGrid.minAmt | BigDecimalColumn | minAmt | false | true | true | true | true | Visible
name | Name | incentiveTargetDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
sourceSysRefKey | Reference Key | incentiveTargetDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
targetAmt | targetAmt | incentiveTargetDataMapGrid.targetAmt | BigDecimalColumn | targetAmt | false | true | true | true | true | Visible
targetId | targetId | incentiveTargetDataMapGrid.targetId | StringColumn | targetId | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 35: Individual Goals Alignment By Employee SmartGrid View (grid based on IndividualGoalAlignment Entity)

AlignedToGoalgoalTitle | Aligned Goal Title | TeamHRGoalAlignmentDetailsGrid.AlignedToGoalgoalTitle | StringColumn | PerfGoalAlignGrid_AlignedToGoalPrefix_goal.name | false | false | true | true | true | Visible
GoalEmployee | Name | TeamHRGoalAlignmentDetailsGrid.GoalEmployee | PersonColumn | PerfGoalAlignGrid_GoalPrefix_name | true | false | true | true | true | Visible
Goalgoalcategory | Goal Category | TeamHRGoalAlignmentDetailsGrid.Goalgoalcategory | UserEnumValueColumn | PerfGoalAlignGrid_GoalPrefix_goal.category | true | false | true | true | true | Visible
GoalgoalProgress | Goal Progress | TeamHRGoalAlignmentDetailsGrid.GoalgoalProgress | SystemEnumColumn | PerfGoalAlignGrid_GoalPrefix_goal.progress | true | false | true | true | true | Visible
GoalgoalTitle | Goal Title | TeamHRGoalAlignmentDetailsGrid.GoalgoalTitle | StringColumn | PerfGoalAlignGrid_GoalPrefix_goal.name | false | false | true | true | true | Visible
GoalgoalWeightInt | Goal Weight (%) | TeamHRGoalAlignmentDetailsGrid.GoalgoalWeightInt | IntegerColumn | PerfGoalAlignGrid_GoalPrefix_goal.weight.percent | true | true | true | true | true | Visible
GoalManager | Manager | TeamHRGoalAlignmentDetailsGrid.GoalManager | PositionManagerColumn | PerfGoalAlignGrid_GoalPrefix_performance.manager | true | false | true | true | true | Visible
GoalName | Plan Name | TeamHRGoalAlignmentDetailsGrid.GoalName | TranslatedStringColumn | PerfGoalAlignGrid_GoalPrefix_evaluation.name | true | false | true | true | true | Visible
GoalParticipantTitle | Position Title | TeamHRGoalAlignmentDetailsGrid.GoalParticipantTitle | StringColumn | PerfGoalAlignGrid_GoalPrefix_performance.positionTitle | false | false | true | true | true | Visible
GoalPlanYear | Year | TeamHRGoalAlignmentDetailsGrid.GoalPlanYear | IntegerColumn | PerfGoalAlignGrid_GoalPrefix_evaluation.year | true | true | true | true | true | Visible
GoalReviewEndDate | Review Period End Date | TeamHRGoalAlignmentDetailsGrid.GoalReviewEndDate | DateColumn | PerfGoalAlignGrid_GoalPrefix_evaluation.end_date | false | false | true | true | true | Visible
GoalReviewStartDate | Review Period Start Date | TeamHRGoalAlignmentDetailsGrid.GoalReviewStartDate | DateColumn | PerfGoalAlignGrid_GoalPrefix_evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 36: Interviews By Candidate Name SmartGrid View (grid based on Interviewer Entity)

Candidate Full Name | Candidate Name | InterviewSmartGrid.Candidate Full Name | PersonColumn | grid.columnHeader.CandidateName | true | false | true | true | true | Visible
DisplayID | Requisition ID | InterviewSmartGrid.DisplayID | LinkedStringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible
interview_location | Interview Location | InterviewSmartGrid.interview_location | StringColumn | interview_location | false | false | true | true | true | Visible
interview_scheduledTime | Interview Date | InterviewSmartGrid.interview_scheduledTime | DateColumn | interview.startDate | false | false | true | true | true | Visible
interview_submissionStatus | Interview Status | InterviewSmartGrid.interview_submissionStatus | UserEnumValueColumn | interviewStatus | true | false | true | true | true | Visible
interview_type | Interview Type | InterviewSmartGrid.interview_type | UserEnumValueColumn | interview_type | true | false | true | true | true | Visible
interviewer_assessment | Overall Assessment | InterviewSmartGrid.interviewer_assessment | RatingScaleValueConvertorColumnWithRatingStyle | interviewer.assessment | true | true | true | true | true | Visible
interviewer_comments | Comments | InterviewSmartGrid.interviewer_comments | StringHoverColumn | comments | false | false | true | false | true | Visible
interviewer_humanResource | Interviewer | InterviewSmartGrid.interviewer_humanResource | PersonColumn | interviewer | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 37: Job Essentials Results By Employee SmartGrid View (grid based on DenormalizedEvaluationData Entity)

Employee | Name | TeamHRJobEssentialsResultsGrid.Employee | PersonColumn | participant.name | true | false | true | true | true | Visible
evalworkflowstatus | Final Evaluation Workflow State | TeamHRJobEssentialsResultsGrid.evalworkflowstatus | TranslatedStringColumn | eval.workflow.state | true | false | true | true | true | Visible
isInterimPeriod | Interim | TeamHRJobEssentialsResultsGrid.isInterimPeriod | BooleanColumn | performance.interimPeriod | true | false | true | true | true | Visible
Job Title | Job Title | TeamHRJobEssentialsResultsGrid.Job Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
jobEssentialName | Job Essential | TeamHRJobEssentialsResultsGrid.jobEssentialName | TranslatedStringColumn | jobEssentialName | true | false | true | true | true | Visible
ManagerRatingScale | Manager Rating - Scale Value | TeamHRJobEssentialsResultsGrid.ManagerRatingScale | RatingScaleValueDisplayNameColumn | mgr.jobEssential_rating_displayName | true | false | true | true | true | Visible
Name | Plan Name | TeamHRJobEssentialsResultsGrid.Name | TranslatedStringColumn | evaluation.name | true | false | true | true | true | Visible
PlanYear | Year | TeamHRJobEssentialsResultsGrid.PlanYear | IntegerColumn | evaluation.year | true | true | true | true | true | Visible
ReviewEndDate | Review Period End Date | TeamHRJobEssentialsResultsGrid.ReviewEndDate | DateColumn | evaluation.end_date | false | false | true | true | true | Visible
ReviewStartDate | Review Period Start Date | TeamHRJobEssentialsResultsGrid.ReviewStartDate | DateColumn | evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 38: Job Histories Default SmartGrid View (grid based on EmploymentInstance Entity)

code | code | jobHistoryDataMapGrid.code | StringColumn | code | false | false | true | true | true | Visible
description | Description | jobHistoryDataMapGrid.description | StringHoverColumn | description | false | false | false | false | true | Visible
eeoCategory | Job Category (EEO) | jobHistoryDataMapGrid.eeoCategory | StringColumn | eeoCategory | false | false | true | true | true | Visible
employeeType | employeeType | jobHistoryDataMapGrid.employeeType | StringColumn | employeeType | false | false | true | true | true | Visible
endDate | End Date | jobHistoryDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
flsaExempt | FLSA Exempt | jobHistoryDataMapGrid.flsaExempt | BooleanColumn | flsaExempt | true | false | true | true | true | Visible
grade | grade | jobHistoryDataMapGrid.grade | StringColumn | grade | false | false | true | true | true | Visible
hrId | hrId | jobHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
inactive | Inactive | jobHistoryDataMapGrid.inactive | BooleanColumn | inactive | true | false | true | true | true | Visible
jobFamily | Job Family | jobHistoryDataMapGrid.jobFamily | StringColumn | jobFamily | false | false | true | true | true | Visible
jobFunction | jobFunction | jobHistoryDataMapGrid.jobFunction | StringColumn | jobFunction | false | false | true | true | true | Visible
jobId | jobId | jobHistoryDataMapGrid.jobId | StringColumn | jobId | false | false | true | true | true | Visible
managementJob | managementJob | jobHistoryDataMapGrid.managementJob | BooleanColumn | managementJob | true | false | true | true | true | Visible
managementLevel | managementLevel | jobHistoryDataMapGrid.managementLevel | StringColumn | managementLevel | false | false | true | true | true | Visible
name | Name | jobHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
promoCategory | promoCategory | jobHistoryDataMapGrid.promoCategory | StringColumn | promoCategory | false | false | true | true | true | Visible
promoRank | promoRank | jobHistoryDataMapGrid.promoRank | IntegerColumn | promoRank | true | true | true | true | true | Visible
sourceSysRefKey | Reference Key | jobHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
startDate | Start Date | jobHistoryDataMapGrid.startDate | DateColumn | startDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 39: Job Pool Members Pool Members SmartGrid View (grid based on QualifiedTalentPoolMember Entity)

EmployeeNoContactInfo | Name | jobQualifiedTalentPoolMemberGrid.EmployeeNoContactInfo | PersonColumn | name | false | false | true | true | true | Visible
Search Method | Pool Member's Search Method | jobQualifiedTalentPoolMemberGrid.Search Method | SystemEnumColumn | potential_successors_search_method | true | false | true | true | true | Visible
Successor Readiness | Pool Member's Readiness | jobQualifiedTalentPoolMemberGrid.Successor Readiness | UserEnumValueColumn | potential_successors_readiness | true | false | true | true | true | Visible
Successor Source | Pool Member's Source | jobQualifiedTalentPoolMemberGrid.Successor Source | UserEnumValueColumn | potential_successors_source | true | false | true | true | true | Visible
TimeInPositionFormatted | Pool Member's Time in Position | jobQualifiedTalentPoolMemberGrid.TimeInPositionFormatted | DurationColumn | potential_successors_Time_In_Position | true | false | true | true | true | Visible
TimeWithCompanyFormatted | Pool Member's Time with Company | jobQualifiedTalentPoolMemberGrid.TimeWithCompanyFormatted | DurationColumn | potential_successors_Time_With_Company | true | false | true | true | true | Visible
Title | Job Title | jobQualifiedTalentPoolMemberGrid.Title | LinkedTranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 40: Job Posts By Requisition Id SmartGrid View (grid based on PostingInfo Entity)

Active Posting Info | Active Posting | PostingInfoSmartGrid.Active Posting Info | ActiveChannelInfoPostColumn | postingInfo.activ.label | false | false | true | false | true | Visible
Channel Name | Channel Name | PostingInfoSmartGrid.Channel Name | StringColumn | channel.name | true | false | true | true | true | Visible
Position Code | Position Code | PostingInfoSmartGrid.Position Code | StringColumn | Position_Code | false | false | true | true | true | Visible
PositionOpening Id | Requisition ID | PostingInfoSmartGrid.PositionOpening Id | StringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible
Posting Title | Title | PostingInfoSmartGrid.Posting Title | LinkedStringDerivedColumn | empprofile.careerPlan.searchOpenPositions.postingInfo.title | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 41: Jobs For Succession Planning Summary SmartGrid View (grid based on Job Entity)

Code | Job Code | SuccessionJobSmartGrid.Code | SuccessionJobCodeLinkedStringColumn | Job_Code | false | false | true | true | true | Visible
Job Category EEO | Job Category (EEO) | SuccessionJobSmartGrid.Job Category EEO | UserEnumValueColumn | gridColumn.job.category.eeo | true | false | true | true | true | Visible
Job Family | Job Family | SuccessionJobSmartGrid.Job Family | UserEnumValueColumn | Job_Family | true | false | true | true | true | Visible
Management Level | Management Level | SuccessionJobSmartGrid.Management Level | UserEnumValueColumn | job_management_level | true | false | true | true | true | Visible
Slateable | Job Pooling Enabled | SuccessionJobSmartGrid.Slateable | YesNoBooleanColumn | succession_Enable.Job.Pooling | true | false | true | true | true | Visible
Talent Pool Count | Job Pool - Count | SuccessionJobSmartGrid.Talent Pool Count | JobTalentPoolMemberCountColumn | Job.Talent.Pool.Count | true | true | true | true | true | Visible
Title | Job Title | SuccessionJobSmartGrid.Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
Turnover | Turnover | SuccessionJobSmartGrid.Turnover | JobStatisticsColumn | job.Statistics.Turnover | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 42: Journal Entries By Employee SmartGrid View (grid based on Journal Entity)

Author | Journal Author | JournalGrid.Author | PersonColumn | journal.author | true | false | true | true | true | Visible
Category | Journal Category | JournalGrid.Category | UserEnumValueColumn | journal.grid.category | true | false | true | true | true | Visible
CreatedDate | Journal Date Created | JournalGrid.CreatedDate | DateColumn | journal.createdDate | false | false | true | true | true | Visible
LastModifiedDate | Journal Last Updated | JournalGrid.LastModifiedDate | DateColumn | journal.lastModifiedDate | false | false | true | true | true | Visible
Subject | Name | JournalGrid.Subject | PersonColumn | journal.subject | true | false | true | true | true | Visible
Text | Journal Notes | JournalGrid.Text | StringHoverColumn | journal.grid.text | false | false | false | false | true | Visible
Title | Journal Entry Description | JournalGrid.Title | StringColumn | journal.grid.title | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 43: Letters By Candidate Name SmartGrid View (grid based on Letter Entity)

Candidate Full Name | Candidate Name | LetterSmartGrid.Candidate Full Name | PersonColumn | grid.columnHeader.CandidateName | true | false | true | true | true | Visible
letter_author | Author | LetterSmartGrid.letter_author | PersonColumn | letterGrid.author | true | false | true | true | true | Visible
letter_createdDate | Created Date | LetterSmartGrid.letter_createdDate | DateColumn | letter.createdDate | false | false | true | true | true | Visible
letter_letterText | Letter Text | LetterSmartGrid.letter_letterText | StringHoverColumn | letter.text | false | false | false | false | true | Visible
letter_letterType | Letter Type | LetterSmartGrid.letter_letterType | UserEnumValueColumn | letterGrid.letterType | true | false | true | true | true | Visible
letter_recipientType | Recipients | LetterSmartGrid.letter_recipientType | SystemEnumColumn | letter_recipientType | true | false | true | true | true | Visible
letter_subject | Subject | LetterSmartGrid.letter_subject | StringHoverColumn | subject | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 44: License Usage Counts By Run Date SmartGrid View (grid based on LicenseUsage Entity)

auditQuantity | Audit Quantity | LicenseUsageCountsGrid.auditQuantity | IntegerColumn | licenseUsage.auditQuantity | true | true | true | true | true | Visible
customer | Customer | LicenseUsageCountsGrid.customer | StringColumn | licenseUsage.customer | false | false | true | true | true | Visible
effectiveLicAlertsEnabled | Effective License Alerts Enabled | LicenseUsageCountsGrid.effectiveLicAlertsEnabled | BooleanColumn | licenseUsage.effectiveLicAlertsEnabled | true | false | true | true | true | Visible
effectiveLicAlertThrPct | Effective License Alert Threshold Pct | LicenseUsageCountsGrid.effectiveLicAlertThrPct | PercentColumn | licenseUsage.effectiveLicAlertThrPct | false | true | true | true | true | Visible
effectiveLicAsOfDate | Effective License As Of Date | LicenseUsageCountsGrid.effectiveLicAsOfDate | DateColumn | licenseUsage.effectiveLicAsOfDate | false | false | true | true | true | Visible
isAlertForModule | Is Alert For Module | LicenseUsageCountsGrid.isAlertForModule | BooleanColumn | licenseUsage.isAlertForModule | true | false | true | true | true | Visible
licQuantity | License Quantity | LicenseUsageCountsGrid.licQuantity | IntegerColumn | licenseUsage.licQuantity | true | true | true | true | true | Visible
module | Module | LicenseUsageCountsGrid.module | StringColumn | licenseUsage.module | false | false | true | true | true | Visible
overage | Overage | LicenseUsageCountsGrid.overage | IntegerColumn | licenseUsage.overage | true | true | true | true | true | Visible
runDate | Run Date | LicenseUsageCountsGrid.runDate | DateColumn | licenseUsage.runDate | false | false | true | true | true | Visible
schema | Schema | LicenseUsageCountsGrid.schema | StringColumn | licenseUsage.schema | false | false | true | true | true | Visible
settingLicAlertsEnabled | Setting License Alerts Enabled | LicenseUsageCountsGrid.settingLicAlertsEnabled | BooleanColumn | licenseUsage.settingLicAlertsEnabled | true | false | true | true | true | Visible
settingLicAlertThrPct | Setting License Alert Threshold Pct | LicenseUsageCountsGrid.settingLicAlertThrPct | PercentColumn | licenseUsage.settingLicAlertThrPct | false | true | true | true | true | Visible
SettingLicAsOfDate | Setting License As Of Date | LicenseUsageCountsGrid.SettingLicAsOfDate | DateColumn | licenseUsage.SettingLicAsOfDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 45: Licenses and Certifications By Employee SmartGrid View (grid based on LicenseOrCertification Entity)

DateAcquired | Date Acquired | LicensesAndCertificationsGrid.DateAcquired | DateColumn | LicenseOrCertification.DateAcquired | false | false | true | true | true | Visible
Employee | Name | LicensesAndCertificationsGrid.Employee | PersonColumn | name | false | false | true | true | true | Visible
IssuingAuthority | Issuing Authority | LicensesAndCertificationsGrid.IssuingAuthority | StringColumn | LicenseOrCertification.IssuingAuthority | true | false | true | true | true | Visible
Job Code | Job Code | LicensesAndCertificationsGrid.Job Code | StringColumn | Job_Code | false | false | true | true | true | Visible
Management Level | Management Level | LicensesAndCertificationsGrid.Management Level | UserEnumValueColumn | job_management_level | true | false | true | true | true | Visible
Manager | Manager | LicensesAndCertificationsGrid.Manager | PositionManagerColumn | manager.WithMiniProfile | true | false | true | true | true | Visible
Name | License/Certification Name | LicensesAndCertificationsGrid.Name | StringColumn | LicenseOrCertification.Name | true | false | true | true | true | Visible
Organizations | Organization & Hierarchy | LicensesAndCertificationsGrid.Organizations | OrganizationColumn | requisition.organizationHierarchy | true | false | true | true | true | Visible
Position Title | Position Title | LicensesAndCertificationsGrid.Position Title | StringColumn | positionTitle | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 46: Lookup Table Summary Default SmartGrid View (grid based on LookupTableSummary Entity)

columnLabelFive | Column Label 5 | lookupTableSummarySecurity.columnLabelFive | TranslatedStringColumn | lookupExport.columnLabelFive | true | false | true | true | true | Visible
columnLabelFour | Column Label 4 | lookupTableSummarySecurity.columnLabelFour | TranslatedStringColumn | lookupExport.columnLabelFour | true | false | true | true | true | Visible
columnLabelOne | Column Label 1 | lookupTableSummarySecurity.columnLabelOne | TranslatedStringColumn | lookupExport.columnLabelOne | true | false | true | true | true | Visible
columnLabelThree | Column Label 3 | lookupTableSummarySecurity.columnLabelThree | TranslatedStringColumn | lookupExport.columnLabelThree | true | false | true | true | true | Visible
columnLabelTwo | Column Label 2 | lookupTableSummarySecurity.columnLabelTwo | TranslatedStringColumn | lookupExport.columnLabelTwo | true | false | true | true | true | Visible
columnValueFive | Column Value 5 | lookupTableSummarySecurity.columnValueFive | StringColumn | lookupExport.columnValueFive | false | false | true | true | true | Visible
columnValueFour | Column Value 4 | lookupTableSummarySecurity.columnValueFour | StringColumn | lookupExport.columnValueFour | false | false | true | true | true | Visible
columnValueOne | Column Value 1 | lookupTableSummarySecurity.columnValueOne | StringColumn | lookupExport.columnValueOne | false | false | true | true | true | Visible
columnValues | Column Values | lookupTableSummarySecurity.columnValues | StringColumn | lookupExport.columnValues | false | false | true | true | true | Visible
columnValueThree | Column Value 3 | lookupTableSummarySecurity.columnValueThree | StringColumn | lookupExport.columnValueThree | false | false | true | true | true | Visible
columnValueTwo | Column Value 2 | lookupTableSummarySecurity.columnValueTwo | StringColumn | lookupExport.columnValueTwo | false | false | true | true | true | Visible
horizontalMatchValue | Horizontal Match Value | lookupTableSummarySecurity.horizontalMatchValue | StringColumn | lookupExport.horizontalMatchValue | false | false | true | true | true | Visible
name | Name | lookupTableSummarySecurity.name | StringColumn | lookupExport.name | false | false | true | true | true | Visible
planName | Plan Name | lookupTableSummarySecurity.planName | StringColumn | lookupExport.planName | false | false | true | true | true | Visible
planType | Plan Type | lookupTableSummarySecurity.planType | TranslatedStringColumn | lookupExport.planType | true | false | true | true | true | Visible
verticalMatchValue | Vertical Match Value | lookupTableSummarySecurity.verticalMatchValue | StringColumn | lookupExport.verticalMatchValue | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 47: Market Data By Job SmartGrid View (grid based on MarketData Entity)

compType | Compensation Type | MarketDataAdminListGrid.compType | UserEnumValueColumn | compType | true | false | true | true | true | Visible
job | Job | MarketDataAdminListGrid.job | StringColumn | job | true | false | true | true | true | Visible
jobTitle | Job Title | MarketDataAdminListGrid.jobTitle | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
marketLocation | Market Location | MarketDataAdminListGrid.marketLocation | StringColumn | marketLocation | true | false | true | true | true | Visible
rangeValue1 | {0}th Pctl | MarketDataAdminListGrid.rangeValue1 | CurrencyColumn | marketData.rangeValue1 | false | true | true | true | true | Visible
rangeValue2 | {0}th Pctl | MarketDataAdminListGrid.rangeValue2 | CurrencyColumn | marketData.rangeValue2 | false | true | true | true | true | Visible
rangeValue3 | {0}th Pctl | MarketDataAdminListGrid.rangeValue3 | CurrencyColumn | marketData.rangeValue3 | false | true | true | true | true | Visible
rangeValue4 | {0}th Pctl | MarketDataAdminListGrid.rangeValue4 | CurrencyColumn | marketData.rangeValue4 | false | true | true | true | true | Visible
setName | Set Name | MarketDataAdminListGrid.setName | StringColumn | setName | true | false | true | true | true | Visible
sourceSysRefKey | Reference Key | MarketDataAdminListGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 48: MultiRater Evaluation By Employee SmartGrid View (grid based on MultiRaterEvaluation Entity)

AggregateGroupType | Aggregate Group Type | MultiRaterGrid.AggregateGroupType | SystemEnumColumn | multiRater.aggregateGroupType | true | false | true | true | true | Visible
Employee | Name | MultiRaterGrid.Employee | PersonColumn | participant.name | true | false | true | true | true | Visible
hasRaterDeclinedReviewRequest | Declined | MultiRaterGrid.hasRaterDeclinedReviewRequest | BooleanColumn | multiRater.raterDeclinedReviewRequest | true | false | true | true | true | Visible
isExcludedFromAggregate | Excluded From Aggregate | MultiRaterGrid.isExcludedFromAggregate | BooleanColumn | multiRater.excludedFromAggregate | true | false | true | true | true | Visible
isForceCompleted | Missed Deadline | MultiRaterGrid.isForceCompleted | BooleanColumn | multiRater.forceCompleted | true | false | true | true | true | Visible
isNomineeRemoved | Rejected | MultiRaterGrid.isNomineeRemoved | BooleanColumn | multiRater.nomineeRemoved | true | false | true | true | true | Visible
NominatedBy | Nominated By | MultiRaterGrid.NominatedBy | PersonColumn | multiRater.nominatedBy | true | false | true | true | true | Visible
PlanName | Plan Name | MultiRaterGrid.PlanName | TranslatedStringColumn | evaluation.name | true | false | true | true | true | Visible
PlanYear | Year | MultiRaterGrid.PlanYear | IntegerColumn | evaluation.year | true | true | true | true | true | Visible
Rater | Rater Name | MultiRaterGrid.Rater | PersonColumn | multiRater.name | true | false | true | true | true | Visible
raterOrganizationHierOrganizations | Rater Organization & Hierarchy | MultiRaterGrid.raterOrganizationHierOrganizations | OrganizationColumn | rater_requisition.organizationHierarchy | true | false | true | true | true | Visible
raterPosition Title | Rater Position Title | MultiRaterGrid.raterPosition Title | StringColumn | rater_positionTitle | true | false | true | true | true | Visible
ReviewEndDate | Review Period End Date | MultiRaterGrid.ReviewEndDate | DateColumn | evaluation.end_date | false | false | true | true | true | Visible
ReviewStartDate | Review Period Start Date | MultiRaterGrid.ReviewStartDate | DateColumn | evaluation.start_date | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 49: My Active People (Succession) Summary SmartGrid View (grid based on HumanResource Entity)

Employee | Name | MyTeamSuccessionGrid.Employee | LinkablePersonColumn | name | false | false | true | true | true | Visible
EmployeePositionSlateMemberCount | Successors - Count | MyTeamSuccessionGrid.EmployeePositionSlateMemberCount | SlateMemberCountColumn | SlateMembersCount | true | true | true | true | true | Visible
flightRisk | Flight Risk | MyTeamSuccessionGrid.flightRisk | UserEnumValueColumn | emp_talent_flight_risk | true | false | true | true | true | Visible
lossImpact | Loss Impact | MyTeamSuccessionGrid.lossImpact | UserEnumValueColumn | emp_talent_loss_impact | true | false | true | true | true | Visible
Manager | Manager | MyTeamSuccessionGrid.Manager | PositionManagerColumn | manager.WithMiniProfile | true | false | true | true | true | Visible
Organizations | Organization & Hierarchy | MyTeamSuccessionGrid.Organizations | OrganizationColumn | requisition.organizationHierarchy | true | false | true | true | true | Visible
PositionHierarchy | Position & Hierarchy | MyTeamSuccessionGrid.PositionHierarchy | PositionHierarchyColumn | gridColumn.positionHierarchy | false | false | true | true | true | Visible
Slateable | Succession Slating Enabled | MyTeamSuccessionGrid.Slateable | YesNoBooleanColumn | succession_Enable.Succession.Slating | true | false | true | true | true | Visible
succession_Ready.Now | Readiness: Ready Now | MyTeamSuccessionGrid.succession_Ready.Now | SensitiveSlateMemberReadinessCountColumn | succession_Ready.Now | true | true | true | true | true | Visible
TimeInPositionFormatted | Time in Position | MyTeamSuccessionGrid.TimeInPositionFormatted | DurationColumn | teamGrid.TimeInPositionFormatted | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 50: My Team Position Information SmartGrid View (grid based on HumanResource Entity)

Job Family | Job Family | TeamHRGrid.Job Family | UserEnumValueColumn | Job_Family | true | false | true | true | true | Visible
Job Title | Job Title | TeamHRGrid.Job Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 51: Org Histories Default SmartGrid View (grid based on EmploymentInstance Entity)

endDate | End Date | orgHistoryDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
hrId | hrId | orgHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
name | Name | orgHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
Organizations | Organizations | orgHistoryDataMapGrid.Organizations | DataMapOrganizationColumn | Organizations | false | false | false | false | true | Visible
orgId | orgId | orgHistoryDataMapGrid.orgId | StringColumn | orgId | false | false | true | true | true | Visible
SecondaryOrganizations | SecondaryOrganizations | orgHistoryDataMapGrid.SecondaryOrganizations | DataMapOrganizationColumn | SecondaryOrganizations | false | false | false | false | true | Visible
secondaryOrgId | secondaryOrgId | orgHistoryDataMapGrid.secondaryOrgId | StringColumn | secondaryOrgId | false | false | true | true | true | Visible
startDate | Start Date | orgHistoryDataMapGrid.startDate | DateColumn | startDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 52: Organizational Goals By Organization SmartGrid View (grid based on OrganizationGoal Entity)

countGoalAlignedCol | Count of Organizational Goals Aligned | OrganizationGoalGrid.countGoalAlignedCol | CollectionSizeColumn | orgGoal.CountgoalAlignedCol | false | true | true | true | true | Visible
goalcategory | Goal Category | OrganizationGoalGrid.goalcategory | UserEnumValueColumn | orgGoal.goal_category | true | false | true | true | true | Visible
goalDueDate | Due Date | OrganizationGoalGrid.goalDueDate | DateColumn | orgGoal.due_date | false | false | true | true | true | Visible
goalExpectedResult | Expected Result | OrganizationGoalGrid.goalExpectedResult | TranslatedStringColumn | orgGoal.expected_result | true | false | true | true | true | Visible
goalmeasure | Measure | OrganizationGoalGrid.goalmeasure | TranslatedStringColumn | orgGoal.meas_measure | true | false | true | true | true | Visible
goalName | Goal Name | OrganizationGoalGrid.goalName | TranslatedStringColumn | orgGoal.goal_name | true | false | true | true | true | Visible
goalWeight | Weight | OrganizationGoalGrid.goalWeight | FormattedPercentColumn | orgGoal.weight | true | true | true | true | true | Visible
organizationHierarchy | Organization & Hierarchy | OrganizationGoalGrid.organizationHierarchy | OrganizationColumn | organization.organizationHierarchy | true | false | true | true | true | Visible
orgGoalPlanYear | Plan Year | OrganizationGoalGrid.orgGoalPlanYear | IntegerColumn | orgGoalPlan_Grid_year | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 53: Organizations By Formal Name SmartGrid View (grid based on Organization Entity)

Code Name | Organization Code | OrganizationAdminListGrid.Code Name | StringColumn | organization.codeName | false | false | true | true | true | Visible
Cost Code | Organization Cost Code | OrganizationAdminListGrid.Cost Code | StringColumn | organization_cost_code | false | false | true | true | true | Visible
Formal Name | Organization Formal Name | OrganizationAdminListGrid.Formal Name | StringColumn | organization.formalName | false | false | true | true | true | Visible
Inactive | Inactive | OrganizationAdminListGrid.Inactive | BooleanColumn | organization.inactive | true | false | true | true | true | Visible
Org Hierarchy Type | Organization Hierarchy Type | OrganizationAdminListGrid.Org Hierarchy Type | UserEnumValueColumn | organization.orgHierarchyType | true | false | true | true | true | Visible
Org Type | Organization Type | OrganizationAdminListGrid.Org Type | UserEnumValueColumn | organization.orgType | true | false | true | true | true | Visible
Parent | Parent | OrganizationAdminListGrid.Parent | StringColumn | organization.parent | false | false | true | true | true | Visible
Short Name | Organization Short Name | OrganizationAdminListGrid.Short Name | StringColumn | organization.shortName | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 54: Performance Goal Results By Employee SmartGrid View (grid based on PerformanceGoalResult Entity)

employeeName | Name | PerformanceGoalResultGrid.employeeName | PersonColumn | performanceGoalResult.EmpName | true | false | true | true | true | Visible
employeePositionTitle | Position Title | PerformanceGoalResultGrid.employeePositionTitle | StringColumn | performanceGoalResult.EmpPositionTitle | false | false | true | true | true | Visible
goalCalculationMethod | Goal Calculation Method | PerformanceGoalResultGrid.goalCalculationMethod | StringColumn | performanceGoalResult.GoalCalcMethod | false | false | true | true | true | Visible
goalCategory | Goal Category | PerformanceGoalResultGrid.goalCategory | UserEnumValueColumn | performanceGoalResult.GoalCategory | true | false | true | true | true | Visible
goalMeasurementPeriodCalendar | Measurement Periods Calendar | PerformanceGoalResultGrid.goalMeasurementPeriodCalendar | StringColumn | performanceGoalResult.MeasurementPeriodCalendar | false | false | true | true | true | Visible
goalResultActualRaw | Goal Period Actual | PerformanceGoalResultGrid.goalResultActualRaw | BigDecimalColumn | performanceGoalResult.ActualNumericRaw | false | true | true | true | true | Visible
goalResultMeasurementPeriodName | Measurement Period Name | PerformanceGoalResultGrid.goalResultMeasurementPeriodName | StringColumn | performanceGoalResult.MeasurementPeriodName | false | false | true | true | true | Visible
goalResultTemplateCount | Measurement Periods Count | PerformanceGoalResultGrid.goalResultTemplateCount | IntegerColumn | performanceGoalResult.ResultTemplateCount | false | false | false | false | true | Visible
goalTitle | Goal Title | PerformanceGoalResultGrid.goalTitle | StringColumn | performanceGoalResult.GoalTitle | false | false | true | true | true | Visible
goalUnitOfMeasure | Unit of Measure | PerformanceGoalResultGrid.goalUnitOfMeasure | SystemEnumColumn | performanceGoalResult.GoalUnitOfMeasure | true | false | true | true | true | Visible
managerName | Manager | PerformanceGoalResultGrid.managerName | PositionManagerColumn | performanceGoalResult.MgrName | true | false | true | true | true | Visible
performanceGoalResultCount | Measurement Period Result Count | PerformanceGoalResultGrid.performanceGoalResultCount | IntegerColumn | performanceGoalResult.GoalResultCount | false | false | false | false | true | Visible
performancePlanDisplayName | Plan Name | PerformanceGoalResultGrid.performancePlanDisplayName | TranslatedStringColumn | performanceGoalResult.PlanName | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 55: Performance Group Competencies Performance Group Competencies SmartGrid View (grid based on PerformanceGroupCompetency Entity)

competencyName | Competency Name | PerformanceGroupCompetencyChartableGrid.competencyName | TranslatedStringColumn | perfGroupCompetencyGrid.competencyName | true | false | true | true | true | Visible
displayName | Plan Name | PerformanceGroupCompetencyChartableGrid.displayName | TranslatedStringColumn | perfGroupCompetencyGrid.displayName | true | false | true | true | true | Visible
groupValue | Performance Group | PerformanceGroupCompetencyChartableGrid.groupValue | StringColumn | perfGroupCompetencyGrid.groupValue | false | false | true | true | true | Visible
planSsrk | Plan Reference Key | PerformanceGroupCompetencyChartableGrid.planSsrk | StringColumn | perfGroupCompetencyGrid.referenceKey | false | false | true | true | true | Visible
planYear | Plan Year | PerformanceGroupCompetencyChartableGrid.planYear | IntegerColumn | perfGroupCompetencyGrid.planYear | true | true | true | true | true | Visible
weight | Weight | PerformanceGroupCompetencyChartableGrid.weight | IntegerColumn | perfGroupCompetencyGrid.weight | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 56: Performance Histories Default SmartGrid View (grid based on PerformanceRatingHistory Entity)

effectiveDate | Effective Date | perfHistoryDataMapGrid.effectiveDate | DateColumn | effectiveDate | false | false | true | true | true | Visible
hrId | hrId | perfHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
managerName | managerName | perfHistoryDataMapGrid.managerName | StringColumn | managerName | false | false | true | true | true | Visible
name | Name | perfHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
normalizedThresholdValue | normalizedThresholdValue | perfHistoryDataMapGrid.normalizedThresholdValue | FloatColumn | normalizedThresholdValue | true | true | true | true | true | Visible
normalizedValue | normalizedValue | perfHistoryDataMapGrid.normalizedValue | FloatColumn | normalizedValue | true | true | true | true | true | Visible
numericThresholdValue | numericThresholdValue | perfHistoryDataMapGrid.numericThresholdValue | FloatColumn | numericThresholdValue | true | true | true | true | true | Visible
numericValue | numericValue | perfHistoryDataMapGrid.numericValue | FloatColumn | numericValue | true | true | true | true | true | Visible
planDisplayName | Display Name | perfHistoryDataMapGrid.planDisplayName | StringColumn | planDisplayName | false | false | true | true | true | Visible
planYear | Plan Year | perfHistoryDataMapGrid.planYear | IntegerColumn | planYear | true | true | true | true | true | Visible
positionTitle | Position Title | perfHistoryDataMapGrid.positionTitle | StringColumn | positionTitle | false | false | true | true | true | Visible
ratingScaleName | ratingScaleName | perfHistoryDataMapGrid.ratingScaleName | StringColumn | ratingScaleName | false | false | true | true | true | Visible
ratingScaleValueId | ratingScaleValueId | perfHistoryDataMapGrid.ratingScaleValueId | StringColumn | ratingScaleValueId | false | false | true | true | true | Visible
sourceSysRefKey | Reference Key | perfHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 57: Performance Scorecard Performance Distribution (Final) SmartGrid View (grid based on DenormalizedEvaluationData Entity)

CompetencyRatingDisplayName | Summary Competency Rating - Scale Value | TeamHRPerformanceScorecardGrid.CompetencyRatingDisplayName | RatingScaleValueConvertorColumnWithDynamicRatingScale | evaluation.summary_competency_rating_scale | true | true | true | true | true | Visible
GoalRatingDisplayName | Summary Goal Rating - Scale Value | TeamHRPerformanceScorecardGrid.GoalRatingDisplayName | RatingScaleValueConvertorColumnWithDynamicRatingScale | evaluation.summary_goal_rating_scale | true | true | true | true | true | Visible
overallRatingDisplayName | Performance Rating - Scale Value | TeamHRPerformanceScorecardGrid.overallRatingDisplayName | RatingScaleValueConvertorColumnWithDynamicRatingScale | evaluation.summary_overall_rating_scale | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 58: Position Histories Default SmartGrid View (grid based on EmploymentInstance Entity)

costCode | costCode | positionHistoryDataMapGrid.costCode | StringColumn | costCode | false | false | true | true | true | Visible
country | Country | positionHistoryDataMapGrid.country | StringColumn | country | false | false | true | true | true | Visible
employeeType | employeeType | positionHistoryDataMapGrid.employeeType | StringColumn | employeeType | false | false | true | true | true | Visible
endDate | End Date | positionHistoryDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
hrId | hrId | positionHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
municipality | Municipality | positionHistoryDataMapGrid.municipality | StringColumn | municipality | false | false | true | true | true | Visible
name | Name | positionHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
positionCode | positionCode | positionHistoryDataMapGrid.positionCode | StringColumn | positionCode | false | false | true | true | true | Visible
positionId | Position Record ID | positionHistoryDataMapGrid.positionId | StringColumn | positionId | false | false | true | true | true | Visible
positionType | positionType | positionHistoryDataMapGrid.positionType | StringColumn | positionType | false | false | true | true | true | Visible
region | Region | positionHistoryDataMapGrid.region | StringColumn | region | false | false | true | true | true | Visible
sourceSysRefKey | Reference Key | positionHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
startDate | Start Date | positionHistoryDataMapGrid.startDate | DateColumn | startDate | false | false | true | true | true | Visible
title | Title | positionHistoryDataMapGrid.title | StringColumn | title | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 59: Position Pool Members Pool Members SmartGrid View (grid based on QualifiedTalentPoolMember Entity)

Current Occupier | Position Holder | qualifiedTalentPoolMemberGrid.Current Occupier | PositionHolderColumn | positionHolder | false | false | true | true | true | Visible
EmployeeNoContactInfo | Name | qualifiedTalentPoolMemberGrid.EmployeeNoContactInfo | PersonColumn | name | false | false | true | true | true | Visible
flightRisk | Position Holder's Flight Risk | qualifiedTalentPoolMemberGrid.flightRisk | DerivedColumn | positionHolders_flightRisk | true | false | true | true | true | Visible
Position Manager | Position Manager | qualifiedTalentPoolMemberGrid.Position Manager | PositionManagerColumn | position_manager | true | false | true | true | true | Visible
Position Title | Position Title | qualifiedTalentPoolMemberGrid.Position Title | LinkedStringColumn | succession_position.title | true | false | true | true | true | Visible
PositionHoldersTimeInPositionFormatted | Position Holder's Time in Position | qualifiedTalentPoolMemberGrid.PositionHoldersTimeInPositionFormatted | DurationDerivedColumn | positionHolders.teamGrid.TimeInPositionFormatted | false | false | true | true | true | Visible
PositionHoldersTimeWithCompanyFormatted | Position Holder's Time with Company | qualifiedTalentPoolMemberGrid.PositionHoldersTimeWithCompanyFormatted | DurationDerivedColumn | positionHolders.teamGrid.TimeWithCompanyFormatted | false | false | true | true | true | Visible
PotentialSuccessorCurrentTitle | Pool Member's Current Title | qualifiedTalentPoolMemberGrid.PotentialSuccessorCurrentTitle | StringColumn | potential_successors_current_title | false | false | true | true | true | Visible
Search Method | Pool Member's Search Method | qualifiedTalentPoolMemberGrid.Search Method | SystemEnumColumn | potential_successors_search_method | true | false | true | true | true | Visible
Successor Readiness | Pool Member's Readiness | qualifiedTalentPoolMemberGrid.Successor Readiness | UserEnumValueColumn | potential_successors_readiness | true | false | true | true | true | Visible
Successor Source | Pool Member's Source | qualifiedTalentPoolMemberGrid.Successor Source | UserEnumValueColumn | potential_successors_source | true | false | true | true | true | Visible
Successor Type | Is Employee | qualifiedTalentPoolMemberGrid.Successor Type | BooleanColumn | succession_Grid.Is.Employee | true | false | true | true | true | Visible
TimeInPositionFormatted | Pool Member's Time in Position | qualifiedTalentPoolMemberGrid.TimeInPositionFormatted | DurationColumn | potential_successors_Time_In_Position | true | false | true | true | true | Visible
TimeWithCompanyFormatted | Pool Member's Time with Company | qualifiedTalentPoolMemberGrid.TimeWithCompanyFormatted | DurationColumn | potential_successors_Time_With_Company | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 60: Positions For Succession Planning Summary SmartGrid View (grid based on Position Entity)

Current Occupier | Position Holder | SuccessionPositionSmartGrid.Current Occupier | PositionHolderColumn | positionHolder | false | false | true | true | true | Visible
Linked Position Title | Position Title | SuccessionPositionSmartGrid.Linked Position Title | SuccessionPositionTitleLinkedStringColumn | positionTitle | true | false | true | true | true | Visible
Organizations | Organization & Hierarchy | SuccessionPositionSmartGrid.Organizations | OrganizationColumn | requisition.organizationHierarchy | true | false | true | true | true | Visible
Position Manager | Manager | SuccessionPositionSmartGrid.Position Manager | PositionManagerColumn | manager | true | false | true | true | true | Visible
PositionHoldersFlightRisk | Position Holder's Flight Risk | SuccessionPositionSmartGrid.PositionHoldersFlightRisk | DerivedColumn | positionHolders_flightRisk | true | false | true | true | true | Visible
PositionHoldersLossImpact | Position Holder's Loss Impact | SuccessionPositionSmartGrid.PositionHoldersLossImpact | DerivedColumn | positionHolders_lossImpact | true | false | true | true | true | Visible
Slateable | Succession Slating Enabled | SuccessionPositionSmartGrid.Slateable | YesNoBooleanColumn | succession_Enable.Succession.Slating | true | false | true | true | true | Visible
SlateMembersCount | Successors - Count | SuccessionPositionSmartGrid.SlateMembersCount | SlateMemberCountColumn | SlateMembersCount | true | true | true | true | true | Visible
succession_Ready.Now | Readiness: Ready Now | SuccessionPositionSmartGrid.succession_Ready.Now | SensitiveSlateMemberReadinessCountColumn | succession_Ready.Now | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 61: Process Hierarchy By Employee SmartGrid View (grid based on ProcessHierarchyDetail Entity)

delete | Delete | processHierarchyDetailGrid.delete | DeleteColumn | delete | false | false | false | false | false | Visible
Emp_Job_Title | Employee Job Title | processHierarchyDetailGrid.Emp_Job_Title | TranslatedStringColumn | processhierarcy.employee.job.JobTitle | true | false | true | true | true | Visible
employee | Employee | processHierarchyDetailGrid.employee | PersonColumn | comp.processHierarchy.Employee | true | false | true | true | true | Visible
manager | Manager | processHierarchyDetailGrid.manager | PersonColumn | comp.processHierarchy.Manager | true | false | true | true | true | Visible
Mgr_Job_Title | Manager Job Title | processHierarchyDetailGrid.Mgr_Job_Title | TranslatedStringColumn | processhierarcy.manager.job.JobTitle | true | false | true | true | true | Visible
processHierarchyName | Process Name | processHierarchyDetailGrid.processHierarchyName | StringColumn | comp.processHierarchy.ProcessName | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 62: Questions and Answers By Contact Name SmartGrid View (grid based on Answer Entity)

answer_score | Score | AnswerSmartGrid.answer_score | IntegerColumn | answer_score | true | true | true | true | true | Visible
answer_value | Answer | AnswerSmartGrid.answer_value | StringHoverColumn | answer_value | false | false | true | true | true | Visible
assessment_score | Assessment Score | AnswerSmartGrid.assessment_score | IntegerColumn | assessment_score | true | true | true | true | true | Visible
assessment_submittedOn | Assessment Submitted | AnswerSmartGrid.assessment_submittedOn | DateColumn | assessment_submittedOn | false | false | true | true | true | Visible
Candidate Full Name | Contact Name | AnswerSmartGrid.Candidate Full Name | PersonColumn | candidate.contactName | true | false | true | true | true | Visible
question_points | Points | AnswerSmartGrid.question_points | IntegerColumn | question_points | true | true | true | true | true | Visible
questionLibrary_I18nKey | Question Library | AnswerSmartGrid.questionLibrary_I18nKey | StringColumn | questionLibrary_I18nKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 63: Rating Scale Value All Rating Scale Values SmartGrid View (grid based on RatingScaleValue Entity)

description | Description | RatingScaleValueGrid.description | TranslatedStringColumn | ratingScaleValue.desc | true | false | true | true | true | Visible
normalizedThresholdValue | Normalized Threshold Value (%) | RatingScaleValueGrid.normalizedThresholdValue | FloatColumn | ratingScaleValue.normalizedThresholdValue | true | true | true | true | true | Visible
normalizedValue | Normalized Value (%) | RatingScaleValueGrid.normalizedValue | FloatColumn | ratingScaleValue.normalizedValue | true | true | true | true | true | Visible
numericThresholdValue | Numeric Threshold Value | RatingScaleValueGrid.numericThresholdValue | FloatColumn | ratingScaleValue.numericThresholdValue | true | true | true | true | true | Visible
numericValue | Numeric Value | RatingScaleValueGrid.numericValue | FloatColumn | ratingScaleValue.numericValue | true | true | true | true | true | Visible
ratingScaleName | Rating Scale Name | RatingScaleValueGrid.ratingScaleName | StringColumn | ratingScaleValue.ratingScaleName | false | false | true | true | true | Visible
ratingScaleValueName | Name | RatingScaleValueGrid.ratingScaleValueName | TranslatedStringColumn | ratingScaleValue.name | true | false | true | true | true | Visible
sourceSysRefKey | Source Sys Ref Key | RatingScaleValueGrid.sourceSysRefKey | StringColumn | ratingScaleValue.ssrk | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 64: Recent Performance Histories Default SmartGrid View (grid based on PerformanceEvaluation Entity)

autoCalculatedNormalizedOverallRating | autoCalculatedNormalizedOverallRating | recentPerfHistoryDataMapGrid.autoCalculatedNormalizedOverallRating | FloatColumn | autoCalculatedNormalizedOverallRating | true | true | true | true | true | Visible
autoCalculatedNumericOverallRating | autoCalculatedNumericOverallRating | recentPerfHistoryDataMapGrid.autoCalculatedNumericOverallRating | FloatColumn | autoCalculatedNumericOverallRating | true | true | true | true | true | Visible
clinicalPlan | clinicalPlan | recentPerfHistoryDataMapGrid.clinicalPlan | BooleanColumn | clinicalPlan | true | false | true | true | true | Visible
competencyNormalizedRating | competencyNormalizedRating | recentPerfHistoryDataMapGrid.competencyNormalizedRating | FloatColumn | competencyNormalizedRating | true | true | true | true | true | Visible
competencyRating | competencyRating | recentPerfHistoryDataMapGrid.competencyRating | FloatColumn | competencyRating | true | true | true | true | true | Visible
completedDate | completedDate | recentPerfHistoryDataMapGrid.completedDate | DateColumn | completedDate | false | false | true | true | true | Visible
confidentialPlan | confidentialPlan | recentPerfHistoryDataMapGrid.confidentialPlan | BooleanColumn | confidentialPlan | true | false | true | true | true | Visible
goalNormalizedRating | goalNormalizedRating | recentPerfHistoryDataMapGrid.goalNormalizedRating | FloatColumn | goalNormalizedRating | true | true | true | true | true | Visible
goalRating | goalRating | recentPerfHistoryDataMapGrid.goalRating | FloatColumn | goalRating | true | true | true | true | true | Visible
hrId | hrId | recentPerfHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
interimEvaluations | interimEvaluations | recentPerfHistoryDataMapGrid.interimEvaluations | DataMapListColumn | interimEvaluations | false | false | false | false | true | Visible
interimPeriod | Interim Period | recentPerfHistoryDataMapGrid.interimPeriod | BooleanColumn | interimPeriod | true | false | true | true | true | Visible
name | Name | recentPerfHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
normalizedThresholdValue | normalizedThresholdValue | recentPerfHistoryDataMapGrid.normalizedThresholdValue | FloatColumn | normalizedThresholdValue | true | true | true | true | true | Visible
normalizedValue | normalizedValue | recentPerfHistoryDataMapGrid.normalizedValue | FloatColumn | normalizedValue | true | true | true | true | true | Visible
numericThresholdValue | numericThresholdValue | recentPerfHistoryDataMapGrid.numericThresholdValue | FloatColumn | numericThresholdValue | true | true | true | true | true | Visible
numericValue | numericValue | recentPerfHistoryDataMapGrid.numericValue | FloatColumn | numericValue | true | true | true | true | true | Visible
overallRatingId | overallRatingId | recentPerfHistoryDataMapGrid.overallRatingId | StringColumn | overallRatingId | false | false | true | true | true | Visible
performancePlan | performancePlan | recentPerfHistoryDataMapGrid.performancePlan | StringColumn | performancePlan | false | false | true | true | true | Visible
perfPlanRefKey | perfPlanRefKey | recentPerfHistoryDataMapGrid.perfPlanRefKey | StringColumn | perfPlanRefKey | false | false | true | true | true | Visible
planEffDate | planEffDate | recentPerfHistoryDataMapGrid.planEffDate | DateColumn | planEffDate | false | false | true | true | true | Visible
planEndDate | planEndDate | recentPerfHistoryDataMapGrid.planEndDate | DateColumn | planEndDate | false | false | true | true | true | Visible
planStartDate | planStartDate | recentPerfHistoryDataMapGrid.planStartDate | DateColumn | planStartDate | false | false | true | true | true | Visible
planYear | Plan Year | recentPerfHistoryDataMapGrid.planYear | IntegerColumn | planYear | true | true | true | true | true | Visible
ratingScaleName | ratingScaleName | recentPerfHistoryDataMapGrid.ratingScaleName | StringColumn | ratingScaleName | false | false | true | true | true | Visible
reviewPeriodEndDate | Review Period End Date | recentPerfHistoryDataMapGrid.reviewPeriodEndDate | DateColumn | reviewPeriodEndDate | false | false | true | true | true | Visible
reviewPeriodStartDate | Review Period Start Date | recentPerfHistoryDataMapGrid.reviewPeriodStartDate | DateColumn | reviewPeriodStartDate | false | false | true | true | true | Visible
sourceSysRefKey | Reference Key | recentPerfHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
workflowStateName | workflowStateName | recentPerfHistoryDataMapGrid.workflowStateName | StringColumn | workflowStateName | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 65: Referral Rewards Referral Rewards Eligibility SmartGrid View (grid based on Submission Entity)

Candidate Full Name | Candidate Name | ReferralRewardsSmartGrid.Candidate Full Name | PersonColumn | grid.columnHeader.CandidateName | true | false | true | true | true | Visible
Lead Recruiter Full Name | Lead Recruiter Full Name | ReferralRewardsSmartGrid.Lead Recruiter Full Name | PersonColumn | positionOpeningGrid.LRFullName | true | false | true | true | true | Visible
Position Title | Requisition Title | ReferralRewardsSmartGrid.Position Title | StringColumn | requisition.positionTitle | false | false | true | true | true | Visible
ReferralBonus | Requisition Referral Bonus | ReferralRewardsSmartGrid.ReferralBonus | StringColumn | submissionGrid_req_referralBonus | true | false | true | true | true | Visible
ReferrerName | Referrer Name | ReferralRewardsSmartGrid.ReferrerName | PersonColumn | Referrer_Name | true | false | true | true | true | Visible
Start Date | Start Date | ReferralRewardsSmartGrid.Start Date | DateColumn | Start_Date | false | false | true | true | true | Visible
Status | Status | ReferralRewardsSmartGrid.Status | SystemEnumColumn | status | true | false | true | true | true | Visible
Submitted Date | Submitted Date | ReferralRewardsSmartGrid.Submitted Date | DateColumn | submissionGrid.submittedDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 66: Requisition Notes By Requisition Id SmartGrid View (grid based on PositionOpeningNote Entity)

DisplayID | Requisition ID | PositionOpeningNoteSmartGrid.DisplayID | LinkedStringColumn | grid.columnHeader.RequisitionId | true | false | true | true | true | Visible
Hiring Manager Person | Hiring Manager Full Name | PositionOpeningNoteSmartGrid.Hiring Manager Person | PersonColumn | positionOpeningGrid.HMFullName | true | false | true | true | true | Visible
Lead Recruiter Person | Lead Recruiter Full Name | PositionOpeningNoteSmartGrid.Lead Recruiter Person | PersonColumn | leadRecruiter.fullName | true | false | true | true | true | Visible
note_author | Name | PositionOpeningNoteSmartGrid.note_author | PersonColumn | name | true | false | true | true | true | Visible
note_createdDate | Created Date | PositionOpeningNoteSmartGrid.note_createdDate | DateColumn | createdDate | false | false | true | true | true | Visible
note_text | Note | PositionOpeningNoteSmartGrid.note_text | StringHoverColumn | note.note | false | false | false | false | true | Visible
note_type | Type | PositionOpeningNoteSmartGrid.note_type | UserEnumValueColumn | type | true | false | true | true | true | Visible
Position Title | Requisition Title | PositionOpeningNoteSmartGrid.Position Title | StringColumn | requisition.positionTitle | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 67: Reward Cycle Budget Pool Transactions Default SmartGrid View (grid based on WorksheetRunBudgetPoolTrx Entity)

amount | Amount | worksheetRunBudgetPoolTrxChartableGrid.amount | CurrencyColumn | worksheetRunBudgetPoolTrxGrid.amount | false | true | true | true | true | Visible
effectiveDate | Effective Date | worksheetRunBudgetPoolTrxChartableGrid.effectiveDate | DateColumn | worksheetRunBudgetPoolTrxGrid.effectiveDate | false | false | true | true | true | Visible
name | Budget Pool Name | worksheetRunBudgetPoolTrxChartableGrid.name | StringColumn | worksheetRunBudgetPoolTrxGrid.name | false | false | true | true | true | Visible
owner | Budget Pool Owner | worksheetRunBudgetPoolTrxChartableGrid.owner | PersonColumn | worksheetRunBudgetPoolTrxGrid.owner | true | false | true | true | true | Visible
rewardCycle | Reward Cycle | worksheetRunBudgetPoolTrxChartableGrid.rewardCycle | TranslatedStringColumn | worksheetRunBudgetPoolTrxGrid.rewardCycle | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 68: Reward Cycle Summary (Combined) Default SmartGrid View (grid based on WorksheetRunSummary Entity)

adjustment | Adjustments | worksheetRunSummaryChartableGrid.adjustment | WorksheetRunCurrencyColumn | worksheetRunSummary.adjustment | false | true | true | true | true | Visible
allocation | Allocated | worksheetRunSummaryChartableGrid.allocation | WorksheetRunCurrencyColumn | worksheetRunSummary.allocation | false | true | true | true | true | Visible
budget | Budget | worksheetRunSummaryChartableGrid.budget | WorksheetRunCurrencyColumn | worksheetRunSummary.budget | false | true | true | true | true | Visible
currencyCode | Currency | worksheetRunSummaryChartableGrid.currencyCode | StringColumn | worksheetRunSummary.currencyCode | true | false | true | true | true | Visible
exchangeRateSetName | Currency Set | worksheetRunSummaryChartableGrid.exchangeRateSetName | StringColumn | worksheetRunSummary.exchangeRateSetName | true | false | true | true | true | Visible
initialDeposit | Initial Deposit | worksheetRunSummaryChartableGrid.initialDeposit | WorksheetRunCurrencyColumn | worksheetRunSummary.initialDeposit | false | true | true | true | true | Visible
isOffcycle | Off-Cycle | worksheetRunSummaryChartableGrid.isOffcycle | BooleanColumn | worksheetRunSummary.offCycleProcess | true | false | true | true | true | Visible
organization | Organization | worksheetRunSummaryChartableGrid.organization | OrganizationColumn | worksheetRunSummary.organization | true | false | true | true | true | Visible
owner | Owner | worksheetRunSummaryChartableGrid.owner | PersonColumn | worksheetRunSummary.owner | true | false | true | true | true | Visible
percentSpent | % Spent | worksheetRunSummaryChartableGrid.percentSpent | PercentColumn | worksheetRunSummary.percentSpent | false | true | true | true | true | Visible
planParticipEndDate | End Date | worksheetRunSummaryChartableGrid.planParticipEndDate | DateColumn | worksheetRunSummary.planParticipEndDate | false | false | true | true | true | Visible
planParticipStartDate | Start Date | worksheetRunSummaryChartableGrid.planParticipStartDate | DateColumn | worksheetRunSummary.planParticipStartDate | false | false | true | true | true | Visible
planType | Plan Type | worksheetRunSummaryChartableGrid.planType | StringColumn | worksheetRunSummary.planType | true | false | true | true | true | Visible
planYear | Plan Year | worksheetRunSummaryChartableGrid.planYear | IntegerColumn | worksheetRunSummary.planYear | true | true | true | true | true | Visible
poolName | Budget Pool | worksheetRunSummaryChartableGrid.poolName | StringColumn | worksheetRunSummary.poolName | true | false | true | true | true | Visible
recordCount | Record Count | worksheetRunSummaryChartableGrid.recordCount | IntegerColumn | worksheetRunSummary.recordCount | true | true | true | true | true | Visible
remaining | Remaining | worksheetRunSummaryChartableGrid.remaining | WorksheetRunCurrencyColumn | worksheetRunSummary.remaining | false | true | true | true | true | Visible
rewardCycle | Reward Cycle | worksheetRunSummaryChartableGrid.rewardCycle | TranslatedStringColumn | worksheetRunSummary.rewardCycle | true | false | true | true | true | Visible
spent | Spent | worksheetRunSummaryChartableGrid.spent | WorksheetRunCurrencyColumn | worksheetRunSummary.spent | false | true | true | true | true | Visible
transferIn | Transferred In | worksheetRunSummaryChartableGrid.transferIn | WorksheetRunCurrencyColumn | worksheetRunSummary.transferIn | false | true | true | true | true | Visible
transferOut | Transferred Out | worksheetRunSummaryChartableGrid.transferOut | WorksheetRunCurrencyColumn | worksheetRunSummary.transferOut | false | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 69: Reward Cycle Summary (Focal) Default SmartGrid View (grid based on WorksheetRunSummaryFocal Entity)

adjustment | Adjustments | worksheetRunSummaryFocalChartableGrid.adjustment | WorksheetRunCurrencyColumn | worksheetRunSummary.adjustment | false | true | true | true | true | Visible
allocation | Allocated | worksheetRunSummaryFocalChartableGrid.allocation | WorksheetRunCurrencyColumn | worksheetRunSummary.allocation | false | true | true | true | true | Visible
budget | Budget | worksheetRunSummaryFocalChartableGrid.budget | WorksheetRunCurrencyColumn | worksheetRunSummary.budget | false | true | true | true | true | Visible
currencyCode | Currency | worksheetRunSummaryFocalChartableGrid.currencyCode | StringColumn | worksheetRunSummary.currencyCode | true | false | true | true | true | Visible
exchangeRateSetName | Currency Set | worksheetRunSummaryFocalChartableGrid.exchangeRateSetName | StringColumn | worksheetRunSummary.exchangeRateSetName | true | false | true | true | true | Visible
initialDeposit | Initial Deposit | worksheetRunSummaryFocalChartableGrid.initialDeposit | WorksheetRunCurrencyColumn | worksheetRunSummary.initialDeposit | false | true | true | true | true | Visible
organization | Organization | worksheetRunSummaryFocalChartableGrid.organization | OrganizationColumn | worksheetRunSummary.organization | true | false | true | true | true | Visible
owner | Owner | worksheetRunSummaryFocalChartableGrid.owner | PersonColumn | worksheetRunSummary.owner | true | false | true | true | true | Visible
percentSpent | % Spent | worksheetRunSummaryFocalChartableGrid.percentSpent | PercentColumn | worksheetRunSummary.percentSpent | false | true | true | true | true | Visible
planParticipEndDate | End Date | worksheetRunSummaryFocalChartableGrid.planParticipEndDate | DateColumn | worksheetRunSummary.planParticipEndDate | false | false | true | true | true | Visible
planParticipStartDate | Start Date | worksheetRunSummaryFocalChartableGrid.planParticipStartDate | DateColumn | worksheetRunSummary.planParticipStartDate | false | false | true | true | true | Visible
planType | Plan Type | worksheetRunSummaryFocalChartableGrid.planType | StringColumn | worksheetRunSummary.planType | true | false | true | true | true | Visible
planYear | Plan Year | worksheetRunSummaryFocalChartableGrid.planYear | IntegerColumn | worksheetRunSummary.planYear | true | true | true | true | true | Visible
poolName | Budget Pool | worksheetRunSummaryFocalChartableGrid.poolName | StringColumn | worksheetRunSummary.poolName | true | false | true | true | true | Visible
recordCount | Record Count | worksheetRunSummaryFocalChartableGrid.recordCount | IntegerColumn | worksheetRunSummary.recordCount | true | true | true | true | true | Visible
remaining | Remaining | worksheetRunSummaryFocalChartableGrid.remaining | WorksheetRunCurrencyColumn | worksheetRunSummary.remaining | false | true | true | true | true | Visible
rewardCycle | Reward Cycle | worksheetRunSummaryFocalChartableGrid.rewardCycle | TranslatedStringColumn | worksheetRunSummary.rewardCycle | true | false | true | true | true | Visible
spent | Spent | worksheetRunSummaryFocalChartableGrid.spent | WorksheetRunCurrencyColumn | worksheetRunSummary.spent | false | true | true | true | true | Visible
transferIn | Transferred In | worksheetRunSummaryFocalChartableGrid.transferIn | WorksheetRunCurrencyColumn | worksheetRunSummary.transferIn | false | true | true | true | true | Visible
transferOut | Transferred Out | worksheetRunSummaryFocalChartableGrid.transferOut | WorksheetRunCurrencyColumn | worksheetRunSummary.transferOut | false | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 70: Reward Cycle Summary (Off-Cycle) Default SmartGrid View (grid based on WorksheetRunSummaryOffCycle Entity)

adjustment | Adjustments | worksheetRunSummaryOffCycleChartableGrid.adjustment | WorksheetRunCurrencyColumn | worksheetRunSummary.adjustment | false | true | true | true | true | Visible
allocation | Allocated | worksheetRunSummaryOffCycleChartableGrid.allocation | WorksheetRunCurrencyColumn | worksheetRunSummary.allocation | false | true | true | true | true | Visible
budget | Budget | worksheetRunSummaryOffCycleChartableGrid.budget | WorksheetRunCurrencyColumn | worksheetRunSummary.budget | false | true | true | true | true | Visible
currencyCode | Currency | worksheetRunSummaryOffCycleChartableGrid.currencyCode | StringColumn | worksheetRunSummary.currencyCode | true | false | true | true | true | Visible
exchangeRateSetName | Currency Set | worksheetRunSummaryOffCycleChartableGrid.exchangeRateSetName | StringColumn | worksheetRunSummary.exchangeRateSetName | true | false | true | true | true | Visible
initialDeposit | Initial Deposit | worksheetRunSummaryOffCycleChartableGrid.initialDeposit | WorksheetRunCurrencyColumn | worksheetRunSummary.initialDeposit | false | true | true | true | true | Visible
organization | Organization | worksheetRunSummaryOffCycleChartableGrid.organization | OrganizationColumn | worksheetRunSummary.organization | true | false | true | true | true | Visible
owner | Owner | worksheetRunSummaryOffCycleChartableGrid.owner | PersonColumn | worksheetRunSummary.owner | true | false | true | true | true | Visible
percentSpent | % Spent | worksheetRunSummaryOffCycleChartableGrid.percentSpent | PercentColumn | worksheetRunSummary.percentSpent | false | true | true | true | true | Visible
planParticipEndDate | End Date | worksheetRunSummaryOffCycleChartableGrid.planParticipEndDate | DateColumn | worksheetRunSummary.planParticipEndDate | false | false | true | true | true | Visible
planParticipStartDate | Start Date | worksheetRunSummaryOffCycleChartableGrid.planParticipStartDate | DateColumn | worksheetRunSummary.planParticipStartDate | false | false | true | true | true | Visible
planType | Plan Type | worksheetRunSummaryOffCycleChartableGrid.planType | StringColumn | worksheetRunSummary.planType | true | false | true | true | true | Visible
planYear | Plan Year | worksheetRunSummaryOffCycleChartableGrid.planYear | IntegerColumn | worksheetRunSummary.planYear | true | true | true | true | true | Visible
poolName | Budget Pool | worksheetRunSummaryOffCycleChartableGrid.poolName | StringColumn | worksheetRunSummary.poolName | true | false | true | true | true | Visible
recordCount | Record Count | worksheetRunSummaryOffCycleChartableGrid.recordCount | IntegerColumn | worksheetRunSummary.recordCount | true | true | true | true | true | Visible
remaining | Remaining | worksheetRunSummaryOffCycleChartableGrid.remaining | WorksheetRunCurrencyColumn | worksheetRunSummary.remaining | false | true | true | true | true | Visible
rewardCycle | Reward Cycle | worksheetRunSummaryOffCycleChartableGrid.rewardCycle | TranslatedStringColumn | worksheetRunSummary.rewardCycle | true | false | true | true | true | Visible
spent | Spent | worksheetRunSummaryOffCycleChartableGrid.spent | WorksheetRunCurrencyColumn | worksheetRunSummary.spent | false | true | true | true | true | Visible
transferIn | Transferred In | worksheetRunSummaryOffCycleChartableGrid.transferIn | WorksheetRunCurrencyColumn | worksheetRunSummary.transferIn | false | true | true | true | true | Visible
transferOut | Transferred Out | worksheetRunSummaryOffCycleChartableGrid.transferOut | WorksheetRunCurrencyColumn | worksheetRunSummary.transferOut | false | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 71: Salary Histories Default SmartGrid View (grid based on SalaryHistory Entity)

currencyCode | Currency Code | salaryHistoryDataMapGrid.currencyCode | CurrencyTypeColumn | currencyCode | false | false | true | true | true | Visible
effDate | effDate | salaryHistoryDataMapGrid.effDate | DateColumn | effDate | false | false | true | true | true | Visible
fte | FTE | salaryHistoryDataMapGrid.fte | BigDecimalColumn | fte | false | true | true | true | true | Visible
fteBudgetAdjReq | fteBudgetAdjReq | salaryHistoryDataMapGrid.fteBudgetAdjReq | BooleanColumn | fteBudgetAdjReq | false | false | false | false | true | Visible
fteRangeAdjReq | fteRangeAdjReq | salaryHistoryDataMapGrid.fteRangeAdjReq | BooleanColumn | fteRangeAdjReq | false | false | false | false | true | Visible
grade | grade | salaryHistoryDataMapGrid.grade | StringColumn | grade | false | false | true | true | true | Visible
gradeSetName | gradeSetName | salaryHistoryDataMapGrid.gradeSetName | StringColumn | gradeSetName | false | false | true | true | true | Visible
gradeStructure | gradeStructure | salaryHistoryDataMapGrid.gradeStructure | StringColumn | gradeStructure | false | false | true | true | true | Visible
hrId | hrId | salaryHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
increaseAmount | increaseAmount | salaryHistoryDataMapGrid.increaseAmount | BigDecimalColumn | increaseAmount | false | true | true | true | true | Visible
increasePercentage | increasePercentage | salaryHistoryDataMapGrid.increasePercentage | BigDecimalColumn | increasePercentage | false | true | true | true | true | Visible
lumpSum | lumpSum | salaryHistoryDataMapGrid.lumpSum | BigDecimalColumn | lumpSum | false | true | true | true | true | Visible
marketSetName | marketSetName | salaryHistoryDataMapGrid.marketSetName | StringColumn | marketSetName | false | false | true | true | true | Visible
marketStructure | marketStructure | salaryHistoryDataMapGrid.marketStructure | StringColumn | marketStructure | false | false | true | true | true | Visible
name | Name | salaryHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
payFactor | payFactor | salaryHistoryDataMapGrid.payFactor | IntegerColumn | payFactor | false | false | false | false | true | Visible
planYear | Plan Year | salaryHistoryDataMapGrid.planYear | IntegerColumn | planYear | true | true | true | true | true | Visible
prorationFactor | Proration Factor | salaryHistoryDataMapGrid.prorationFactor | BigDecimalColumn | prorationFactor | false | true | true | true | true | Visible
reason | reason | salaryHistoryDataMapGrid.reason | DataMapListColumn | reason | false | false | false | false | true | Visible
salaryGradeId | salaryGradeId | salaryHistoryDataMapGrid.salaryGradeId | StringColumn | salaryGradeId | false | false | true | true | true | Visible
salaryId | salaryId | salaryHistoryDataMapGrid.salaryId | StringColumn | salaryId | false | false | true | true | true | Visible
salaryPeriodName | salaryPeriodName | salaryHistoryDataMapGrid.salaryPeriodName | StringColumn | salaryPeriodName | false | false | false | false | true | Visible
salaryPeriodTypeId | salaryPeriodTypeId | salaryHistoryDataMapGrid.salaryPeriodTypeId | IntegerColumn | salaryPeriodTypeId | true | true | true | true | true | Visible
salaryPeriodTypeName | salaryPeriodTypeName | salaryHistoryDataMapGrid.salaryPeriodTypeName | StringColumn | salaryPeriodTypeName | false | false | true | true | true | Visible
salaryRate | salaryRate | salaryHistoryDataMapGrid.salaryRate | BigDecimalColumn | salaryRate | false | true | true | true | true | Visible
sourceSysRefKey | Reference Key | salaryHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 72: Salary History By Employee SmartGrid View (grid based on SalaryHistory Entity)

currencyCode | Currency Code | salaryHistorySmartGrid.currencyCode | CurrencyTypeColumn | salHistory.currencyCode | false | false | true | true | true | Visible
grade | Grade | salaryHistorySmartGrid.grade | StringColumn | salHistory.grade | false | false | true | true | true | Visible
increaseAmt | Increase Amount | salaryHistorySmartGrid.increaseAmt | SelectedCurrencyColumn | salHistory.increaseAmt | false | true | true | true | true | Visible
increasePct | Increase % | salaryHistorySmartGrid.increasePct | PercentColumn | salHistory.increasePct | false | true | true | true | true | Visible
personColumn | Name | salaryHistorySmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
reason | Reason | salaryHistorySmartGrid.reason | ListColumn | salHistory.reason | false | false | false | false | true | Visible
salary | Salary | salaryHistorySmartGrid.salary | SelectedCurrencyColumn | salHistory.salary | false | true | true | true | true | Visible
salaryGradeMax | Salary Grade Max | salaryHistorySmartGrid.salaryGradeMax | SelectedCurrencyColumn | salHistory.salaryGradeMax | false | true | true | true | true | Visible
salaryGradeMid | Salary Grade Mid | salaryHistorySmartGrid.salaryGradeMid | SelectedCurrencyColumn | salHistory.salaryGradeMid | false | true | true | true | true | Visible
salaryGradeMin | Salary Grade Min | salaryHistorySmartGrid.salaryGradeMin | SelectedCurrencyColumn | salHistory.salaryGradeMin | false | true | true | true | true | Visible
salHistoryEffectiveDate | Effective Date | salaryHistorySmartGrid.salHistoryEffectiveDate | DateColumn | salHistory.effectiveDate | false | false | true | true | true | Visible
salHistoryEndDate | End Date | salaryHistorySmartGrid.salHistoryEndDate | DateColumn | salHistory.endDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 73: Salary Plan Plan Participants SmartGrid View (grid based on SalaryPlanParticipantDetail Entity)

currency | Currency | salaryPlanParticipDetGrid.currency | StringColumn | salaryPlanParticip.currencyCode | true | false | true | true | true | Read Only
currentSalary | Current Salary | salaryPlanParticipDetGrid.currentSalary | CurrencyColumn | salaryPlanParticip.currentSalary | false | true | true | true | true | Read Only
exchangeRate | Exchange Rate | salaryPlanParticipDetGrid.exchangeRate | BigDecimalColumn | salaryPlanParticip.exchangeRate | false | true | true | true | true | Read Only
fte | FTE | salaryPlanParticipDetGrid.fte | PercentColumn | salaryPlanParticip.fte | true | true | true | true | true | Read Only
name | Name | salaryPlanParticipDetGrid.name | PersonColumn | salaryPlanParticip.participName | false | false | true | true | true | Read Only
newJobTitle | New Job | salaryPlanParticipDetGrid.newJobTitle | TranslatedStringColumn | salaryPlanParticip.newJobTitle | true | false | true | true | true | Visible
payDate | Pay Date | salaryPlanParticipDetGrid.payDate | DateColumn | salaryPlanParticip.payDate | false | false | true | true | true | Read Only
prorationPct | Proration Factor | salaryPlanParticipDetGrid.prorationPct | PercentColumn | salaryPlanParticip.prorationPct | false | true | true | true | true | Read Only
salaryGrade | Salary Grade | salaryPlanParticipDetGrid.salaryGrade | StringColumn | salaryPlanParticip.salaryGrade | true | false | true | true | true | Read Only
salaryGradeMax | Salary Grade Max | salaryPlanParticipDetGrid.salaryGradeMax | CurrencyColumn | salaryPlanParticip.salaryGradeMax | false | true | true | true | true | Read Only
salaryGradeMid | Salary Grade Mid | salaryPlanParticipDetGrid.salaryGradeMid | CurrencyColumn | salaryPlanParticip.salaryGradeMid | false | true | true | true | true | Read Only
salaryGradeMin | Salary Grade Min | salaryPlanParticipDetGrid.salaryGradeMin | CurrencyColumn | salaryPlanParticip.salaryGradeMin | false | true | true | true | true | Read Only
salaryGradeSetName | Salary Grade Set Name | salaryPlanParticipDetGrid.salaryGradeSetName | StringColumn | salaryPlanParticip.salaryGradeSetName | true | false | true | true | true | Read Only
salaryGradeStructure | Salary Grade Structure | salaryPlanParticipDetGrid.salaryGradeStructure | StringColumn | salaryPlanParticip.salaryGradeStructure | true | false | true | true | true | Read Only
salaryPeriodType | Frequency | salaryPlanParticipDetGrid.salaryPeriodType | StringColumn | salaryPlanParticip.salaryPeriodType | true | false | true | true | true | Read Only
sigKey | SIG Name | salaryPlanParticipDetGrid.sigKey | StringColumn | salaryPlanParticip.sigKey | true | false | true | true | true | Read Only
xaxisValue | X Axis Value | salaryPlanParticipDetGrid.xaxisValue | StringColumn | salaryPlanParticip.xaxisValue | true | false | true | true | true | Read Only
yaxisValue | Y Axis Value | salaryPlanParticipDetGrid.yaxisValue | StringColumn | salaryPlanParticip.yaxisValue | true | false | true | true | true | Read Only

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 74: Skill Inventory By Employee SmartGrid View (grid based on SkillInventorySummary Entity)

Employee | Name | SkillInventoryGrid.Employee | PersonColumn | name | true | false | true | true | true | Visible
SkillCatCol | Category | SkillInventoryGrid.SkillCatCol | UserEnumValueColumn | skill.category | true | false | true | true | true | Visible
SkillCol | Skill | SkillInventoryGrid.SkillCol | UserEnumValueColumn | skill.skill | true | false | true | true | true | Visible
SkillExpCol | Experience | SkillInventoryGrid.SkillExpCol | UserEnumValueColumn | skill.experience | true | false | true | true | true | Visible
SkillLastUsedCol | Last Used | SkillInventoryGrid.SkillLastUsedCol | UserEnumValueColumn | skill.lastUsed | true | false | true | true | true | Visible
SkillProfCol | Proficiency | SkillInventoryGrid.SkillProfCol | UserEnumValueColumn | skill.proficiency | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 75: Stakeholders Default SmartGrid View (grid based on HrRelationship Entity)

aor | Area of Responsibility | unifiedStakeholdersSmartGrid.aor | HrRelationshipTypeColumn | stakeholder_aor | false | false | true | true | true | Visible
managedByName | Stakeholder Name | unifiedStakeholdersSmartGrid.managedByName | PositionHolderColumn | stakeholder | false | false | true | true | true | Visible
posCode | Stakeholder Position Code | unifiedStakeholdersSmartGrid.posCode | StringColumn | stakeholder_code | false | false | true | true | true | Visible
posMgr | Stakeholder Manager | unifiedStakeholdersSmartGrid.posMgr | PositionManagerColumn | stakeholder_manager | true | false | true | true | true | Visible
posTitle | Stakeholder Position Title | unifiedStakeholdersSmartGrid.posTitle | StringColumn | stakeholder_title | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 76: Status Histories Default SmartGrid View (grid based on EmployeeStatus Entity)

endDate | End Date | statusHistoryDataMapGrid.endDate | DateColumn | endDate | false | false | true | true | true | Visible
hrId | hrId | statusHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
name | Name | statusHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
startDate | Start Date | statusHistoryDataMapGrid.startDate | DateColumn | startDate | false | false | true | true | true | Visible
statusId | statusId | statusHistoryDataMapGrid.statusId | StringColumn | statusId | false | false | true | true | true | Visible
statusParent | statusParent | statusHistoryDataMapGrid.statusParent | StringColumn | statusParent | false | false | true | true | true | Visible
statusType | statusType | statusHistoryDataMapGrid.statusType | StringColumn | statusType | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 77: Stock Histories Default SmartGrid View (grid based on StockHistory Entity)

currencyCode | Currency Code | stockHistoryDataMapGrid.currencyCode | CurrencyTypeColumn | currencyCode | false | false | true | true | true | Visible
currentShareValue | currentShareValue | stockHistoryDataMapGrid.currentShareValue | BigDecimalColumn | currentShareValue | false | true | true | true | true | Visible
description | Description | stockHistoryDataMapGrid.description | StringHoverColumn | description | false | false | true | true | true | Visible
grantDate | grantDate | stockHistoryDataMapGrid.grantDate | DateColumn | grantDate | false | false | true | true | true | Visible
hrId | hrId | stockHistoryDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
name | Name | stockHistoryDataMapGrid.name | PersonColumn | name | true | false | true | true | true | Visible
planYear | Plan Year | stockHistoryDataMapGrid.planYear | IntegerColumn | planYear | true | true | true | true | true | Visible
prorationFactor | Proration Factor | stockHistoryDataMapGrid.prorationFactor | BigDecimalColumn | prorationFactor | false | true | true | true | true | Visible
sharesCancelled | sharesCancelled | stockHistoryDataMapGrid.sharesCancelled | BigDecimalColumn | sharesCancelled | false | true | true | true | true | Visible
sharesExercised | sharesExercised | stockHistoryDataMapGrid.sharesExercised | BigDecimalColumn | sharesExercised | false | true | true | true | true | Visible
sharesGranted | sharesGranted | stockHistoryDataMapGrid.sharesGranted | BigDecimalColumn | sharesGranted | false | true | true | true | true | Visible
sharesVested | sharesVested | stockHistoryDataMapGrid.sharesVested | BigDecimalColumn | sharesVested | false | true | true | true | true | Visible
shareValueAtGrant | shareValueAtGrant | stockHistoryDataMapGrid.shareValueAtGrant | BigDecimalColumn | shareValueAtGrant | false | true | true | true | true | Visible
shareValueDate | shareValueDate | stockHistoryDataMapGrid.shareValueDate | DateColumn | shareValueDate | false | false | true | true | true | Visible
sourceSysRefKey | Reference Key | stockHistoryDataMapGrid.sourceSysRefKey | StringColumn | sourceSysRefKey | false | false | true | true | true | Visible
stockId | stockId | stockHistoryDataMapGrid.stockId | StringColumn | stockId | false | false | true | true | true | Visible
totalShareValue | totalShareValue | stockHistoryDataMapGrid.totalShareValue | BigDecimalColumn | totalShareValue | false | true | true | true | true | Visible
type | Type | stockHistoryDataMapGrid.type | StringHoverColumn | type | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 78: Stock History By Employee SmartGrid View (grid based on StockHistory Entity)

grantDate | Grant Date | stockHistorySmartGrid.grantDate | DateColumn | stockHist.grantDate | false | false | true | true | true | Visible
grantType | Grant Type | stockHistorySmartGrid.grantType | StringColumn | stockHist.grantType | false | false | true | true | true | Visible
personColumn | Name | stockHistorySmartGrid.personColumn | PersonColumn | compHistory.personName | true | false | true | true | true | Visible
planYear | Plan Year | stockHistorySmartGrid.planYear | IntegerColumn | stockHist.planYear | true | true | true | true | true | Visible
sharesGranted | Shares Granted | stockHistorySmartGrid.sharesGranted | UnitsColumn | stockHist.sharesGranted | false | true | true | true | true | Visible
shareValueAtGrant | Share Value at Grant | stockHistorySmartGrid.shareValueAtGrant | SelectedCurrencyColumn | stockHist.shareValueAtGrant | false | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 79: Stock Plan Plan Participants SmartGrid View (grid based on IncentivePlanParticipantPayment Entity)

actualUnits | Actual Units | incentivePlanParticipPayGridGR.actualUnits | UnitsColumn | incentivePlanParticipPay.actualUnits | false | true | true | true | true | Read Only
alert | Alert | incentivePlanParticipPayGridGR.alert | WorksheetAlertColumn | worksheetalertcolumn | true | false | true | true | true | Visible
basisValue | Basis Value | incentivePlanParticipPayGridGR.basisValue | CurrencyColumn | incentivePlanParticipPay.basisValue | false | true | true | true | true | Read Only
calculatedUnits | Calculated Units | incentivePlanParticipPayGridGR.calculatedUnits | UnitsColumn | incentivePlanParticipPay.calculatedUnits | false | true | true | true | true | Read Only
criteriaValue | Criteria Value | incentivePlanParticipPayGridGR.criteriaValue | StringColumn | incentivePlanParticipPay.criteriaValue | false | false | true | true | true | Read Only
name | Name | incentivePlanParticipPayGridGR.name | PersonColumn | incentivePlanParticipPay.participName | false | false | true | true | true | Visible
payDate | Pay Date | incentivePlanParticipPayGridGR.payDate | DateColumn | incentivePlanParticipPay.payDate | false | false | true | true | true | Visible
targetUnits | Target Units | incentivePlanParticipPayGridGR.targetUnits | UnitsColumn | incentivePlanParticipPay.targetUnits | false | true | true | true | true | Read Only

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 80: Stock Plan Performance Groups Stock Incentive Plan Perf Groups SmartGrid View (grid based on IncentivePlanPerfGroups Entity)

adjustmentCalcDescI18nKey | Adjustment Calc Decription | stockIncentivePlanPerfGroupsChartableGrid.adjustmentCalcDescI18nKey | TranslatedStringColumn | ipGRPerfGroupsGrid.adjustmentCalcDescI18nKey | false | false | true | true | true | Visible
adjustmentCalcName | Adjustment Calc Name | stockIncentivePlanPerfGroupsChartableGrid.adjustmentCalcName | StringColumn | ipGRPerfGroupsGrid.adjustmentCalcName | false | false | true | true | true | Visible
calcType | Goal Type | stockIncentivePlanPerfGroupsChartableGrid.calcType | SystemEnumColumn | ipGRPerfGroupsGrid.calcType | true | false | true | true | true | Visible
goalName | Goal Name | stockIncentivePlanPerfGroupsChartableGrid.goalName | StringColumn | ipGRPerfGroupsGrid.goalName | false | false | true | true | true | Visible
goalSsrk | Goal Reference Key | stockIncentivePlanPerfGroupsChartableGrid.goalSsrk | StringColumn | ipGRPerfGroupsGrid.goalReferenceKey | false | false | true | true | true | Visible
groupValue | Performance Group | stockIncentivePlanPerfGroupsChartableGrid.groupValue | StringColumn | ipGRPerfGroupsGrid.groupValue | false | false | true | true | true | Visible
modifiedCategoryDesc | Modified Category Description | stockIncentivePlanPerfGroupsChartableGrid.modifiedCategoryDesc | UserEnumValueColumn | ipGRPerfGroupsGrid.modifiedCategoryDescI18nKey | true | false | true | true | true | Visible
modifiedCategoryName | Modified Category Name | stockIncentivePlanPerfGroupsChartableGrid.modifiedCategoryName | StringColumn | ipGRPerfGroupsGrid.modifiedCategoryName | false | false | true | true | true | Visible
modifiedGoalName | Modified Goal | stockIncentivePlanPerfGroupsChartableGrid.modifiedGoalName | StringColumn | ipGRPerfGroupsGrid.modifiedGroupGoalName | false | false | true | true | true | Visible
modifiedGoalSsrk | Modified Goal Reference Key | stockIncentivePlanPerfGroupsChartableGrid.modifiedGoalSsrk | StringColumn | ipGRPerfGroupsGrid.modifiedGroupGoalReferenceKey | false | false | true | true | true | Visible
name | Stock Plan Name | stockIncentivePlanPerfGroupsChartableGrid.name | StringColumn | ipGRPerfGroupsGrid.planName | false | false | true | true | true | Visible
planSsrk | Stock Plan Reference Key | stockIncentivePlanPerfGroupsChartableGrid.planSsrk | StringColumn | ipGRPerfGroupsGrid.referenceKey | false | false | true | true | true | Visible
planYear | Stock Plan Year | stockIncentivePlanPerfGroupsChartableGrid.planYear | IntegerColumn | ipGRPerfGroupsGrid.planYear | true | true | true | true | true | Visible
sequence | Order | stockIncentivePlanPerfGroupsChartableGrid.sequence | IntegerColumn | ipGRPerfGroupsGrid.sequence | true | true | true | true | true | Visible
weight | Goal Weight | stockIncentivePlanPerfGroupsChartableGrid.weight | PercentColumn | ipGRPerfGroupsGrid.weight | true | true | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 81: Successors Successors SmartGrid View (grid based on SlateMember Entity)

Current Occupier | Position Holder | slateMemberGrid.Current Occupier | PositionHolderColumn | positionHolder | false | false | true | true | true | Visible
EmployeeNoContactInfo | Name | slateMemberGrid.EmployeeNoContactInfo | PersonColumn | name | false | false | true | true | true | Visible
Position Manager | Position Manager | slateMemberGrid.Position Manager | PositionManagerColumn | position_manager | true | false | true | true | true | Visible
Position Title | Position Title | slateMemberGrid.Position Title | LinkedStringColumn | succession_position.title | true | false | true | true | true | Visible
Search Method | Successor's Search Method | slateMemberGrid.Search Method | SystemEnumColumn | succession_Grid.Search.Method | true | false | true | true | true | Visible
Successor Readiness | Successor's Readiness | slateMemberGrid.Successor Readiness | UserEnumValueColumn | succession_successor.readiness | true | false | true | true | true | Visible
Successor Source | Successor's Source | slateMemberGrid.Successor Source | UserEnumValueColumn | succession_successor.source | true | false | true | true | true | Visible
Successor Type | Is Employee | slateMemberGrid.Successor Type | BooleanColumn | succession_Grid.Is.Employee | true | false | true | true | true | Visible
SuccessorCurrentTitle | Successor's Current Title | slateMemberGrid.SuccessorCurrentTitle | StringColumn | successor_current_title | false | false | true | true | true | Visible
TimeInPositionFormatted | Successor's Time in Position | slateMemberGrid.TimeInPositionFormatted | DurationColumn | succession.TimeInPositionFormatted | true | false | true | true | true | Visible
TimeWithCompanyFormatted | Successor's Time with Company | slateMemberGrid.TimeWithCompanyFormatted | DurationColumn | succession.TimeWithCompanyFormatted | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 82: Test Results Contacts By Test Results SmartGrid View (grid based on TestResult Entity)

Administered By | Administered By | TestResultsSmartGrid.Administered By | StringColumn | testResult.administeredBy | false | false | true | true | true | Visible
Candidate Full Name | Contact Name | TestResultsSmartGrid.Candidate Full Name | PersonColumn | candidate.contactName | true | false | true | true | true | Visible
Entered By | Entered By | TestResultsSmartGrid.Entered By | StringColumn | testResult.enteredBy | false | false | true | true | true | Visible
Entered Date | Entered Date | TestResultsSmartGrid.Entered Date | DateColumn | testResult.enteredDate | false | false | true | true | true | Visible
Results | Test Result | TestResultsSmartGrid.Results | StringColumn | testResult.result | false | false | true | true | true | Visible
Test Date | Test Date | TestResultsSmartGrid.Test Date | DateColumn | testResult.testDate | false | false | true | true | true | Visible
Test Type | Test Type | TestResultsSmartGrid.Test Type | UserEnumValueColumn | testResult.testType | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 83: User Policy Status Default SmartGrid View (grid based on User Entity)

actionDate | Notice Action Date | userPolicyStatusGrid.actionDate | DateColumn | last.userPolicy.action.performedOn | false | false | true | true | true | Visible
inactive | Inactive | userPolicyStatusGrid.inactive | BooleanColumn | inactive | true | false | true | true | true | Visible
Name | Name | userPolicyStatusGrid.Name | PersonNameColumn | name | false | false | true | true | true | Visible
userIPAddress | User's IP Address | userPolicyStatusGrid.userIPAddress | StringColumn | userPolicy.action.ipAddress | false | false | true | true | true | Visible
userPolicyAction | Notice Action | userPolicyStatusGrid.userPolicyAction | SystemEnumColumn | last.userPolicy.action | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 84: Users By Name SmartGrid View (grid based on User Entity)

DebugMode | Debug Mode | UserListGrid.DebugMode | BooleanColumn | debug_mode | true | false | true | true | true | Not Visible
Email | Business E-mail | UserListGrid.Email | ContactInfoColumn | uev.contactsubtype.Business_E_mail | false | false | true | true | true | Visible
Login | Login | UserListGrid.Login | LinkedStringColumn | Login | true | false | true | true | true | Visible
Name | Name | UserListGrid.Name | PersonColumn | name | true | false | true | true | true | Visible
StartPage | Start Page | UserListGrid.StartPage | StringColumn | Start_Page | false | false | true | true | true | Visible
User_Roles | Roles | UserListGrid.User_Roles | MultipleRolesDisplayColumn | User_Roles | false | false | true | false | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 85: Work History By Employee SmartGrid View (grid based on WorkInstance Entity)

CompanyName | Work History Company Name | WorkHistoryGrid.CompanyName | StringColumn | workHistory.companyName | false | false | true | true | true | Visible
description | Description | WorkHistoryGrid.description | StringHoverColumn | job.Description | false | false | false | false | true | Visible
Employee | Name | WorkHistoryGrid.Employee | PersonColumn | name | false | false | true | true | true | Visible
Job Title | Job Title | WorkHistoryGrid.Job Title | TranslatedStringColumn | job.JobTitle | true | false | true | true | true | Visible
workHistoryEndDate | Work History End date | WorkHistoryGrid.workHistoryEndDate | DateColumn | workHistory.endDate | false | false | true | true | true | Visible
workHistoryStartDate | Work History Start Date | WorkHistoryGrid.workHistoryStartDate | DateColumn | workHistory.startDate | false | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 86: Worksheet Audit History By Event Time SmartGrid View (grid based on WorksheetAuditHistory Entity)

afterValue | After Value | worksheetAuditHistorySmartGrid.afterValue | AuditRecordValueColumn | worksheetAuditHistory.afterValue | false | false | false | false | true | Visible
auditEvent | Audit Event | worksheetAuditHistorySmartGrid.auditEvent | SystemEnumColumn | worksheetAuditHistory.auditEvent | true | false | true | true | true | Visible
beforeValue | Before Value | worksheetAuditHistorySmartGrid.beforeValue | AuditRecordValueColumn | worksheetAuditHistory.beforeValue | false | false | false | false | true | Visible
employeeName | Employee Name | worksheetAuditHistorySmartGrid.employeeName | PersonColumn | worksheetAuditHistory.employeeName | true | false | true | true | true | Visible
eventTime | Event Time | worksheetAuditHistorySmartGrid.eventTime | DateColumn | worksheetAuditHistory.eventTime | false | false | true | true | true | Visible
fieldName | Field Name | worksheetAuditHistorySmartGrid.fieldName | StringColumn | worksheetAuditHistory.fieldName | false | false | true | true | true | Visible
managerName | Manager Name | worksheetAuditHistorySmartGrid.managerName | PersonColumn | worksheetAuditHistory.managerName | true | false | true | true | true | Visible
planType | Plan Type | worksheetAuditHistorySmartGrid.planType | StringColumn | worksheetAuditHistory.planType | false | false | true | true | true | Visible
proxyFor | Proxy For | worksheetAuditHistorySmartGrid.proxyFor | PersonColumn | worksheetAuditHistory.proxyFor | true | false | true | true | true | Visible
proxyUser | Proxy User | worksheetAuditHistorySmartGrid.proxyUser | PersonColumn | worksheetAuditHistory.proxyUser | true | false | true | true | true | Visible
rewardCycleName | Reward Cycle Name | worksheetAuditHistorySmartGrid.rewardCycleName | StringColumn | worksheetAuditHistory.rewardCycleName | false | false | true | true | true | Visible
rewardCycleYear | Reward Cycle Year | worksheetAuditHistorySmartGrid.rewardCycleYear | IntegerColumn | worksheetAuditHistory.rewardCycleYear | true | true | true | true | true | Visible
userName | User Name | worksheetAuditHistorySmartGrid.userName | PersonColumn | worksheetAuditHistory.userName | true | false | true | true | true | Visible

Start of Page

ID | Header (en_US) | Security Id | Column Type | Translation Key | Groupable | Aggregatable | Filterable | Sortable | Exportable | Default Restriction
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---

## Table 87: Worksheet Rows Default SmartGrid View (grid based on WorksheetRow Entity)

alertException | alertException | worksheetRowDataMapGrid.alertException | IntegerColumn | alertException | true | true | true | true | true | Visible
budget | budget | worksheetRowDataMapGrid.budget | BigDecimalColumn | budget | false | true | true | true | true | Visible
budgetPool | budgetPool | worksheetRowDataMapGrid.budgetPool | StringColumn | budgetPool | false | false | true | true | true | Visible
currencyCode | Currency Code | worksheetRowDataMapGrid.currencyCode | StringColumn | currencyCode | false | false | true | true | true | Visible
currentCompaRatio | currentCompaRatio | worksheetRowDataMapGrid.currentCompaRatio | BigDecimalColumn | currentCompaRatio | false | true | true | true | true | Visible
currentFte | currentFte | worksheetRowDataMapGrid.currentFte | BigDecimalColumn | currentFte | false | true | true | true | true | Visible
currentGrade | currentGrade | worksheetRowDataMapGrid.currentGrade | StringColumn | currentGrade | false | false | true | true | true | Visible
currentGradeRegion | Structure | worksheetRowDataMapGrid.currentGradeRegion | StringColumn | currentGradeRegion | false | false | true | true | true | Visible
currentGradeSetName | Current Grade Set Name | worksheetRowDataMapGrid.currentGradeSetName | StringColumn | currentGradeSetName | false | false | true | true | true | Visible
currentJobEffDate | currentJobEffDate | worksheetRowDataMapGrid.currentJobEffDate | DateColumn | currentJobEffDate | false | false | true | true | true | Visible
currentMaximum | currentMaximum | worksheetRowDataMapGrid.currentMaximum | BigDecimalColumn | currentMaximum | false | true | true | true | true | Visible
currentMidrange | currentMidrange | worksheetRowDataMapGrid.currentMidrange | BigDecimalColumn | currentMidrange | false | true | true | true | true | Visible
currentMinimum | currentMinimum | worksheetRowDataMapGrid.currentMinimum | BigDecimalColumn | currentMinimum | false | true | true | true | true | Visible
currentPayFrequency | currentPayFrequency | worksheetRowDataMapGrid.currentPayFrequency | StringColumn | currentPayFrequency | false | false | true | true | true | Visible
currentPositionInRange | currentPositionInRange | worksheetRowDataMapGrid.currentPositionInRange | BigDecimalColumn | currentPositionInRange | false | true | true | true | true | Visible
currEvalNumericVal | currEvalNumericVal | worksheetRowDataMapGrid.currEvalNumericVal | FloatColumn | currEvalNumericVal | true | true | true | true | true | Visible
dateHired | Date Hired | worksheetRowDataMapGrid.dateHired | DateColumn | dateHired | false | false | true | true | true | Visible
equityPct | equityPct | worksheetRowDataMapGrid.equityPct | BigDecimalColumn | equityPct | false | true | true | true | true | Visible
equityRecPct | equityRecPct | worksheetRowDataMapGrid.equityRecPct | BigDecimalColumn | equityRecPct | false | true | true | true | true | Visible
exchangeRate | exchangeRate | worksheetRowDataMapGrid.exchangeRate | BigDecimalColumn | exchangeRate | false | true | true | true | true | Visible
fteBudgetAdjReq | fteBudgetAdjReq | worksheetRowDataMapGrid.fteBudgetAdjReq | BooleanColumn | fteBudgetAdjReq | true | false | true | true | true | Visible
fteRangeAdjReq | fteRangeAdjReq | worksheetRowDataMapGrid.fteRangeAdjReq | BooleanColumn | fteRangeAdjReq | true | false | true | true | true | Visible
hrId | hrId | worksheetRowDataMapGrid.hrId | StringColumn | hrId | false | false | true | true | true | Visible
increaseReason | increaseReason | worksheetRowDataMapGrid.increaseReason | StringColumn | increaseReason | false | false | true | true | true | Visible
localAdjAmt | localAdjAmt | worksheetRowDataMapGrid.localAdjAmt | BigDecimalColumn | localAdjAmt | false | true | true | true | true | Visible
localAdjRecAmt | localAdjRecAmt | worksheetRowDataMapGrid.localAdjRecAmt | BigDecimalColumn | localAdjRecAmt | false | true | true | true | true | Visible
localCurrentSalary | localCurrentSalary | worksheetRowDataMapGrid.localCurrentSalary | BigDecimalColumn | localCurrentSalary | false | true | true | true | true | Visible
localEquityAmt | localEquityAmt | worksheetRowDataMapGrid.localEquityAmt | BigDecimalColumn | localEquityAmt | false | true | true | true | true | Visible
localEquityRecAmt | localEquityRecAmt | worksheetRowDataMapGrid.localEquityRecAmt | BigDecimalColumn | localEquityRecAmt | false | true | true | true | true | Visible
localLumpSumAmt | localLumpSumAmt | worksheetRowDataMapGrid.localLumpSumAmt | BigDecimalColumn | localLumpSumAmt | false | true | true | true | true | Visible
localMeritAmt | localMeritAmt | worksheetRowDataMapGrid.localMeritAmt | BigDecimalColumn | localMeritAmt | false | true | true | true | true | Visible
localMeritRecAmt | localMeritRecAmt | worksheetRowDataMapGrid.localMeritRecAmt | BigDecimalColumn | localMeritRecAmt | false | true | true | true | true | Visible
localNewSalary | localNewSalary | worksheetRowDataMapGrid.localNewSalary | BigDecimalColumn | localNewSalary | false | true | true | true | true | Visible
localPromoAmt | localPromoAmt | worksheetRowDataMapGrid.localPromoAmt | BigDecimalColumn | localPromoAmt | false | true | true | true | true | Visible
localPromoRecAmt | localPromoRecAmt | worksheetRowDataMapGrid.localPromoRecAmt | BigDecimalColumn | localPromoRecAmt | false | true | true | true | true | Visible
localTotalCash | localTotalCash | worksheetRowDataMapGrid.localTotalCash | BigDecimalColumn | localTotalCash | false | true | true | true | true | Visible
localTotalComp | localTotalComp | worksheetRowDataMapGrid.localTotalComp | BigDecimalColumn | localTotalComp | false | true | true | true | true | Visible
localTotalIncAmt | localTotalIncAmt | worksheetRowDataMapGrid.localTotalIncAmt | BigDecimalColumn | localTotalIncAmt | false | true | true | true | true | Visible
maxPct | maxPct | worksheetRowDataMapGrid.maxPct | BigDecimalColumn | maxPct | false | true | true | true | true | Visible
meritPct | meritPct | worksheetRowDataMapGrid.meritPct | BigDecimalColumn | meritPct | false | true | true | true | true | Visible
meritProratedPct | meritProratedPct | worksheetRowDataMapGrid.meritProratedPct | BigDecimalColumn | meritProratedPct | false | true | true | true | true | Visible
meritRecPct | meritRecPct | worksheetRowDataMapGrid.meritRecPct | BigDecimalColumn | meritRecPct | false | true | true | true | true | Visible
meritSigKeyLookup | meritSigKeyLookup | worksheetRowDataMapGrid.meritSigKeyLookup | StringColumn | meritSigKeyLookup | false | false | true | true | true | Visible
midPct | midPct | worksheetRowDataMapGrid.midPct | BigDecimalColumn | midPct | false | true | true | true | true | Visible
minPct | minPct | worksheetRowDataMapGrid.minPct | BigDecimalColumn | minPct | false | true | true | true | true | Visible
name | Name | worksheetRowDataMapGrid.name | StringColumn | name | false | false | true | true | true | Visible
newCompaRatio | newCompaRatio | worksheetRowDataMapGrid.newCompaRatio | BigDecimalColumn | newCompaRatio | false | true | true | true | true | Visible
newEvalNumericVal | newEvalNumericVal | worksheetRowDataMapGrid.newEvalNumericVal | FloatColumn | newEvalNumericVal | true | true | true | true | true | Visible
newGrade | newGrade | worksheetRowDataMapGrid.newGrade | StringColumn | newGrade | false | false | true | true | true | Visible
newGradeRegion | New Structure | worksheetRowDataMapGrid.newGradeRegion | StringColumn | newGradeRegion | false | false | true | true | true | Visible
newGradeSetName | New Grade Set Name | worksheetRowDataMapGrid.newGradeSetName | StringColumn | newGradeSetName | false | false | true | true | true | Visible
newMaximum | newMaximum | worksheetRowDataMapGrid.newMaximum | BigDecimalColumn | newMaximum | false | true | true | true | true | Visible
newMidrange | newMidrange | worksheetRowDataMapGrid.newMidrange | BigDecimalColumn | newMidrange | false | true | true | true | true | Visible
newMinimum | newMinimum | worksheetRowDataMapGrid.newMinimum | BigDecimalColumn | newMinimum | false | true | true | true | true | Visible
newPositionInRange | newPositionInRange | worksheetRowDataMapGrid.newPositionInRange | BigDecimalColumn | newPositionInRange | false | true | true | true | true | Visible
offCycleRejectReason | offCycleRejectReason | worksheetRowDataMapGrid.offCycleRejectReason | StringColumn | offCycleRejectReason | false | false | true | true | true | Visible
promoPct | promoPct | worksheetRowDataMapGrid.promoPct | BigDecimalColumn | promoPct | false | true | true | true | true | Visible
promoRecPct | promoRecPct | worksheetRowDataMapGrid.promoRecPct | BigDecimalColumn | promoRecPct | false | true | true | true | true | Visible
refKey | refKey | worksheetRowDataMapGrid.refKey | StringColumn | refKey | false | false | true | true | true | Visible
salaryEffDate | salaryEffDate | worksheetRowDataMapGrid.salaryEffDate | DateColumn | salaryEffDate | false | false | true | true | true | Visible
sigKey | sigKey | worksheetRowDataMapGrid.sigKey | StringColumn | sigKey | false | false | true | true | true | Visible
spent | spent | worksheetRowDataMapGrid.spent | BigDecimalColumn | spent | false | true | true | true | true | Visible
wrId | wrId | worksheetRowDataMapGrid.wrId | StringColumn | wrId | false | false | true | true | true | Visible
xaxisValue | xaxisValue | worksheetRowDataMapGrid.xaxisValue | StringColumn | xaxisValue | false | false | true | true | true | Visible
yaxisValue | yaxisValue | worksheetRowDataMapGrid.yaxisValue | StringColumn | yaxisValue | false | false | true | true | true | Visible
yearlyPayFactor | Pay Factor | worksheetRowDataMapGrid.yearlyPayFactor | IntegerColumn | yearlyPayFactor | true | true | true | true | true | Visible

Start of Page