Placement Overview
Branch-wise stats from placement_dashboard view
Total Students
—
Registered
Placed
—
Offers accepted
Avg Package
—
LPA
Max Package
—
Highest LPA
Placement % by Branch
VIEW: placement_dashboard
Company Offers
VIEW: company_stats
Branch-wise Dashboard
VIEW: placement_dashboard
Loading...
Students
All registered students · sorted by CPI
Student Registry
TABLE: STUDENT
Loading...
Companies & Roles
Registry with offer analytics · company_stats view
Loading...
Applications
All student applications · CPI trigger fires on INSERT
Application Log
TABLE: APPLICATION
Loading...
Offers
All placement offers · Accepting fires DB triggers
⚡ Triggers on OFFER acceptance:
1. trg_auto_reject_on_acceptance — auto-rejects other pending apps
2. trg_close_role_when_full — closes role when openings filled
3. Student eligible flag set to FALSE
1. trg_auto_reject_on_acceptance — auto-rejects other pending apps
2. trg_close_role_when_full — closes role when openings filled
3. Student eligible flag set to FALSE
Loading...
Application Tracker
Per-student view · VIEW: application_tracker
Interesting Queries
Subqueries · Window functions · Aggregates
Tech Pass / HR Fail
No Offer ≥3 Apps
Company CPI Rank
Loading...
Welcome
Loading your profile...
My Applications
VIEW: application_tracker
My Offers
Accept or decline your placement offers
⚡ Accepting an offer fires DB triggers: all your other pending applications are automatically rejected, and the role closes if full.
Open Roles
All currently open job roles you can apply to
Available Positions
TABLE: JOB_ROLE · is_open = TRUE