# audit_2025_05_31

timestamp: 2025-05-31T07:02:05.162Z
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-05-31T07:02:20.272Z
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-05-31T07:02:20.439Z
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-10T07:00:00.000Z","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-05-31T07:02:20.458Z
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", "date(application_work_details"."joining_date)" as "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_village_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_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "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"."mandal_id", "application_address_details"."village_name", "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_mandal_id", "application_address_details"."perm_village_name", "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_lannd_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"."villages" on "villages"."village_id" = "work_village_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_distrcit_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-05-31T07:02:20.608Z
level: error
metadata: {}
message:
Knex query error: 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", "date(application_work_details"."joining_date)" as "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_village_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_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "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"."mandal_id", "application_address_details"."village_name", "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_mandal_id", "application_address_details"."perm_village_name", "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_lannd_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"."villages" on "villages"."village_id" = "work_village_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_distrcit_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 - missing FROM-clause entry for table "date(application_work_details"


timestamp: 2025-05-31T07:02:20.643Z
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"."village_name", "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-05-31T07:02:20.714Z
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", "application_educational_details"."institution_name", "application_educational_details"."course_specialization", "application_educational_details"."start_date", "application_educational_details"."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"."mandal_id", "application_educational_details"."pin_code", "application_educational_details"."district_name", "application_educational_details"."mandal_name", "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_id" from "verification"."application_educational_details" inner join "master"."districts" on "districts"."district_id" = "application_educational_details"."district_id" inner join "master"."mandals" on "mandals"."mandal_id" = "application_educational_details"."mandal_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-05-31T07:02:20.774Z
level: debug
metadata: {}
message:
Knex query: select "application_employment_details"."employment_details_id", "application_employment_details"."employment_details_uuid", "application_employment_details"."application_uuid", "application_employment_details"."start_date", "application_employment_details"."end_date", "application_employment_details"."still_working", "application_employment_details"."company_name", "application_employment_details"."designation", "application_employment_details"."address", "application_employment_details"."reason_for_resignation", "application_employment_details"."offer_letter_doc_id", "application_employment_details"."exp_letter_doc_id", "application_employment_details"."is_active", "application_employment_details"."is_draft" from "verification"."application_employment_details" where "application_employment_details"."application_uuid" = $1 and "application_employment_details"."is_active" = $2


timestamp: 2025-05-31T07:03:25.272Z
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_village_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_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "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"."mandal_id", "application_address_details"."village_name", "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_mandal_id", "application_address_details"."perm_village_name", "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_lannd_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"."villages" on "villages"."village_id" = "work_village_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_distrcit_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-05-31T07:03:25.368Z
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-06T07:00:00.000Z","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":null,"departmentId":1,"recruitmentType":1,"designationId":"9fa193d2-3b66-4fd7-9797-7bd68381c160","joiningDate":"2025-05-06T07:00:00.000Z","address":"BRP ROAD, BESIDE H.P.O., VIJAYAWADA, ANDHRA PRADESH - 520 001","placeOfWork":"Vijayawada","workStateId":1,"workDistrictId":1,"workMandalId":1,"workVillageId":1,"workPinCode":"52007","basicDetailsId":null,"basicDetailsUuid":null,"secondaryPhoneNo":null,"secondaryEmail":null,"voterId":null,"religionId":null,"casteId":null,"subCasteId":null,"birthStateId":null,"birthDistrcitId":null,"birthPlace":null,"nationalityId":null,"familyDetailsId":null,"familyDetailsUuid":null,"fatherName":null,"fatherSurName":null,"motherName":null,"motherSurName":null,"guardianName":null,"guardianSurName":null,"spouseName":null,"spouseSurName":null,"fatherNationalityId":null,"motherNationalityId":null,"spouseNationalityId":null,"guardianNationalityId":null,"addressDetailsId":null,"addressDetailsUuid":null,"houseNo":null,"streetName":null,"districtId":null,"stateId":null,"mandalId":null,"villageName":null,"pinCode":null,"policeStationId":null,"policeStationName":null,"isCurrentIsPermanent":null,"permHouseNo":null,"permStreetName":null,"permDistrictId":null,"permStateId":null,"permMandalId":null,"permVillageName":null,"permPinCode":null,"permPoliceStationId":null,"permPoliceStationName":null,"landMark":null,"permLanndMark":null,"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-05-31T07:03:29.356Z
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-05-31T07:03:29.466Z
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-05-31T07:03:29.473Z
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-05-31T07:03:29.525Z
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-05-31T09:45:12.513Z
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-05-31T09:45:12.595Z
level: error
metadata: {}
message:
Knex query error: select "religion_id", "religion_name", "is_active", "description" from "master"."religions" where "is_active" = $1 order by "religion_name" asc - column "is_active" does not exist


timestamp: 2025-05-31T09:49:53.751Z
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-05-31T09:53:23.605Z
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-05-31T09:53:23.663Z
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-05-31T05:14:04.844Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-31T09:53:23.819Z
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-05-31T09:53:23.893Z
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-05-31T09:53:23.903Z
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-05-31T09:54:20.475Z
level: debug
metadata: {}
message:
Knex query response: [{"religionId":1,"religionName":"Hindu","isActive":true,"description":""},{"religionId":2,"religionName":"Muslim","isActive":true,"description":""}]


timestamp: 2025-05-31T16:05:02.985Z
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-05-31T09:53:23.814Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-31T16:11:56.142Z
level: error
metadata: {}
message:
Knex query error: 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 - Connection terminated unexpectedly


timestamp: 2025-05-31T18:24:59.711Z
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-05-31T18:24:59.762Z
level: error
metadata: {}
message:
Knex query error: 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 - operator does not exist: bigint = uuid


timestamp: 2025-05-31T18:34:33.928Z
level: debug
metadata: {}
message:
Knex query response: [{"subCasteId":"1","subCasteName":"OC A","casteId":1,"casteName":"OC","isActive":true,"description":null}]


timestamp: 2025-05-31T19:16:55.880Z
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-05-31T19:16:55.940Z
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":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-31T23:36:27.384Z
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-05-31T16:05:03.122Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-06-01T00:12:31.493Z
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 order by "district_name" asc


timestamp: 2025-06-01T00:12:31.550Z
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-10T07:00:00.000Z","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":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","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-06-01T02:10:04.780Z
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_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "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"."mandal_id", "application_address_details"."village_name", "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_mandal_id", "application_address_details"."perm_village_name", "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_lannd_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_distrcit_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-06-01T02:10:04.870Z
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-06T07:00:00.000Z","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":null,"departmentId":1,"recruitmentType":1,"designationId":"9fa193d2-3b66-4fd7-9797-7bd68381c160","joiningDate":"2025-05-06T07:00:00.000Z","address":"BRP ROAD, BESIDE H.P.O., VIJAYAWADA, ANDHRA PRADESH - 520 001","placeOfWork":"Vijayawada","workStateId":1,"workDistrictId":1,"workMandalId":1,"workPinCode":"52007","basicDetailsId":null,"basicDetailsUuid":null,"secondaryPhoneNo":null,"secondaryEmail":null,"voterId":null,"religionId":null,"casteId":null,"subCasteId":null,"birthStateId":null,"birthDistrcitId":null,"birthPlace":null,"nationalityId":null,"familyDetailsId":null,"familyDetailsUuid":null,"fatherName":null,"fatherSurName":null,"motherName":null,"motherSurName":null,"guardianName":null,"guardianSurName":null,"spouseName":null,"spouseSurName":null,"fatherNationalityId":null,"motherNationalityId":null,"spouseNationalityId":null,"guardianNationalityId":null,"addressDetailsId":null,"addressDetailsUuid":null,"houseNo":null,"streetName":null,"districtId":null,"stateId":null,"mandalId":null,"villageName":null,"pinCode":null,"policeStationId":null,"policeStationName":null,"isCurrentIsPermanent":null,"permHouseNo":null,"permStreetName":null,"permDistrictId":null,"permStateId":null,"permMandalId":null,"permVillageName":null,"permPinCode":null,"permPoliceStationId":null,"permPoliceStationName":null,"landMark":null,"permLanndMark":null,"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-06-01T02:32:33.999Z
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-06-01T02:32:34.017Z
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_distrcit_id", "application_basic_details"."birth_place", "application_basic_details"."nationality_id", "application_basic_details"."gender", "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"."mandal_id", "application_address_details"."village_name", "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_mandal_id", "application_address_details"."perm_village_name", "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_lannd_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_distrcit_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-06-01T02:32:34.113Z
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":null,"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":null,"basicDetailsUuid":null,"secondaryPhoneNo":null,"secondaryEmail":null,"voterId":null,"religionId":null,"casteId":null,"subCasteId":null,"birthStateId":null,"birthDistrcitId":null,"birthPlace":null,"nationalityId":null,"gender":null,"familyDetailsId":null,"familyDetailsUuid":null,"fatherName":null,"fatherSurName":null,"motherName":null,"motherSurName":null,"guardianName":null,"guardianSurName":null,"spouseName":null,"spouseSurName":null,"fatherNationalityId":null,"motherNationalityId":null,"spouseNationalityId":null,"guardianNationalityId":null,"addressDetailsId":null,"addressDetailsUuid":null,"houseNo":null,"streetName":null,"districtId":null,"stateId":null,"mandalId":null,"villageName":null,"pinCode":null,"policeStationId":null,"policeStationName":null,"isCurrentIsPermanent":null,"permHouseNo":null,"permStreetName":null,"permDistrictId":null,"permStateId":null,"permMandalId":null,"permVillageName":null,"permPinCode":null,"permPoliceStationId":null,"permPoliceStationName":null,"landMark":null,"permLanndMark":null,"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-06-01T05:38:57.233Z
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":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","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-06-01T05:59:58.307Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"}]


