TripOn

The Employee Management module is used to add and manage employees working under a specific enterprise (company).
Each employee is linked to a location and enterprise, and optionally can be given system login access by enabling the is_user option.
If login is enabled, the employee will have a user ID and password to access the system based on assigned role and permissions.

Table

employee_master

• id (PK) INT Unique employee ID
• employee_name VARCHAR(150) Employee full name
• location (FK) INT References khm_loc_mst_geography.geog_id
• mobile VARCHAR(15) Employee mobile number
• email VARCHAR(150) Employee email
• address TEXT Employee address
• is_user BOOLEAN Whether employee has system login access
• user_id VARCHAR(100) Login username
• password VARCHAR(255) Login password (encrypted)
• enterprise_id (FK) INT References enterprise_master.enterprise_id
• added_date DATETIME Record creation date

Validation

Add

• Employee Name is mandatory
• Minimum 3 characters required
• Location must be selected from Geography Master
• Mobile number is mandatory
• Mobile must be numeric
• Mobile length must be 10–15 digits
• Email is mandatory
• Email must be valid format
• Address is optional

Login Access

• If is_user = TRUE, then:
  • user_id is mandatory
  • user_id must be unique
  • password is mandatory
  • password minimum 6 characters
  • password must be stored encrypted (not plain text)
• If is_user = FALSE:
  • user_id and password must be NULL or empty

Duplicate

• System must prevent duplicate:
  * Same mobile number under same enterprise
  * Same email under same enterprise
  * Same user_id globally

Edit Employee

• Must allow editing:
  • Name
  • Mobile
  • Email
  • Address
  • Location
  • Login access enable/disable
• Must NOT allow:
  • Duplicate mobile
  • Duplicate user_id