1id: tblNffrMY4phfCfGwkQ
2name: "@ATS"
3fieldVersionSum: 698
4fields:
5 - name: identifier
6 id: fldeq2xiO1NZFeHwe1f
7 type: formula
8 - name: name
9 id: fldkTKdhsxewVxPvC6x
10 type: rollup
11 - name: status
12 id: fldm06BBFZaOa8pNKcR
13 type: singleSelect
14 choices:
15 - "00: Rejected"
16 - "20: Applied"
17 - "30: Pre-submitted"
18 - "31: Submitted"
19 - "50: Pre-assessment"
20 - "51: 1st Interview"
21 - "52: 2nd Interview"
22 - "53: 3rd+ Interview"
23 - "54: Final Assessment"
24 - "50: Recruiter Pre-Screen"
25 - "51: Peer Screen"
26 - "52: Hiring Manager Screen"
27 - "53: Pre-Screen Assessment"
28 - "54: On Site Interview"
29 - "90: Offered"
30 - "91: Hired"
31 - "92: Hire Started"
32 - "93: Hire Confirmed"
33 - "51: Preliminary Phone Screen"
34 - "53: Phone Interview"
35 - "52: Hiring Manager Review"
36 - name: submittedToClientAt
37 id: fldXHFHQadAoPopbZ2v
38 type: date
39 - name: lastStatusChangeAt
40 id: fldIoaLcrk2mDvLcYNb
41 type: date
42 - name: // AC-Log
43 id: fldsxg4U1sfmpmEX6sT
44 type: longText
45 - name: preSubmittedBy
46 id: fldK3w3oN7LBcY9Hjly
47 type: user
48 - name: submittedToClientBy
49 id: fldmX0fbFXSXtOkkZCL
50 type: user
51 - name: preSubmittedAt
52 id: fldrJ6cMUhGBOqU1hxv
53 type: date
54 - name: salaryCurrency
55 id: fld8Hj2BsFtuvr5QZEh
56 type: singleSelect
57 choices:
58 - HKD
59 - USD
60 - SGD
61 - CNY
62 - TWD
63 - EUR
64 - GBP
65 - AUD
66 - CAD
67 - JPY
68 - TWD [Airtable choice 9]
69 - name: salaryExpected
70 id: flddOsxhs9ThJ2ohDeJ
71 type: number
72 - name: salaryPeriod
73 id: flddKNO755ENJEWJ0sI
74 type: singleSelect
75 choices:
76 - Yearly
77 - Monthly
78 - Hourly
79 - name: numInterviewsReceived
80 id: fldDJxJ2qeHJgmM49CJ
81 type: number
82 - name: // createdAt
83 id: fldiECjOPyxXEdmveJd
84 type: createdTime
85 - name: rejectReason
86 id: fld0t27H37JNm6uk3XW
87 type: singleSelect
88 choices:
89 - Candidate Withdrew
90 - Job Closed
91 - Technically Unfit
92 - Culturally Unfit
93 - Offer Declined
94 - Filled by Competitor
95 - Left During Probation
96 - Already Applied
97 - Fired During Probation
98 - No Response from Client
99 - Client Rejected Without Feedback
100 - name: recruiterPitch
101 id: fldWtEfjTwmNuQzxkmI
102 type: longText
103 - name: clientOpenedAt
104 id: fldChLIOidXMMV20AvK
105 type: date
106 - name: clientDecidedAt
107 id: fldEKodTCX61oNc8z4j
108 type: date
109 - name: clientChoice
110 id: fldlw0LODwpJ1XhpMBJ
111 type: singleSelect
112 choices:
113 - Reject
114 - Hold
115 - Schedule
116 - Wait
117 - name: clientNotes
118 id: fld8ZKpok0HccJLmHrp
119 type: longText
120 - name: jobOfferedAt
121 id: fldwvvQfCwgsiTNIlvm
122 type: date
123 - name: jobSignedAt
124 id: fld7QKP87pGXzSe0xgM
125 type: date
126 - name: user_id
127 id: fldI7XhVeW4UDCqNOHd
128 type: rollup
129 - name: companyIdentifier
130 id: fldZbXKapZ4RVNnrKfF
131 type: rollup
132 - name: jobIdentifier
133 id: fldsSDJzld2eRtZ3e7Z
134 type: singleLineText
135 - name: submitMessageId
136 id: fldnQEFcL6pQySuUkli
137 type: singleLineText
138 - name: submitSubject
139 id: fldl5YjoRi6hCjWrXQ9
140 type: singleLineText
141 - name: submitRecipients
142 id: fldizENTOSbTvhM9Fpz
143 type: longText
144 - name: linkedin_id
145 id: fldFfBhsTq9HbiONG44
146 type: rollup
147 - name: clientNextSteps
148 id: fldI4xVRjHoKaLkQyYM
149 type: singleSelect
150 choices:
151 - Candidate does not fit the role
152 - Candidate is too junior/senior
153 - No interest in candidate
154 - Would like to clarify some details of the candidate
155 - Candidate does not fit what we have in mind
156 - Already have someone promising in the process
157 - Call
158 - Meeting
159 - Other
160 - name: jobStartsAt
161 id: fld0ddW7TL5erX6mokd
162 type: date
163 - name: offeredJobTitle
164 id: fldZrfn8HvvjuUFGls1
165 type: singleLineText
166 - name: // candidateFullName
167 id: fldq5Vl4gsI3fu1s8tW
168 type: rollup
169 - name: // candidateAddress
170 id: fldDe9S30btMnWx58Fg
171 type: rollup
172 - name: employmentAddress
173 id: fldxnwxc19HVq6zJm7L
174 type: longText
175 - name: employerName
176 id: fldFk22VhJqkvans3aV
177 type: singleLineText
178 - name: invoiceCurrency
179 id: fldAYq4Qj1qM7q3YyPa
180 type: singleSelect
181 choices:
182 - HKD
183 - USD
184 - SGD
185 - CNY
186 - GBP
187 - TWD
188 - name: invoiceDueDate
189 id: fldFtaXIxQNzR9DfXXS
190 type: date
191 - name: collectedAmount
192 id: fldlhMSf62aDQJQuGNx
193 type: number
194 - name: probationEndsAt
195 id: fldYGsSUOOkBscV2bbg
196 type: date
197 - name: invoiceDate
198 id: fld7TX7e170OCJHdjpP
199 type: date
200 - name: // candidateIdDocumentNumber
201 id: fldrdD9kZUs7icfFpb1
202 type: rollup
203 - name: // candidatePassportAuthority
204 id: fldYq3AQY48mGnQP0Kn
205 type: rollup
206 - name: recruiterNotes
207 id: fldeLRpBJuiLkIe6odd
208 type: longText
209 - name: lastInterviewAt
210 id: fldYiZWHGpi52uH4MGV
211 type: date
212 - name: jobTitle
213 id: fldWFogQGyBAUMJP77A
214 type: singleLineText
215 - name: rejectedAt
216 id: fldhRs1rZrMoWNpa4tO
217 type: date
218 - name: employmentType
219 id: fld0jVoXxSOkVTgRnlK
220 type: singleSelect
221 choices:
222 - Full-Time
223 - Part-Time
224 - Internship
225 - name: salaryOffered
226 id: fldV1tTmnqUTyPmUHTd
227 type: number
228 - name: salaryAccepted
229 id: fldGgXVpDClnmN59QPe
230 type: number
231 - name: hideSalary
232 id: fldbnnyeDqsPj45dphH
233 type: checkbox
234 - name: hideEmail
235 id: fldLbPjVloFXgJTkOlM
236 type: checkbox
237 - name: hideTel
238 id: fld7EcrWrXJrnRHIfRR
239 type: checkbox
240 - name: collectedAt
241 id: fldx7G9qFBV1TWfmg6E
242 type: date
243 - name: refundedAmount
244 id: fldmftbmqzRhYgpv1aK
245 type: number
246 - name: dealValue
247 id: fldd6diXS36ETuEtAIA
248 type: number
249 - name: "# job company"
250 id: fldKxu2J9pPJUT7heEn
251 type: formula
252 - name: // company auth0
253 id: fldMDHij0FOtE2wp2VM
254 type: link
255 linksTo: "@Auth0"
256 - name: updatedTime
257 id: fldIlHB2PEfkB9MI9O3
258 type: lastModifiedTime
259 - name: interviewStatuses
260 id: fld3rI7dx3muXjkL2qt
261 type: longText
262 - name: isBlind
263 id: fldKAX1dL0ilPlmqilv
264 type: checkbox
265 - name: nextSteps
266 id: fldYSsT4lqukhly2Q1x
267 type: longText
268 - name: invoiceAmount
269 id: flduHmsdtMfAnEStjiB
270 type: number
271 - name: invoiceNumber
272 id: fld2agsylUIXq2vZMt8
273 type: singleLineText
274 - name: nextInterviewAt
275 id: fldeJCwMy23MdJNDbZK
276 type: date
277 - name: visaStatus
278 id: fldgV21Fod4U2yCzI5W
279 type: singleSelect
280 choices:
281 - No visa required
282 - Dependant visa
283 - Visa transfer
284 - New visa
285 - N/A - Remote work
286 - name: relocationStatus
287 id: fldJXIqCAk7FSvHOJMy
288 type: singleSelect
289 choices:
290 - No relocation
291 - Different city
292 - Different country
293 - name: appliedAt
294 id: fldcjlsk6e5Kj0bXm5G
295 type: date
296 - name: placementLikelihood
297 id: fldncgUDUEkJhg0g2Eb
298 type: number
299 - name: locationAccepted
300 id: fldenmRX0Qzd8PL9Drx
301 type: singleSelect
302 choices:
303 - HK
304 - CN
305 - TW
306 - SG
307 - UK
308 - XR
309 - name: // roleName
310 id: fld7ch0SP250KI98HVo
311 type: singleLineText
312 - name: // status.updatedBy
313 id: fldSQG0jxVg85u3Aupm
314 type: singleLineText
315 - name: // @Applicant
316 id: fld1oCGYGFfrXFrwaOB
317 type: link
318 linksTo: "@Applicant"
319 - name: statusBeforeReject
320 id: fldwIiajNlt1vMDUxCc
321 type: singleLineText
322 - name: // @Applicant.repAgreement
323 id: fldYtcbWqmlK2ovrtKJ
324 type: attachment
325 - name: rejectDetail
326 id: fldNoDv9BbNmQiS1avS
327 type: singleLineText
328 - name: // AC Payment Reminded Time
329 id: fldmtuTQ8FvT5AIm7h3
330 type: date
331 - name: // AC-Flag-NewStarterGiftPackage
332 id: fldEpfMyzAyKbnQ3PjB
333 type: singleSelect
334 choices:
335 - purchased
336 - ignored
337 - name: recruiterPitchForCandidate
338 id: fldpoFu2PnN5nlpz0nv
339 type: longText
340 - name: // Company:interviewProcess
341 id: fld958JZAYsJtzzemeq
342 type: rollup
343 - name: // AC-Log-