asked on
display data from previous rows
i have a result set from an existing Oracle View attached with the question. i need to add 2 more columns to this view.
here is the brief business logic for those 2 dates
Service date: this is typically the hire_date, if a person is terminated and rehired within 12 months then its Service date is retained but if a person is rehired after 12 months of termination then its rehire_date is the Service_date
term service date: if a person is rehired after 12 months of termination then its previous hire date is the term service date
i am trying to write a logic something like
case when prev_endofday_status = 'TF' and hire_flag = 1 and hire_code = 'REHIRE' and add_months(term_date, 12) < hire_date then....??
test-data.xlsx
here is the brief business logic for those 2 dates
Service date: this is typically the hire_date, if a person is terminated and rehired within 12 months then its Service date is retained but if a person is rehired after 12 months of termination then its rehire_date is the Service_date
term service date: if a person is rehired after 12 months of termination then its previous hire date is the term service date
i am trying to write a logic something like
case when prev_endofday_status = 'TF' and hire_flag = 1 and hire_code = 'REHIRE' and add_months(term_date, 12) < hire_date then....??
test-data.xlsx
Oracle Database
Last Comment
Jayesh Acharya
what should your spreadsheet look like with the 2 new columns added?
odd data, that employee got hired multiple times on the same date
that's probably why you can't get it to work
that's probably why you can't get it to work
ASKER
Attached is the spreadsheet with the 2 new columns.
And I should take back the logic i wrote for the new date columns,
Service date: this is the hire_date!
term service date: if a person is rehired after 12 months of termination then its previous hire date is the term service date
test-data.xlsx
And I should take back the logic i wrote for the new date columns,
Service date: this is the hire_date!
term service date: if a person is rehired after 12 months of termination then its previous hire date is the term service date
test-data.xlsx
your data doesn't make sense !
column B and M both have the title hire_date
and you indicate service date is the hire date
leave out all the columns which are not used for this problem
it just confuses
column B and M both have the title hire_date
and you indicate service date is the hire date
leave out all the columns which are not used for this problem
it just confuses
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.