Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
2.5 kB
5
Indexable
Never
INSERT INTO hobs_ods_staging.hos_event_log_by_businesskeys
 hosel_event_value            | createUser
 hosel_event_date             | 2024-01-04 14:29:29.957000+0530
 hosel_event_seq              | 92096e58-aadf-11ee-b515-0017a477741a
 hosel_bu_id                  | BUNEW11
 hosel_date                   | 2024-01-04
 hosel_enriched_data          | {'@referredType': 'individual', 'buID': 'BUNEW11', 'currency': 'INR', 'emailID': 'tester11@gmail.com', 'eventDateTime': '2024-01-04T08:59:29.957381+00:00', 'eventID': '92096e58-aadf-11ee-b515-0017a477741a', 'firstName': 'tester11', 'language': 'English', 'lastName': 'tester11', 'opID': 'OPNEW11', 'phoneNumber': '1231207711', 'postalAddress': '{''city'': ''Chennai'', ''country'': ''India'', ''postcode'': ''600096'', ''stateOrProvince'': ''Taramani'', ''street1'': ''12th Floor, B Wing'', ''street2'': ''Tidel''}', 'requestedRole': '[{''action'': ''add'', ''id'': ''BILLMGM'', ''name'': ''Billing Management''}]', 'role': 'Director', 'startDate': '2024-01-04T08:59:29.957381+00:00', 'title': 'Mr', 'userID': 'tester11'}
 hosel_entity_enriched_data   | null
 hosel_entity_enricher_status | null
 hosel_entity_staging_status  | null
 hosel_event_clv_attr_status  | null
 hosel_event_clv_status       | null
 hosel_event_clv_value_status | null
 hosel_event_data             | {"userName": "tester11", "tradingName": "Tata Consultancy Services", "name": "OPNEW11", "nameType": "BUNEW11", "relatedParty": [{"title": "Mr", "firstName": "tester11", "lastName": "tester11", "role": "Director", "@referredType": "individual", "language": "English", "currency": "INR"}], "contactMedium": [{"preferred": "false", "mediumType": "email", "characteristic": "tester11@gmail.com"}, {"preferred": "true", "mediumType": "contact", "characteristic": "1231207711"}, {"preferred": "false", "mediumType": "postalAddress", "characteristic": [{"city": "Chennai", "country": "India", "postcode": "600096", "stateOrProvince": "Taramani", "street1": "12th Floor, B Wing", "street2": "Tidel"}]}], "engagedPartyRole": [{"action": "add", "id": "BILLMGM", "name": "Billing Management"}]}
 hosel_event_status           | {'details': '[{"validation": "success"},{"scheduler": "success"},{"userCreation": "success"},{"tenantCreation": "success"}]', 'overallStatus': 'success'}
 hosel_event_type             | createUser
 hosel_op_id                  | OPNEW11
 hosel_trigged_by             | null
 hosel_triggered_by           | multiTenantJob


Leave a Comment