-------- Default Value Script -----------------

Insert into TA_TBL_EmailScripts values (19,'<html>  <body direction="<<ltr_rtl>>">  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 700px;" bordercolor="#666666">      <tr bgcolor="#003466">      <td colspan="2" style="height: 25px;">        <b><span class="Header" style="color:white;">&nbsp;<<lblCompressedWorkHoursSanctionForm>></span></b>      </td>    </tr>      <tr>      <td style="width: 30%; height: 25px;"><b><font face="Arial" size="2"><<lblemployeeid>></font></b></td>      <td style="width: 70%; height: 25px;"><font face="Arial" size="2">&nbsp;<<employeeid>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblemployeename>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<employeename>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblapplicationdate>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<applicationdate>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblCompressedWorkHours>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<CompressedWorkHours>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblScheduleStartDate>></font></b></td>      <td>        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 100%;">          <tr>            <td style="width: 50%; height: 25px;"><font face="Arial" size="2">&nbsp;<<ScheduleStartDate>></font></td>            <td style="width: 25%; height: 25px; border-left: 1px solid #666666;"><b><font face="Arial" size="2">&nbsp;<<lblScheduleEndDate>></font></b></td>            <td style="height: 25px; border-left: 1px solid #666666;"><font face="Arial" size="2">&nbsp;<<ScheduleEndDate>></font></td>          </tr>        </table>      </td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblreason>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<reason>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblStatus>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Status>></font></td>    </tr>    </table>   <a href=<<LinkData>>><font face="Arial" size="2">Click here for approval</font></a>    </body>  </html>','CompressedWorkHoursApproval')


Insert into TA_TBL_EmailScripts values (20,'<html>  <body direction="<<ltr_rtl>>">  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 700px;" bordercolor="#666666">      <tr bgcolor="#003466">      <td colspan="2" style="height: 25px;">        <b><span class="Header" style="color:white;">&nbsp;<<lblCompressedWorkHoursSanctionForm>></span></b>      </td>    </tr>      <tr>      <td style="width: 30%; height: 25px;"><b><font face="Arial" size="2"><<lblemployeeid>></font></b></td>      <td style="width: 70%; height: 25px;"><font face="Arial" size="2">&nbsp;<<employeeid>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblemployeename>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<employeename>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblapplicationdate>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<applicationdate>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblCompressedWorkHours>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<CompressedWorkHours>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblScheduleStartDate>></font></b></td>      <td>        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 100%;">          <tr>            <td style="width: 50%; height: 25px;"><font face="Arial" size="2">&nbsp;<<ScheduleStartDate>></font></td>            <td style="width: 20%; height: 25px; border-left: 1px solid #666666;"><b><font face="Arial" size="2"><<lblScheduleEndDate>></font></b></td>            <td style="height: 25px; border-left: 1px solid #666666;"><font face="Arial" size="2">&nbsp;<<ScheduleEndDate>></font></td>          </tr>        </table>      </td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblStatus>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Status>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblreason>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<reason>></font></td>    </tr>    </table>  <a href=<<LinkData>>><font face="Arial" size="2">Click here for approval</font></a>  </body>  </html>','CompressedWorkHoursMail')


Insert into TA_TBL_EmailScripts values (21,'<html>  <body direction="<<ltr_rtl>>">  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 700px;" bordercolor="#666666">      <tr bgcolor="#003466">      <td colspan="2" style="height: 25px;">        <b><span class="Header" style="color:white;">&nbsp;<<lblCompressedWorkHoursSanctionForm>></span></b>      </td>    </tr>      <tr>      <td style="width: 30%; height: 25px;"><b><font face="Arial" size="2"><<lblemployeeid>></font></b></td>      <td style="width: 70%; height: 25px;"><font face="Arial" size="2">&nbsp;<<employeeid>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblemployeename>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<employeename>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblapplicationdate>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<applicationdate>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblCompressedWorkHours>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<CompressedWorkHours>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblScheduleStartDate>></font></b></td>      <td>        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 100%;">          <tr>            <td style="width: 50%; height: 25px;"><font face="Arial" size="2">&nbsp;<<ScheduleStartDate>></font></td>            <td style="width: 20%; height: 25px; border-left: 1px solid #666666;"><b><font face="Arial" size="2"><<lblScheduleEndDate>></font></b></td>            <td style="height: 25px; border-left: 1px solid #666666;"><font face="Arial" size="2">&nbsp;<<ScheduleEndDate>></font></td>          </tr>        </table>      </td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblStatus>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Status>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblreason>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<reason>></font></td>    </tr>      <tr>      <td style="height: 25px;"><b><font face="Arial" size="2"><<lblRemark>></font></b></td>      <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Remark>></font></td>    </tr>    </table>  </body>  </html>','CompressedWorkHoursApprovalStatus')

Insert into TA_TBL_EmailScripts values (22,'<html>    <body direction="<<ltr_rtl>>">      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 700px;" bordercolor="#666666">          <tr bgcolor="#003466">          <td colspan="2" style="height: 25px;">            <b><span class="Header" style="color:white;">&nbsp;<<lblCompressedWorkHoursSanctionForm>></span></b>          </td>        </tr>          <tr>          <td style="width: 30%; height: 25px;"><b><font face="Arial" size="2"><<lblemployeeid>></font></b></td>          <td style="width: 70%; height: 25px;"><font face="Arial" size="2">&nbsp;<<employeeid>></font></td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblemployeename>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<employeename>></font></td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblapplicationdate>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<applicationdate>></font></td>        </tr>          <!-- Compressed Work Hours + Achieved Hours side by side -->        <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblCompressedWorkHours>></font></b></td>          <td style="padding: 0;">            <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 100%;">              <tr>                <td style="width: 50%; height: 25px;"><font face="Arial" size="2">&nbsp;<<CompressedWorkHours>></font></td>                <td style="width: 25%; height: 25px; border-left: 1px solid #666666;"><b><font face="Arial" size="2">&nbsp;<<lblAchievedHours>></font></b></td>                <td style="width: 25%; height: 25px; border-left: 1px solid #666666;"><font face="Arial" size="2">&nbsp;<<AchievedHours>></font></td>              </tr>            </table>          </td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblScheduleStartDate>></font></b></td>          <td>            <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 100%;">              <tr>                <td style="width: 50%; height: 25px;"><font face="Arial" size="2">&nbsp;<<ScheduleStartDate>></font></td>                <td style="width: 20%; height: 25px; border-left: 1px solid #666666;"><b><font face="Arial" size="2"><<lblScheduleEndDate>></font></b></td>                <td style="height: 25px; border-left: 1px solid #666666;"><font face="Arial" size="2">&nbsp;<<ScheduleEndDate>></font></td>              </tr>            </table>          </td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblStatus>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Status>></font></td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblreason>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<reason>></font></td>        </tr>          <tr>          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblRemark>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<Remark>></font></td>        </tr>          <!-- Auto-Rejection Section -->        <tr bgcolor="#8B0000">          <td colspan="2" style="height: 25px;">            <b><span style="color:white;">&nbsp;<<lblAutoRejection>></span></b>          </td>        </tr>          <tr bgcolor="#fff0f0">          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblAutoRejectionStatus>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<AutoRejectionStatus>></font></td>        </tr>          <tr bgcolor="#fff0f0">          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblAutoRejectionReason>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<AutoRejectionReason>></font></td>        </tr>          <tr bgcolor="#fff0f0">          <td style="height: 25px;"><b><font face="Arial" size="2"><<lblAutoRejectionDate>></font></b></td>          <td style="height: 25px;"><font face="Arial" size="2">&nbsp;<<AutoRejectionDate>></font></td>        </tr>        </table>    </body>  </html>','CompressedWorkHoursRejection')


