# audit_2025_07_12

timestamp: 2025-07-12T22:53:49.427Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":1,"oid":null,"rows":[{"?column?":1}],"fields":[{"name":"?column?","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"?column?":null}}


timestamp: 2025-07-12T23:47:10.250Z
level: debug
metadata: {}
message:
Knex query: select "user_id", "username", "email", "email_verified", "password_hash", "password_salt", "first_name", "last_name", "phone_number", "phone_verified", "last_login", "last_login_ip", "failed_login_attempts", "timezone", "locale", "user_type", "is_active", "is_system" from "identity"."users" where "username" = $1 and "user_type" in ($2, $3) and "is_active" = $4 limit $5


timestamp: 2025-07-12T23:47:10.351Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-07-11T06:02:48.676Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-07-12T23:47:10.462Z
level: debug
metadata: {}
message:
Knex query: update "identity"."users" set "failed_login_attempts" = $1, "last_login" = $2, "last_login_ip" = $3 where "user_id" = $4


timestamp: 2025-07-12T23:47:10.584Z
level: debug
metadata: {}
message:
Knex query: select "user_roles"."role_id", "roles"."name", "roles"."code" from "core"."user_roles" inner join "core"."roles" on "roles"."role_id" = "user_roles"."role_id" where "user_roles"."user_id" = $1 and "user_roles"."is_active" = $2 and "core"."roles"."is_active" = $3


timestamp: 2025-07-12T23:47:10.692Z
level: debug
metadata: {}
message:
Knex query: select "useraccessprofile"."accessprofileid", "access_profiles"."name" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "useraccessprofile"."userid" = $1 and "access_profiles"."is_active" = $2


timestamp: 2025-07-12T23:51:53.989Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "districts"."is_active" = $1 and "master"."districts"."state_id" = $2 order by "district_name" asc


timestamp: 2025-07-12T23:51:54.417Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":6,"districtName":"Vijayawada","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":null,"headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-07-12T23:51:54.427Z
level: debug
metadata: {}
message:
Knex query: select "religion_id", "religion_name", "is_active", "description" from "master"."religions" where "is_active" = $1 order by "religion_name" asc


timestamp: 2025-07-12T23:51:54.451Z
level: debug
metadata: {}
message:
Knex query: select "caste_id", "caste_name", "is_active", "description" from "master"."castes" where "is_active" = $1 order by "caste_name" asc


timestamp: 2025-07-12T23:51:55.038Z
level: debug
metadata: {}
message:
Knex query response: [{"religionId":1,"religionName":"Hindu","isActive":true,"description":""},{"religionId":2,"religionName":"Muslim","isActive":true,"description":""}]


timestamp: 2025-07-12T23:51:55.050Z
level: debug
metadata: {}
message:
Knex query: select "sub_caste_id", "sub_caste_name", "subcastes"."caste_id", "caste_name", "subcastes"."is_active", "subcastes"."description" from "master"."subcastes" inner join "master"."castes" on "castes"."caste_id" = "subcastes"."caste_id" where "subcastes"."is_active" = $1 order by "sub_caste_name" asc


timestamp: 2025-07-12T23:51:55.068Z
level: debug
metadata: {}
message:
Knex query: select "state_id", "state_name", "state_code", "is_union_territory", "country_name", "country_code" from "master"."states" where "is_active" = $1 order by "state_name" asc


timestamp: 2025-07-12T23:51:55.410Z
level: debug
metadata: {}
message:
Knex query response: [{"subCasteId":"1","subCasteName":"OC A","casteId":1,"casteName":"OC","isActive":true,"description":null}]


timestamp: 2025-07-12T23:51:55.418Z
level: debug
metadata: {}
message:
Knex query: select "course_id", "course_name", "is_active" from "master"."edu_courses" where "is_active" = $1 order by "course_name" asc


timestamp: 2025-07-12T23:51:55.433Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-07-12T23:51:55.472Z
level: debug
metadata: {}
message:
Knex query: select "applicant_details"."application_id", "applicant_details"."application_tx_id", "applicant_details"."application_no", "applicant_details"."application_entry_type", "applicant_details"."first_name", "applicant_details"."last_name", "applicant_details"."date_of_birth", "applicant_details"."email", "applicant_details"."aadhar_no", "applicant_details"."applicant_user_id", "applicant_details"."phone_no", "applicant_details"."application_status", "applicant_details"."is_draft", "application_work_details"."department_details_id", "application_work_details"."department_details_uuid", "application_work_details"."application_uuid", "application_work_details"."department_id", "application_work_details"."recruitment_type", "application_work_details"."designation_id", "application_work_details"."joining_date", "application_work_details"."address", "application_work_details"."place_of_work", "application_work_details"."work_state_id", "application_work_details"."work_district_id", "application_work_details"."work_mandal_id", "application_work_details"."work_pin_code", "application_basic_details"."basic_details_id", "application_basic_details"."basic_details_uuid", "application_basic_details"."application_uuid", "application_basic_details"."secondary_phone_no", "application_basic_details"."secondary_email", "application_basic_details"."voter_id", "application_basic_details"."religion_id", "application_basic_details"."caste_id", "application_basic_details"."sub_caste_id", "application_basic_details"."birth_state_id", "application_basic_details"."birth_district_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_basic_details"."gender", "application_basic_details"."other_state_name", "application_basic_details"."other_district_name", "application_family_details"."family_details_id", "application_family_details"."family_details_uuid", "application_family_details"."application_uuid", "application_family_details"."father_name", "application_family_details"."father_sur_name", "application_family_details"."mother_name", "application_family_details"."mother_sur_name", "application_family_details"."guardian_name", "application_family_details"."guardian_sur_name", "application_family_details"."spouse_name", "application_family_details"."spouse_sur_name", "application_family_details"."father_nationality_id", "application_family_details"."mother_nationality_id", "application_family_details"."spouse_nationality_id", "application_family_details"."guardian_nationality_id", "application_address_details"."address_details_id", "application_address_details"."address_details_uuid", "application_address_details"."application_uuid", "application_address_details"."house_no", "application_address_details"."street_name", "application_address_details"."district_id", "application_address_details"."state_id", "application_address_details"."town_city", "application_address_details"."pin_code", "application_address_details"."police_station_id", "application_address_details"."police_station_name", "application_address_details"."is_current_is_permanent", "application_address_details"."perm_house_no", "application_address_details"."perm_street_name", "application_address_details"."perm_district_id", "application_address_details"."perm_state_id", "application_address_details"."perm_town_city", "application_address_details"."perm_pin_code", "application_address_details"."perm_police_station_id", "application_address_details"."perm_police_station_name", "application_address_details"."land_mark", "application_address_details"."perm_land_mark", "master"."employment_departments"."department_name", "master"."employment_departments"."department_email", "master"."employment_departments"."department_head_name" as "head_of_department_name", "master"."employment_departments"."department_official_phone" as "department_official_phone_no", "master"."employment_departments"."department_office_district_id", "master"."employment_departments"."department_office_state_id", "master"."employment_departments"."department_office_mandal_id", "master"."employment_departments"."department_office_location", "master"."employment_departments"."department_office_pin_code", "master"."employment_departments"."department_office_address", "master"."employment_designations"."designation_name", 1 from "verification"."applicant_details" inner join "verification"."application_work_details" on "applicant_details"."application_tx_id" = "application_work_details"."application_uuid" and "application_work_details"."is_active" = "applicant_details"."is_active" left join "verification"."application_basic_details" on "applicant_details"."application_tx_id" = "application_basic_details"."application_uuid" and "application_basic_details"."is_active" = "applicant_details"."is_active" left join "verification"."application_family_details" on "applicant_details"."application_tx_id" = "application_family_details"."application_uuid" and "application_family_details"."is_active" = "applicant_details"."is_active" left join "verification"."application_address_details" on "applicant_details"."application_tx_id" = "application_address_details"."application_uuid" and "application_address_details"."is_active" = "applicant_details"."is_active" inner join "master"."states" on "states"."state_id" = "work_state_id" inner join "master"."districts" on "districts"."district_id" = "work_district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "work_mandal_id" inner join "master"."employment_departments" on "employment_departments"."department_id" = "application_work_details"."department_id" inner join "master"."mandals" as "office_mandals" on "mandals"."mandal_id" = "master"."employment_departments"."department_office_mandal_id" inner join "master"."states" as "office_states" on "states"."state_id" = "master"."employment_departments"."department_office_state_id" inner join "master"."districts" as "office_districts" on "districts"."district_id" = "master"."employment_departments"."department_office_district_id" left join "master"."religions" on "religions"."religion_id" = "application_basic_details"."religion_id" left join "master"."castes" on "castes"."caste_id" = "application_basic_details"."caste_id" left join "master"."subcastes" on "subcastes"."sub_caste_id" = "application_basic_details"."sub_caste_id" left join "master"."countries" on "countries"."id" = "application_basic_details"."nationality_id" left join "master"."districts" as "birth_districts" on "districts"."district_id" = "birth_district_id" left join "master"."states" as "birth_states" on "states"."state_id" = "birth_state_id" left join "master"."religions" as "father_religions" on "religions"."religion_id" = "application_family_details"."father_nationality_id" left join "master"."religions" as "mother_religions" on "religions"."religion_id" = "application_family_details"."mother_nationality_id" left join "master"."religions" as "spouse_religions" on "religions"."religion_id" = "application_family_details"."spouse_nationality_id" left join "master"."religions" as "guardian_religions" on "religions"."religion_id" = "application_family_details"."guardian_nationality_id" inner join "master"."employment_designations" on "application_work_details"."designation_id" = "master"."employment_designations"."designation_uuid" where "application_no" = $1 and "application_tx_id" = $2 and "applicant_details"."is_active" = $3 group by "applicant_details"."application_id", "application_work_details"."department_details_id", "application_basic_details"."basic_details_id", "application_family_details"."family_details_id", "application_address_details"."address_details_id", "master"."employment_departments"."department_id", "master"."employment_designations"."designation_id" limit $4


timestamp: 2025-07-12T23:51:55.615Z
level: debug
metadata: {}
message:
Knex query response: [{"courseId":"1","courseName":"B.Tech","isActive":"true"},{"courseId":"2","courseName":"Intermediate","isActive":"true"}]


timestamp: 2025-07-12T23:51:55.622Z
level: debug
metadata: {}
message:
Knex query: select "application_prior_address_details"."prior_address_details_id", "application_prior_address_details"."prior_address_details_uuid", "application_prior_address_details"."application_uuid", "application_prior_address_details"."from_date", "application_prior_address_details"."to_date", "application_prior_address_details"."house_no", "application_prior_address_details"."street_name", "application_prior_address_details"."district_id", "application_prior_address_details"."state_id", "application_prior_address_details"."mandal_id", "application_prior_address_details"."town_city", "application_prior_address_details"."pin_code", "application_prior_address_details"."police_station_id", "application_prior_address_details"."police_station_name", "application_prior_address_details"."land_mark", "application_prior_address_details"."createdby", "application_prior_address_details"."createdon", "application_prior_address_details"."modifiedby", "application_prior_address_details"."modifiedon", "application_prior_address_details"."deletedby", "application_prior_address_details"."deletedon", "application_prior_address_details"."is_active", "application_prior_address_details"."is_draft", "application_prior_address_details"."address_order", "master"."districts"."district_name", "master"."mandals"."mandal_name", "master"."states"."state_name" from "verification"."application_prior_address_details" inner join "master"."districts" on "districts"."district_id" = "application_prior_address_details"."district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "application_prior_address_details"."mandal_id" inner join "master"."states" on "states"."state_id" = "application_prior_address_details"."state_id" where "application_prior_address_details"."application_uuid" = $1 and "application_prior_address_details"."is_active" = $2


timestamp: 2025-07-12T23:51:55.709Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"21","priorAddressDetailsUuid":"ff0d9a6e-5555-44b0-a2a7-1ef6ca1942c4","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-11T13:09:32.390Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-12T23:51:55.715Z
level: debug
metadata: {}
message:
Knex query: select "application_educational_details"."educational_details_id", "application_educational_details"."educational_details_uuid", "application_educational_details"."application_uuid", "application_educational_details"."course_id", "application_educational_details"."course_type_id", "application_educational_details"."institution_name", "application_educational_details"."course_specialization", "application_educational_details"."edu_start_date", "application_educational_details"."edu_end_date", "application_educational_details"."still_pursuing", "application_educational_details"."institute_address", "application_educational_details"."district_id", "application_educational_details"."state_id", "application_educational_details"."pin_code", "application_educational_details"."district_name", "application_educational_details"."town_city", "application_educational_details"."state_name", "application_educational_details"."createdby", "application_educational_details"."createdon", "application_educational_details"."modifiedby", "application_educational_details"."modifiedon", "application_educational_details"."deletedby", "application_educational_details"."deletedon", "application_educational_details"."is_active", "application_educational_details"."is_draft", "application_educational_details"."ref_doc_path", "application_educational_details"."ref_doc_name" from "verification"."application_educational_details" inner join "master"."districts" on "districts"."district_id" = "application_educational_details"."district_id" inner join "master"."states" on "states"."state_id" = "application_educational_details"."state_id" where "application_educational_details"."application_uuid" = $1 and "application_educational_details"."is_active" = $2


timestamp: 2025-07-12T23:51:55.806Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"15","educationalDetailsUuid":"dd0065a8-e6cd-42a3-a5b4-8c95bac64c68","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-11T13:09:32.492Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-12T23:51:55.810Z
level: debug
metadata: {}
message:
Knex query: select "application_prev_employment_details"."employment_details_id", "application_prev_employment_details"."employment_details_uuid", "application_prev_employment_details"."application_uuid", "application_prev_employment_details"."emp_start_date", "application_prev_employment_details"."emp_end_date", "application_prev_employment_details"."still_working", "application_prev_employment_details"."company_name", "application_prev_employment_details"."designation", "application_prev_employment_details"."company_address", "application_prev_employment_details"."reason_for_resignation", "application_prev_employment_details"."offer_letter_doc_id", "application_prev_employment_details"."exp_letter_doc_id", "application_prev_employment_details"."responsibilities", "application_prev_employment_details"."district_id", "application_prev_employment_details"."state_id", "application_prev_employment_details"."is_active", "application_prev_employment_details"."has_exp", "application_prev_employment_details"."is_draft" from "verification"."application_prev_employment_details" left join "master"."districts" on "districts"."district_id" = "application_prev_employment_details"."district_id" left join "master"."states" on "states"."state_id" = "application_prev_employment_details"."state_id" where "application_prev_employment_details"."application_uuid" = $1 and "application_prev_employment_details"."is_active" = $2 limit $3


timestamp: 2025-07-12T23:51:55.898Z
level: debug
metadata: {}
message:
Knex query response: {"employmentDetailsId":2,"employmentDetailsUuid":"13d68492-de46-4c6b-91b8-16bb4e28648b","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","empStartDate":"2025-06-01","empEndDate":"2025-06-02","stillWorking":false,"companyName":"Sample","designation":"Dev","companyAddress":"Netaji Road","reasonForResignation":"dismissed","offerLetterDocId":"","expLetterDocId":"","responsibilities":"Res","districtId":null,"stateId":null,"isActive":true,"hasExp":true,"isDraft":null}


timestamp: 2025-07-12T23:51:55.906Z
level: debug
metadata: {}
message:
Knex query: select "application_other_details"."other_details_id", "application_other_details"."question_id", "application_other_details"."question_value" as "value", "application_other_details"."question_details" as "details", "application_other_details"."other_details_uuid" from "verification"."application_other_details" where "application_other_details"."application_uuid" = $1 and "application_other_details"."is_active" = $2 order by "other_details_id" asc


timestamp: 2025-07-12T23:51:55.949Z
level: debug
metadata: {}
message:
Knex query: select "application_reference_details"."reference_details_id", "application_reference_details"."name", "application_reference_details"."address", "application_reference_details"."contact_no", "application_reference_details"."relation" from "verification"."application_reference_details" where "application_reference_details"."application_uuid" = $1 and "application_reference_details"."is_active" = $2 order by "reference_details_id" asc


timestamp: 2025-07-12T23:51:55.963Z
level: debug
metadata: {}
message:
Knex query: select "other_ack_id", "other_ack_uuid", "question", "options", "is_active", "details", "category" from "master"."applicant_other_ack" order by "other_ack_id" asc


timestamp: 2025-07-12T23:51:56.066Z
level: debug
metadata: {}
message:
Knex query response: [{"otherAckId":"1","otherAckUuid":"579f85a6-27d2-4063-83ab-6958dfa773c8","question":"Are any proceedings in respect of an offence alleged to have been committed by you pending before a criminal court in India?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"caseNumber","size":3,"type":"textfield","label":"Case Number","required":true},{"name":"caseDate","size":3,"type":"date","label":"Case Date","required":true},{"name":"caseDetails","size":12,"type":"textfield","label":"Details","required":true}]},"category":"Basic"},{"otherAckId":"2","otherAckUuid":"b7174f4e-53d7-4b3f-aa6a-45a905d352d0","question":" Has any warrant or summons for your appearance been issued and pending before a court under any law for the time being in force?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"caseNumber","size":3,"type":"textfield","label":"Case Number","required":true},{"name":"caseDate","size":3,"type":"date","label":"Case Date","required":true},{"name":"caseDetails","size":12,"type":"textfield","label":"Details","required":true}]},"category":"Basic"},{"otherAckId":"3","otherAckUuid":"ce5fa22c-12e2-4b79-b523-b1862b4a7e7b","question":" Has a warrant for your arrest been issued by a court under any law for the time being in force?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"caseNumber","size":3,"type":"textfield","label":"Case Number","required":true},{"name":"caseDate","size":3,"type":"date","label":"Case Date","required":true},{"name":"caseDetails","size":12,"type":"textfield","label":"Details","required":true}]},"category":"Basic"},{"otherAckId":"4","otherAckUuid":"1e7ab348-9b3a-449d-a967-b628c3c78b4b","question":" Has an order prohibiting your departure from India been made by any court","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"caseNumber","size":3,"type":"textfield","label":"Case Number","required":true},{"name":"caseDate","size":3,"type":"date","label":"Case Date","required":true},{"name":"caseDetails","size":12,"type":"textfield","label":"Details","required":true}]},"category":"Basic"},{"otherAckId":"5","otherAckUuid":"fcc4007f-961c-44ef-9b34-9499803e4b19","question":"Are you a member of any Political Party?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Political Party","required":true}]},"category":"Membership"},{"otherAckId":"6","otherAckUuid":"5f8bbfd6-2c74-42e4-98ea-4673e0dc1150","question":"Are you a member of any Communal Organisation?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Communal Organisation","required":true}]},"category":"Membership"},{"otherAckId":"7","otherAckUuid":"6c3c18e4-3cdd-452d-b6b5-0f36c784ca34","question":"Are you a member of any Youth Organisation?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Youth Organisation","required":true}]},"category":"Membership"},{"otherAckId":"8","otherAckUuid":"0c4e4bee-cd72-46ba-837e-cf8eb0d58ff0","question":"Are you a member of any Student Organisation?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Student Organisation","required":true}]},"category":"Membership"},{"otherAckId":"9","otherAckUuid":"efe3007f-484b-4f9a-b859-32c79eae78b3","question":"Are you a member of any Service Organisation?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Service Organisation","required":true}]},"category":"Membership"},{"otherAckId":"10","otherAckUuid":"3ccf6ad2-7afb-4020-8bcf-f06911e72d24","question":"Are you a member of any Labour Organisation?","options":["Yes","No"],"isActive":true,"details":{"no":[],"yes":[{"name":"partyName","size":12,"type":"textfield","label":"Name of Labour Organisation","required":true}]},"category":"Membership"}]


timestamp: 2025-07-12T23:52:09.182Z
level: debug
metadata: {}
message:
Knex query response: {"applicationId":"1","applicationTxId":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","applicationNo":"AR-1065481","applicationEntryType":"WEBAPP","firstName":"Srinivasa Reddy","lastName":"Alla","dateOfBirth":"1995-05-06","email":"srinireddy.alla@gmail.com","aadharNo":"547825809632","applicantUserId":"56d824c3-783a-4910-9d22-4d0b9461df64","phoneNo":"8885219211","applicationStatus":1,"isDraft":true,"departmentDetailsId":"1","departmentDetailsUuid":"783a5da4-bddd-4b7d-82b3-cd44507735ca","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","departmentId":1,"recruitmentType":1,"designationId":"9fa193d2-3b66-4fd7-9797-7bd68381c160","joiningDate":"2025-05-06","address":"BRP ROAD, BESIDE H.P.O., VIJAYAWADA, ANDHRA PRADESH - 520 001","placeOfWork":"Vijayawada","workStateId":1,"workDistrictId":1,"workMandalId":1,"workPinCode":"52007","basicDetailsId":"3","basicDetailsUuid":"bc29f219-afa1-4863-83af-8a9241aace62","secondaryPhoneNo":null,"secondaryEmail":null,"voterId":null,"religionId":1,"casteId":1,"subCasteId":1,"birthStateId":1,"birthDistrictId":6,"birthPlace":"Vijayawada","nationalityId":1,"gender":"male","otherStateName":"","otherDistrictName":"","familyDetailsId":"1","familyDetailsUuid":"63511d1f-10dc-4e80-bd96-b92286d3d3db","fatherName":"Venkata Ramana Reddy","fatherSurName":"Alla","motherName":"Venkata Ramana","motherSurName":"Alla","guardianName":null,"guardianSurName":null,"spouseName":null,"spouseSurName":null,"fatherNationalityId":1,"motherNationalityId":1,"spouseNationalityId":null,"guardianNationalityId":null,"addressDetailsId":"2","addressDetailsUuid":"45334baf-0adc-4e92-a896-bf7b60db2c47","houseNo":"74-6/7-1/13A","streetName":"Netaji Road","districtId":6,"stateId":1,"townCity":"Ayyappa Nagar","pinCode":520007,"policeStationId":null,"policeStationName":null,"isCurrentIsPermanent":true,"permHouseNo":"74-6/7-1/13A","permStreetName":"Netaji Road","permDistrictId":6,"permStateId":1,"permTownCity":"Ayyappa Nagar","permPinCode":520007,"permPoliceStationId":null,"permPoliceStationName":"","landMark":"Opposite Kanaka durga Residency","permLandMark":"Opposite Kanaka durga Residency","departmentName":"Agricultural Development","departmentEmail":"user@argi.com","headOfDepartmentName":"Dr. R. Sarada Jayalakshmi Devi","departmentOfficialPhoneNo":"1800-425-0430","departmentOfficeDistrictId":1,"departmentOfficeStateId":1,"departmentOfficeMandalId":1,"departmentOfficeLocation":"Location","departmentOfficePinCode":"520001","departmentOfficeAddress":"Address","designationName":"Designation 1","?column?":1}


timestamp: 2025-07-12T23:52:09.530Z
level: debug
metadata: {}
message:
Knex query: select "mandal_id", "mandal_name", "mandals"."district_id", "mandals"."state_id", "mandals"."is_active", "mandals"."headquarters", "mandals"."area_sq_km", "mandals"."population", "mandals"."pin_code", "mandals"."std_code", "districts"."district_name", "districts"."district_code", "states"."state_name", "states"."state_code" from "master"."mandals" inner join "master"."districts" on "districts"."district_id" = "mandals"."district_id" inner join "master"."states" on "states"."state_id" = "mandals"."state_id" order by "mandal_name" asc


timestamp: 2025-07-12T23:52:09.616Z
level: debug
metadata: {}
message:
Knex query response: [{"mandalId":4,"mandalName":"Araku Valley","districtId":2,"stateId":1,"isActive":true,"headquarters":"Araku","areaSqKm":"890.12","population":75000,"pinCode":"531149","stdCode":null,"districtName":"Northern Pines District","districtCode":"NPD02","stateName":"Andhra Pradesh","stateCode":"AP"},{"mandalId":3,"mandalName":"Bheemunipatnam","districtId":1,"stateId":1,"isActive":true,"headquarters":"Bheemunipatnam","areaSqKm":"312.45","population":95000,"pinCode":"531163","stdCode":null,"districtName":"Capital City District","districtCode":"CCD01","stateName":"Andhra Pradesh","stateCode":"AP"},{"mandalId":2,"mandalName":"Gajuwaka","districtId":1,"stateId":1,"isActive":true,"headquarters":"Gajuwaka","areaSqKm":"198.34","population":220000,"pinCode":"530026","stdCode":null,"districtName":"Capital City District","districtCode":"CCD01","stateName":"Andhra Pradesh","stateCode":"AP"},{"mandalId":5,"mandalName":"Paderu","districtId":2,"stateId":1,"isActive":true,"headquarters":"Paderu","areaSqKm":"1200.45","population":85000,"pinCode":"531024","stdCode":null,"districtName":"Northern Pines District","districtCode":"NPD02","stateName":"Andhra Pradesh","stateCode":"AP"},{"mandalId":1,"mandalName":"Visakhapatnam Rural","districtId":1,"stateId":1,"isActive":true,"headquarters":"Anakapalle","areaSqKm":"245.67","population":185000,"pinCode":"531001","stdCode":null,"districtName":"Capital City District","districtCode":"CCD01","stateName":"Andhra Pradesh","stateCode":"AP"}]


timestamp: 2025-07-12T23:52:10.015Z
level: debug
metadata: {}
message:
Knex query: select "designation_id", "designation_uuid", "designation_name", "employment_department_id", "employment_designations"."is_active", "employment_departments"."department_name" from "master"."employment_designations" inner join "master"."employment_departments" on "employment_departments"."department_id" = "employment_designations"."employment_department_id" where "employment_designations"."is_active" = $1 and "master"."employment_designations"."employment_department_id" = $2 order by "designation_name" asc


timestamp: 2025-07-12T23:52:10.115Z
level: debug
metadata: {}
message:
Knex query response: [{"designationId":"1","designationUuid":"9fa193d2-3b66-4fd7-9797-7bd68381c160","designationName":"Designation 1","employmentDepartmentId":1,"isActive":true,"departmentName":"Agricultural Development"}]


timestamp: 2025-07-13T00:12:38.738Z
level: debug
metadata: {}
message:
Knex query: update "verification"."application_prior_address_details" set "is_active" = $1 where "application_prior_address_details"."application_uuid" = $2 and "application_prior_address_details"."is_active" = $3


timestamp: 2025-07-13T00:12:38.837Z
level: debug
metadata: {}
message:
Knex query: update "verification"."application_educational_details" set "is_active" = $1 where "application_educational_details"."application_uuid" = $2 and "application_educational_details"."is_active" = $3


timestamp: 2025-07-13T00:12:38.930Z
level: debug
metadata: {}
message:
Knex query: update "verification"."application_reference_details" set "is_active" = $1 where "application_reference_details"."application_uuid" = $2 and "application_reference_details"."is_active" = $3


timestamp: 2025-07-13T00:12:39.027Z
level: debug
metadata: {}
message:
Knex query: update "verification"."application_other_details" set "is_active" = $1 where "application_other_details"."application_uuid" = $2 and "application_other_details"."is_active" = $3


timestamp: 2025-07-13T00:12:39.125Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_basic_details" ("application_uuid", "basic_details_uuid", "birth_district_id", "birth_place", "birth_state_id", "caste_id", "gender", "is_active", "nationality_id", "other_district_name", "other_state_name", "religion_id", "secondary_email", "secondary_phone_no", "sub_caste_id", "voter_id") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) on conflict ("basic_details_uuid") do update set "application_uuid" = excluded."application_uuid", "basic_details_uuid" = excluded."basic_details_uuid", "birth_district_id" = excluded."birth_district_id", "birth_place" = excluded."birth_place", "birth_state_id" = excluded."birth_state_id", "caste_id" = excluded."caste_id", "gender" = excluded."gender", "is_active" = excluded."is_active", "nationality_id" = excluded."nationality_id", "other_district_name" = excluded."other_district_name", "other_state_name" = excluded."other_state_name", "religion_id" = excluded."religion_id", "secondary_email" = excluded."secondary_email", "secondary_phone_no" = excluded."secondary_phone_no", "sub_caste_id" = excluded."sub_caste_id", "voter_id" = excluded."voter_id"


timestamp: 2025-07-13T00:12:39.209Z
level: debug
metadata: {}
message:
Knex query response: {"command":"INSERT","rowCount":1,"oid":0,"rows":[],"fields":[],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":null}


timestamp: 2025-07-13T00:12:39.221Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_family_details" ("application_uuid", "family_details_uuid", "father_name", "father_nationality_id", "father_sur_name", "guardian_name", "guardian_nationality_id", "guardian_sur_name", "mother_name", "mother_nationality_id", "mother_sur_name", "spouse_name", "spouse_nationality_id", "spouse_sur_name") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) on conflict ("family_details_uuid") do update set "application_uuid" = excluded."application_uuid", "family_details_uuid" = excluded."family_details_uuid", "father_name" = excluded."father_name", "father_nationality_id" = excluded."father_nationality_id", "father_sur_name" = excluded."father_sur_name", "guardian_name" = excluded."guardian_name", "guardian_nationality_id" = excluded."guardian_nationality_id", "guardian_sur_name" = excluded."guardian_sur_name", "mother_name" = excluded."mother_name", "mother_nationality_id" = excluded."mother_nationality_id", "mother_sur_name" = excluded."mother_sur_name", "spouse_name" = excluded."spouse_name", "spouse_nationality_id" = excluded."spouse_nationality_id", "spouse_sur_name" = excluded."spouse_sur_name"


timestamp: 2025-07-13T00:12:39.317Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_address_details" ("address_details_uuid", "application_uuid", "district_id", "house_no", "is_current_is_permanent", "land_mark", "perm_district_id", "perm_house_no", "perm_land_mark", "perm_pin_code", "perm_police_station_id", "perm_police_station_name", "perm_state_id", "perm_street_name", "perm_town_city", "pin_code", "police_station_id", "police_station_name", "state_id", "street_name", "town_city") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) on conflict ("address_details_uuid") do update set "address_details_uuid" = excluded."address_details_uuid", "application_uuid" = excluded."application_uuid", "district_id" = excluded."district_id", "house_no" = excluded."house_no", "is_current_is_permanent" = excluded."is_current_is_permanent", "land_mark" = excluded."land_mark", "perm_district_id" = excluded."perm_district_id", "perm_house_no" = excluded."perm_house_no", "perm_land_mark" = excluded."perm_land_mark", "perm_pin_code" = excluded."perm_pin_code", "perm_police_station_id" = excluded."perm_police_station_id", "perm_police_station_name" = excluded."perm_police_station_name", "perm_state_id" = excluded."perm_state_id", "perm_street_name" = excluded."perm_street_name", "perm_town_city" = excluded."perm_town_city", "pin_code" = excluded."pin_code", "police_station_id" = excluded."police_station_id", "police_station_name" = excluded."police_station_name", "state_id" = excluded."state_id", "street_name" = excluded."street_name", "town_city" = excluded."town_city"


timestamp: 2025-07-13T00:12:39.416Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_prior_address_details" ("application_uuid", "district_id", "district_name", "from_date", "house_no", "land_mark", "mandal_id", "mandal_name", "pin_code", "police_station_id", "police_station_name", "prior_address_details_uuid", "state_id", "street_name", "to_date", "town_city") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16)


timestamp: 2025-07-13T00:12:39.506Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_educational_details" ("application_uuid", "course_id", "course_specialization", "course_type_id", "district_id", "district_name", "edu_end_date", "edu_start_date", "educational_details_uuid", "institute_address", "institution_name", "is_active", "pin_code", "ref_doc_name", "ref_doc_path", "state_id", "state_name", "still_pursuing", "town_city") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19)


timestamp: 2025-07-13T00:12:39.598Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_other_details" ("application_uuid", "is_active", "is_draft", "other_details_uuid", "question_details", "question_id", "question_value") values ($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)


timestamp: 2025-07-13T00:12:39.686Z
level: debug
metadata: {}
message:
Knex query response: {"command":"INSERT","rowCount":10,"oid":0,"rows":[],"fields":[],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":null}


timestamp: 2025-07-13T00:12:39.691Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_prev_employment_details" ("application_uuid", "company_address", "company_name", "designation", "district_id", "emp_end_date", "emp_start_date", "employment_details_uuid", "exp_letter_doc_id", "has_exp", "is_active", "offer_letter_doc_id", "reason_for_resignation", "responsibilities", "state_id", "still_working") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) on conflict ("employment_details_uuid") do update set "application_uuid" = excluded."application_uuid", "company_address" = excluded."company_address", "company_name" = excluded."company_name", "designation" = excluded."designation", "district_id" = excluded."district_id", "emp_end_date" = excluded."emp_end_date", "emp_start_date" = excluded."emp_start_date", "employment_details_uuid" = excluded."employment_details_uuid", "exp_letter_doc_id" = excluded."exp_letter_doc_id", "has_exp" = excluded."has_exp", "is_active" = excluded."is_active", "offer_letter_doc_id" = excluded."offer_letter_doc_id", "reason_for_resignation" = excluded."reason_for_resignation", "responsibilities" = excluded."responsibilities", "state_id" = excluded."state_id", "still_working" = excluded."still_working"


timestamp: 2025-07-13T00:13:38.710Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"22","priorAddressDetailsUuid":"ec30ed5a-1a12-46ee-86b2-153b05e3486a","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:12:39.468Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:13:38.803Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"16","educationalDetailsUuid":"41872219-0940-4bb7-bde3-b2649a7cecd2","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:12:39.558Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:13:38.896Z
level: debug
metadata: {}
message:
Knex query response: {"employmentDetailsId":1,"employmentDetailsUuid":"5b57235b-2cf0-4ae1-909e-37d797ef2382","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","empStartDate":"2025-06-01","empEndDate":"2025-06-02","stillWorking":false,"companyName":"Sample","designation":"Dev","companyAddress":"Netaji Road","reasonForResignation":"dismissed","offerLetterDocId":"","expLetterDocId":"","responsibilities":"Res","districtId":null,"stateId":null,"isActive":true,"hasExp":true,"isDraft":null}


timestamp: 2025-07-13T00:13:38.983Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":61,"questionId":"1","value":"no","details":{},"otherDetailsUuid":"08a1695d-eb72-4056-a089-24293b1edd6b"},{"otherDetailsId":62,"questionId":"2","value":"no","details":{},"otherDetailsUuid":"4dda208e-8c59-4082-9739-5e986f863f04"},{"otherDetailsId":63,"questionId":"3","value":"no","details":{},"otherDetailsUuid":"8a96ff3b-2ebb-4f79-a2d2-d5cc5ec97208"},{"otherDetailsId":64,"questionId":"4","value":"no","details":{},"otherDetailsUuid":"51b8d8fc-25d6-4deb-9a4e-4ee470e7a1d7"},{"otherDetailsId":65,"questionId":"5","value":"no","details":{},"otherDetailsUuid":"182e891b-68c9-4fff-9fbc-cdc59c89f9bd"},{"otherDetailsId":66,"questionId":"6","value":"no","details":{},"otherDetailsUuid":"639a46a6-9b3b-4f22-bee6-074fb30e3411"},{"otherDetailsId":67,"questionId":"7","value":"no","details":{},"otherDetailsUuid":"39c216d8-c166-4ae3-8afb-b0e954e8af4e"},{"otherDetailsId":68,"questionId":"8","value":"no","details":{},"otherDetailsUuid":"91439bf6-2f99-456d-8233-8b1f590b676c"},{"otherDetailsId":69,"questionId":"9","value":"no","details":{},"otherDetailsUuid":"c49f1ce8-dd3c-40ac-99cb-d9b05deaeb99"},{"otherDetailsId":70,"questionId":"10","value":"no","details":{},"otherDetailsUuid":"6aa2b35d-3a51-4633-b741-a4682fd20db8"}]


timestamp: 2025-07-13T00:14:01.981Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_other_details" ("application_uuid", "is_active", "is_draft", "other_details_uuid", "question_details", "question_id", "question_value") values ($1, $2, $3, $4, $5, DEFAULT, $6), ($7, $8, $9, $10, $11, DEFAULT, $12), ($13, $14, $15, $16, $17, DEFAULT, $18), ($19, $20, $21, $22, $23, DEFAULT, $24), ($25, $26, $27, $28, $29, DEFAULT, $30), ($31, $32, $33, $34, $35, DEFAULT, $36), ($37, $38, $39, $40, $41, DEFAULT, $42), ($43, $44, $45, $46, $47, DEFAULT, $48), ($49, $50, $51, $52, $53, DEFAULT, $54), ($55, $56, $57, $58, $59, $60, $61)


timestamp: 2025-07-13T00:17:51.773Z
level: debug
metadata: {}
message:
Knex query: select "application_other_details"."other_details_id", "application_other_details"."question_id" as "question_ack_id", "application_other_details"."question_value" as "value", "application_other_details"."question_details" as "details", "application_other_details"."other_details_uuid" from "verification"."application_other_details" where "application_other_details"."application_uuid" = $1 and "application_other_details"."is_active" = $2 order by "other_details_id" asc


timestamp: 2025-07-13T00:17:51.835Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"23","priorAddressDetailsUuid":"9edaa4f8-fb45-4c1b-aa38-364c1810603a","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:14:01.840Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:17:51.852Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"17","educationalDetailsUuid":"e8ded8fb-511d-45e7-8d70-7a22741903a3","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:14:01.940Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:18:07.307Z
level: error
metadata: {}
message:
Knex query error: insert into "verification"."application_basic_details" ("application_uuid", "basic_details_uuid", "birth_district_id", "birth_place", "birth_state_id", "caste_id", "gender", "is_active", "nationality_id", "other_district_name", "other_state_name", "religion_id", "secondary_email", "secondary_phone_no", "sub_caste_id", "voter_id") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) on conflict ("basic_details_uuid") do update set "application_uuid" = excluded."application_uuid", "basic_details_uuid" = excluded."basic_details_uuid", "birth_district_id" = excluded."birth_district_id", "birth_place" = excluded."birth_place", "birth_state_id" = excluded."birth_state_id", "caste_id" = excluded."caste_id", "gender" = excluded."gender", "is_active" = excluded."is_active", "nationality_id" = excluded."nationality_id", "other_district_name" = excluded."other_district_name", "other_state_name" = excluded."other_state_name", "religion_id" = excluded."religion_id", "secondary_email" = excluded."secondary_email", "secondary_phone_no" = excluded."secondary_phone_no", "sub_caste_id" = excluded."sub_caste_id", "voter_id" = excluded."voter_id" - invalid input syntax for type integer: ""


timestamp: 2025-07-13T00:42:55.532Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"23","priorAddressDetailsUuid":"9edaa4f8-fb45-4c1b-aa38-364c1810603a","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:14:01.840Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"22","priorAddressDetailsUuid":"ec30ed5a-1a12-46ee-86b2-153b05e3486a","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:12:39.468Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:43:35.168Z
level: debug
metadata: {}
message:
Knex query: insert into "verification"."application_prior_address_details" ("application_uuid", "district_id", "district_name", "from_date", "house_no", "land_mark", "mandal_id", "mandal_name", "pin_code", "police_station_id", "police_station_name", "prior_address_details_uuid", "state_id", "street_name", "to_date", "town_city") values ($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)


timestamp: 2025-07-13T00:43:35.251Z
level: debug
metadata: {}
message:
Knex query response: {"command":"INSERT","rowCount":2,"oid":0,"rows":[],"fields":[],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":null}


timestamp: 2025-07-13T00:44:39.847Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"27","priorAddressDetailsUuid":"cf2d68e9-7d6d-42a7-94ee-5f243d1b9664","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:44:23.819Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"26","priorAddressDetailsUuid":"4314b60e-9694-4bcf-a119-a246aa138463","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:44:23.819Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:44:39.868Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"18","educationalDetailsUuid":"9228e694-d3e9-4270-b2bf-bd2d79aface2","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:44:23.918Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:44:39.902Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":81,"questionId":"1","value":"no","details":{},"otherDetailsUuid":"8c371c39-9e48-4a68-b3ad-1d62954835a6"},{"otherDetailsId":82,"questionId":"2","value":"no","details":{},"otherDetailsUuid":"f8ca68ea-41d8-42c1-806c-47c5f5eb9215"},{"otherDetailsId":83,"questionId":"3","value":"no","details":{},"otherDetailsUuid":"beac6b83-7235-46ed-b5e8-784e9135c7d0"},{"otherDetailsId":84,"questionId":"4","value":"no","details":{},"otherDetailsUuid":"821032ed-05db-4ac2-b79b-b7e8568c7e5e"},{"otherDetailsId":85,"questionId":"5","value":"no","details":{},"otherDetailsUuid":"98ec1dbf-c7e9-46b0-8680-5acd0bc27efc"},{"otherDetailsId":86,"questionId":"6","value":"no","details":{},"otherDetailsUuid":"e11bb1c7-7bfe-4d7c-bd1c-5cddd4f574af"},{"otherDetailsId":87,"questionId":"7","value":"no","details":{},"otherDetailsUuid":"9d8f0602-0f5c-4848-a01b-2ba909d8778f"},{"otherDetailsId":88,"questionId":"8","value":"no","details":{},"otherDetailsUuid":"0407770f-cd56-4bec-98d1-0ed93901848e"},{"otherDetailsId":89,"questionId":"9","value":"no","details":{},"otherDetailsUuid":"66b02e50-aa2d-4c81-b04e-661955af982d"},{"otherDetailsId":90,"questionId":"10","value":"no","details":{},"otherDetailsUuid":"c3ab2faa-f00e-44e4-b82e-fe04cf85ff9f"}]


timestamp: 2025-07-13T00:48:59.222Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"29","priorAddressDetailsUuid":"5cafa42e-1992-4e95-98f5-a3af05fb87ef","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:47:52.324Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"28","priorAddressDetailsUuid":"644b27fc-4115-4ec6-a73f-60ffd45df492","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:47:52.324Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:48:59.236Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"19","educationalDetailsUuid":"2bddbe86-dbf3-4adc-b0b6-8c72c6d961b8","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:47:52.410Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:48:59.269Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":81,"questionAckId":"1","value":"no","details":{},"otherDetailsUuid":"8c371c39-9e48-4a68-b3ad-1d62954835a6"},{"otherDetailsId":82,"questionAckId":"2","value":"no","details":{},"otherDetailsUuid":"f8ca68ea-41d8-42c1-806c-47c5f5eb9215"},{"otherDetailsId":83,"questionAckId":"3","value":"no","details":{},"otherDetailsUuid":"beac6b83-7235-46ed-b5e8-784e9135c7d0"},{"otherDetailsId":84,"questionAckId":"4","value":"no","details":{},"otherDetailsUuid":"821032ed-05db-4ac2-b79b-b7e8568c7e5e"},{"otherDetailsId":85,"questionAckId":"5","value":"no","details":{},"otherDetailsUuid":"98ec1dbf-c7e9-46b0-8680-5acd0bc27efc"},{"otherDetailsId":86,"questionAckId":"6","value":"no","details":{},"otherDetailsUuid":"e11bb1c7-7bfe-4d7c-bd1c-5cddd4f574af"},{"otherDetailsId":87,"questionAckId":"7","value":"no","details":{},"otherDetailsUuid":"9d8f0602-0f5c-4848-a01b-2ba909d8778f"},{"otherDetailsId":88,"questionAckId":"8","value":"no","details":{},"otherDetailsUuid":"0407770f-cd56-4bec-98d1-0ed93901848e"},{"otherDetailsId":89,"questionAckId":"9","value":"no","details":{},"otherDetailsUuid":"66b02e50-aa2d-4c81-b04e-661955af982d"},{"otherDetailsId":90,"questionAckId":"10","value":"no","details":{},"otherDetailsUuid":"c3ab2faa-f00e-44e4-b82e-fe04cf85ff9f"}]


timestamp: 2025-07-13T00:49:36.973Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"31","priorAddressDetailsUuid":"efb3d1ad-b01f-4c05-b456-ac974f135284","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:49:22.881Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"30","priorAddressDetailsUuid":"211a7e8c-83fd-4e61-a1c1-a704d4f1353d","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:49:22.881Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:49:37.060Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"20","educationalDetailsUuid":"c996ea48-520e-4646-ab24-bfc2b55eb47c","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:49:22.972Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:49:37.238Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":101,"questionAckId":"1","value":"no","details":{},"otherDetailsUuid":"567b00ac-7b73-4090-9c94-23f202f2730d"},{"otherDetailsId":102,"questionAckId":"2","value":"no","details":{},"otherDetailsUuid":"0ffb8926-18e9-4225-bbd8-acd971dba2ce"},{"otherDetailsId":103,"questionAckId":"3","value":"no","details":{},"otherDetailsUuid":"06c332b6-f13d-426d-8067-d804b7c3c9fc"},{"otherDetailsId":104,"questionAckId":"4","value":"no","details":{},"otherDetailsUuid":"6554242d-3a51-42c6-8733-1a07d1e14402"},{"otherDetailsId":105,"questionAckId":"5","value":"no","details":{},"otherDetailsUuid":"5b9d2a7b-2908-4bbf-a32a-a4d9f00556db"},{"otherDetailsId":106,"questionAckId":"6","value":"no","details":{},"otherDetailsUuid":"b1f3fd5b-13b3-4060-807f-bb85cf37bebc"},{"otherDetailsId":107,"questionAckId":"7","value":"no","details":{},"otherDetailsUuid":"43db2817-33bd-4aac-bb53-031198581f61"},{"otherDetailsId":108,"questionAckId":"8","value":"no","details":{},"otherDetailsUuid":"b3c7d0ec-6349-4d24-9402-32fe16f7bda8"},{"otherDetailsId":109,"questionAckId":"9","value":"no","details":{},"otherDetailsUuid":"efc0e5ce-6265-458a-97d7-0b8841bd71e6"},{"otherDetailsId":110,"questionAckId":"10","value":"yes","details":{"partyName":"Sample"},"otherDetailsUuid":"4b844e58-3867-432f-8f5e-cd363f5e535f"}]


timestamp: 2025-07-13T00:50:46.150Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"33","priorAddressDetailsUuid":"8924d211-073d-4ee9-be20-25e439806545","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:50:36.802Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"32","priorAddressDetailsUuid":"d56d5272-9c8b-47a8-9e61-182a56484a93","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:50:36.802Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:50:46.239Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"21","educationalDetailsUuid":"3704048f-0ec8-4f8c-b232-36b40a383fe1","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:50:36.906Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:50:46.414Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":111,"questionAckId":"1","value":"yes","details":{"caseDate":"2025-07-01T07:00:00.000Z","caseNumber":"1234","caseDetails":"Test"},"otherDetailsUuid":"f6496402-6099-4487-af97-66b962c2e09a"},{"otherDetailsId":112,"questionAckId":"2","value":"no","details":{},"otherDetailsUuid":"43e6c22e-92f9-4b63-927a-952d07987924"},{"otherDetailsId":113,"questionAckId":"3","value":"no","details":{},"otherDetailsUuid":"f9f6e07b-81ec-4feb-90d5-0d74c72af4f5"},{"otherDetailsId":114,"questionAckId":"4","value":"no","details":{},"otherDetailsUuid":"353d79e9-b852-425c-b711-6e107c0858ed"},{"otherDetailsId":115,"questionAckId":"5","value":"no","details":{},"otherDetailsUuid":"7a399e82-79b3-42bb-ae6c-111434589198"},{"otherDetailsId":116,"questionAckId":"6","value":"no","details":{},"otherDetailsUuid":"22cf67c6-fd9c-4b4c-a541-5476c0f0eba2"},{"otherDetailsId":117,"questionAckId":"7","value":"no","details":{},"otherDetailsUuid":"5baae4f4-b9dd-4ef1-8906-91b2f3053bad"},{"otherDetailsId":118,"questionAckId":"8","value":"no","details":{},"otherDetailsUuid":"99ae5be3-40bc-4524-9043-d2ac2909cfa1"},{"otherDetailsId":119,"questionAckId":"9","value":"no","details":{},"otherDetailsUuid":"13967a9c-7de7-40f7-bdb9-47a6a378f778"},{"otherDetailsId":120,"questionAckId":"10","value":"yes","details":{"partyName":"Sample"},"otherDetailsUuid":"74cd8b86-425d-46e4-b225-3466a78b92ed"}]


timestamp: 2025-07-13T00:51:18.997Z
level: debug
metadata: {}
message:
Knex query response: [{"priorAddressDetailsId":"35","priorAddressDetailsUuid":"0fac0ab0-1073-4ca5-95dc-d0aaf2fef00e","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:51:10.513Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"},{"priorAddressDetailsId":"34","priorAddressDetailsUuid":"608219f7-53fb-4ccc-b1f8-192ae70d0221","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","fromDate":"2009-05-06","toDate":"2025-06-02","houseNo":"74-6","streetName":"Netaji Road","districtId":6,"stateId":1,"mandalId":3,"townCity":"Vijayawada","pinCode":520007,"policeStationId":2,"policeStationName":"test2","landMark":"","createdby":"system","createdon":"2025-07-13T07:51:10.513Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"addressOrder":null,"districtName":"Vijayawada","mandalName":"Bheemunipatnam","stateName":"Andhra Pradesh"}]


timestamp: 2025-07-13T00:51:19.094Z
level: debug
metadata: {}
message:
Knex query response: [{"educationalDetailsId":"22","educationalDetailsUuid":"4ed25a88-1ddb-4a3e-9a87-ba6287bccf03","applicationUuid":"8f0aa2f5-2f7b-4f85-a1d7-403982aa780f","courseId":2,"courseTypeId":1,"institutionName":"MVR","courseSpecialization":"ECE","eduStartDate":"2016-06-01","eduEndDate":"2018-06-05","stillPursuing":false,"instituteAddress":"Address","districtId":6,"stateId":1,"pinCode":520007,"districtName":"","townCity":"Beza","stateName":"","createdby":"system","createdon":"2025-07-13T07:51:10.606Z","modifiedby":null,"modifiedon":null,"deletedby":null,"deletedon":null,"isActive":true,"isDraft":null,"refDocPath":"","refDocName":""}]


timestamp: 2025-07-13T00:51:19.282Z
level: debug
metadata: {}
message:
Knex query response: [{"otherDetailsId":121,"questionAckId":"1","value":"yes","details":{"caseDate":"2025-05-14T07:00:00.000Z","caseNumber":"1234","caseDetails":"Test"},"otherDetailsUuid":"dd25746b-0d40-4324-80c8-c59e71094668"},{"otherDetailsId":122,"questionAckId":"2","value":"no","details":{},"otherDetailsUuid":"e1eb2e6f-552e-4e3c-887b-a5c9ca4b3082"},{"otherDetailsId":123,"questionAckId":"3","value":"no","details":{},"otherDetailsUuid":"b343ae62-abf6-4800-b76e-f93942641eea"},{"otherDetailsId":124,"questionAckId":"4","value":"no","details":{},"otherDetailsUuid":"2430cfee-e709-410e-9953-fa0f70174a3b"},{"otherDetailsId":125,"questionAckId":"5","value":"no","details":{},"otherDetailsUuid":"6e93bfe5-dea3-4727-99a4-b1107e7c5dfe"},{"otherDetailsId":126,"questionAckId":"6","value":"no","details":{},"otherDetailsUuid":"53180c40-ee40-447a-af9e-e306976f4705"},{"otherDetailsId":127,"questionAckId":"7","value":"no","details":{},"otherDetailsUuid":"e1f44453-2df6-46dd-9c37-cf5e4d60f84a"},{"otherDetailsId":128,"questionAckId":"8","value":"no","details":{},"otherDetailsUuid":"6ba738b4-4b4e-47fc-94a9-fa9306668633"},{"otherDetailsId":129,"questionAckId":"9","value":"no","details":{},"otherDetailsUuid":"4d5aa17b-2e27-4431-a461-eaccc98faf45"},{"otherDetailsId":130,"questionAckId":"10","value":"yes","details":{"partyName":"Sample"},"otherDetailsUuid":"dc6d269b-fd7b-4a50-a99f-506ebbe6976e"}]


