1. Getting Started — Login

Type your User ID on the login page. Your Name and Department fill in automatically from the user list that HR maintains under HR Control → User Access; then enter the password conferred to you and click Unlock Application. The default HR user is 104870 (Ashok Tripathi, HR) whose password is the Master Password (initially VSLP@123). On a successful login the page celebrates with crackers and a bell, then opens the application. Users, passwords and every record live in the VSLP_QR SQL Server database, so every terminal that opens this application works on the same data; a copy is also kept in the browser so work continues if the server is briefly unavailable and syncs back automatically. The connection state is shown in the heading of every page and in the badge at the bottom-right.

2. The Heading, Clock, Badges and Master Refresh

Every page carries the VSLP logo with VSLP ENTRY PRO — Digital Identity for a Secure Workplace both in the horizontal heading (beside the sidebar, above the pages) and the vertical heading (left, with the numbered tabs), together with the HR CONTROLLED badge and the VERSION badge (the version number changes with every release of the application). The horizontal heading also shows a live analog + digital clock. The red MASTER REFRESH button re-reads all shared data from SQL Server, redraws every page and every card sheet, and turns green once the refresh is complete.

3. Voice Guidance

A voice guide welcomes you on the login page and, on every tab, explains what to do and in which order to get the result. Use the VOICE ON / OFF button to switch it on or off, choose a Male or Female voice, and click ↻ Repeat to hear the guidance for the current page again. The choice is remembered on this computer. (Some browsers play the welcome message only after the first click or key press on the page.)

4. The Six Card Types

• QR ID Card — Employee / contractor identity cards with a scannable QR code containing all details.
• Monitoring Card — Photo identity cards with an automatically generated Employee ID (2 letters of the contractor name + 4 digits), blood group badge, DOB / AGE, DEPT / GENDER, VALID UPTO and a SEAL block beside an AUTHORISED SIGNATORY block.
• Employee Canteen Card — Canteen beneficiary QR cards for employees with residency, status and eligibility.
• Family Beneficiary ID Card — Photo identity card for a family member, carrying the VSLP logo and a logo watermark. The Beneficiary ID is generated automatically as the relation letter + the 6-digit Employee ID (Father F, Mother M, Son S, Daughter D, Wife W, Husband H; e.g. S104870) and is printed in bold red directly above the photograph. AGE is calculated from DOB and Date of Issue, VALID UPTO is exactly 6 months from the Date of Issue, and the card has the same SEAL and AUTHORISED SIGNATORY blocks as the Monitoring Card.
• Family Member QR ID Card — QR beneficiary card for family members (canteen). It can be filled directly from the Family Beneficiary ID Card records (see section 6), so the Family ID is the same Beneficiary ID.
• IT Asset QR Generator — Asset custody cards for laptops and desktops; the QR code holds the full configuration and the user it is issued to.

5. Creating & Generating Cards

Fill the form on the left and click Add / Update Record. The record appears in the table. Click Generate Card to render the printable vertical (54 mm × 86 mm) cards on the sheet. Use Print / Save A4, A6 or A7 Sheet (choose “Save as PDF”) to export. Every printed or saved page — page 1, 2, 3 and onwards — carries the same 0.5 inch header and footer with the VSLP logo, the card type and the date, and the cards never run into them (nine cards to an A4 page, one card to an A6 or A7 page). Every table carries an SL. NO column for reference (it is never printed on a card). Edit next to any row loads that record back into the form on the left — every field, including the photograph — while the ID stays locked so an edit can never create a duplicate; change what is needed and click Add / Update Record, or Cancel Edit to start a fresh record; Delete removes the record and its card on every terminal. Every card carries the VSLP logo as a watermark. Valid Upto is always exactly 6 months from the Date of Issue and every date is shown as DD-MM-YYYY.

6. Family Beneficiary ID Card → Family Member QR ID Card

Create the beneficiaries once on the Family Beneficiary ID Card tab (with photos). Then either (a) click ⬇ Export for Family Member QR ID Card (Excel) — the file comes out in the Family Member QR ID Card template — and upload it on the Family Member QR ID Card tab, click Add / Update Record and Generate QR Card; or (b) open the Family Member QR ID Card tab and click ⬇ Import from Family Beneficiary ID Card to pull all beneficiaries in directly without any file. In both cases the Family ID is the same as the Beneficiary ID; when a family member is typed manually on the QR tab with the same Employee ID and relation, the existing Beneficiary ID is picked up automatically.

7. Employee Canteen Card → QR ID Card, and Monitoring Card → QR ID Card

The Employee Canteen Card tab has ⬇ Export for QR ID Card (Excel) — download those employees in the QR ID Card layout, upload the file on the QR ID CARD tab, click Add / Update Record and Generate QR Card.

Leave Employee ID blank, type the Contractor Name, and the application builds a 6-character ID: two letters of the contractor name + a 4-digit number from a single running series held in SQL Server (never issued twice, even by two terminals at the same moment; bulk uploads reserve a block in one request). After the IDs are generated click ⬇ Export for QR ID Card (Excel), upload the file on the QR ID Card tab, click Add / Update Record and Generate QR Card — same employees, same IDs, same dates.

8. Import / Export (Bulk Upload)

Every tab follows the same four steps: 1) Download Excel Template, 2) fill and save it, 3) upload it with the file picker (a green bar confirms how many records were read), 4) click Add / Update Record. Cards are generated automatically for batches up to 150. A row keeps its own Date of Issue; where the file has none, the date selected in the form is used, else today's date. A re-upload updates existing records instead of duplicating them, and an empty cell never erases a value already on record. Photographs cannot travel in a spreadsheet — add them per row after the upload. Every photo column offers Upload, Replace and Remove, and a thumbnail of the photo currently on record.

9. HR Control

The tab is protected: the Master Password is asked every time HR Control is opened.

• Password Management — change the shared Master Password, set or reset any user's password, and see the map of where each password is used.
• User Access — create, update, disable or delete the users who may log in (User ID, User Name, Department, Password). The login page auto-populates Name and Department from this list. Changes require the Master Password.
• Data Reset — choose a From and To Date of Issue; the working records and cards of every tab in that range are removed on all terminals so they can be re-issued. The issuance log is kept. Your User ID, Name and Department are filled from your login; enter your password (HR-department user or Master Password). Use Preview first to see how many records are affected.
• Archived Data — every card ever generated is archived automatically. Filter by date, then Export any card type (the file comes out in that tab's own upload layout, so uploading it back regenerates the cards) or Restore to tab to put the records straight back into the working tab. Export ALL gives one workbook with a worksheet per card type.
• Archived Cards — type an Employee ID (or Beneficiary ID / Family ID / IT Serial No, or a name) and the card is pulled back. Edit any detail, upload, replace or remove the photograph, click Save Changes, and Print or Save that single card on A4, A6 or A7.
• Clear Data — choose the date range and the data set to clear from the dropdown (one card type, the Issuance Log, all working records, or everything). The selected data is deleted permanently on SQL Server and on every terminal and cannot come back.

10. Clear Data on the card tabs (Locked 🔒)

The Clear Data button on each tab wipes the working records and cards of that tab after the Master Password is entered. The permanent issuance log (ID Card Summary and Dashboard) is kept as evidence of issuance; only HR Control → Clear Data or the summary's own clear button can remove it.

11. ID Card Summary and Dashboard

The ID Card Summary consolidates every record ever issued, per card type, with the true time of issue; filter by card type and Daily / Weekly / Monthly period, then print or export (Excel / CSV). The Dashboard shows totals, validity status and expiry alerts, the 12-month issuance trend, cards by type, contractor and canteen breakdowns, family relations, IT assets, users and the SQL Server connection. Use Export Dashboard (Excel) for the full workbook.

12. Shared database and connection status

Every save is pushed to SQL Server within half a second; other terminals pick it up within 5 seconds. Records are merged by identity, deletions and clears propagate to every terminal, Employee IDs are allocated by the server, and the master password and user list are shared. The heading shows SQL Server: CONNECTED in green when the database is reachable; the status only turns red after three consecutive failed checks, so a momentary delay never flickers the badge. Hover the badge for the exact reason when it is red (for example “Login failed for user”), and use MASTER REFRESH to re-read the shared data at any time.

13. Integration — VSLP CAFE ONE

Click Export for CAFE ONE in the header to download the consolidated canteen beneficiary dataset (Employee & Family) in the CAFE ONE vslp_state structure.

VS Lignite Power Pvt. Ltd. — Internal HR / Operations Tool.