04pallav
9/13/2017 - 9:59 PM

land_zn schema

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