This page (revision-17) was last changed on 23-Feb-2023 16:11 by Kevin Higgs

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
17 23-Feb-2023 16:11 7 KB Kevin Higgs to previous
16 26-Nov-2021 10:22 6 KB Karen Parrott to previous | to last
15 26-Nov-2021 10:22 6 KB Lilia Urtan to previous | to last
14 26-Nov-2021 10:22 6 KB kparrott to previous | to last
13 26-Nov-2021 10:22 6 KB kparrott to previous | to last
12 26-Nov-2021 10:22 4 KB kparrott to previous | to last
11 26-Nov-2021 10:22 3 KB kparrott to previous | to last
10 26-Nov-2021 10:22 3 KB khiggs to previous | to last
9 26-Nov-2021 10:22 3 KB khiggs to previous | to last
8 26-Nov-2021 10:22 3 KB rforbes to previous | to last
7 26-Nov-2021 10:22 3 KB rforbes to previous | to last
6 26-Nov-2021 10:22 3 KB rmorrell to previous | to last
5 26-Nov-2021 10:22 3 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB RForbes to previous | to last
3 26-Nov-2021 10:22 3 KB JEscott to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links
UPDTB
UPDTB

Version management

Difference between version and

At line 2 added one line
If your organization creates direct deposits, an interface file needs to be created and then sent to the bank. You may generate this file through the Create Payroll Direct Deposit File (UPDTB) form.
At line 3 removed 6 lines
!!Processing Information
If your organization creates direct deposits or Electronic Fund Transfers (EFT), an interface file needs to be created and then sent to the bank. You may generate this file through the Create Payroll Direct Deposit File (UPDTB) form.
The UPDTB will ignore/bypass deposits that have status of 'Cancelled'.
At line 11 removed 2 lines
The UPDTB supports the Scotia Bank ACH format - interface Type 28 is used for this. \\
At line 14 changed 6 lines
|Bank Deposit| [HL$ACH]| USA
|TD Fund$Out|[HL$TDBANK_CDN] |Canada
| |[HL$TDBANK_USA]| USA
|Royal Bank Deposit| [HL$RYBANK_STD152]| Canada
|Scotia Bank Deposit| [HL$BNS_BANK]| Canada
|CIBC Deposits| [HL$CIBC] |Canada
|Bank Deposit| HL$ACH| USA
|Disbursement File|HL$UPDIF_CDN| Canada
| |HL$UPDIF_USA| USA
|TD Fund$Out|H$TDBANK_CDN |Canada
| |H$TDBANK_USA| USA
|Royal Bank Deposit| HL$RYBANK_STD152| Canada
|Scotia Bank Deposit| HL$BNS_BANK| Canada
|CIBC Deposits| HL$CIBC |Canada
At line 21 changed one line
Note that record 7 - Child Support addendum is created by the UPDISB and not through the set up of the fields on the interface.
Pre-notification deposits are processed.
At line 23 changed 80 lines
The values on Record 7 of the IDIF will be used when creating an ACH file and the 'Debit Payroll Account' account is set to yes. These will be the totals for all deposits in the file.
!Prenoting Employees without a Pay/Disbursement Feature:
The Payroll Direct Deposit Interface program (UPBTB) will process pre-notification records when the employee has a disbursement (IPDS) resulting from a pay run. In the case where employers do not issue pay checks, it is desirable to enter the direct deposit information as soon as possible and send a pre-note to the bank for processing. Therefore the employee’s first pay would be a direct deposit not a check. In order to create a pre-note wihtout a pay/disbursement in a pay run, the following must be done:\\
• The parameter called 'Prenotes ONLY' needs to toggled\\
• When this toggle is ON, UPDTB will review the Payment Method table for all Active Records based on the ‘As of Date’ that have the Prenote Required toggle turned on. Then it will create a direct deposit file with the pre-note records. The record will be the same as currently being created, no changes are required.\\
• The UPDTB will update the disbursement (IPPM) Prenote Date with the As of Date from the UPDTB parameter. \\
• The UPDTB will update the disbursement (IPPM) Deposit Starts Date with the As Of Date (Prenote date) plus the number of prenote days from the employer’s bank (IPBA). \\
The current processing 'The Gross to Net' program will continue to work exactly the same. When the issue date of the UPCALC program is equal to or greater than the number of days on the employee’s Deposit Start Date then the deposit record will be used. The logic in UPDTB without the ‘Prenote ONLY’ toggle on will remain the same. This means that if an employee is hired after UPDTB is run for ‘Prenotes ONLY’, the employee will receive a check for the first Pay.
----
!!Report Parameters
||Report Parameters||
|Payroll Bank Account|Mandatory, LOV Available\\The bank account from where the deposits are drawn.
|Entity Code|Optional, LOV Available\\Limits the process to the Entity specified.
|Debit Payroll Account|Optional, Toggle\\This parameter is used only for the ACH format and will create conditional debit \\to cover the total of all checks.
|As Of Date|Mandatory, Date, LOV Available\\The date of the EFT.
|From Pay Issue Date|Mandatory, Date, LOV Available\\The earliest issue date of the deposits that will qualify for this EFT
|To Pay Issue Date|Mandatory, Date, LOV Available\\The latest issue date of the deposits that will qualify for this EFT.
|Interface Code|Mandatory, LOV Available\\The report definition selected will determine the format of the output file (if any), \\as well as the columnar content of the report.
|Interface Directory|Mandatory, Text\\Must be a directory on the [data base server|DATA BASE SERVER] for which the current user (as signed onto the \\client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the \\‘TEMP’ directory on the server, not the local directory for the computer terminal\\ being used.
|File Name|Mandatory, Text\\Enter the name of the file that will be created in the interface directory specified.
|Write or Append|Mandatory, LOV Available\\Append or overwrite any existing file.
|Custom Header Record|Optional, Text\\This exact text will be written as a separate record at the beginning of the file.
|Custom Trailer Record|Optional, Text\\This exact text will be written as a separate record at the end of the file.
|Output Headers/Trailer|Optional, Toggle\\If this toggle is ON, these records will be marked as ‘/H’ at the beginning and ‘/T’ at \\the end.
|Test Run|Optional, Toggle (Only used for the Royal Bank)\\This is a function for Canadian installations. This field ensures that in the Royal\\Bank format, Record ‘1’, Field ‘6’ will have a value of TEST. This indicates that this\\is a test file and not an actual file that the bank will load. The file will still be created\\normally.
|ACH Blocking|Optional, Toggle\\This is a function for US installations only.\\Some clearing houses require blocking as described in the ‘ACH Rules’. Normally\\these are ones who still use ‘reel to reel’ tape drives.\\ACH records must be written in groups (blocks) of 10 records. After the file control\\record is written onto the file, the remaining unused records of the last physical\\block is completed with all 9's. If the total number records (headers + details +\\control records) is a number evenly divisible by ten then there are no records written\\with 9's.
|Prenotes ONLY|Optional, Toggle\\If 'ON', the Payment Method table will be reviewed for all Active Records based on the ‘As of Date’ and those that have the Prenote Required toggle turned on will have pre-note records created in the direct deposit file. This is a function for US installations.
|Trial|Optional, Toggle\\If ‘ON’ then the update is not committed and UPDTB may be run again. If run in update mode the MEX_ID will be populated as a flag on the P2K_PR_DEPOSITS table. If the MEX_ID is populated the deposit will not be picked up on any subsequent runs.
|Exception Level|Mandatory, LOV Available\\Users may increase the level of logging done from exception to user, legislation,\\usercalc, program or utility levels.
----
!!BYPASSED DEPOSIT NOTIFICATIONS
The UPDTB process will flag all deposits as being completed if run in non-trial mode.
The deposit will be updated with the MEX_ID of the UPDTB that processed them.
The UPDTB will report any outstanding deposits that do not have this MEX_ID and meet the additional conditions of\\
\\
- Having a status of "Deposit Issued" in the lexicon X_DEPOSIT_STATUS \\
- Having a Pay Issue Date less than the "From" date in the UPDTB_CPA1496 parameters.
!!HOW TO UNDO UPDTB
There is no standard function to "undo" a UPDTB that has been run in UPDATE mode.
The UPDTB will update MEX_ID column found on the P2K_PR_DEPOSITS table with the execution ID created when UPDTB was processed.
This prevents deposits that have already been sent to the bank from appearing in susequent runs of UPDTB.
A script can be used in situations where the file sent is rejected, or problems are identified after running the process.\\
\\
Please note - '######' will be replaced by the MEX_ID from UPDTB
First verify the number of records to be updated;
{{{
select count(mex_id)
from p2k_pr_deposits
where mex_id = '######';
/
}}}
Once you have verified the number of records, the update script can be run;
{{{
UPDATE p2k_pr_deposits
set mex_id = NULL
where mex_id = '######';
/
}}}
Once the update script has been completed - commit the records;
{{{
COMMIT;
/
}}}
----
![Notes|Edit:Internal.UPDTB]
[{InsertPage page='Internal.UPDTB' default='Click to create a new notes page'}]
||__Report Parameter Form__||
|__Payroll Bank Account__|__Mandatory, LOV Available__\\The bank account from where the deposits are drawn.
|__Debit Payroll Account__|__Optional, Toggle__\\This parameter is used only for the ACH format and will create conditional debit \\to cover the total of all checks.
|__As Of Date__|__Mandatory, Date, LOV Available__\\The date of the EFT.
|__From Pay Issue Date__|__Mandatory, Date, LOV Available__\\The earliest issue date of the deposits that will qualify for this EFT
|__To Pay Issue Date__|__Mandatory, Date, LOV Available__\\The latest issue date of the deposits that will qualify for this EFT.
|__Interface Code__|__Mandatory, LOV Available__\\The report definition selected will determine the format of the output file (if any), \\as well as the columnar content of the report.
|__Interface Directory__|__Mandatory, Text__\\Must be a directory on the server for which the current user (as signed onto the \\client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the \\‘TEMP’ directory on the server, not the local directory for the computer terminal\\ being used.
|__File Name__|__Mandatory, Text__\\Enter the name of the file that will be created in the interface directory specified.
|__Write or Append__|__Mandatory, LOV Available__\\Append or overwrite any existing file.
|__Custom Header Record__|__Optional, Text__\\This exact text will be written as a separate record at the beginning of the file.
|__Custom Trailer Record__|__Optional, Text__\\This exact text will be written as a separate record at the end of the file.
|__Output Headers/Trailer__|__Optional, Toggle__\\If this toggle is ON, these records will be marked as ‘/H’ at the beginning and ‘/T’ at \\the end.
|__Test Run__|__Optional, Toggle (Only used for the Royal Bank)__\\This is a function for Canadian installations. This field ensures that in the Royal\\Bank format, Record ‘1’, Field ‘6’ will have a value of TEST. This indicates that this\\is a test file and not an actual file that the bank will load. The file will still be created\\normally.
|__ACH Blocking__|__Optional, Toggle__\\This is a function for US installations only.\\Some clearing houses require blocking as described in the ‘ACH Rules’. Normally\\these are ones who still use ‘reel to reel’ tape drives.\\ACH records must be written in groups (blocks) of 10 records. After the file control\\record is written onto the file, the remaining unused records of the last physical\\block is completed with all 9's. If the total number records (headers + details +\\control records) is a number evenly divisible by ten then there are no records written\\with 9's.
|__Trial__|__Optional, Toggle__\\If ‘ON’ then the update is not committed and UPDTB may be run again.
|__Exception Level__|__Mandatory, LOV Available__\\Users may increase the level of logging done from exception to user, legislation,\\usercalc, program or utility levels.
This page (revision-17) was last changed on 23-Feb-2023 16:11 by Kevin HiggsTop