People Directory

module: people-directory
intent: null            # setup | advice | review | fix | build | convert | export
scale: null             # Starter | Growth | Scale, only if the answer changes it
areas:
  "People": null
  "Data": null
  "Structure": null
  "Current process": null
  "Outcome": null
requested_outputs: []   # csv | sql | json | notion | xlsx - requested formats only
confirmed_facts: []     # only what the user actually said
open_questions: []      # the unanswered ones, in the order worth asking

Full Name,Annual CTC,Currency,Date of Birth,Department,Email,Accounts,Emergency Contact,Emergency Phone,Employee ID,Employment Type,End Date,Grade Level,KPIs,Job Title,Access Role,LinkedIn,Manager,Nationality,Notes,Phone,Probation Status,Profile Photo URL,Skills,Start Date,Status,Time Zone,Work Location
Aarav Sharma,1200000.00,INR,1991-04-18,Delivery,aarav.sharma@example.com,"Payroll portal, HRIS",Anil Sharma,+91 98xxxxxx34,,Full Time,2027-03-31,L1,On-time delivery %,Delivery Manager,Line manager,https://linkedin.com/in/aarav-sharma-example,Sneha Iyer,Indian,Joined from a competitor; notice period is one month.,+91 98xxxxxx21,Passed,https://example.com/photo.jpg,"Excel, SQL, Client Handling",2021-03-08,Active,IST (UTC+5:30),Bengaluru

CREATE TABLE people_directory (
  full_name VARCHAR(255),
  annual_ctc NUMERIC(14,2) NOT NULL,
  currency VARCHAR(255),
  date_of_birth DATE NOT NULL,
  department VARCHAR(255),
  email VARCHAR(255),
  accounts VARCHAR(255),
  emergency_contact VARCHAR(255),
  emergency_phone VARCHAR(255),
  employee_id SERIAL PRIMARY KEY,
  employment_type VARCHAR(100) NOT NULL,
  end_date DATE,
  grade_level VARCHAR(100) NOT NULL,
  kpis VARCHAR(255),
  job_title VARCHAR(255),
  access_role VARCHAR(255),
  linkedin TEXT,
  manager VARCHAR(255),
  nationality VARCHAR(255),
  notes TEXT,
  phone VARCHAR(255),
  probation_status VARCHAR(100) NOT NULL,
  profile_photo_url TEXT,
  skills VARCHAR(255),
  start_date DATE NOT NULL,
  status VARCHAR(100) NOT NULL,
  time_zone VARCHAR(255),
  work_location VARCHAR(255),
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_people_directory_status ON people_directory (status);

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "People Directory",
  "type": "object",
  "additionalProperties": false,
  "properties": {
    "Full Name": {
      "type": "string"
    },
    "Annual CTC": {
      "type": "number"
    },
    "Currency": {
      "type": "string"
    },
    "Date of Birth": {
      "type": "string",
      "format": "date"
    },
    "Department": {
      "type": "string"
    },
    "Email": {
      "type": "string",
      "format": "email"
    },
    "Accounts": {
      "type": "string"
    },
    "Emergency Contact": {
      "type": "string"
    },
    "Emergency Phone": {
      "type": "string"
    },
    "Employee ID": {
      "type": "integer"
    },
    "Employment Type": {
      "type": "string"
    },
    "End Date": {
      "type": "string",
      "format": "date"
    },
    "Grade Level": {
      "type": "string"
    },
    "KPIs": {
      "type": "string"
    },
    "Job Title": {
      "type": "string"
    },
    "Access Role": {
      "type": "string"
    },
    "LinkedIn": {
      "type": "string",
      "format": "uri"
    },
    "Manager": {
      "type": "string"
    },
    "Nationality": {
      "type": "string"
    },
    "Notes": {
      "type": "string"
    },
    "Phone": {
      "type": "string"
    },
    "Probation Status": {
      "type": "string"
    },
    "Profile Photo URL": {
      "type": "string",
      "format": "uri"
    },
    "Skills": {
      "type": "string"
    },
    "Start Date": {
      "type": "string",
      "format": "date"
    },
    "Status": {
      "type": "string"
    },
    "Time Zone": {
      "type": "string"
    },
    "Work Location": {
      "type": "string"
    }
  },
  "required": [
    "Annual CTC",
    "Date of Birth",
    "Employment Type",
    "Grade Level",
    "Probation Status",
    "Start Date",
    "Status"
  ]
}

| CSV column | Notion property | Set after import |
|---|---|---|
| Full Name | Title | Use as the database title |
| Annual CTC | Number (format: currency) | Convert to Number, set format to Currency |
| Currency | Text | Leave as Text |
| Date of Birth | Date | Convert to Date |
| Department | Text | Leave as Text |
| Email | Email | Convert to Email |
| Accounts | Text | Leave as Text |
| Emergency Contact | Text | Leave as Text |
| Emergency Phone | Text | Leave as Text |
| Employee ID | Text (preserve source ID) | Keep imported IDs as Text; optionally add a separate Unique ID property |
| Employment Type | Select (add options after import) | Convert to Select, add options: "Full Time", "Part Time", "Contract", "Intern", "Consultant" |
| End Date | Date | Convert to Date |
| Grade Level | Select (add options after import) | Convert to Select, add options: "L1", "L2", "L3", "L4", "L5", "M1", "M2" |
| KPIs | Text | Leave as Text |
| Job Title | Text | Leave as Text |
| Access Role | Text | Leave as Text |
| LinkedIn | URL | Convert to URL |
| Manager | Text | Leave as Text |
| Nationality | Text | Leave as Text |
| Notes | Text | Leave as Text |
| Phone | Text | Leave as Text |
| Probation Status | Select (add options after import) | Convert to Select, add options: "Not Started", "In Progress", "Passed", "Failed", "Extended" |
| Profile Photo URL | URL | Convert to URL |
| Skills | Text | Leave as Text |
| Start Date | Date | Convert to Date |
| Status | Select (add options after import) | Convert to Select, add options: "Active", "On Leave", "Notice Period", "Exited" |
| Time Zone | Text | Leave as Text |
| Work Location | Text | Leave as Text |