This page (revision-32) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
32 26-Nov-2021 10:22 14 KB JEscott to previous
31 26-Nov-2021 10:22 14 KB JEscott to previous | to last
30 26-Nov-2021 10:22 14 KB JEscott to previous | to last
29 26-Nov-2021 10:22 14 KB JEscott to previous | to last
28 26-Nov-2021 10:22 14 KB JEscott to previous | to last
27 26-Nov-2021 10:22 14 KB JEscott to previous | to last
26 26-Nov-2021 10:22 14 KB JEscott to previous | to last
25 26-Nov-2021 10:22 14 KB JEscott to previous | to last
24 26-Nov-2021 10:22 14 KB JEscott to previous | to last
23 26-Nov-2021 10:22 14 KB JEscott to previous | to last
22 26-Nov-2021 10:22 14 KB JEscott to previous | to last
21 26-Nov-2021 10:22 14 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
UBEF APA INTERFACE
UBEF APA INTERFACE

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
At line 3 changed one line
The Generate Benefit/Payroll Interface (UBEF) screen may be used to generate a pension interface file for the province of Alberta. The following describes the necessary set up required in order to create this type of interface.
The Generate Benefit/Payroll Interface (UBEF) screen may be used to generate a pension interface file for the province of Alberta.
At line 5 changed one line
!!Step 1 - Define Plan Type in [IBPT]
!!Required Set Up
The following describes the necessary set up required in order to create this type of interface.
!Step 1 - Define Plan Type in [IBPT]
At line 7 changed one line
!!Step 2- Define Plan Definitions in [IBPN]
!Step 2- Define Plan Definitions in [IBPN]
At line 18 changed 2 lines
!!Step 3 - Define User Fields in [IMUF]
A new 'PN-EMPLOYER NUMBER' user-defined field must be set up for each APA pension plans. This employer number is assigned by the Alberta Pension Administration.
!Step 3 - Define User Fields in [IMUF]
A new '[PN Employer Number|PN-EMPLOYER NUMBER (UDF)]' user-defined field must be set up for each APA pension plans. This employer number is assigned by the Alberta Pension Administration.
At line 21 changed 5 lines
The 'PN-EMPLOYER NUMBER' UDF must be defined in [IMUF] for the table [P2K_BE_PLAN_DEFINITIONS] with the following fields:
;[User Field|USER_FIELD_NAME]:PN-EMPLOYER NUMBER
;[Prompt|FIELD_PROMPT]:PN Employer Number
;[Type|FIELD_TYPE]:Char
;[Format|FORMAT_MASK]:999
The '[PN Employer Number|PN-EMPLOYER NUMBER (UDF)]' UDF must be defined in [IMUF] for the table [P2K_BE_PLAN_DEFINITIONS] with the following fields:
At line 29 added one line
[User Field|USER_FIELD_NAME]:PN-EMPLOYER NUMBER
At line 31 added 7 lines
[Prompt|FIELD_PROMPT]:PN Employer Number
[Type|FIELD_TYPE]:Char
[Format|FORMAT_MASK]:999
At line 30 changed one line
!!Step 4 - Define Pay Elements in [IPPE]
!Step 4 - Define Pay Elements in [IPPE]
At line 35 changed one line
!!Step 5 - Define Usercalcs in [IMUC]
!Step 5 - Define Usercalcs in [IMUC]
At line 38 changed 2 lines
!!Step 6 - Define Interface Format in [IDIF]
HL$ABPERS-184 is provided in the [IDIF] screen as an example of a Pipe Delimited interface file for generating Record Type 18-4 for the Alberta Pension Administration.
!Step 6 - Define Interface Format in [IDIF]
[HL$ABPERS-184] is provided in the [IDIF] screen as an example of a Pipe Delimited interface file for generating Record Type 18-4 for the Alberta Pension Administration.
At line 41 changed one line
HL$ABPERS-184C is also provided in [IDIF] as an example of a Comma Delimited file for generating an audit report of Record Type 18-4.
[HL$ABPERS-184C] is also provided in [IDIF] as an example of a Comma Delimited file for generating an audit report of Record Type 18-4.
At line 43 changed one line
Standard [IDIF] definitions are provided for the other supported record types (HL$ABPERS-18A and HL$ABPERS-18AC for record type 18-A; HL$ABPERS-18L and HL$ABPERS-18LC for record type 18-L; HL$ABPERS-18M and HL$ABPERS-18MC for record type 18-M; HL$ABPERS-18W and HL$ABPERS-18WC for record type 18-W).
Standard [IDIF] definitions are provided for the other supported record types ([HL$ABPERS-18A] and [HL$ABPERS-18AC] for record type 18-A; [HL$ABPERS-18L] and [HL$ABPERS-18LC] for record type 18-L; [HL$ABPERS-18M] and [HL$ABPERS-18MC] for record type 18-M; [HL$ABPERS-18W] and [HL$ABPERS-18WC] for record type 18-W).
At line 48 changed 2 lines
!!Interface File Layout for the Alberta Pension Administration
The file is pipe delimited
The interface file layout for the Alberta Pension Administration is constructed so that the file is pipe delimited. Each file contains one header record and multiple detail records. The Transaction code and Detail type for the header record is always '94-1' for all files, while the Transaction code and Detail type for the detail records can be either '18-4', '18-A', '18-L', '18-M', or '18-W'.
At line 51 removed one line
Each file contains one header record and multiple detail records. The Transaction code and Detail type for the header record is always '94-1' for all files, while the Transaction code and Detail type for the detail records can be either '18-4', '18-A', '18-L', '18-M', or '18-W'.
At line 53 changed 2 lines
!Supported Transaction Types for the Province of Alberta
;Supported Transaction Types for the Province of Alberta
At line 63 changed 2 lines
!!Step 7 - Run UBEF To Create APA Interface File
The user is now ready to run the UBEF to create an APA interface file
----
At line 205 added 5 lines
----
![Notes|Edit:Internal.UBEF+APA+INTERFACE]
[{InsertPage page='Internal.UBEF+APA+INTERFACE' default='Click to create a new notes page'}]
This page (revision-32) was last changed on 26-Nov-2021 10:22 by JEscottTop