USP_DATAFORMTEMPLATE_VIEW_CREDITCARDTRANSACTIONSETTLEMENT

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CREDITCARDTRANSACTIONSETTLEMENT
            (
                @DATALOADED bit = 0 output,
                @RECENTIMPORTSTATUS tinyint = null output,
                @HASPREVIOUSIMPORT bit = null output,
                @RECENTIMPORTDATE date = null output,
                @RECENTIMPORTFILENAME nvarchar(100) = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                -- Grab the status of the most recent import
                select top 1
                    @DATALOADED = 1,
                    @RECENTIMPORTSTATUS = STATUSCODE,
                    @HASPREVIOUSIMPORT = 1,
                    @RECENTIMPORTDATE = convert(date, DATECHANGED),
                    @RECENTIMPORTFILENAME = FILENAME
                from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORT
                order by DATECHANGED desc

                if @DATALOADED = 0
                begin
                    set @DATALOADED = 1
                    set @HASPREVIOUSIMPORT = 0
                end

                return 0;