DECLARE @OrgIds TABLE (Id INT IDENTITY(1,1), OrgId INT);

INSERT INTO @OrgIds (OrgId)
SELECT Id FROM sSetup.tOrganizationMaster WHERE Id <> 1 AND IsObsolete = 0

DECLARE @CurrentId INT = 1;
DECLARE @MaxId INT;
DECLARE @CurrentOrgId INT;
DECLARE @CreatedUserId BigInt

SELECT @MaxId = MAX(Id) FROM @OrgIds;

WHILE @CurrentId <= @MaxId
BEGIN
    SELECT @CurrentOrgId = OrgId FROM @OrgIds WHERE Id = @CurrentId;
	SELECT @CreatedUserId = [sCommon].[fGetBigIntIdForOrg](3, @CurrentOrgId)

	-- 1) Certificate_FirstTrial : Software Sample First Trial Certificate
    EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample First Trial Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 650px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding-inline: 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td colspan="5" style="text-align: center; font-size: 16px; font-weight: 600; margin-bottom: 15px">								<p style="margin: 15px">									<i>Trial Certificate</i></p>							</td>						</tr>						<!-- main description part -->						<tr>							<td colspan="1" style="width:40%; font-size:15px; padding-left: 20px; font-style: italic">								This is to Certify that [Kumar-Kumari]</td>							<td colspan="4" style="width: 60%; text-align: center; border-bottom: 1px solid #000">								<p style="margin: 0; font-size:15px">									<strong>[Name]</strong></p>							</td>						</tr>						<tr>							<td colspan="5" style="font-size:15px; font-style: italic">								[is-was] a bonafide student of this School. [He-She] has passed [Exam] Exam held in</td>						</tr>						<tr>							<td style="width: 15%; display: inline-block; font-size:15px; font-style: italic">								Year</td>							<td style="width: 80%; display: inline-block; text-align: center; border-bottom: 1px solid #000">								<p style="margin: 0; display: inline-block; font-size:15px;">									<strong>[ExamYear]</strong></p>							</td>							<td style="width: 10%; font-style: italic; text-align: center; font-size:15px;">								By</td>							<td style="width: 95%; display: inline-block; text-align: center; border-bottom: 1px solid #000">								<p style="margin: 0">									<strong>[Trial]</strong></p>							</td>							<td style="width: 5%; font-size:15px;font-style: italic">								Trial</td>						</tr>						<tr>							<td colspan="5">								<div style="display: flex; align-items: center; font-size: 15px;">									<span style="font-style: italic; margin-right: 8px;">[His-Her] Exam Center was</span> <span style="flex: 1; border-bottom: 1px solid #000; text-align: center; font-weight: bold; margin-right: 15px;">[ExamCentre]</span> <span style="font-style: italic; margin-right: 8px;">Exam seat no. was</span> <span style="flex: 1; border-bottom: 1px solid #000; text-align: center; font-weight: bold;">[SeatNo]</span></div>							</td>						</tr>						<tr>							<td colspan="5" style="padding-bottom: 25px;">								<div style="display: flex; align-items: center; font-size: 15px;">									<span style="font-style: italic; margin-right: 8px;">[His-Her] Gr No. is</span> <span style="min-width: 150px; border-bottom: 1px solid #000; display: inline-block; text-align: center; font-weight: bold;"> [Code] </span></div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[FirstTrialDate]<br />								<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0;text-align: center;">Class Teacher&#39;s Signature</b></td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal&#39;s Signature</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=4;


	-- 2) Certificate_FirstTrial_LetterHead : Software Sample First Trial Certificate Letter Head
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample First Trial Certificate Letter Head',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 30px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 10px;">								<p style="font-size: 18px; font-weight: bold;text-decoration: underline;">									To Whomsoever it may concern</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px;">					<tbody>						<tr>							<td style="text-align: left; width: 37%; padding-left: 70px;">								This is to certify that&nbsp; [Mr.-Miss]</td>							<td style="text-align: center;border-bottom: 1px solid #000; width: 55%; font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 10%;">								[Son-Daughter]&nbsp;of</td>							<td style="text-align: center; width: 65%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								Mr . [FatherName]</td>							<td style="text-align: center; width: 25%;">								is a bonafide student of</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 25%">								this school studying in</td>							<td style="text-align: center; width: 33%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 10%">								since</td>							<td style="text-align: center; width: 32%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[AdmissionDate]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 25%">								[He-She]&nbsp;has passed the</td>							<td style="text-align: center; width: 25%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Exam]</td>							<td style="text-align: center; width: 25%">								exam held in year the</td>							<td style="text-align: center; width: 25%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[ExamYear]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 5%">								by</td>							<td style="text-align: center; width: 20%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Trial]</td>							<td style="text-align: center; width: 45%">								attempt and&nbsp;<span style="text-transform: lowercase;">[His-Her]</span>&nbsp;exam Seat No. was</td>							<td style="text-align: center; width: 30%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[SeatNo]</td>						</tr>					</tbody>				</table>				<table style="border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								[His-Her] GR No is</td>							<td style="text-align: center; width: 30%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 100%; padding-left: 70px;">								To the best of my knowledge,&nbsp;<span style="text-transform: lowercase;">[He-She]</span>&nbsp;bears good moral character.</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 100%;">								I wish <span style="text-transform: lowercase;">[Him-Her]</span> success in <span style="text-transform: lowercase;">[His-Her]</span> future.</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[FirstTrialDate]<br />								&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<b style="padding-top: 2px; padding-right: 14px; padding-left: 14px; border-top: 1px solid rgb(0, 0, 0);">Class Teacher&#39;s Signature</b>&nbsp; &nbsp; &nbsp; &nbsp;</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal&#39;s Signature</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=4;


	-- 3) Certificate_Character : Software Sample Character Certificate
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Character Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgName]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 30px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 30px;">								<p style="font-size: 18px; font-weight: bold;">									Character Certificate</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px;">					<tbody>						<tr>							<td style="text-align: right; width: 37%;">								This is to Certify that [Kumar-Kumari]</td>							<td style="text-align: center;border-bottom: 1px solid #000; width: 55%; font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 32%;">								[is-was] a bonafide student of standard</td>							<td style="text-align: center; width: 24%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 10%;">								in Year</td>							<td style="text-align: center;width: 15%; border-bottom: 1px solid #000; font-weight: bold; font-style: normal;">								[Batch]</td>						</tr>					</tbody>				</table>				<table style="border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 150px">								[His-Her] Gr No. is</td>							<td style="text-align: center; width: 265px; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code].</td>						</tr>					</tbody>				</table>				<table style="border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: right; width: 510px">								To the best of my knowledge [He-She]&nbsp;bears a good moral character</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date :&nbsp;</b>[characterDate]<br />								<br />								<b>Place :</b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0;text-align: center;">Class Teacher Sign</b></td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal Sign</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=3


	-- 4) Certificate_Leaving : Software Sample Student Leaving Certificate
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Student Leaving Certificate',@rTemplate=N'<title></title><table style="width: 100%; max-width: 650px; border-collapse: collapse; margin: 0 auto;  border: 1px solid #000;">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 15%;">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center;">								<div style="font-weight: bold; font-size: 16px;">									[OrgTitle]</div>								<div style="font-size: 12px;">									[SmallAddress1]</div>								<div style="font-size: 12px;">									[SmallAddress2]</div>								<div style="font-size: 12px;">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 30%; font-size: 12px;">								<b>Certificate No : </b>[LCNumber]</td>							<td style="width: 40%; text-align: center; font-size: 18px; font-weight: bold;">								Leaving Certificate</td>							<td style="width: 30%; text-align: right; font-size: 12px;">								<b>Date : </b>[LCDate]</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Registration Number -->		<tr>			<td style="padding: 10px; text-align: center;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;">								<b>Student&#39;s General Registration Number :&nbsp;&nbsp;</b><span style=" border-bottom: 1px solid #000; padding-left: 5px; width: 200px; display: inline-block;text-align: left;">[Code]</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Details -->		<tr>			<td style="padding: 0;">				<table style="width: 100%; border-collapse: collapse;">					<tbody style="padding: 8px; display: inline-block;">						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">01. Name of the Student : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Name]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">02. Mother&#39;s Name : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[MotherName]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">03. Religion and Subcaste : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Religion] / [SubCaste]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">04. Nationality: </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Nationality]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">05. Place of Birth : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[BirthPlace]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">06. Date of Birth according to</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DateOfBirth]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">christian era : (In Words) : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DOBInWord]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">07. Name of Previous School : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[PreviousSchool]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">08. Date of Admission : </b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;">[AdmissionDate]</span>&nbsp;<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;"><b>Standard :&nbsp;</b>&nbsp;[AdmissionStandard]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">09. Date of Leaving :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LeftDate]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">10. Student&#39;s Current Standard :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[CurrentStandard]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">11. Reason of Leaving School :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCReason]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">12. Progress :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCProgress]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">13. Conduct :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCConduct]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">14. Total Days of Presence : </b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;">[PresentDaysSum]</span>&nbsp;<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;"><b>From Days :&nbsp;</b>[TotalDaysSum]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">15. Remarks :</b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; border-bottom: 1px solid #000; width: 400px; display: inline-block;">[LCRemark]</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certification -->		<tr>			<td style="padding: 20px 10px; font-size: 12px; ">				<b>Certified that the above information is in accordance with the student register.</b></td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;">								<b>Date :&nbsp;</b>[LCDate]<br />								<br />								<b>Place :&nbsp;</b>[City] [CityState]</td>						</tr>						<tr>							<td style="height: 40px;">								&nbsp;</td>						</tr>						<tr>							<td>								<table style="width: 100%; border-collapse: collapse;">									<tbody>										<tr>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>(Signature of Class Teacher)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>(Signature of Clerk)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>Signature of Principal</b></td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 5) Certificate_Leaving_College : Software Sample Leaving Certificate College
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Leaving Certificate College',@rTemplate=N'<title></title><table style="width: 100%; max-width: 650px; border-collapse: collapse; margin: 0 auto;  border: 1px solid #000;">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 15%;">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center;">								<div style="font-weight: bold; font-size: 16px;">									[OrgTitle]</div>								<div style="font-size: 12px;">									[SmallAddress1]</div>								<div style="font-size: 12px;">									[SmallAddress2]</div>								<div style="font-size: 12px;">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 8px;padding-bottom: 30px;">				<table style="border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 20%; font-size: 12px;padding-left: 8px;">								<b>Certificate No :&nbsp;</b>[LCNumber]</td>							<td style="width: 60%; text-align: center; font-size: 18px; font-weight: bold;">								Leaving Certificate</td>							<!-- <td style="width: 30%; text-align: right; font-size: 12px;"><b>Date : </b> 22/05/2025</td> -->						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Registration Number -->		<tr>			<td style="padding: 0 8px; text-align: left;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;padding: 0;">								<b style="padding: 0 8px; width: 240px; display: inline-block;text-align: left;">Student&#39;s General Registration Number : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 0 8px;width: 360px; display: inline-block;text-align: left;">[Code]</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Details -->		<tr>			<td style="padding: 0;">				<table style="width: 100%; border-collapse: collapse;">					<tbody style="padding: 8px; display: inline-block;">						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">01. Name of the Student : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Name]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">02. Mother&#39;s Name : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[MotherName]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">03. Religion and Subcaste : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Religion] / [SubCaste]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">04. Nationality: </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Nationality]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">05. Place of Birth : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[BirthPlace]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">06. Mother Tongue : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[MotherTongue]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">07. Date of Birth according to</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DateOfBirth]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">christian era : (In Words) : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DOBInWord]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">08. Name of Previous School : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[PreviousSchool]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">09. Date of Admission : </b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; width: 400px; display: inline-block;border-bottom: 1px solid #000;">[AdmissionDate]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">10. Date of Leaving :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LeftDate]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">11. Standard in which studying :</b></td>							<td style="font-size: 12px; ">								<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;">[CurrentStandard]</span>&nbsp;<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;"><b>Since when :&nbsp;</b>[BatchDate]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">12. Reason of Leaving College :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCReason]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">13. Progress :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCProgress]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">14. Conduct :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCConduct]</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">15. Remarks :</b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; border-bottom: 1px solid #000; width: 400px; display: inline-block;">[LCRemark]</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certification -->		<tr>			<td style="padding: 20px 10px; font-size: 12px; ">				<b>Certified that the above information is in accordance with the student register.</b></td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;">								<b>Date :</b>[LCDate]<br />								<br />								<b>Place :</b>[City] [CityState]</td>						</tr>						<tr>							<td style="height: 40px;">								&nbsp;</td>						</tr>						<tr>							<td>								<table style="width: 100%; border-collapse: collapse;">									<tbody>										<tr>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>(Signature of Class Lecturer)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>(Signature of Clerk)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b>Signature of Principal</b></td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 6) Certificate_Leavingwithoutattendance : Software Sample Leaving Certificate Without Attendance
	exec sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Leaving Certificate Without Attendance',@rTemplate=N'<title></title><table style="width: 100%; max-width: 650px; border-collapse: collapse; margin: 0 auto;  border: 1px solid #000;">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 15%;">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center;">								<div style="font-weight: bold; font-size: 16px;">									[OrgTitle]</div>								<div style="font-size: 12px;">									[SmallAddress1]</div>								<div style="font-size: 12px;">									[SmallAddress2]</div>								<div style="font-size: 12px;">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 8px;padding-bottom: 30px;">				<table style="border-collapse: collapse;">					<tbody>						<tr>							<td style="width: 20%; font-size: 12px;padding-left: 8px;">								<b>Certificate No :</b>[LCNumber]</td>							<td style="width: 60%; text-align: center; font-size: 18px; font-weight: bold;">								Leaving Certificate</td>							<!-- <td style="width: 30%; text-align: right; font-size: 12px;"><b>Date : </b> 22/05/2025</td> -->						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Registration Number -->		<tr>			<td style="padding: 0 8px; text-align: left;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;padding: 0;">								<b style="padding: 8px; width: 200px; display: inline-block;text-align: left;">Student&#39;s General Registration Number : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[Code]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;padding: 0;">								<b style="padding: 8px; width: 200px; display: inline-block;text-align: left;">Student Id (SUID No) : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[SUId]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;padding: 0;">								<b style="padding: 8px; width: 200px; display: inline-block;text-align: left;">UID No. (Aadhaar card No) :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[AdhaarNumber]&nbsp;</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Student Details -->		<tr>			<td style="padding: 0;">				<table style="width: 100%; border-collapse: collapse;">					<tbody style="padding: 8px; display: inline-block;">						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">01. Name of the Student : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px;width: 400px; display: inline-block;">[Name]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">02. Mother&#39;s Name : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[MotherName]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">03. Religion : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[Religion]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">04. Nationality:</b></td>							<td style="font-size: 12px; ">								<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;">[Nationality]&nbsp;</span>&nbsp;<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;"><b>Mother Tongue :&nbsp;</b>[MotherTongue]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">05. Place of Birth : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[BirthPlace]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">06. Date of Birth according to</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DateOfBirth]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">christian era : (In Words) : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[DOBInWord]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">07. Name of Previous School : </b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;padding: 0;">								<span style="padding: 8px;width: 400px; display: inline-block;text-align: left;">[PreviousSchool]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">08. Date of Admission : </b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;">[AdmissionDate]&nbsp;</span>&nbsp;<span style="padding: 8px; width: 190px; display: inline-block;border-bottom: 1px solid #000;"><b>Standard :&nbsp;</b>[AdmissionStandard]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">9. Academic Performance :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCProgress]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">10. Behaviour :</b></td>							<td style="font-size: 12px; ">								<span style="padding: 8px; width: 400px; display: inline-block;border-bottom: 1px solid #000;">[LCConduct]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">11. Date of Leaving :</b></td>							<td style="font-size: 12px; ">								<span style="padding: 8px; width: 400px; display: inline-block;border-bottom: 1px solid #000;">[LeftDate]&nbsp;</span></td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse;">					<tbody style="padding: 0 8px; display: inline-block;">						<tr>							<td style="font-size: 12px;">								<b style="padding: 0 8px; width: 290px; display: inline-block;">12. Class in which he was studying (in numbers) :</b></td>							<td style="font-size: 12px; ">								<span style="padding: 8px; width: 145px; display: inline-block;border-bottom: 1px solid #000;">[CurrentStandard]&nbsp;</span>&nbsp;<span style="padding: 8px; width: 145px; display: inline-block;border-bottom: 1px solid #000;"><b>From when :&nbsp;</b>[BatchDate]&nbsp;</span></td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse;">					<tbody style="padding: 8px; display: inline-block;">						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">13. Reason of Leaving College :</b></td>							<td style="font-size: 12px; border-bottom: 1px solid #000;">								<span style="padding: 8px; width: 400px; display: inline-block;">[LCReason]&nbsp;</span></td>						</tr>						<tr>							<td style="font-size: 12px;">								<b style="padding: 8px; width: 200px; display: inline-block;">14. Remarks :</b></td>							<td style="font-size: 12px;">								<span style="padding: 8px; border-bottom: 1px solid #000; width: 400px; display: inline-block;">[LCRemark]&nbsp;</span></td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certification -->		<tr>			<td style="padding: 20px 10px; font-size: 12px; ">				<b>Certified that the above information is in accordance with the student register.</b></td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px;">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 12px;">								<b>Date :</b>[LCDate]<br />								<br />								<b>Place :</b>[City] [CityState]</td>						</tr>						<tr>							<td style="height: 40px;">								&nbsp;</td>						</tr>						<tr>							<td>								<table style="width: 100%; border-collapse: collapse;">									<tbody>										<tr>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b style="padding-top: 5px; border-top: 1px solid #000;">(Signature of Class Teacher)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b style="padding-top: 5px; border-top: 1px solid #000;">(Signature of Clerk)</b></td>											<td style="width: 33%; text-align: center; font-size: 12px;">												<b style="padding-top: 5px; border-top: 1px solid #000;">(Signature of Principal)</b></td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 7) Certificate_CBSETransfer : Software Sample Transfer Certificate
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Transfer Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \</style><table style="width: 100%; max-width: 710px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; max-height: 80px; height: 90px;" /></td>							<td style="width: 85%; text-align: center">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px">									[OrgTitle]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[SmallAddress1]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[SmallAddress2]</div>								<div style="font-size: 14px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<tr>			<td style="padding-top: 10px; width: 40%; text-align: center; font-size: 20px; font-family: serif; font-weight: bold">				Transfer Certificate</td>		</tr>		<tr>			<td>				<table style="width: 100%; padding: 10px">					<tbody>						<tr>							<td>								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									1. Name of Pupil</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[Name]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									2. Father&#39;s Name</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[FatherName]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									3. Mother&#39;s Name</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[MotherName]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									4. Nationality</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[Nationality]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 93%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									5. Whether the candidate belongs to schedule Caste or Schedule Tribe or Other Backward Class</p>								<p style="width: 99%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									Yes/No</p>							</td>						</tr>						<tr>							<td>								<p style="width: 42%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									6. Date of First Admission in the School</p>								<p style="width: 16%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[AdmissionDate]</p>								<p style="width: 7%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px; text-align: center">									Class</p>								<p style="width: 33%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[AdmissionStandard]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 80%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									7. Date of Birth (In Christian Era) according to Admission Register (In Figure)</p>								<p style="width: 19%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[DateOfBirth]</p>							</td>						</tr>						<tr>							<td>								<p style="width: 19%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px; text-align: center">									(In Words)</p>								<p style="width: 80%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[DOBInWord]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 19%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									8. Birth Place</p>								<p style="width: 80%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[BirthPlace]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 49%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									9. Class in which the pupil last studied (In Figure)</p>								<p style="width: 5%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[CurrentStandard]</p>								<p style="width: 12%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px;">									(In Words)</p>								<p style="width: 33%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[CurrentStandardInWords]</p>							</td>						</tr>						<tr>							<td>								<p style="width: 60%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									10. Board/School/Annual examination last taken with result</p>								<p style="width: 39%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[Result]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 52%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									11. Whether failed,if so once/twice in the same class</p>								<p style="width: 47%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[FailOrPass]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 21%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px; vertical-align: top">									12. Subjects Studied</p>								<p style="width: 78%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[SubjectNAme]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 54%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									13. Whether qualified for promotion to the higher class</p>								<p style="width: 45%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[PromotedorNot]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 50%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									14. Month upto which pupil has paid school fees</p>								<p style="width: 49%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[LastFeesPaid]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									15. Any fee concession availed of : If so, the nature of such concession</p>								<p style="width: 99%; display: inline-block; border-bottom: 1px solid rgb(0, 0, 0); padding-top: 8px;">									[AnyConcession]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 40%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									16. Total No. of Working Days</p>								<p style="width: 59%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[PresentDaysSum]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 40%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									17. Total No. of working days present</p>								<p style="width: 59%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[TotalDaysSum]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									18. Whether NCC Cadet / Boy Scout / Girl Guid (details may be given)</p>								<p style="width: 99%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[NCCScoutDetail]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									19. Games played or extra-curricular activities in which the pupil usually took part</p>								<p style="width: calc(50% - 22px); display: inline-block; border-bottom: 1px solid #000; padding-top: 8px; margin-left: 22px">									(Mention achievements level therein)</p>								<p style="width: 49%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[GamesPlayed]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									20. General Conduct</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[LCConduct]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 39%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									21. Date of application for certificate</p>								<p style="width: 60%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[LeftDate]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 39%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									22. Date of issue of certificate</p>								<p style="width: 60%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[LCDate]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 39%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									23. Reasons for leaving the school</p>								<p style="width: 60%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[LCReason]&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 39%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; font-style: italic; padding-top: 8px">									24. Any other remarks</p>								<p style="width: 60%; display: inline-block; border-bottom: 1px solid #000; padding-top: 8px">									[LCRemark]&nbsp;</p>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td>				<table style="width: 100%; padding: 50px 10px 10px;">					<tbody>						<tr>							<td style="font-size: 16px; font-weight: 600;">								Class Teacher Sign</td>							<td style="font-size: 16px; font-weight: 600;">								Checked by</td>							<td style="font-size: 16px; font-weight: 600; text-align: end;">								Principal Sign</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 8) Certificate_Transfer_CBSE : Software Sample Transfer Certificate CBSE
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Transfer Certificate CBSE',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 780px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 10px 10px; font-size: 14px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 10px;">								<p>									<b>Book No:</b>&nbsp;[LCNumber]</p>							</td>							<td style="text-align: center;padding-bottom: 10px;">								<p style="font-size: 18px; font-weight: bold;">									Transfer Certificate</p>							</td>							<td style="text-align: center;padding-bottom: 10px;">								<p>									<b>GR No:</b> 1022</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 20%; font-weight: bold;">								1. Name of Pupil</td>							<td style="text-align: left; width: 80%; border-bottom: 1px solid #000;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 20%; font-weight: bold;">								2. Mother&#39;s Name</td>							<td style="text-align: left; width: 80%; border-bottom: 1px solid #000;">								[MotherName]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 30%; font-weight: bold;">								3. Father&#39;s/Guardian&#39;s Name</td>							<td style="text-align: left; width: 70%; border-bottom: 1px solid #000;">								[FatherName]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 86%; font-weight: bold;">								4. Date of Birth (In Christian Era) according to Admission &amp; withdrawal Register (In Figure)</td>							<td style="text-align: center; width: 14%; border-bottom: 1px solid #000;">								[DateOfBirth]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: right; width: 13%; font-weight: bold;">								(In Words)</td>							<td style="text-align: left; width: 87%; border-bottom: 1px solid #000;">								([DOBInWord])</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 18%; font-weight: bold;">								5. Nationality</td>							<td style="text-align: left; width: 82%; border-bottom: 1px solid #000;">								[Nationality]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 80%; font-weight: bold;">								6. Whether the candidate belongs to schedule Caste or Schedule Tribe or OBC</td>							<td style="text-align: left; width: 20%; border-bottom: 1px solid #000;">								Yes/No</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 40%; font-weight: bold;">								7. Date of First Admission in the School</td>							<td style="text-align: left; width: 20%; border-bottom: 1px solid #000;">								[AdmissionDate]</td>							<td style="text-align: center; width: 10%; font-weight: bold;">								Class</td>							<td style="text-align: left; width: 30%; border-bottom: 1px solid #000;">								[AdmissionStandard]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 47%; font-weight: bold;">								8. Class in which the pupil last studied (In Figure)</td>							<td style="text-align: left; width: 15%; border-bottom: 1px solid #000;">								[CurrentStandard]</td>							<td style="text-align: center; width: 12%; font-weight: bold;">								(In Words)</td>							<td style="text-align: left; width: 21%; border-bottom: 1px solid #000;">								[CurrentStandardInWords]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 58%; font-weight: bold;">								9. School/Board Annual examination last taken with result</td>							<td style="text-align: left; width: 42%; border-bottom: 1px solid #000;">								[Result]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 52%; font-weight: bold;">								10. Whether failed,if so once/twice in the same class</td>							<td style="text-align: left; width: 48%; border-bottom: 1px solid #000;">								[FailOrPass]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 20%; font-weight: bold;">								11. Subjects Studied</td>							<td style="text-align: left; width: 80%; border-bottom: 1px solid #000;">								[SubjectNAme]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 58%; font-weight: bold;">								12. Whether qualified for promotion to the higher class</td>							<td style="text-align: left; width: 22%; border-bottom: 1px solid #000;">								[PromotedorNot]</td>							<td style="text-align: left; width: 19%; font-weight: bold;">								if so,to which class</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: right; width: 15%; font-weight: bold;">								(In Figure)</td>							<td style="text-align: left; width: 85%; border-bottom: 1px solid #000;">								[PromotedToClass]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 48%; font-weight: bold;">								13. Month upto which pupil has paid school dues</td>							<td style="text-align: left; width: 52%; border-bottom: 1px solid #000;">								[LastFeesPaid]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 70%; font-weight: bold;">								14. Any fee concession availed of : If so, the nature of such concession</td>							<td style="text-align: left; width: 30%; border-bottom: 1px solid #000;">								[AnyConcession]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 53%; font-weight: bold;">								15. Total No. of Working Days in the academic session</td>							<td style="text-align: left; width: 47%; border-bottom: 1px solid #000;">								[TotalDaysSum]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 55%; font-weight: bold;">								16. Total No. of working days pupil present in the school</td>							<td style="text-align: left; width: 45%; border-bottom: 1px solid #000;">								[PresentDaysSum]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 69%; font-weight: bold;">								17. Whether NCC Cadet / Boy Scout / Girl Guide (details may be given)</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 31%; border-bottom: 1px solid #000;">								[NCCScoutDetail]&nbsp;&nbsp;</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 100%; font-weight: bold;">								18. Games played or extra-curricular activities in which the pupil usually took part</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 35%;">								(Mention achievements level therein)</td>							<td style="text-align: left; width: 65%; border-bottom: 1px solid #000;">								[GamesPlayed]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 22%; font-weight: bold;">								19. General Conduct</td>							<td style="text-align: left; width: 78%; border-bottom: 1px solid #000;">								[LCConduct]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 37%; font-weight: bold;">								20. Date of application for certificate</td>							<td style="text-align: left; width: 63%; border-bottom: 1px solid #000;">								[LeftDate]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 30%; font-weight: bold;">								21. Date of issue of certificate</td>							<td style="text-align: left; width: 70%; border-bottom: 1px solid #000;">								[LCDate]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 35%; font-weight: bold;">								22. Reasons for leaving the school</td>							<td style="text-align: left; width: 65%; border-bottom: 1px solid #000;">								[LCReason]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 10px;">					<tbody>						<tr>							<td style="text-align: left; width: 23%; font-weight: bold;">								23. Any other remarks</td>							<td style="text-align: left; width: 77%; border-bottom: 1px solid #000;">								[LCRemark]</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td style="font-size: 15px; text-align: left; vertical-align: bottom">								<b style="padding: 2px 14px 0">Class Teacher&#39;s Signature </b></td>							<td style="font-size: 15px; text-align: center; vertical-align: bottom">								<b style="padding: 2px 14px 0">Checked by</b></td>							<td style="font-size: 15px; text-align: right; vertical-align: bottom">								<b style="padding: 2px 14px 0">Principal&#39;s Signature</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 9) TransferenceCertificate : Software Sample Transference Certificate
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Transference Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 710px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%; padding-right: 15px">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; max-height: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px">									[OrgTitle]</div>								<div style="font-size: 12px; margin-bottom: 10px">									[SmallAddress1]</div>								<div style="font-size: 12px; margin-bottom: 10px">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 10px">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="width: 100%; padding-left: 30px; text-align: center">								<p style="font-size: 18px; font-weight: bold; border: 1px solid #000; display: inline-block; padding: 0 30px">									Transference Certificate</p>							</td>						</tr>					</tbody>				</table>				<table style="margin-bottom: 15px; width: 100%">					<tbody>						<tr>							<td style="font-weight: 600">								(No change in any entry in this certificate shall be made except by the authority issuing it, and any infringement of this requirement is liable to attract penalty or legal action involve the imposition of penalty such as that of rustication)</td>						</tr>					</tbody>				</table>				<table style="margin-bottom: 15px; width: 100%">					<tbody>						<tr>							<td style="width: 50%">								<p style="width: 50%; display: inline-block; font-weight: 600">									General Register No :</p>								[Code]</td>							<td style="width: 50%; text-align: end">								<p style="width: 50%; display: inline-block; font-weight: 600">									No :&nbsp;</p>								<p style="width: 48%; display: inline-block; border-bottom: 1px solid #000; text-align: left">									[LCNumber]</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="text-align: left; width: 33%; font-weight: bold; font-style: normal">								01. Name In Full:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="text-align: right; width: 33%; font-weight: bold; font-style: normal">								Mother&#39;s Name :</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000">								[MotherName]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								02. Caste and Subcaste :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[Caste] / [SubCaste]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								03. Nationality :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[Nationality]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								04. Date of Birth(In Figure) :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[DateOfBirth]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								(In Words)</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[DOBInWord]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								05. Place of Birth&nbsp;:</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[BirthPlace]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								06. Previous Institute :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[PreviousSchool]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								07. Date of Admission :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[AdmissionDate]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								08. Date of Leaving :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[LeftDate]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								09. Reason of Leaving :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[LCReason]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								10. Conduct :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[LCConduct]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 7px">					<tbody>						<tr>							<td style="width: 33%; font-weight: bold; font-style: normal">								11. Remark :</td>							<td style="width: 67%; border-bottom: 1px solid #000">								[LCRemark]</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="padding-bottom: 8px">								The information is in accordance as per college record .</td>						</tr>						<tr>							<td style="padding-bottom: 8px">								<span style="display: inline-block; width: 60px; font-weight: bold">Date : </span>&nbsp;​[LeftDate]</td>						</tr>						<tr>							<td style="padding-bottom: 8px">								<span style="display: inline-block; width: 60px; font-weight: bold">Place : </span> [City] [CityState]</td>						</tr>						<tr>							<td>								<table style="width: 100%; margin: 25px 0 10px">									<tbody>										<tr>											<td style="font-weight: bold; width: 50%">												<p style="display: inline-block; padding: 0 40px; text-align: center">													OS /Registrar</p>											</td>											<td style="font-weight: bold; width: 50%; text-align: end">												<p style="display: inline-block; padding: 0 40px; text-align: center">													Principal&#39;s Signature</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-bottom: 8px">								Forwarded with compliments :</td>						</tr>						<tr>							<td style="padding-bottom: 8px; font-weight: bold">								01.The Registrar</td>						</tr>						<tr>							<td style="padding-bottom: 5px; font-weight: bold; border-bottom: 1px solid #000">								[University]</td>						</tr>						<tr>							<td style="padding: 5px 0 45px; font-weight: bold">								<p>									02.The Principal/The Registrar,</p>								<p>									[ToCollege]</p>								<p>									[ToCollegeAddress]</p>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=5


	-- 10) Certificate_Bonafied : Software Sample Bonafied Certificate
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 0px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 10px;">								<p style="font-size: 18px; font-weight: bold;">									Bonafide Certificate</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px;">					<tbody>						<tr>							<td style="text-align: right; width: 37%;">								This is to Certify that [Kumar-Kumari]</td>							<td style="text-align: center;border-bottom: 1px solid #000; width: 55%; font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%;">								[is-was]&nbsp;a student of class</td>							<td style="text-align: center; width: 20%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 20%;">								in Year</td>							<td style="text-align: center;width: 20%; border-bottom: 1px solid #000; font-weight: bold; font-style: normal;">								[Batch]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								[His-Her] Birthdate is</td>							<td style="text-align: center; width: 25%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DateOfBirth]</td>							<td style="text-align: center; width: 55%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DOBInWords]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								[His-Her]&nbsp;Caste is</td>							<td style="text-align: center; width: 80%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Caste]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								and BirthPlace is</td>							<td style="text-align: center; width: 30%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[BirthPlace]</td>							<td style="text-align: left; width: 20%">								. [His-Her] GR No is</td>							<td style="text-align: center; width: 30%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%;font-weight: bold; padding-left: 15px;">								[He-She] [is-was] regular &amp; Bonafide student of this [AffiliationType].</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 30%">								The certificate is issued for</td>							<td style="text-align: center; width: 70%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[BonafiedReason]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 100%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[ReceiptNo]</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[BonafideDate]<br />								<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal&#39;s Signature</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 11) Certificate_BonafiedTabular : Software Sample Bonafied Certificate Tabular
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate Tabular',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 0px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 10px;">								<p style="font-size: 18px; font-weight: bold;">									Bonafide Certificate</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 70%; margin: 0 auto; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px;">					<tbody>						<tr>							<td style="text-align: center;border-bottom: 1px solid #000; width: 100%; font-weight: bold; font-style: normal;">								[Caste]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%;">								This is to Certify that Kumari</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%;">								[is-was] a student of class</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 27%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 20%">								in Year</td>							<td style="text-align: center; width: 20%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Batch]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								[His-Her]&nbsp;Birthdate is</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DateOfBirth]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic;">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								[His-Her]&nbsp;Birthdate is</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DOBInWords]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								(in Words)</td>							<td style="text-align: left; width: 67%; font-weight: bold; font-style: normal;">								&nbsp;</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								[His-Her]&nbsp;Religion or SubCaste</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; font-weight: bold; font-style: normal;">								[Caste]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								[His-Her]&nbsp;BirthPlace</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[BirthPlace] [Taluka] [District]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								[His-Her]&nbsp;Gr. No</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 28%">								Remark</td>							<td style="width: 5%;font-style: normal;font-weight: 700;">								:</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[ReceiptNo]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 30%;font-weight: bold;">								[He-She] [is-was] regular &amp; Bonafide student of this [AffiliationType].</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 30%">								The certificate is issued for</td>							<td style="text-align: left; width: 70%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[BonafiedReason]</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[BonafideDate]<br />								<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal Sign</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 12) Certificate_Bonafied_College : Software Sample Bonafied Certificate College
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate College',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; padding-right: 15%;">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 0px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="text-align: center;padding-bottom: 10px;">								<p style="font-size: 18px; font-weight: bold;">									To Whom-Sover it may concern</p>							</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px;">					<tbody>						<tr>							<td style="text-align: right; width: 37%;">								This is to Certify that [Kumar-Kumari]</td>							<td style="text-align: center;border-bottom: 1px solid #000; width: 55%; font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%;">								[is-was]&nbsp;studing in</td>							<td style="text-align: center; width: 40%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DegreeAwarded]</td>							<td style="text-align: center; width: 5%;">								in</td>							<td style="text-align: center;width: 35%; border-bottom: 1px solid #000; font-weight: bold; font-style: normal;">								[DepartmentName]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 15%">								semester</td>							<td style="text-align: center; width: 25%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 25%">								<span style="text-transform: lowercase;">[His-Her]</span> Enrollment no is</td>							<td style="text-align: center; width: 25%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code]</td>							<td style="text-align: right; width: 10%">								and</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								<span style="text-transform: lowercase;">[His-Her]</span>&nbsp;Birthdate is</td>							<td style="text-align: center; width: 20%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DateOfBirth]</td>							<td style="text-align: center; width: 60%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								([DOBInWords])</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 20%">								as per <span style="text-transform: lowercase;">[His-Her]</span> school living certificate.</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; font-style: italic; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 100%; font-weight: bold; font-style: normal; padding-left: 70px;">								[He-She] [is-was] regular &amp; Bonafide student of this [AffiliationType].</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[BonafideDate]<br />								<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal&#39;s Signature</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 13) Certificate_Bonafied_Double : Software Sample Bonafied Certificate Double
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate Double',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 720px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%; padding-right: 15px;">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center; ">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px; border: 1px solid #000; border-bottom: 5px solid #000;">									[OrgTitle]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress1]</div>								<div style="font-size: 12px;margin-bottom: 10px;">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 10px 25px;">				<table style="width: 100%; border-collapse: collapse; line-height: 1.8">					<tbody>						<tr>							<td style="width: 33%;text-align: left;padding-bottom: 10px;">								<span style="font-size: 18px; font-weight: bold;">No.:</span> [Number]</td>							<td style="width: 67%;  padding-left: 30px;">								<p style="font-size: 18px; font-weight: bold; border: 1px solid #000;display: inline-block;padding: 0 30px;">									To Whom May Concern</p>							</td>						</tr>					</tbody>				</table>				<p>					&nbsp;</p>				<p>					&nbsp;</p>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%;">								This is to Certify that [Kumar-Kumari]</td>							<td style="text-align: left; width: 67%; font-weight: bold; font-style: normal;">								[Name]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%;">								[is-was]&nbsp;a student of class</td>							<td style="text-align: left; width: 27%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Class]</td>							<td style="text-align: center; width: 20%">								in Year</td>							<td style="text-align: center; width: 20%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Batch]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								[His-Her]&nbsp;Birthdate is (in figure) :</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DateOfBirth]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								[His-Her]&nbsp;Birthdate is (in Words) :</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[DOBInWords]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								[His-Her]&nbsp;Religion or SubCaste :</td>							<td style="width: 67%; border-bottom: 1px solid rgb(0, 0, 0); font-weight: bold; font-style: normal;">								[Caste]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								[His-Her]&nbsp;BirthPlace :</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[BirthPlace] [Taluka] [District]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 33%">								[His-Her]&nbsp;Gr. No :</td>							<td style="text-align: left; width: 67%; border-bottom: 1px solid #000;  font-weight: bold; font-style: normal;">								[Code]</td>						</tr>					</tbody>				</table>				<table style="width: 100%; border-collapse: collapse; line-height: 1.8; margin-bottom: 15px">					<tbody>						<tr>							<td style="text-align: left; width: 30%;font-weight: bold;">								[He-She] [is-was]&nbsp;regular &amp; Bonafide student of this [AffiliationType].</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse;">					<tbody>						<tr>							<td colspan="2" style="font-size: 15px">								<b>Date : </b>[BonafideDate]<br />								<br />								<b>Receipt No. : </b>[ReceiptNo]</td>							<td style="font-size: 15px; text-align: center; vertical-align: top">								<b style=" padding: 2px 14px 0">Place : </b>[City] [CityState]</td>							<td style="font-size: 15px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Principal Sign</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 14) Certificate_Bonafied_College_LetterHead : Software Sample Bonafied Certificate College Letter Head
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate College Letter Head',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \</style><table style="width: 100%; margin: 0 auto">	<tbody>		<tr>			<td>				<table style="width: 100%; max-width: 650px; margin: 0 auto">					<tbody>						<tr>							<td style="border-bottom: 2px solid #000; padding: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 15%">												<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>											<td style="width: 85%; padding-left: 95px">												<div style="display: inline-block">													<p style="font-weight: bold; font-size: 20px; margin-bottom: 10px; text-align: center">														[OrgTitle]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress1]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress2]</p>													<p style="font-size: 16px; text-align: center">														[RegistrationDetail]</p>												</div>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding: 10px; text-align: center">								<p style="font-style: italic; font-size: 24px; font-weight: 700; padding: 25px 0; font-family: serif">									BONAFIDE CERTIFICATE</p>							</td>						</tr>						<tr>							<td style="padding: 10px; text-align: center">								<p style="font-size: 20px; font-weight: 600; padding: 15px 0 30px; text-decoration: underline">									To Whomsoever it may concern</p>							</td>						</tr>						<tr>							<td style="padding-bottom: 20px">								<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">									This is to Certify that [Mr-Miss]</p>							</td>						</tr>						<tr>							<td style="border-bottom: 1px solid #000; padding-top: 10px">								<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">									[Name]</p>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 30%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500;">													[is-was] studying in</p>											</td>											<td style="border-bottom: 1px solid #000; width: 55%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[DegreeAwarded]</p>											</td>											<td style="width: 30%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													in semester</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="border-bottom: 1px solid #000; width: 30%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[Class].</p>											</td>											<td style="width: 40%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													[His-Her] Enrollment no is</p>											</td>											<td style="border-bottom: 1px solid #000; width: 30%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[Code]</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 30%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													[His-Her] Birthdate is</p>											</td>											<td style="border-bottom: 1px solid #000; width: 70%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[DateOfBirth]</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="border-bottom: 1px solid #000; padding-top: 10px">								<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">									([DOBInWords])</p>							</td>						</tr>						<tr>							<td style="padding: 20px 0">								<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">									as per <span style="text-transform: lowercase;">[His-Her]</span> school living certificate.</p>							</td>						</tr>						<tr>							<td style="padding: 20px 0">								<p style="font-family: serif; font-size: 20px; font-weight: 700; text-align: center">									[He-She] [is-was] regular &amp; Bonafide student of this School.</p>							</td>						</tr>						<tr>							<td style="padding: 20px 0">								<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">									The certificate is issued for</p>							</td>						</tr>						<tr>							<td style="border-bottom: 1px solid #000; padding-top: 10px">								<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">									[BonafiedReason]</p>							</td>						</tr>						<tr>							<td>								<table style="width: 100%; padding-top: 100px">									<tbody>										<tr>											<td style="font-weight: 700; width: 50%">												Issued on : [BonafideDate]</td>											<td style="font-weight: 700; width: 50%; text-align: end">												<p style="display: inline-block; border-top: 1px solid #000; padding: 5px 20px 0">													Principal&#39;s Signature</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 15 ) Certificate_Bonafied_LetterHead : Software Sample Bonafied Certificate Letter Head
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate Letter Head',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \</style><table style="width: 100%; margin: 0 auto">	<tbody>		<tr>			<td>				<table style="width: 100%; max-width: 650px; margin: 0 auto">					<tbody>						<tr>							<td style="padding: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 15%">												<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>											<td style="width: 85%; padding-left: 95px">												<div style="display: inline-block">													<p style="font-weight: bold; font-size: 20px; margin-bottom: 10px; text-align: center">														[OrgTitle]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress1]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress2]</p>													<p style="font-size: 16px; text-align: center">														[RegistrationDetail]</p>												</div>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding: 10px; text-align: center">								<p style="font-style: italic; font-size: 24px; font-weight: 700; padding: 25px 0; font-family: serif">									BONAFIDE CERTIFICATE</p>							</td>						</tr>						<tr>							<td style="padding: 10px; text-align: center">								<p style="font-size: 20px; font-weight: 600; padding: 15px 0 30px; text-decoration: underline">									To Whomsoever it may concern</p>							</td>						</tr>						<tr>							<td style="padding-bottom: 20px">								<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">									This is to Certify that [Mr-Miss]</p>							</td>						</tr>						<tr>							<td style="border-bottom: 1px solid #000; padding-top: 10px">								<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">									[Name]</p>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 20%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													[Son-Daughter] of</p>											</td>											<td style="border-bottom: 1px solid #000; width: 50%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													Mr. [FatherName]</p>											</td>											<td style="width: 30%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													is a bonafied student of</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 21%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													our school since</p>											</td>											<td style="border-bottom: 1px solid #000; width: 47%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[AdmissionDate]</p>											</td>											<td style="width: 32%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													and is presently studying</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 5%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													in</p>											</td>											<td style="width: 40%; border-bottom: 1px solid #000">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[Class]</p>											</td>											<td style="width: 55%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													. [His-Her] date of birth according to admission</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 18%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													register no.</p>											</td>											<td style="border-bottom: 1px solid #000; width: 30%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[Code]</p>											</td>											<td style="width: 5%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													is</p>											</td>											<td style="border-bottom: 1px solid #000; width: 30%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[DateOfBirth]</p>											</td>											<td style="width: 15%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													( in words )</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="border-bottom: 1px solid #000; padding-top: 10px">								<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">									([DOBInWords])</p>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 30%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													[His-Her] place of birth is</p>											</td>											<td style="border-bottom: 1px solid #000; width: 44%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[BirthPlace]</p>											</td>											<td style="width: 25%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500; text-align: center">													and [He-She] belongs</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding-top: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 3%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													to</p>											</td>											<td style="border-bottom: 1px solid #000; width: 50%">												<p style="font-family: Arial, sans-serif; font-size: 18px; font-weight: 700; text-align: center">													[Caste]</p>											</td>											<td style="width: 46%">												<p style="font-family: serif; font-style: italic; font-size: 20px; font-weight: 500">													community.</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding: 20px 0">								<p style="font-family: serif; font-size: 20px; font-weight: 700; text-align: center">									[He-She] [is-was] regular &amp; Bonafide student of this [AffiliationType].</p>							</td>						</tr>						<tr>							<td>								<table style="width: 100%; padding-top: 100px">									<tbody>										<tr>											<td style="font-weight: 700; width: 50%">												Issued on : [BonafideDate]</td>											<td style="font-weight: 700; width: 50%; text-align: end">												<p style="display: inline-block; border-top: 1px solid #000; padding: 5px 20px 0">													Principal&#39;s Signature</p>											</td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 16) Certificate_Bonafied_WithPreviousDetail : Software Sample Bonafied Certificate With Previous Detail
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate With Previous Detail',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      .record-table \        border-collapse: collapse;        text-align: center;      \      .record-table th,      .record-table tr,      .record-table td \        border: 1px solid rgba(153, 153, 153, 0.541);        padding: 10px;      \      .photobox \        width: 130px;        height: 150px;        border: 1px solid #000;      \</style><table style="width: 100%; margin: 0 auto">	<tbody>		<tr>			<td>				<table style="width: 100%; max-width: 650px; margin: 0 auto">					<tbody>						<tr>							<td style="padding: 10px">								<table style="width: 100%">									<tbody>										<tr>											<td style="width: 15%">												<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>											<td style="width: 85%; padding-left: 95px">												<div style="display: inline-block">													<p style="font-weight: bold; font-size: 20px; margin-bottom: 10px; text-align: center">														[OrgTitle]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress1]</p>													<p style="font-size: 16px; margin-bottom: 5px; text-align: center">														[SmallAddress2]</p>													<p style="font-size: 16px; text-align: center">														[RegistrationDetail]</p>												</div>											</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td style="padding: 10px 0; text-align: center">								<p style="font-family: serif; font-size: 22px; font-weight: 700; padding: 15px 0 30px; text-decoration: underline">									TO WHOM SO EVER IT MAY CONCERN</p>							</td>						</tr>						<tr>							<td style="text-align: end">								<p style="font-weight: 600">									Date - [BonafideDate]</p>							</td>						</tr>						<tr>							<td>								<table style="width: 88%">									<tbody>										<tr>											<td>												<div class="wrapperdiv" style="line-height: 2">													<div class="t-row">														<p style="display: inline-block; width: 30%">															This is to Certify that</p>														<p style="display: inline-block; width: 69%; border-bottom: 1.5px solid #000; font-weight: 600; padding-left: 10px">															[Name]</p>													</div>													<div class="t-row">														<span>[is-was] a student of this school and was admitted on</span> <span style="font-weight: 600">[AdmissionDate]</span></div>													<p>														And left the school since <strong>[LeftDate]</strong></p>													<div class="t-row">														<span>[His-Her] birthdate as recorded in the General Register of the school is</span> <span style="font-weight: 600">[DateOfBirth]</span></div>													<p>														[His-Her]&nbsp; birthplace is&nbsp;<strong>[BirthPlace]</strong></p>													<div class="t-row" style="margin-bottom: 25px">														<span>Caste : <b>[Caste]</b></span></div>													<p>														[He-She] bears a good moral character</p>													<p>														Other particulars as per school record are shown as under :</p>												</div>											</td>										</tr>										<tr>											<td>												<table class="record-table" style="width: 100%; margin-top: 24px">													<tbody>														<tr>															<th>																Standard</th>															<th>																Code</th>															<th>																Department</th>															<th style="width: 20%">																Year</th>															<th>																School</th>														</tr>														<tr>															<td>																[ClassName]</td>															<td>																[Code]</td>															<td>																[DepartmentName]</td>															<td>																[Batch]</td>															<td>																[Orgtitle]</td>														</tr>													</tbody>												</table>											</td>										</tr>										<tr>											<td style="padding-top: 16px;">												<div class="photobox">													&nbsp;</div>											</td>										</tr>									</tbody>								</table>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 17) Certificate_Bonafied_WithAddress : Software Sample Bonafied Certificate With Address
	EXEC sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Bonafied Certificate With Address',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \      p \        margin: 0;      \</style><table style="width: 100%; max-width: 650px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; height: 90px;" /></td>							<td style="width: 85%; text-align: center">								<div style="font-weight: bold; font-size: 16px">									[OrgTitle]</div>								<div style="font-size: 12px">									[SmallAddress1]</div>								<div style="font-size: 12px">									[SmallAddress2]</div>								<div style="font-size: 12px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Certificate Title -->		<tr>			<td style="padding: 10px">				<table style="width: 100%; border-collapse: collapse; line-height: 1.7">					<tbody>						<tr>							<td colspan="4" style="text-align: center; font-size: 18px; font-weight: bold; margin-bottom: 15px">								<p style="margin-bottom: 15px">									Bonafide Certificate</p>							</td>						</tr>						<!-- main description part -->						<tr>							<td colspan="1" style="width: 40%; font-style: italic">								This is to Certify that [Kumar-Kumari]</td>							<td colspan="3" style="width: 60%; text-align: center; border-bottom: 1px solid #000">								<strong>[Name]</strong></td>						</tr>						<tr>							<td style="width: 20%; font-style: italic">								[is-was]&nbsp;a student of class</td>							<td style="width: 35%; text-align: center; border-bottom: 1px solid #000">								<strong>[Class]</strong></td>							<td style="width: 10%; font-style: italic">								in Year</td>							<td style="width: 35%; text-align: center; border-bottom: 1px solid #000">								<strong>[Batch]</strong></td>						</tr>						<tr>							<td colspan="4">								<div style="display: inline-block; width: 21%; font-style: italic">									[His-Her]<span>&nbsp;Birthdate is</span></div>								<div style="display: inline-block; border-bottom: 1px solid #000; width: 78%; text-align: center">									<strong>[DateOfBirth] ([DOBInWords])</strong></div>							</td>						</tr>						<tr>							<td colspan="4">								<div style="display: inline-block; width: 21%; font-style: italic">									[His-Her]<span>&nbsp;SubCaste is</span></div>								<div style="display: inline-block; border-bottom: 1px solid #000; width: 78%; text-align: center">									<strong>[SubCaste]</strong></div>							</td>						</tr>						<tr>							<td colspan="4" style="width: 100%">								<div style="display: inline-block; width: 20%; font-style: italic">									<span>and BirthPlace is</span></div>								<div style="display: inline-block; border-bottom: 1px solid #000; width: 40%; text-align: center">									<strong>[BirthPlace]</strong></div>								<div style="display: inline-block; width: 17%; font-style: italic">									<span>.</span>[His-Her]&nbsp;<span>GR No is</span></div>								<div style="display: inline-block; border-bottom: 1px solid #000; width: 20%; text-align: center">									<strong>[Code]</strong></div>							</td>						</tr>						<tr>							<td colspan="4">								<p style="font-style: italic; font-weight: 800; padding-left: 60px">									[He-She] [is-was] regular &amp; Bonafide student of this [AffiliationType].</p>							</td>						</tr>						<tr>							<td colspan="4" style="width: 100%">								<div style="display: inline-block; width: 32%; font-style: italic">									<span>The certificate is issued for</span></div>								<div style="display: inline-block; border-bottom: 1px solid #000; width: 67%; text-align: center">									<strong>[BonafiedReason]</strong></div>							</td>						</tr>						<tr>							<td colspan="4" style="width: 100%">								<div style="display: inline-block; width: 13%; font-style: italic; font-weight: 700">									<span>Address</span></div>								<div style="display: inline-block;width: 85%;text-align: center;">									[PresentStreetOne] [PresentStreetTwo] [PresentStreetThree] [PresentCity] [PresentState] [PresentCountry] [PresentZipCode]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<tr>			<td style="border: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="font-size: 12px">								<b>Date : </b>[BonafideDate]<br />								<br />								<b>Place : </b>[City] [CityState]</td>							<td style="font-size: 12px; text-align: end; vertical-align: bottom">								<b style="border-top: 1px solid #000; padding: 2px 14px 0">Signature of Principal</b></td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=2


	-- 18) Software Sample Transfer Certificate (Transfer)
	exec sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Transfer Certificate (Transfer)',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \</style><table style="width: 100%; max-width: 710px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="border-bottom: 1px solid #000; padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; max-height: 80px; height: 90px;" /></td>							<td style="width: 85%; text-align: center">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px">									[OrgTitle]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[SmallAddress1]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[SmallAddress2]</div>								<div style="font-size: 14px">									[RegistrationDetail]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<tr>			<td style="padding-top: 10px; width: 40%; text-align: center; font-size: 20px; font-family: serif; font-weight: bold">				Transfer Certificate</td>		</tr>		<tr>			<td>				<table style="width: 100%; padding: 5px">					<tbody>						<tr>							<td>								<p style="width: 50%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									Sr No: [Number]</p>								<p style="width: 49%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px; text-align: end">									GR No:[Code]</p>							</td>						</tr>						<tr>							<td style="padding-top: 20px;">								<p style="width: 25%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									This is to certify that [Mr-Miss]</p>								<p style="width: 74%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px">									[Name]</p>							</td>						</tr>						<tr>							<td>								<p style="width: 74%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									has been a bonafide student of this college, [His-Her] Aadhaar card number is</p>								<p style="width: 25%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px">									&nbsp;</p>							</td>						</tr>						<tr>							<td>								<p style="width: 21%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(a) Since passing the</p>								<p style="width: 14%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px">									[ClassName]</p>								<p style="width: 56%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									Examination <span style="text-transform: lowercase;">[He-She]</span> kepts terms /semester in this college as</p>							</td>						</tr>						<tr>							<td>								<p style="width: 12%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									under</p>								<p style="width: 87%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px">									[SemesterDuration]</p>							</td>						</tr>						<tr>							<td>								<table style="width: 100%; border-collapse: collapse; margin: 10px 0">									<tbody>										<tr>											<th style="text-align: center; padding: 5px 0; border: 1px solid #999">												Examination</th>											<th style="text-align: center; padding: 5px 0; border: 1px solid #999">												Seat No.</th>											<th style="text-align: center; padding: 5px 0; border: 1px solid #999">												Month &amp; Year</th>											<th style="text-align: center; padding: 5px 0; border: 1px solid #999">												Result</th>										</tr>										<tr>											<td style="text-align: center; padding: 5px 0; border: 1px solid #999">												[ExamName]</td>											<td style="text-align: center; padding: 5px 0; border: 1px solid #999">												[ExamSeatNo]</td>											<td style="text-align: center; padding: 5px 0; border: 1px solid #999">												[ExamYear]</td>											<td style="text-align: center; padding: 5px 0; border: 1px solid #999">												[ExamResult]</td>										</tr>									</tbody>								</table>							</td>						</tr>						<tr>							<td>								<p style="width: 23%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(c) [He-She] was absent at</p>								<p style="width: 25%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; text-align: center">									[AbsentExamName]</p>								<p style="width: 23%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									Examination held in</p>								<p style="width: 27%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; text-align: center">									[AbsentExamYear]</p>								<p style="width: 100%; padding-top: 10px; font-family: serif; font-weight: 600; font-size: 16px">									by the university.</p>							</td>						</tr>						<tr>							<td>								<p style="width: 31%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(d) [He-She] would have been in the</p>								<p style="width: 16%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; text-align: center">									[PromotedClass]</p>								<p style="width: 51%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									class if <span style="text-transform: lowercase;">[He-She]</span> had continued.</p>							</td>						</tr>						<tr>							<td>								<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(e) No books belonging to this college are in <span style="text-transform: lowercase;">[His-Her]</span> possession.</p>							</td>						</tr>						<tr>							<td>								<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(f) All College dues have been cleared by the student</p>							</td>						</tr>						<tr>							<td>								<p style="width: 33%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(g) [His-Her] conduct and character is</p>								<p style="width: 66%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; text-align: center">									[TransferConduct]</p>							</td>						</tr>						<tr>							<td>								<p style="width: 56%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">									(h) [His-Her] date of birth as entered in the college Register is</p>								<p style="width: 43%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; text-align: center">									[DateOfBirth]</p>								<div style="padding-left: 20px; width: 100%">									<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">										(i) [He-She] has attended courses of instruction at this college in optional subject</p>									<p style="width: 100%; display: inline-block; border-bottom: 1px solid #000; padding-top: 10px; line-height: 2;">										[OptionalSubject]</p>									<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">										(ii) [He-She] has satisfactory carried out the practical work in science/commerce/Arts subjects by performing necessary experiments/projects.</p>									<p style="width: 100%; display: inline-block; font-family: serif; font-weight: 600; font-size: 16px; padding-top: 10px">										(iii) [He-She] has satisfactory undergone the physical Training prescribed by the University.</p>								</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<!-- Footer -->		<tr>			<td>				<table style="width: 100%; padding: 10px; border-top: 1px solid #000;">					<tbody>						<tr>							<td colspan="3" style="font-size: 16px;">								<strong>Date :</strong> [TransferDate]</td>						</tr>						<tr>							<td style="font-size: 16px; font-weight: 600">								<p style="border-top: 1px solid #000;text-align: center;display: inline-block;padding: 5px 10px 0;margin-top: 50px;">									Prepared by</p>							</td>							<td style="font-size: 16px; font-weight: 600; text-align: end;">								<p style="border-top: 1px solid #000;text-align: center;display: inline-block;padding: 5px 10px 0;margin-top: 70px;">									Verified by</p>							</td>							<td style="font-size: 16px; font-weight: 600; text-align: end">								<p style="border-top: 1px solid #000;text-align: center;display: inline-block;padding: 5px 10px 0;margin-top: 70px;">									Signature of Principal</p>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=6


	-- 19) Software Sample Employee Joining Certificate
	exec sCertificate.pPrintTemplateAdd @rId=0,@rTitle=N'Software Sample Employee Joining Certificate',@rTemplate=N'<title></title><style type="text/css">* \        box-sizing: border-box;        margin: 0;        padding: 0;      \</style><table style="width: 100%; max-width: 710px; border-collapse: collapse; margin: 0 auto; border: 1px solid #000">	<!-- Header -->	<tbody>		<tr>			<td style="padding: 10px">				<table style="width: 100%; border-collapse: collapse">					<tbody>						<tr>							<td style="width: 15%">								<img alt="School Logo" src="[OrgLogo]" style="width: 90px; max-height: 80px; height: 90px;" /></td>							<td style="width: 85%; text-align: center">								<div style="font-weight: bold; font-size: 16px; margin-bottom: 10px">									[ReportOrgGroupTitle]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[OrgTitle]</div>								<div style="font-size: 14px; margin-bottom: 5px">									[SmallAddress1]</div>								<div style="font-size: 14px">									[SmallAddress2]</div>							</td>						</tr>					</tbody>				</table>			</td>		</tr>		<tr>			<td style="padding-top: 10px; width: 40%; text-align: center; font-size: 20px; font-weight: bold">				OFFER LETTER</td>		</tr>		<tr>			<td>				<table style="width: 100%; padding: 10px">					<tbody>						<tr>							<td>								<p style="width: 6%; display: inline-block; padding-top: 8px">									Dear</p>								<p style="width: 40%; display: inline-block; font-weight: 600; border-bottom: 1px solid #000; padding-top: 8px; text-align: center">									[EmployeeName]</p>								<span style="font-weight: 600">,</span></td>						</tr>						<tr>							<td>								<p style="width: 60%; display: inline-block; padding-top: 8px">									It gives me great pleasure to offer you an appointment as</p>								<p style="width: 16%; display: inline-block; font-weight: 600; border-bottom: 1px solid #000; padding-top: 8px; text-align: center">									[Designation]</p>								<p style="width: 22%; display: inline-block; padding-top: 8px">									in the Department of</p>							</td>						</tr>						<tr>							<td>								<p style="width: 45%; display: inline-block; font-weight: 600; border-bottom: 1px solid #000; padding-top: 8px; text-align: center">									[DepartmentName1]</p>								<p style="width: 9%; display: inline-block; padding-top: 8px">									to begin</p>								<p style="width: 43%; display: inline-block; font-weight: 600; border-bottom: 1px solid #000; padding-top: 8px; text-align: center">									[DateOfJoining]</p>								<span style="font-weight: 600">.</span></td>						</tr>						<tr>							<td>								<p style="width: 66%; display: inline-block; padding-top: 8px">									The position will be a month appointment at a monthly salary of</p>								<p style="width: 10%; display: inline-block; font-weight: 600; border-bottom: 1px solid #000; padding-top: 8px; text-align: center">									[PayScale]</p>								<span style="font-weight: 600">.</span>								<p style="width: 100%; display: inline-block; padding-top: 8px">									Salary increases are based entirely on merit.</p>							</td>						</tr>						<tr>							<td>								<p style="padding-top: 24px; line-height: 1.5">									In addition to the salary, <strong>[OrgTitle]</strong> provides a generous fringe benefit package that includes annul Increment (10 to 15% of the basic salary depends upon your working efficiency) training, exposure etc.</p>							</td>						</tr>						<tr>							<td>								<p style="padding-top: 24px; line-height: 1.5">									On your first day of employement you will need to bring to the School Office appropriate documentation from the attached Three Passport Size Photos, Two sets of Certificates of Matric, 12th Graduation, Professional Degrees, Experience Certificates.</p>							</td>						</tr>						<tr>							<td>								<p style="padding-top: 24px; line-height: 1.5">									This offer is not intended to create a contract of employement for any specific period of time, and is contingent upon your eligiblity to work in the <strong>[OrgTitle]</strong> . In your case, we have every reason to believe such actions will be forthcoming.</p>							</td>						</tr>						<tr>							<td>								<p style="padding-top: 24px; line-height: 1.5">									We welcome you to the <strong>[ShortTitle]</strong> and look forward to work with you. We trust that it will be mutually rewarding. The period of agreement for this post is <strong>[AgreementPeriod]</strong> from date of joining. So you are directed to read this document carefully before signing.</p>							</td>						</tr>						<tr>							<td>								<p style="padding-top: 24px; line-height: 1.5">									Note : You can not claim any salary, experience certificate and other amount if you leave the institution without one month prior intimation to management.</p>							</td>						</tr>						<tr>							<td style="padding-top: 24px">								<p style="line-height: 1.5">									Sincerely,</p>								<p style="line-height: 1.5; font-weight: 600">									[UserDisplayName]</p>								<p style="line-height: 1.5; font-weight: 600">									[UserDesignation]</p>								<p style="line-height: 1.5; font-weight: 600">									[OrgTitle]</p>							</td>						</tr>						<tr>							<td>								<p style="display: inline-block; line-height: 1.5">									Applicant Signature&nbsp;</p>								<p style="display: inline-block; font-weight: 600; line-height: 1.5">									[EmployeeName]</p>							</td>						</tr>						<tr>							<td>								<p style="display: inline-block; line-height: 1.5">									Date <b>[CreatedDateTime]</b></p>							</td>						</tr>						<tr>							<td>								<p style="width: 83%; display: inline-block; line-height: 1.5">									Complete Residential Address with Husband/Fathers Name, Mobile No.</p>							</td>						</tr>						<tr>							<td>								<p style="width: 83%; display: inline-block; line-height: 1.5">									[PresentStreetOne] [PresentStreetTwo] [PresentStreetThree]&nbsp;&nbsp;</p>								<p style="width: 83%; display: inline-block; line-height: 1.5">									[PresentCity] [PresentState] [PresentZipCode] [PresentContactNo]</p>								<p style="width: 83%; display: inline-block; line-height: 1.5">									&nbsp;</p>							</td>						</tr>					</tbody>				</table>			</td>		</tr>	</tbody></table><p>	&nbsp;</p>',@rOrgId=@CurrentOrgId,@rCreatedUserId=@CreatedUserId,@rTemplateSourceId=2,@rPrintTemplateFunctionalityId=7

    SET @CurrentId += 1;

END

