select * from tbl_EAI_inboundFileFormats with (nolock) where formatName = '1FS_OPERATOR_EXPORT_TXT' and ownerId = 0 and ownerType = '*' order by cho_Id

Blanking host #operatorId# #host_cho_id#

select distinct c.cho_Id, a.affiliationDate, a.partnerAffiliateNbr from tbl_CRM_Affiliations a with (nolock) inner join tbl_OPR_ClientOperators g with (nolock) on g.operatorId = a.orgId and 'OPR' = a.orgType and g.ownerId = a.ownerId and g.fsltablecode = a.ownerType inner join tbl_CHO_Operators c with (nolock) on c.cho_id = g.fsl_choId where a.ownerId = and a.ownerType = and a.affiliationStatus = 'A' and a.partnerType = 'OPR' and a.partnerId in ( ) order by affiliationDate desc

Not Found #cho_id#

select cho_Id as operator_1fs_id, cho_name as operator_name, cho_address as operator_address, cho_city as operator_city, cho_state as operator_state, cho_zipcode as operator_zipcode, cho_segment as operator_1fs_segment, cho_segmentId as operator_1fs_segment_id, ofs_freshness_date operator_freshness_date, ofs_type as operator_type, host_cho_id as host_1fs_id, parent_cho_id as parent_1fs_id , affiliation_#_ax#_cho_id as affiliation_#_ax#_1fs_id , affiliation_#_ax#_since , affiliation_#_ax#_member_id from qmd_1fsMasterSrc where keep = 'Y' order by operator_1fs_id --->

1FS Master Records #lsnumberformat( qmd_1fsMaster.recordCount )#

select * from qmd_1fsMaster where operator_type = 'UNIT' and ( parent_1fs_id is null or parent_1fs_id = 0 )

#operator_1fs_id# #_c# #_1fsId# not in the export

Integrity Check Passed

Integrity Check Failed

select * from qmd_1fsMasterSrc where cho_Id in ( ) select operator_1fs_id, count(*) instances from qmd_1fsMaster group by operator_1fs_Id having count(*) > 1

Repeat Check Failed

select * from qmd_1fsMasterSrc where cho_id in ( )

Repeat Check Passed

#min( qmd_1fsMaster.recordCount, _maxRows )##qmd_1fsMaster.recordCount# rows exported

Checking file for corrupt row count:

....The output file is corrupted and should contain #qmd_1fsMaster.recordCount + 1# lines, but has #_fileRowCount# lines instead.

....The output file contains the correct number of lines: #_fileRowCount# lines.

FTP Queued: #htmleditformat( _v )#

FTP NOT QUEUED

update tbl_EAI_inboundBatches set fileName = , ttlDays = 365 where batchId = and ownerId = and ownerType =