land_zn schema
################## remedy_tickets
case_id -- id for the ticet
category -- category of ticket uman resources or payroll
type --- categorises tickets further into different categories Payroll, Termintion etc
item --- description of ticket
case when datediff('minutes', rt.create_date, rt.resolved_date) < 10 and resolved_by = submitted_by then 'call' else 'ticket' end as call_or_ticket ### nice logic for call or ticket
################## remedy_audittrail
case_id -- same as above
audit_eid -- another id
type ---- various types. weant only type 10 ? why ?
to_string ---- to field in the email??
modified_date
create_date
Domains :: Data Management, Exits, Internal Transfers, NA, Onboarding, Payroll, Timekeeping