Skip to content

main-5082

main-5082: #3965 - Separate Sequencing for FT and PT eCert Numbers (#4207)
@bidyashish bidyashish tagged this 07 Jan 17:50 
**Technical** 
- [x] Append the offering intensity as a prefix following the same done
for MSFAA.
- [x] Create the DB migration to rename the current
`DISBURSEMENT_DOCUMENT_NUMBER` to `Part
Time_DISBURSEMENT_DOCUMENT_NUMBER`.
- [x] Upinsert the mentioned values for non-PROD (DEV/TEST/Staging).


 Db Migrations: Run

![image](https://github.com/user-attachments/assets/9883e731-542f-40e9-b011-2f46ddb0e15c)

 Db Migrations:: Demo

![image](https://github.com/user-attachments/assets/aa46f702-0d13-4cee-bbcb-ddc9e68bd8f9)


 Db Migrations: Revert

![image](https://github.com/user-attachments/assets/3e5a9da9-e7cb-4961-a358-151adf8a417e)

Up Insert:  non-PROD (DEV/TEST/Staging).

```
-- Part Time Document Number Sequence Control
UPDATE sims.sequence_controls
SET sequence_number = 200000
WHERE sequence_name = 'Part Time_DISBURSEMENT_DOCUMENT_NUMBER';

-- Full Time Document Number Sequence Control
UPDATE sims.sequence_controls
SET sequence_number = 12000000
WHERE sequence_name = 'Full Time_DISBURSEMENT_DOCUMENT_NUMBER';

```

Extra E2E Test
`sources/packages/backend/apps/api/src/route-controllers/confirmation-of-enrollment/_tests_/e2e/confirmation-of-enrollment.institutions.confirmEnrollment.e2e-spec.ts`


![image](https://github.com/user-attachments/assets/40346a5c-78df-440d-8930-4e80ce96a421)
Assets 2
Loading