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 11 added 2 lines
The UPDTB supports the Scotia Bank ACH format - interface Type 28 is used for this. \\
At line 28 changed one line
• 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 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). \\
At line 60 added 41 lines
!!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;
/
}}}
----
This page (revision-17) was last changed on 23-Feb-2023 16:11 by Kevin HiggsTop