Add a field program_id to each program. It is a string auto generated with the format: PROG_{SEQ}

[jeremi]

Overview

Each program within the OpenSPP system needs to have a unique identification. This will be represented by the program_id field.

• program_id is a string and should be auto-generated by the system.
• The format of program_id should be PROG_{SEQ}.
  • PROG_ is a static prefix.
  • {SEQ} is a dynamically generated unique sequence number.
• The sequence number {SEQ} should increment for each new program.

Program Referencing

• Each program should be easily identifiable and searchable through its unique program_id. This implies that program_id should be indexed in the database to allow efficient searching and sorting.
• The program_id should also serve as the XML ID of the record, facilitating easy referencing of the program in XML files and throughout the system.

Constraints

• program_id should be unique. The system should not allow the creation of two programs with the same program_id.
• program_id should not be editable by users once the program is created. This is to maintain the integrity of the program_id.

This detailed specification aims to improve the handling and identification of programs within the OpenSPP system. The unique program_id not only ensures the uniqueness of each program but also enhances the search and sorting capabilities, providing a better user experience.

[gonzalesedwin1123]

@jeremi @dasunhegoda @nhatnm0612 may I propose that this be moved to the openspp-program repo as a customization of the existing spp_programs module.

[nhatnm0612]

@jeremi @dasunhegoda @nhatnm0612 may I propose that this be moved to the openspp-program repo as a customization of the existing spp_programs module.

about this, I think not, it will affect PDS as well, since this field is required on the view, it will raise an error for all the programs that not having it

[adriancris]

Findings: All test cases below are passed and approved by QA

TSACF-19: Create a Program to verify that Program ID is automatically generated
TSACF-20: Create three or more Programs to verify that Program IDs increment for each new program
TSACF-21: Create Program simultaneously to verify that Program IDs still increment for each new program
TSACF-22: Archive a Program to verify that Program IDs are not reused
TSACF-48: Searching a Program using Program ID
TSACF-49: Sort Programs according to Program ID

All working as expected

[jeremi]

So this has been implemented already? @adriancris ?

[adriancris]

hi @jeremi
yes this is already in ACF-DEV