Index of every page on this site: llms.txt
All skills
Run it yourself

Build, extend and audit the 360° person profile at /admin/people/<ref>. Use when adding a panel, when asked "does the 360 show X", when a person surface looks thin or repetitive, or on the quarterly drift audit. Carries the source registry, the person-shape matrix, and three re-runnable audits that catch missing sources, unreadable rows, and permission drift.

  • 2 files
  • 24.8 KB
  • Updated 2 months ago
  • GitHub
Use this Skill: https://skilld.dev/gh/colaberryintern/colaberryenterprise_ai_leadershipaccelerator/person-360

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencessource-registry.md

≈2.4k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Person-keyed source registry

Every table in accelerator_prod that can be attached to a human being, with what the 360 profile does about it.

Measured 2026-09-09 against three real people chosen for different shapes: farhat@colaberry.com (heavy learner, org member), mungama2016@gmail.com (re-enrolled, one active + two withdrawn), qninying@gmail.com (13 failed payments, client project work).

Rows = rows held for those three combined. It measures whether a source is real, not its platform total.

Re-run the audit in ../SKILL.md and diff against this file. A table with rows that is not listed here is a gap.


Wired — read by a panel

Class and curriculum → panels/classPanels.ts

Table Key Rows Shown as
timeline_card_progress enrollment_id 3,884 Curriculum completion, quiz scores, attempts, last completed
attendance_records enrollment_id 33 Attendance rate and per-session register
session_presence_events enrollment_id 94 Live-room joins and leaves
session_poll_responses enrollment_id 91 Polls answered
session_pulse enrollment_id 23 Pulse checks
reflection_entries enrollment_id 29 Written reflections
timeline_survey_responses enrollment_id 29 Surveys
live_sessions (join) — Session titles and dates
timeline_cards (join) — Card titles, types, week numbers

Work product → panels/workPanels.ts

Table Key Rows Shown as
projects enrollment_id 5 Name, client org, stage, health/velocity/stability, repo, portfolio
student_task_lists project_id 32 Open and done task counts per project
capstone_records enrollment_id 4 Capstone status, visibility, publication
case_studies via projects 1 Title, client org, capability, publication count
case_study_publications case_study_id — Times published
case_study_snapshots case_study_id — Snapshot count
career_portfolio_pages enrollment_id 2 Portfolio page status
runtime_portfolio_artifacts enrollment_id 148 Artifacts produced
cert_sessions enrollment_id 0 Cert attempts (3 exist platform-wide)
cert_evidence_mappings enrollment_id 0 Evidence mapped to objectives

Account and billing → panels/accountPanels.ts

Table Key Rows Shown as
organizations owner_enrollment_id — Business accounts they own
org_members enrollment_id 1 Seats they occupy, invite status
lead_tenant_contexts lead_id — Which brand acquired them
tenants (join) — Brand name
sponsors contact_lead_id — Sponsor contact status
subscriptions enrollment_id 18 Full history, failures since last success
account_credits enrollment_id 1 Credits granted
refunds enrollment_id 1 Refunds issued
subscription_renewal_reminders enrollment_id 4 Last reminder sent

Development and context → panels/growthPanels.ts

Table Key Rows Shown as
student_level enrollment_id 4 Level, rank, architect readiness
student_competency enrollment_id 52 Domain confidence and evidence
student_architecture_skill enrollment_id 40 Per-skill proficiency
student_skill_evidence enrollment_id 2,841 Evidence count
evidence_records enrollment_id 173 Records, validated share
resume_skill_claims enrollment_id 1 Claims extracted from résumé
xp_events enrollment_id 589 XP total
student_points_events enrollment_id 679 Points total
runtime_mentor_turns enrollment_id 79 Questions asked of the AI mentor
learner_memory enrollment_id 3 What the mentor concluded about them
runtime_assessment_attempts enrollment_id 64 Assessments, scores, pass/fail
architect_evaluations enrollment_id 1 Weekly architect reviews
podcast_views enrollment_id 48 Podcasts consumed
blog_post_views enrollment_id 86 Articles read
network_video_views enrollment_id 86 Videos watched
today_feed_impressions enrollment_id 712 Feed served and interacted
cape_ai_pulse_exposure enrollment_id 38 CAPE pulse exposures
community_members enrollment_id 4 Level and points
community_posts via member_id 26 Posts written
community_likes member_id 9 Likes given
community_points_events member_id 19 Points events
community_contributions enrollment_id 5 Contributions
room_memberships enrollment_id 14 Rooms joined
room_messages enrollment_id 8 Messages sent
friend_referrals enrollment_id 1 Friends referred
user_curriculum_profiles enrollment_id 2 Company, role, goal, AI maturity
onboarding_profiles enrollment_id 4 Résumé, LinkedIn
github_connections enrollment_id 5 Connected repositories

Acquisition and sales → panels/acquisitionPanels.ts, personTimelineService.ts

Table Key Rows Shown as
leads email — The 29-field acquisition panel
visitor_sessions lead_id — Session count, sites, first/last seen
page_events lead_id — Page views on the timeline
behavioral_signals lead_id — Signals on the timeline
intent_scores lead_id — Intent (suppressed post-conversion)
activities lead_id 75 Sales activities
interaction_outcomes lead_id 88 Call and email outcomes
scheduled_emails lead_id 66 Emails sent
communication_logs lead_id 46 Communication log
campaign_leads lead_id 6 Campaign enrolment and step
openclaw_responses lead_id — Outreach posts
appointments lead_id — Booked appointments
strategy_calls lead_id — Strategy calls
automation_logs related_id — Automation runs
enrollments email — Enrolment rows, stage derivation
visitors lead_id — Visitor identity

Not yet wired — real rows, no panel

Each is a deliberate deferral, not an oversight. Wire when someone needs it.

Table Rows Why deferred
community_digest_logs 187 Digest emails sent to them. Delivery telemetry, not behaviour.
room_presence 43 Ephemeral online/offline. room_memberships answers the durable question.
community_leaderboard_entries 12 Derived from points, already shown.
community_notifications 11 Notifications sent to them, not actions taken.
reese_welcomes 10 Outbound automation record; belongs in an automation view.
build_intake 5 Project intake answers. Fold into the project card when someone asks.
room_booking_attendees 5 Room bookings; low signal until rooms are used more.
timeline_card_comments 3 Comments on cards. Add to the timeline when volume justifies it.
opportunity_scores 3 Sales scoring; overlaps intent, which is suppressed post-conversion.
lead_temperature_history 20 Rendered on the Notes tab via the lead components, not as its own panel.

Excluded on purpose

Table Reason
portal_handoff_tokens Auth credentials. Never render a token in an admin surface.
delivery_client_signin_tokens Same.
github_connections.access_token_encrypted Column excluded; the repo metadata is shown, the token is not.
onboarding_profiles.resume_data Raw résumé bytes. Filename and date shown instead.
*_backup_* tables Snapshots, not live records. Excluded by the audit query.
admin_users, responsible_persons Staff identity, not the person being profiled.

Empty platform-wide — nothing to show yet

Verified COUNT(*) = 0 across the whole table on 2026-09-09. A panel over these would always look broken. Re-check on the next audit.

skill_mastery · student_github_activity · student_navigation_events · delivery_engagements · delivery_projects · cohort_memberships · internship_applications · cert_responses · cert_readiness_snapshots · interview_sessions · mentor_review_items · diagnostic_attempts · project_dna · runtime_notes · artifacts · showcase_artifacts · sponsor_seats · tenant_memberships · case_study_collections · delivery_client_acceptances

Nearly empty, worth knowing: student_assessments (1), mentor_conversations (1), capstone_review_approvals (1), cert_sessions (3), requirements_generation_jobs (3).


What the three test people actually looked like

Useful as a regression fixture — if a change makes these look different, ask why.

farhat@ mungama2016@ qninying@
Enrolments 1 active 1 active + 2 withdrawn 1 active
Stage enrolled enrolled (read "lapsed" before the MAX fix) enrolled
Attendance 9 present 12 present, 1 late 8 present, 2 late, 1 absent
Cards completed 217 of 1,131 87 of 1,629 205 of 1,124
Projects 2 (Colaberry) 1 (Keysy) 2 (Oklahoma Turnpike Authority)
Case studies 1 draft — —
Capstones 1 draft 1 draft 2 draft
Account org member, invited individual individual
Subscriptions 1 active, no PaySimple 1 active, 1 failed 1 active, 13 failed, 2 cancelled

Source: SKILL.md on GitHub

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No third-party reports yet.

Signed by skilld at 7f168b8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 months ago

README badge

README badge for colaberryintern/colaberryenterprise_ai_leadershipaccelerator/person-360