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 | P61Y | P61Y | 3 | TP61Y0002_20171201_1507.TAP | 2017-12-01 15:12:00.000 | $DBName1= | $Server1= | $AcctNo1= | $BaslineTapeId1= | $AcctNo1= | $LoadFileName1= | $RightSeqNo1= | $AcctNoSub1= |
| Test0002 | 590Y | 590Y | 2 | T590Y2429_20170701_1146.TA1 | 2017-12-06 16:13:00.000 | $DBName2= | $Server2= | $AcctNo2= | $BaslineTapeId2= | $AcctNo2= | $LoadFileName2= | $RightSeqNo2= | $AcctNoSub2= |
| Test0003 | 965H | 965H | 2 | T965H0221_20170801_0941.TA1 | 2017-12-06 10:04:00.000 | $DBName3= | $Server3= | $AcctNo3= | $BaslineTapeId3= | $AcctNo3= | $LoadFileName3= | $RightSeqNo3= | $AcctNoSub3= |
| Test0004 | A541 | A541 | 4 | TA5410293_20170705_1449.TA1 | 2017-12-06 14:22:00.000 | $DBName4= | $Server4= | $AcctNo4= | $BaslineTapeId4= | $AcctNo4= | $LoadFileName4= | $RightSeqNo4= | $AcctNoSub4= |
| Test0005 | 9078 | 9078 | 3 | T90780622_20170707_1220.TA1 | 2017-12-06 14:58:00.000 | $DBName5= | $Server5= | $AcctNo5= | $BaslineTapeId5= | $AcctNo5= | $LoadFileName5= | $RightSeqNo5= | $AcctNoSub5= |
| Test0006 | 5889 | 5889 | 4 | T653T0563_20170728_0656.TA1 | 2017-12-08 10:00:00.000 | $DBName6= | $Server6= | $AcctNo6= | $BaslineTapeId6= | $AcctNo6= | $LoadFileName6= | $RightSeqNo6= | $AcctNoSub6= |
| Test0007 | 5889 | 653T | 4 | T653T0563_20170728_0656.TA1 | 2017-12-08 10:00:00.000 | $DBName7= | $Server7= | $AcctNo7= | $BaslineTapeId7= | $AcctNo7= | $LoadFileName7= | $RightSeqNo7= | $AcctNoSub7= |
| Test0008 | 675K | 675K | 9 | T675K0262_20170711_1352.TA1 | 2017-12-11 09:33:00.000 | $DBName8= | $Server8= | $AcctNo8= | $BaslineTapeId8= | $AcctNo8= | $LoadFileName8= | $RightSeqNo8= | $AcctNoSub8= |
| Test0009 | 675K | 675K | 10 | T675K0263_20170816_1035.TA1 | 2017-12-11 09:39: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 - MIAProp
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * FROM LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.MIAProp_{{DataBaseName}} B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.MIAProp B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,TranSeq | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | P61Y_MIAProp.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | P11A_MIAProp.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | 965H_MIAProp.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | A541_MIAProp.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | 9078_MIAProp.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | 5889_MIAProp.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | 5889_MIAProp.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | 675K_MIAProp.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | 675K_MIAProp.xml | Match |
Execute Data Compare - MIASet
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * FROM LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.MIASet_{{DataBaseName}} B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.MIASet B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,TranSeq | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | P61Y_MIASet.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | P11A_MIASet.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | 965H_MIASet.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | A541_MIASet.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | 9078_MIASet.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | 5889_MIASet.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | 5889_MIASet.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | 675K_MIASet.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | 675K_MIASet.xml | Match |
Execute Data Compare - Prop
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * FROM LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Prop_{{DataBaseName}} B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Prop B ON A.TrustKey=B.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,TranSeq | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | P61Y_Prop.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | P11A_Prop.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | 965H_Prop.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | A541_Prop.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | 9078_Prop.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | 5889_Prop.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | 5889_Prop.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | 675K_Prop.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | 675K_Prop.xml | Match |
Execute Data Compare - CharOthDetail[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.CharOthDetail_{{DataBaseName}} C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE B.TapeAddId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.CharOthDetail C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo, YrSeq, Source, DetailType_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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_CharOthDetail.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_CharOthDetail.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_CharOthDetail.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_CharOthDetail.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_CharOthDetail.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_CharOthDetail.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_CharOthDetail.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_CharOthDetail.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_CharOthDetail.xml | Match |
Execute Data Compare - CharBalSheet2[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.CharBalSheet2_{{DataBaseName}} C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.CharBalSheet2 C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,YrSeq, Source | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_CharBalSheet2.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_CharBalSheet2.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_CharBalSheet2.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_CharBalSheet2.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_CharBalSheet2.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_CharBalSheet2.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_CharBalSheet2.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_CharBalSheet2.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_CharBalSheet2.xml | Match |
Execute Data Compare - CharBalSheet[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.CharBalSheet_{{DataBaseName}} C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.CharBalSheet C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,YrSeq, Source | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_CharBalSheet.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_CharBalSheet.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_CharBalSheet.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_CharBalSheet.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_CharBalSheet.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_CharBalSheet.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_CharBalSheet.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_CharBalSheet.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_CharBalSheet.xml | Match |
Execute Data Compare - CharAssetDetail[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.CharAssetDetail_{{DataBaseName}} C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.CharAssetDetail C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,YrSeq, Source | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_CharAssetDetail.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_CharAssetDetail.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_CharAssetDetail.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_CharAssetDetail.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_CharAssetDetail.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_CharAssetDetail.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_CharAssetDetail.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_CharAssetDetail.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_CharAssetDetail.xml | Match |
Execute Data Compare - CharTrustYr[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.CharTrustYr_{{DataBaseName}} C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.CharTrustYr C ON A.TrustKey=C.TrustKey AND B.YrSeq=C.YrSeq WHERE C.TapeId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' AND SEQNO='{{SEQNO}}') | 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 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_CharTrustYr.xml | Match |
| $AcctNo2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_CharTrustYr.xml | Match |
| $AcctNo3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_CharTrustYr.xml | Match |
| $AcctNo4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_CharTrustYr.xml | Match |
| $AcctNo5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_CharTrustYr.xml | Match |
| $AcctNo6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_CharTrustYr.xml | Match |
| $AcctNo7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_CharTrustYr.xml | Match |
| $AcctNo8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_CharTrustYr.xml | Match |
| $AcctNo9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_CharTrustYr.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