This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

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

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
15 26-Nov-2021 10:22 41 KB Kevin Higgs to previous
14 26-Nov-2021 10:22 41 KB Kevin Higgs to previous | to last
13 26-Nov-2021 10:22 40 KB Kevin Higgs to previous | to last
12 26-Nov-2021 10:22 39 KB Kevin Higgs to previous | to last
11 26-Nov-2021 10:22 11 KB Kevin Higgs to previous | to last
10 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
9 26-Nov-2021 10:22 64 KB Kevin Higgs to previous | to last
8 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
7 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
6 26-Nov-2021 10:22 8 KB Kevin Higgs to previous | to last
5 26-Nov-2021 10:22 7 KB Kevin Higgs to previous | to last
4 26-Nov-2021 10:22 1 KB Kevin Higgs to previous | to last
3 26-Nov-2021 10:22 5 KB khiggs to previous | to last
2 26-Nov-2021 10:22 5 KB khiggs to previous | to last
1 26-Nov-2021 10:22 5 KB khiggs to last

Page References

Incoming links Outgoing links
RBINTERFACE
RBINTERFACE

Version management

Difference between version and

At line 1 removed one line
[{TableOfContents }]
At line 3 added 2 lines
The RBINTERFACE program creates a HIPPA ANSI 834 File layout for reporting benefit information to carriers.
At line 5 removed 2 lines
RBINTERFACE provides the capability for users to generate an ANSI X12N 005010X220A1 (834) standard
interface file from employee benefit information.
At line 8 changed 4 lines
!Step 1 - Define User Defined Fields [IMUF] (Conditional based on carrier needs)
||Table Name|| User Field Name || Sample Value ||Notes
|P2K_HR_CONTACTS|MARITAL_STATUS| ABC123|Only required if reporting dependants
|P2K_BE_COVERAGES|REF_DX_LOCATION|ABC123|Only required if DX_LOCATION is needed by provider
1) Report Parameters
2) IDIF
2) IMUF
At line 11 added one line
!!Report Parameters
At line 14 changed 82 lines
!Step 2 - Define Interface Format in [IDIF]
[HL$ANSI-X12N834] is provided in the [IDIF] definitions screen as a default for set up. You should use (Deep Copy) to copy into a different Interface Code and then enter your own company data. These values will be provided by the benefit Carrier.
||REC#||FIELD#||Name||Values||Notes
|10|5|ISA05|Sender |
|10|6|ISA06|Sender|
|10|7|ISA07|Receiver|
|10|8|ISA08|Receiver|
|10|12|ISA12|Control version|Typically ‘00501’
|20|2|GS02|Sender|Usually agency TIN
|20|3|GS03|Receiver|
|52|2|N102|The name of the client group|
|52|3|N103|FI|
|52|4|N104|Client group TIN |or some other designation
----
!!Processing Information
From selection criteria, UBEF retrieves employee basic information and primary assignment information
From parameter Interface Level, the data base tables will be loaded accordingly:
*at company level: DEN / DLN / DDP / DDD / DUN / DGR / DGD / DGV
*at employee level: EID / EPS / EEM / EAS / EASD / PPRU / PPRC / ECT
*for BE only: BPT / BPN / BCG / BCGD / BCGD / BCGR / BEND / BBR / ECT
From parameter Interface Level, the following information will be written to the interface file
Lexicon [X_INTERFACE_LEVEL] values:
|01 - EEM + EASD| *(not applicable for UBEF processing)
|02 - EEM + EASD + Contacts |* (not applicable for UBEF processing)
|10 - BE Plans | *primary Assignment and BE related data base tables are loaded \\* this level will perform IDIF Record Type 'Detail Record' for each BE plan \\*i.e. write one entry per employee for each BE plan
|11 - BE + Contacts |* (not applicable for UBEF processing).
UBEF provides an audit report in Excel spreadsheet format to verify each data column that is entered in the interface file, in order to obtain this report, the UBEF function must be run a second time using the exact same parameters that was used to obtain the interface file with the following two exceptions:
# The 'Interface Code' must contain a file name that is specified with a file format of 'Comma Delimited'.
# The 'File Name' must have a file extension of .csv so that it can be viewed through an Excel spreadsheet.
----
!!Report Parameters & Filters
||Report Parameters||
|Entity| Mandatory. You must enter an entity
|From Date| Mandatory. Enter a Pay Period Begin Date
|To Date| Mandatory. Enter a Pay Period End Date
|Interface Code| Mandatory. Enter the Interface code from the [IDIF] screen
|Interface Level |Mandatory. Specify the level for the Interface file to be produced; this must be '10'. Lexicon [X_INTERFACE_LEVEL] values are:\\01 - EEM + EASD (not applicable for UBEF processing) \\02 - EEM + EASD + Contacts (not applicable for UBEF processing) \\10 - BE Plans \\11 - BE + Contacts (not applicable for UBEF processing)
|ER Addr Location| Optional. This allows you to enter an overridden location to retrieve the employer’s address. If this is not specified, the entity's location address is used.
|Sort by Active/Inactive| Optional. Check this toggle to sort inactive employees first.
|Sort Employees By|Optional. You should sort employees by Last Name/First Name, however, you may sort by the employee's pay destination or sort by Person code
|Create File |Optional. This field provides an option to create the file
|Directory Name |Optional. Enter a valid directory name
|File Name|Optional. Enter a file name or use the default file name from [IDIF] screen
|Exception Level |Optional. You should always run with the Exception level unless for tracing. In Trace Level 1, the employee header with Person Code and Employee Name are displayed with performance time, this can be used for Progress bar or to locate employee with problem. In Trace Level 2, the BE plans are displayed after employee header information
||Report Filters||
|People List Code| Optional. Please specify if People list is to be used
|Person Code| Optional. Enter one or more Person Codes
|Location| Optional. Enter one or more Location codes
|Authorization| Optional. Enter one or more Authorization Areas
|Department| Optional. Enter one or more Department Codes
|Org Level Type|Optional. Enter one or more Org Level Types
|Org Level |Optional. Enter one or more Org Level within Org Level Types
|Unit| Optional. Enter one or more Unit codes
|Group |Optional. Enter one or more Group codes
|Payroll| Optional. Enter one or more Payroll Codes
|Employment Status| Optional. Enter one or more Employment Statuses
|Termination Reason| Optional. Enter one or more Termination Reasons
|Plan Type| Optional. This field is applicable if Interface Level = 'BE plans'
|Plan| Optional. This field is applicable if Interface Level = 'BE plans'
A spreadsheet will be provided which includes all data columns that were recorded in the interface file.
To generate this report, you must run UBEF a second time, using a 'Comma Delimited' Interface File Format, and create a file with a file extension of '.csv'.
Once the.csv file is created, you can then view this file through Excel spreadsheet and delete those data columns that are of no use.
----
![Notes|Edit:Internal.UBEF+GENERIC+INTERFACE]
[{InsertPage page='Internal.UBEF+GENERIC+INTERFACE' default='Click to create a new notes page'}]
||Report Parameters||Description
|Entity|Mandatory, LOV Available\\You must enter one entity|
|Interface Format Code|Mandatory, LOV Available\\You must select an interface code defined on IDIF (Sample ‘HL$ANSI-X12N834’)|
|ASK Partner Number| Used to populate Segment ‘ISA’ element ‘06’; and Segment ‘GS’ element ’02’.
|ISA Control Number| Used to populate Segment ‘ISA’ element ‘13’; and Segment ‘IEA’ element ‘02’.
|GS Control Number| Used to populate Segment ‘GS’ element ’06’; and Segment ‘GE’ element ‘02’..
|Master Policy Number| Used to populate Segment ‘REF’ element ’02’.
|From Date|
|To Date|
|Plan Type| Mandatory, LOV Available\\You must select a Benefit plan type to process (Sample Dental,Medical, Vision,Health)|
|This is a Test File| Value of ‘Y’ or ‘N’. Used to populate Segment ‘ISA’ element ’15’ (populate with ‘T’ for test file; and ‘P’ for production file).|
|This is an Update File| Value of ‘Y’ or ‘N’. Used to populate Segment ‘BGN’ element ’08’ (populate with ‘RX’ for replace action).|
|Create File| Value of ‘Y’ or ‘N’. If set to 'N' no file will be created.|
|Directory Name| Enter a valid directory name (Directory must be found on the database server)|
|File Name| Enter a file name|
|Include Exception| Value of ‘Y’ or ‘N’ (to include exception messages on the report)|
|Exception Level| You should always run with Exception level unless for tracing. In Trace Level 1, the employee Header with Person Code and Employee Name are displayed with performance time, this can be used for Progress bar or to locate employee with problem. In Trace Level 2, the BE plans are displayed after employee header information|
This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop