#! /bin/sh

sBillPeriod="2024/02"

echo "tDataSourceType.DataSource,BH.ID,tBatchType.ProgramID,tBatchType.Description,BH.BatchStatusID,BatchTypeID"
tbssql <<SQLCMD0
SELECT tDataSourceType.DataSource, BH.ID, tBatchType.ProgramID, 
   tBatchType.Description, BH.BatchStatusID, tBatchType.ID AS BatchTypeID
FROM (tBatchType LEFT JOIN tDataSourceType
	 ON tBatchType.DataSourceTypeID = tDataSourceType.ID
     )
LEFT JOIN (SELECT tBatch.BatchTypeID AS BTypeID, tBatch.BatchStatusID, tBatch.ID
	   FROM tBatch
	   WHERE tBatch.BillingPeriod LIKE '$sBillingPeriod'
	  ) AS BH ON tBatchType.ID = BH.BTypeID
WHERE tBatchType.Active = 1 OR BH.ID IS NOT NULL
ORDER BY tDataSourceType.DataSource, tBatchType.Description
SQLCMD0

exit 0