Mapping of Result Values

The assessment process generates run results, which are used to generate the reports. These run results are later rolled back.

Here's the data generated in these temporary run results:

Results Values Mapping

INPUT_VALUE_NAME	INPUT_VALUE_BASE_NAME
Employee Classification	EMP_CLASS
Eligible Jobholder Date	EJ_DATE
Active Postponement Type	POSTP_TYPE
Active Postponement Rule	POSTP_RULE
Active Postponement End Date	POSTP_END_DATE
Active Qualifying Scheme	ACT_QPS_ID
Qualifying Scheme Joining Method	QPS_JOIN_METHOD
Qualifying Scheme Joining Date	QPS_JOIN_DATE
Reason for Leaving Scheme	LEAVE_REAS
Qualifying Scheme Leaving Date	LEAVE_DATE
Opt-Out Period End Date	OPTOUT_END_DATE
Joining Scheme Processed Date	JOIN_PROC_DATE
Leaving Scheme Processed Date	LEAVE_PROC_DATE
Class Change Processed Date	CLS_CHNG_PROC_DATE
Postponement Processed Date	POSTP_PROC_DATE
Opt-Out Refund Due	OPTOUT_REFUND_DUE
Last Assessment Date	LST_ASSMNT_DATE
Process Assessment ID	PROC_ASSMNT_ID
Qualifying Scheme ID	QPS_ID
Assessable Earnings	ASSBLE_EARNINGS
Automatic Re-Enrolment Date	REENROL_DATE
Qualifying Scheme Start Date	QPS_START_DATE
Effective Update Date	EFF_UPD_DATE
Last Assessment Period	LST_ASSMNT_PERIOD
Type Of Letter Generated	LETTER_TYPE
Date Letter Generated	LETTER_DATE
Re-enrolment Assessment Only	RE_ENROL_ONLY
Reason for exclusion	REAS_FOR_EXCL
Letter Status	LETTER_STATUS
Subsequent Communication Required	COMMS_REQ
Letter History	LETTER_HIST
Notice Given Date	NOTICE_DATE

• Date Letter Generated: This is the value comes from the flow parameter Correspondence Date. Also, the letter date wouldn’t be stamped on the Pensions Automatic Enrolment component if the corresponding PSU’s Disable pension letters option is set to Yes.
• Opt-Out Period End Date: This value would be picked from the run result value OPTOUT_END_DATE and whenever this value isn't blank or empty the update process would replace the value with Letter Date (Flow parameter Letter Date value) + 1 Month.
• Reason for Exclusion: This value is derived from the run result value REAS_FOR_EXCL and shows why a person was excluded from enrolment or re-enrolment. One of the following values may apply

  Code and Meanings

  Code	Meaning
  ORA_HRX_GB_LEFTQPSLESS12MTH	Left Qualifying Pension Scheme less than 12 months ago
  ORA_HRX_GB_LEFTQPSMORE12MTH	Left Qualifying Pension Scheme 12 or more months ago
  ORA_HRX_GB_LET_GENERATED	Generated
  ORA_HRX_GB_LET_NOTYETGEN	Not yet generated
  ORA_HRX_GB_NOTICE6WKPRD	Notice given date is within 6 weeks of assessment date
  ORA_HRX_GB_TAXPROTECTED	Tax Protection applied
  ORA_HRX_GB_WULSRECEIPT	Received Winding Up Lump Sum Payment

  Letter Status: This value would be picked from the run result value LETTER_STATUS which can have one of the following values:

  Code and Meanings of Letter Status

  Code	Meaning
  ORA_HRX_GB_LET_GENERATED	Generated. This status is given after the Generate Pensions Automatic Enrolment Reports process is completed.
  ORA_HRX_GB_LET_NOTYETGEN	Not yet generated This status is given before the Generate Pensions Automatic Enrolment Report process is completed.
  ORA_HRX_GB_LET_DISABLED	Letter generation disabled