How to populate Gap records in teradata sql query

Database

How to populate Gap records in teradata sql query

Hi All,

Can anyone suggest me to write a sql to populate gap reacords as per the below requirement.

I tried with recursive query but it didn't  work.

Here in my source date ,Enrolled and On-Hold Statuses are available and have gaps in the active enrollment period between statuses,then it is required to pupulate the status/record  for missing months until next available enrolled/On-Hold status record is available. 

Selection criteria is :  processed date between jan2015 and dec2015.

Source table as below

PID Enrolled Date Status Processed date

1234 01/27/2015 Enrolled Jan-2015

1234 01/27/2015 On-Hold April-2015

1234 01/27/2015 Enrolled July-2015

Desired Output  as below:

PID Enrolled Date Status Processed date

1234 01/27/2015 Enrolled Jan-2015

1234 01/27/2015 Enrolled Feb-2015  

1234 01/27/2015 Enrolled March-2015 

1234 01/27/2015 On-Hold April-2015

1234 01/27/2015 On-Hold May-2015 

1234 01/27/2015 On-Hold June-2015 

1234 01/27/2015 Enrolled July-2015

1234 01/27/2015 Enrolled Aug-2015  

1234 01/27/2015 Enrolled sept-2015  

1234 01/27/2015 Enrolled Oct-2015  

1234 01/27/2015 Enrolled Nov-2015  

1234 01/27/2015 Enrolled Dec-2015