Master Sheet | SVIN<>Integration Checks Mapping.xlsx

	A	B	C	D
1	Candidate Details	Mandatory / Optional	Value Type	Predefined Values
2	Full name	Mandatory	String	-
3	Email Address	Mandatory/Optional	Email	Based on Configuration by the Client's team
4	Mobile Number	Mandatory/Optional	Phone	Based on Configuration by the Client's team
5	Gender	Optional	String	Based on Configuration by the Client's team
6	Employee ID	Optional	String	-
7	Universal Account Number(UAN)	Optional	Numeric	-
8	Resume - preferrably from the employer for CV analysis	Optional	Document	Based on Configuration by the Client's team
9	DOB	Mandatory	String	Format YYYY-MM-DD
10	Father's name	Mandatory	String	-
11	Employment Check / Reference Check
12	Company Name	Mandatory	String
13	Employee ID	Mandatory	String	-
14	Location - City	Mandatory	String	-
15	Designation	Mandatory	String	-
16	Date of Joining	Mandatory	Date	-
17	Last Working Date	Mandatory	Date	-
18	Currently Working?	Mandatory	Boolean	-
19	Reason for leaving	Optional	String	-
20	Employment Proof Document Type	Mandatory	Pre-defined Options	"offer_letter","appointment_letter","payslip","resignation_acceptance_letter","relieving_letter","experience_letter","full_and_final_settlement_document","internship_experience_letter","internship_offer_letter","employment_agreement","contract_completion","termination_letter","others"
21	Employment Proof Document	Mandatory	URL	-
22	HR Details	-	-	-
23	Name	Mandatory	String	-
24	Email	Optional	Email	-
25	Phone number	Optional	Phone	-
26	Manager Details	-	-	-
27	Full name	Mandatory	String	-
28	Email	Optional	Email	Mandatory if reference check is selected with the Package
29	Phone number	Optional	Phone	Mandatory if reference check is selected with the Package
30	Education Check
31	Course Type - 10th / 12th / Graduation / PG / Diploma / Doctorate / Others	Mandatory	Pre-defined Options	"10", "12", "UNDERGRAD", "POSTGRAD", "PHD", "OTHER"
32	Attendance Type - Full time / Part time / Distance	Mandatory	Pre-defined Options	"Full Time", "Part Time", "Distance"
33	University / Board	Mandatory	String	-
34	College / Institution / School	Mandatory	String	-
35	Registration Number	Mandatory	String	-
36	Degree	Optional	String	-
37	Specialization	Optional	String	-
38	Date of Joining	Mandatory	Date	-
39	Date of Completion	Mandatory	Date	-
40	Education proof Document Type	Mandatory	Pre-defined Options	"degree_certificate","grade_sheet","consolidated_marksheet","provisional_certificate","others"
41	Education proof Document	Mandatory	URL	-
42	Address Check/ Court check
43	Address Type	Mandatory	String	Permanent or Current
44	Permanent Address (complete address with Door # / House Name)	Mandatory	String	-
45	Residence Type	Mandatory	String	"Rented", "Own / Parents"
46	Landmark	Mandatory	String	-
47	Pincode	Mandatory	Number	-
48	Country	Mandatory	String	-
49	City	Mandatory	String	-
50	State	Mandatory	String	-
51	How long have you stayed here?	Mandatory	Pre-defined Options	"Under 6 months", "6 months to 1 year", "1 year", "2 years", "3 years", "More than 3 years"
52	Is this also your current address?	Mandatory	Boolean	-
53	Will you be available at the same address between 9am to 5pm?	Mandatory	Alphanumeric	-
54	Alt. Contact Name	Conditional	String	-
55	Alt. Contact Phone	Conditional	Phone	-
56	Alt. Contact Relationship	Conditional	Pre-defined Options	-
57	Document Type	Mandatory	Pre-defined Options	"rental_agreement","sale_deed","gas_bill","electricity_bill","internet_bill","telephone_bill","water_bill","aadhaar","driving_license","voter_id","passport","ration_card","credit_card_statement","bank_passbook","vehicle_registration_certificate","society_maintenance_bill","rent_receipts","affidavit","others"
58	Document Proof	Mandatory	URL	-
59	Identity
60	ID Document Type	Mandatory	Pre-defined Options	"PAN","Driving License","Voter ID","Aadhaar","Passport"
61	ID Proof: PAN / Voter ID / DL Passport	Mandatory	URL	-
62	ID Number	Mandatory	String	-
63	Package Information
64	Package Identifiers	Mandatory		Package Information field is required to assign BGV package to the Candidate Profile while BGV Initation
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