[Effective Date] between Start Date? and End Date?
[Effective Date] = Start Date?
[Employee Number] = '07515'
[Employee Status Code] = 'T'
[Effective Date] between '01-01-2019' and current_date
[Effective Date] = maximum( [Effective Date] for [Employee Number] )
[Company Code] in Company Code?
[Location Code] in Location Code?