Catalog Item: Employee Code Reservation

[kpanchal]

Hello All,

I need help building this requirement, Please help.

Objective:
Develop a catalog item for Employee Codes Reservation to accommodate all potential combinations of AA999 & AA99 employee codes.

Scenario Description:

For employees associated, existing employee codes adhere to the AA99 format. If an existing employee leaves and returns within 400 days, they will regain their previous employee code in the AA99 format.

For new employees requesting an employee code for the first time, the following criteria must align:
1. Provide code suggestions.
2. Generate a new code in the AA999 format.
3. Once a suggestion is offered, the code remains reserved until the employee either submits or selects a different code.

Acceptance Criteria:
Fields:
- Status: Free/Reserved/Assigned/Blocked/Completed
- Employee Code: Unique key combining AA99 (for old employees) & AA999 (for new employees). It will include the employee's first and last name initials. (EMP CODE = FIRST INITIAL + LAST INITIAL + 2/3 DIGITS)
- Employee ID: Reference field to Sys ID
- Date: Readonly once code allocation occurs
- SN Fields: Basic fields
- Name: FreeText

Conditions:
For Old Employees:
- If an employee previously had an EMP code, leaves RCGT, and returns within 400 days, they will retain their original EMP code.

For New Employees:
- Upon meeting criteria, additional conditions apply:
1. STATUS remains locked at RESERVED if the user selects a code from suggestions but does not submit.
2. STATUS changes to RELEASE if the user fails to submit within a one-hour period.
3. STATUS changes to ASSIGNED once the user submits and the code is allocated.
4. STATUS changes to Terminate if the employee leaves and does not return within 400 days.

Note: Reserved codes will be released back into the suggestion pool if the user selects a different code after initially choosing one and not submitting it.