No Data Available - TotalOverall - Total [CIF].[CIF Account].[Acct. Type (CIFA)][CIF].[CIF Account].[Acct. Number (CIFA)][CIF].[CIF Account].[CIF # (CIFA)][CIF].[CIF Account].[Catagory Code (CIFA)][CIF].[CIF Account].[Short Name (CIFA)]case when [Acct. Type (CIFA)] = 'T' then[End of Month].[CD Master EOM].[Current Balance (CDMA EOM)] when [Acct. Type (CIFA)] in ('D', 'S', 'X') then [End of Month].[DD Master EOM].[Current Balance (DDMA EOM)] else null end [CIF # (CIFA)] + [Catagory Code (CIFA)][CIF].[CIF Account].[CIF Relationship (CIFA)]case when [Acct. Type (CIFA)] = 'T' then [Cert Deposits].[CD Master].[Class (CDMA)] when [Acct. Type (CIFA)] in ('D', 'S', 'X') then [Demand Deposit].[DD Master].[Class (DDMA)] else null end case when ([Class] in ('T', 'M', 'F', 'K') and [CIF Relationship (CIFA)] = 'T') then 'SO' when ([Acct. Type (CIFA)] in ('T') and [Cert Deposits].[CD Master].[IRA Code (CDMA)] = 'Y') then 'IR' else [Catagory Code (CIFA)] end count([Acct. Number (CIFA)] for [Short Name (CIFA)])case when [Acct. Type (CIFA)] = 'T' then[Cert Deposits].[CD POD Beneficiary File].[Beneficiary Level (CDBENE)] when [Acct. Type (CIFA)] in ('D', 'S', 'X') then [Demand Deposit].[DD POD Beneficiary File].[Beneficiary Level (DDBENE)] else null end TSDXJO0not ([CIF Relationship (CIFA)] + [Class]) in ('PM', 'PF', 'PT', 'PK')NOT [Bene Level] > 0not [Catagory Code (CIFA)] in ('JO')PTnot ([PODs Exist]) in ('Y',' ')[Count of AcctNbr] = 1NOT [Class] in ( 'F', 'T', 'K', 'D', 'G', 'X', 'U', 'Z')NOT [CIF].[CIF Account].[CIF # (CIFA)] = 'RAA0964' [Cert Deposits].[CD Master].[CIF # (CDMA)][Cert Deposits].[CD POD Beneficiary File].[Acct # (CDBENE)][Cert Deposits].[CD POD Beneficiary File].[Beneficiary Percentage (CDBENE)] [Demand Deposit].[DD Master].[CIF # (DDMA)][Demand Deposit].[DD POD Beneficiary File].[Acct # (DDBENE)][Demand Deposit].[DD POD Beneficiary File].[Beneficiary Percentage (DDBENE)][Demand Deposit].[DD POD Beneficiary File].[Acct Type (DDBENE)] [CIF].[Acct. Number (CIFA)] = [CD].[Acct # (CDBENE)] and [CIF].[CIF # (CIFA)] = [CD].[CIF # (CDMA)] [CIF].[Acct. Type (CIFA)][CIF].[Acct. Number (CIFA)][CIF].[CIF # (CIFA)][CIF].[Catagory Code (CIFA)][CIF].[Short Name (CIFA)][CIF].[EOM Balance][CIF].[Total(EOM Balance)][CIF].[Ownership Group][CIF].[Total(EOM Balance)2][CIF].[CIF Relationship (CIFA)][CIF].[Class][CIF].[Ownership Category][CIF].[Count of AcctNbr][CD].[CIF # (CDMA)][CD].[Acct # (CDBENE)][CIF].[Bene Level] [CIF & CD].[Acct. Number (CIFA)] = [DD].[Acct # (DDBENE)] and [CIF & CD].[CIF # (CIFA)] = [DD].[CIF # (DDMA)] if ([Is FDIC Insured] = 'N') then ( [total val] - 250000) else (0)if ( [total val] < 250000) then ('Y') else ('N')total([EOM Balance] for [Ownership Group])[CIF & CD].[Acct. Type (CIFA)][CIF & CD].[Acct. Number (CIFA)][CIF & CD].[CIF # (CIFA)][CIF & CD].[Catagory Code (CIFA)][CIF & CD].[Short Name (CIFA)][CIF & CD].[EOM Balance][CIF & CD].[Ownership Group][CIF & CD].[CIF Relationship (CIFA)][CIF & CD].[Class][CIF & CD].[Ownership Category][CIF & CD].[Data Item1][CIF & CD].[CIF # (CDMA)][CIF & CD].[Acct # (CDBENE)][DD].[CIF # (DDMA)][DD].[Acct # (DDBENE)][DD].[Acct Type (DDBENE)]if ([Bene Level] > 0) then ('Y') else('N')[CIF & CD].[Bene Level]RUNNING-COUNT ( [Excess for Report] FOR [CIF # (CIFA)])TOTAL ( IF ( [Data Item2]=1) THEN ( [Excess for Report] ) ELSE (0) FOR [CIF # (CIFA)])TOTAL ( IF ( [Data Item2]=1) THEN ( [Excess for Report] ) ELSE (0) FOR REPORT) 0[PODs Exist]='N' [Final].[Excess for Report][Final].[Is FDIC Insured][Final].[total val][Final].[Acct. Type (CIFA)][Final].[Acct. Number (CIFA)][Final].[CIF # (CIFA)][Final].[Catagory Code (CIFA)][Final].[Short Name (CIFA)][Final].[EOM Balance][Final].[Ownership Group][Final].[CIF Relationship (CIFA)][Final].[Class][Final].[Ownership Category][Final].[Data Item1][Final].[CIF # (CDMA)][Final].[Acct # (CDBENE)][Final].[CIF # (DDMA)][Final].[Acct # (DDBENE)][Final].[Acct Type (DDBENE)][Final].[PODs Exist][Final].[Total(Excess for Report)][Final].[Bene Level] N[CIF # (CIFA)] = 'BAA0127'/content/folder[@name='Packages']/package[@name='SL_Outlink_P11']/model[@name='model']FDIC Uninsured Analysis (CURRENT)