All files / src/domains/recruitment/schemas applications-pipelines.schema.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { Prop, Schema, SchemaFactory } from '@nestjs/mongoose';
import { Document, Schema as MongooseSchema } from 'mongoose';
 
@Schema({ timestamps: true, collection: 'job_applications' })
export class JobApplication extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'Candidate', index: true })
  candidateId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'JobPosting', index: true })
  jobPostingId: string;
 
  @Prop({ default: 'submitted', enum: ['submitted', 'acknowledged', 'screening', 'recruiter_review', 'hiring_manager_review', 'shortlisted', 'assessment', 'interview', 'background_check', 'offer', 'hired', 'rejected', 'withdrawn', 'on_hold', 'talent_pool', 'archived'] })
  status: string;
 
  @Prop()
  currentStageId?: string;
 
  @Prop({ default: 0 })
  rating: number; // Candidate rating 1-5
 
  @Prop()
  source?: string; // 'Careers Page' | 'Referral' | 'Agency'
 
  @Prop()
  rejectionReason?: string;
 
  @Prop()
  withdrawalReason?: string;
 
  @Prop()
  dispositionCode?: string;
 
  @Prop()
  appliedAt: Date;
}
 
export const JobApplicationSchema = SchemaFactory.createForClass(JobApplication);
JobApplicationSchema.index({ tenantId: 1, candidateId: 1, jobPostingId: 1 }, { unique: true });
 
@Schema({ timestamps: true, collection: 'application_answers' })
export class ApplicationAnswer extends Document {
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'JobApplication' })
  applicationId: string;
 
  @Prop({ required: true })
  questionText: string;
 
  @Prop({ required: true })
  answerText: string;
}
 
export const ApplicationAnswerSchema = SchemaFactory.createForClass(ApplicationAnswer);
 
@Schema({ timestamps: true, collection: 'hiring_pipelines' })
export class HiringPipeline extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true })
  pipelineName: string;
 
  @Prop({ default: true })
  isDefault: boolean;
}
 
export const HiringPipelineSchema = SchemaFactory.createForClass(HiringPipeline);
 
@Schema({ timestamps: true, collection: 'hiring_stages' })
export class HiringStage extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'HiringPipeline' })
  pipelineId: string;
 
  @Prop({ required: true })
  stageName: string;
 
  @Prop({ required: true })
  sequence: number;
 
  @Prop({ default: 1440 }) // Default 24 hours (in minutes) SLA
  slaMinutes: number;
 
  @Prop({ default: false })
  requiresApproval: boolean;
}
 
export const HiringStageSchema = SchemaFactory.createForClass(HiringStage);
HiringStageSchema.index({ tenantId: 1, pipelineId: 1, sequence: 1 });
 
@Schema({ timestamps: true, collection: 'application_stage_instances' })
export class ApplicationStageInstance extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'JobApplication' })
  applicationId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'HiringStage' })
  stageId: string;
 
  @Prop({ required: true })
  enteredAt: Date;
 
  @Prop()
  exitedAt?: Date;
 
  @Prop({ default: 'active', enum: ['active', 'completed', 'bypassed', 'rolled_back'] })
  status: string;
}
 
export const ApplicationStageInstanceSchema = SchemaFactory.createForClass(ApplicationStageInstance);
ApplicationStageInstanceSchema.index({ tenantId: 1, applicationId: 1, stageId: 1 });