AdministrationData Model
Every data type and its fields. Related types are joined one-to-many.
Relationships
Requisitionone-to-manyApplicantsjoined by requisition_id Requisitionone-to-manyCampaignsjoined by requisition_id Recruiterone-to-manyRequisitionsjoined by recruiting team Prospectone-to-manyApplicantjoined by conversion Core identification| requisition_id | uuid | 9fa59627-fb7a-4d5a-871e-4cf1af29e19c |
| title | text | Senior Product Designer |
| internalTitle | text | Senior Product Designer (DSN) |
| jobCode | text | DSN-1000 |
| status | select | Open |
| reqType | select | New |
| confidential | boolean | Yes |
| postInternally | boolean | Yes |
| postExternally | boolean | No |
Organization and location| company | select | Cintoso, Inc. |
| businessUnit | select | Product |
| department | select | Design |
| location | tags | Remote — US||New York, NY |
| remoteType | select | In Office |
| timeZone | select | ET |
Position and headcount| positionId | text | POS-2000 |
| openings | number | 1 |
| headcountType | select | Budgeted |
| replacing | text | — |
| startDate | date | 01/01/26 |
| opened | date | 01/01/26 |
| endDate | date | 12/01/26 |
Job classification| jobFamily | select | Design |
| jobLevel | select | IC2 |
| employmentType | select | Full-time |
| regularTemp | select | Temporary |
| flsa | select | Non-exempt |
| eeoCategory | select | Professionals |
| weeklyHours | number | 40 |
Compensation| payMin | currency | 90000 |
| payMax | currency | 130000 |
| payFrequency | select | Salaried |
| currency | select | USD |
| bonusEligible | boolean | Yes |
| equityEligible | boolean | Yes |
| budgetedSalary | currency | 110000 |
Recruiting team| recruiters | people | Dana Lopez||Maya Chen |
| sourcers | people | Bianca Reyes |
| coordinators | people | Lena Novak |
Hiring team| hiringManagers | people | Sam Patel||Noah West |
| interviewers | people | Alex Kim||Cory Yang||Ivy Brooks |
| approvers | people | Sam Patel||Omar Farah |
Job content| body | richtext | <h3>About the role</h3><p>We are hiring … |
| responsibilities | richtext | <ul><li>Own key initiatives within Desig… |
| requiredQualifications | richtext | <ul><li>Relevant experience in a similar… |
| preferredQualifications | richtext | <ul><li>Experience in a fast-growing com… |
| screeningQuestions | textarea | Are you authorized to work in the postin… |
| skills | tags | Figma||User research||Visual design |
Posting| jobBoards | tags | LinkedIn||Glassdoor |
| postingStart | date | 01/01/26 |
| postingEnd | date | 12/01/26 |
| autoRepost | boolean | Yes |
| applyUrl | readonly | https://jobs.hisci.com/DSN-1000 |
Compliance and metadata| payTransparency | textarea | The pay range reflects the base salary f… |
| visaSponsorship | boolean | Yes |
| createdBy | readonly | Dana Lopez |
| createdDate | readonly | 01/01/26 |
| modifiedBy | readonly | Alex Kim |
| modifiedDate | readonly | 06/16/26 |
| Field | Type | Example |
|---|
| applicant_id | uuid | 02dc38ef-afa4-4182-3c6f-a2f9b35a7004 |
| name | text | Jordan Lee |
| email | email | jordan.lee0@example.com |
| score | number | 13 |
| scoreBand | text | 0–39 |
| requisition | text | Senior Product Designer |
| company | text | Northwind |
| experience | number | 1 |
| otherRoles | number | 1 |
| otherRoleTitles | text | Design Systems Lead |
| stage | text | Applied |
| status | text | Active |
| applied | date | 01/01/26 |
| appliedBand | date | Earlier |
| recruiter | person | Dana Lopez |
| Field | Type | Example |
|---|
| prospect_id | uuid | 6612dbb7-63ce-45aa-f1c0-f901b78afe6c |
| name | text | Jordan Lee |
| email | email | jordan.lee0@example.com |
| title | text | Senior Product Designer |
| company | text | Northwind |
| experience | number | 1 |
| source | text | LinkedIn |
| stage | text | Sourced |
| owner | person | Dana Lopez |
| added | date | 01/01/26 |
| Field | Type | Example |
|---|
| campaign_id | uuid | c9497e7f-17f7-49d2-a712-4f09bbbb8cd4 |
| name | text | Senior Product Designer outreach |
| channel | text | Email |
| status | text | Active |
| audience | number | 20 |
| replies | number | 0 |
| owner | person | Dana Lopez |
| created | date | 01/01/26 |
HiSci