Please enable JavaScript.
Coggle requires JavaScript to display documents.
How to test B&B Vux ((Set student status 'XTRAINO2' = '…
How to test B&B Vux
Set student status 'XTRAINO2' = 'ERS' (This means that which student status will get the compensation)
-Use persona 'Bengt Vux' to set the 'ERS' to student status
-Go to Grund uppgifter => Kod
Search 'Kodtyp' = STATUS
Grund uppgifter/Enhet (Use personas 'Bengt' to set up)
set 'Godkänd för delutbetalning' to some school (ex. Lärgården)
TO TEST in TecOrwell Sthlm_lsm
In Elev - Beräkningsdata ..search 'Lärgården', fr.o.m. 2018-01-08
, STATUS 'Antagen'
, KOMMUN='Stockholm'
filter Fr.o.m '2018-01' , ERSÄTTNING 'ja' ...Antal elev - beräkningsdata: 26 / 55
test calculate Lärgården utbildning ab ...
calculation date = 2018/01/25,
4.1 filter Fr.o.m '2018-02' , Ersättning 'ja' ...Antal elev - beräkningsdata: 26 / 55
5.1 test calculate Lärgården utbildning ab ...
calculation date = 2018/02/25,
5.3 ...before testing 2018/03 (test slut betalning at month of EVG-End-date)
*
*
update integration date to get the previous payment
*
update kjgv0brs set INTEGRADATUM = '20180120' where skolform='kv' and BEST_ID=(select best_id from kjgvaa1brh where skolform='kv' and BEST_ID_T='Lärgården-201801')
update kjgv0brs set INTEGRADATUM = '20180220' where skolform='kv' and BEST_ID=(select best_id from kjgvaa1brh where skolform='kv' and BEST_ID_T='Lärgården-201802')
5.5 Final payment ..if student has no grade then school should not get any payments
**
And -Final payment should not calculate the surcharge(påslag)
*
*
Insert grade in EBT
**
insert into kjgv0ebt values ('JENS','KV','INSELI0','S','198402216819','{BFA424B3-2D45-4ECB-906B-B691F7A276C5}','C','20180316',' ','0',' ','0.00','0.0','0.0','0.0',' '
,'2018:1','JE1ELI0KGRELX',' ',' ',' ','20170714','29121212TF21','135216681',' ','0.00',' ','0.00',' ','0.00',' ',' ',' ',' ',' ',' ','0.0'
,'20180316',' ',' ',' ',' ',' ',' ',' ',' ',' ','195611096032',' ','19020202TF20','20170714',' ','0',' ',' ',' ','20170714','0')
5.4 test calculation factor
5.4 test tilläggsuppgift
-Set points(poäng) values & Shows points in result-gridview
-Set number(antal) = payment days(ersättning dager)
-For school is not approved for partial payment should shows the student cost only in the last month of EVG-end-date
-Final payment should not calculate the surcharge(påslag)
-calulation factor ...antal * factor
SELECT
BRS.POANG, BRS.ANTAL, BRS.*
FROM KJGVAA22BRS_VUX BRS
WHERE SKOLFORM='kv' and SKOLENHET='LÄRG' --'ULTR'
AND BELOPPSGRUPP='ERS_EXTERN'
AND FROMDAT <= '20180125' AND TOMDAT >= '20180125'
AND ((EJ_ERSATTNING = '0' AND ERS_FROMDAT = '' AND ERS_TOMDAT = '') OR
(EJ_ERSATTNING = '0' AND ERS_FROMDAT <= '20180125' AND ERS_TOMDAT >= '20180125'))
and brs.hemkommun = '0180'
order by KURSKOD