Included page: .FrontPage.QA.Archive.TrustLoad.AutoLoad.QA.LoadAssertions.SuiteSetUp (edit)
| import |
| TBOT.Generic.Database |
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100 |
| RightConnection | Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BaseDir | D:\Installations\FitNesseRoot\files\CompareTables\BaseLine |
| ActualDir | D:\Installations\FitNesseRoot\files\CompareTables\Actuals |
| ResultDir | D:\_WebAPP\Files\DataLoad |
| CompareVersion | v2 |
| import |
| TBOT.Generic |
Get Details for Files that needs to be validated.
| ddt: DynamicQuery | select AcctNo as MainAcctNo , LTRIM(RTRIM(A.DB_Name)) DB_NAME, LTRIM(RTRIM(Server)) as SERVER, '{{FileName}}' as LoadFileName, '{{BaslineTapeId}}' as BaslineTapeId, '{{PAN1}}' as AcctNo, '{{NETSEQNO}}' AS RightSeqNo FROM BTMDB..Package A WHERE AcctNo='{{PAN}}' | ||||||||||||
| Comments# | PAN | PAN1 | NETSEQNO | FileName | BaslineTapeId | DB_NAME? | SERVER? | AcctNo? | BaslineTapeId? | MainAcctNo? | LoadFileName? | RightSeqNo? | AcctNo? |
| Test0001 | P11A | P11A | 37 | P11A_LD1_20170524102842_Sanitized_1Acct_201712111436 | 2017-12-08 17:21:00.000 | $DBName1= | $Server1= | $AcctNo1= | $BaslineTapeId1= | $AcctNo1= | $LoadFileName1= | $RightSeqNo1= | $AcctNoSub1= |
| Test0002 | P11A | P11A | 38 | P11A_TM1_8KN15J_201710181412_201712111439 | 2017-12-08 17:22:00.000 | $DBName2= | $Server2= | $AcctNo2= | $BaslineTapeId2= | $AcctNo2= | $LoadFileName2= | $RightSeqNo2= | $AcctNoSub2= |
| Test0003 | Q29P | Q29P | 93 | Q29P_ADK_20170310151327_201703101428_201712111448 | 2017-12-08 17:21:00.000 | $DBName3= | $Server3= | $AcctNo3= | $BaslineTapeId3= | $AcctNo3= | $LoadFileName3= | $RightSeqNo3= | $AcctNoSub3= |
| Test0004 | Q29P | Q29P | 94 | Q29P_111_TQ29P16909_20170311_0846_201712111554 | 2017-12-11 11:40:00.000 | $DBName4= | $Server4= | $AcctNo4= | $BaslineTapeId4= | $AcctNo4= | $LoadFileName4= | $RightSeqNo4= | $AcctNoSub4= |
| Test0005 | Q29P | Q29P | 95 | Q29P_111_TQ29P18068_20170808_0902_201712111610 | 2017-12-08 12:07:00.000 | $DBName5= | $Server5= | $AcctNo5= | $BaslineTapeId5= | $AcctNo5= | $LoadFileName5= | $RightSeqNo5= | $AcctNoSub5= |
| Test0006 | K482 | 569N | 18 | PG4_20170401_20170430.BRIDGE | 2017-12-14 15:39:00.000 | $DBName6= | $Server6= | $AcctNo6= | $BaslineTapeId6= | $AcctNo6= | $LoadFileName6= | $RightSeqNo6= | $AcctNoSub6= |
| Test0007 | K482 | 569N | 19 | T569N1172_20170606_0802.TA1 | 2017-12-14 16:00:00.000 | $DBName7= | $Server7= | $AcctNo7= | $BaslineTapeId7= | $AcctNo7= | $LoadFileName7= | $RightSeqNo7= | $AcctNoSub7= |
| Test0008 | 9155 | 970F | 74 | FTX515L_20170504_160044.DAT | 2017-12-15 14:17:00.000 | $DBName8= | $Server8= | $AcctNo8= | $BaslineTapeId8= | $AcctNo8= | $LoadFileName8= | $RightSeqNo8= | $AcctNoSub8= |
| Test0009 | 9155 | 970F | 75 | T970F0324_20170608_0931.TA1 | 2017-12-15 15:24:00.000 | $DBName9= | $Server9= | $AcctNo9= | $BaslineTapeId9= | $AcctNo9= | $LoadFileName9= | $RightSeqNo9= | $AcctNoSub9= |
| ddt: DynamicQuery | select top 1 B.*, LTRIM(RTRIM(A.DB_Name)) DB_NAME, LTRIM(RTRIM(Server)) as SERVER, '{{BaslineTapeId}}' as BaslineTapeId FROM BTMDB..Package A JOIN {{SERVERNAME}}.OPERATIONSDB.DBO.LoadStats B ON A.AcctNo=B.AcctNo WHERE OrigFile='{{FileName}}' and B.MainAcct='{{PAN}}' AND B.AcctNo='{{PAN1}}' AND B.SeqNo='{{SeqNo}}' ORDER BY SeqNo Desc | ||||||||
| Comments# | PAN | PAN1 | SeqNo | SERVERNAME | FileName | BaslineTapeId | DB_NAME? | SERVER? | SeqNo? |
| Test0001 | $AcctNo1 | $AcctNoSub1 | $RightSeqNo1 | $Server1 | $LoadFileName1 | $BaslineTapeId1 | $DBName1= | $Server1= | $SeqNo1= |
| Test0002 | $AcctNo2 | $AcctNoSub2 | $RightSeqNo2 | $Server2 | $LoadFileName2 | $BaslineTapeId2 | $DBName2= | $Server2= | $SeqNo2= |
| Test0003 | $AcctNo3 | $AcctNoSub3 | $RightSeqNo3 | $Server3 | $LoadFileName3 | $BaslineTapeId3 | $DBName3= | $Server3= | $SeqNo3= |
| Test0004 | $AcctNo4 | $AcctNoSub4 | $RightSeqNo4 | $Server4 | $LoadFileName4 | $BaslineTapeId4 | $DBName4= | $Server4= | $SeqNo4= |
| Test0005 | $AcctNo5 | $AcctNoSub5 | $RightSeqNo5 | $Server5 | $LoadFileName5 | $BaslineTapeId5 | $DBName5= | $Server5= | $SeqNo5= |
| Test0006 | $AcctNo6 | $AcctNoSub6 | $RightSeqNo6 | $Server6 | $LoadFileName6 | $BaslineTapeId6 | $DBName6= | $Server6= | $SeqNo6= |
| Test0007 | $AcctNo7 | $AcctNoSub7 | $RightSeqNo7 | $Server7 | $LoadFileName7 | $BaslineTapeId7 | $DBName7= | $Server7= | $SeqNo7= |
| Test0008 | $AcctNo8 | $AcctNoSub8 | $RightSeqNo8 | $Server8 | $LoadFileName8 | $BaslineTapeId8 | $DBName8= | $Server8= | $SeqNo8= |
| Test0009 | $AcctNo9 | $AcctNoSub9 | $RightSeqNo9 | $Server9 | $LoadFileName9 | $BaslineTapeId9 | $DBName9= | $Server9= | $SeqNo9= |
Execute Data Compare - Basic Trust
| ddt: CompareRecordSets | -- query in AUTOTESTING SELECT * FROM LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON B.TrustKey=A.TrustKey LEFT JOIN LOADTESTBASELINE.dbo.TrustPerm_{{DataBaseName}} C ON C.TrustKey=A.TrustKey AND C.PermSeq=B.PermSeq and C.LastTapeId=B.LastTapeId LEFT JOIN LOADTESTBASELINE.dbo.TrustYr_{{DataBaseName}} D ON D.TrustKey=B.TrustKey AND D.YrSeq=B.YrSeq WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo | -- query in {{DataBaseName}} SELECT * FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON B.TrustKey=A.TrustKey LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.TrustPerm C ON C.TrustKey=A.TrustKey AND C.PermSeq=B.PermSeq and C.LastTapeId=B.TapeAddId LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.TrustYr D ON D.TrustKey=B.TrustKey AND D.YrSeq=B.YrSeq WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo | AcctNo,TrustNo,YrSeq | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_TrustBasic.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_TrustBasic.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_TrustBasic.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_TrustBasic.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_TrustBasic.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_TrustBasic.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_TrustBasic.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_TrustBasic.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_TrustBasic.xml | Match |
Execute Data Compare - Basic Trust
| ddt: CompareRecordSets | -- query in AUTOTESTING select A.*, C.* from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.StComDetail_{{DataBaseName}} C ON C.TrustKey=A.TrustKey AND C.YrSeq=B.YrSeq WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo, C.YrSeq, C.State_CD | -- query in {{DataBaseName}} select A.*, C.* FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.StComDetail C ON C.TrustKey=A.TrustKey AND C.YrSeq=B.YrSeq WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo, C.YrSeq, C.State_CD | AcctNo,TrustNo,YrSeq | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_StateRecords.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_StateRecords.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_StateRecords.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_StateRecords.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_StateRecords.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_StateRecords.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_StateRecords.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_StateRecords.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_StateRecords.xml | Match |
Execute Data Compare - Trust Balance
| ddt: CompareRecordSets | -- query in loadtestbaseline select A.*, C.* from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.TrustBalance_{{DataBaseName}} C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo | -- query in {{DataBaseName}} select A.*, C.* FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.TrustBalance C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo | AcctNo,TrustNo,Bal_Dt | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_TrustBalance.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_TrustBalance.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_TrustBalance.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_TrustBalance.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_TrustBalance.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_TrustBalance.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_TrustBalance.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_TrustBalance.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_TrustBalance.xml | Match |
Execute Data Compare - PrepNotes[?]
| ddt: CompareRecordSets | -- query in loadtestbaseline select A.*, C.* from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.PrepNotes_{{DataBaseName}} C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo | -- query in {{DataBaseName}} select A.*, C.* FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.PrepNotes C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo | AcctNo,TrustNo,SourceOfNote,TranSeq,NoteSeq | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_PrepNotes.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_PrepNotes.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_PrepNotes.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_PrepNotes.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_PrepNotes.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_PrepNotes.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_PrepNotes.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_PrepNotes.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_PrepNotes.xml | Match |
Execute Data Compare - TaxStats[?]
| ddt: CompareRecordSets | -- query in loadtestbaseline select A.*, C.* from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.TaxStats_{{DataBaseName}} C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo | -- query in {{DataBaseName}} select A.*, C.* FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.TaxStats C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo | AcctNo,TrustNo,YrSeq, InsolSeqNo, FedType_Cd, SeqNo | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_TaxStats.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_TaxStats.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_TaxStats.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_TaxStats.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_TaxStats.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_TaxStats.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_TaxStats.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_TaxStats.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_TaxStats.xml | Match |
Execute Data Compare - StTaxStats[?]
| ddt: CompareRecordSets | -- query in loadtestbaseline select A.*, C.* from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A LEFT JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.StTaxStats_{{DataBaseName}} C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' ORDER BY A.AcctNo, A.TrustNo | -- query in {{DataBaseName}} select A.*, C.* FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.StTaxStats C ON C.TrustKey=A.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') ORDER BY A.AcctNo, A.TrustNo | AcctNo,TrustNo,YrSeq, State_Cd, InsolSeqNo, FedType_Cd | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_StTaxStats.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_StTaxStats.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_StTaxStats.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_StTaxStats.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_StTaxStats.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_StTaxStats.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_StTaxStats.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_StTaxStats.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_StTaxStats.xml | Match |
Execute Data Compare - Combined
| ddt: CompareRecordSets | -- query in loadtestbaseline select A.*, B.AcctNo AS MainAcctNo, B.TrustNo as MainTrustNo, C.AcctNo AS SubAcctNo, C.TrustNo as SubTrustNo FROM LOADTESTBASELINE.dbo.Combined_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} B ON A.MainTrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} C ON A.SubTrustKey=C.TrustKey | -- query in {{DataBaseName}} select A.*, B.AcctNo AS MainAcctNo, B.TrustNo as MainTrustNo, C.AcctNo AS SubAcctNo, C.TrustNo as SubTrustNo FROM {{ServerName}}.{{DataBaseName}}.dbo.Combined A JOIN {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef B ON A.MainTrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef C ON A.SubTrustKey=C.TrustKey | MainAcctNo,MainTrustNo,SubAcctNo, SubTrustNo | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_Combined.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_Combined.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_Combined.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_Combined.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_Combined.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_Combined.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_Combined.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_Combined.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_Combined.xml | Match |
Keyboard Shortcuts ?
General
- t Test page or suite
- e Edit page
- v View page (after test)
- a Add new page
Go To
- g u User Guide
- g q Quick Reference Guide
- g f Full Reference Guide
- g c Recent Changes
Edit Mode
- CTRL+s Save page
- ESC Cancel edit
Tools
- p Properties
- w Where used?
- AK+v Versions
- AK+h Page History
- / Focus on search bar
- s Open search page