|
New Variables
|
|
|
|
New variables for March2007
|
Database
|
Report
|
Description
|
|
|
TOTASTFV
|
FTS
|
RC-BAL
|
TOTAL ASSETS FV OPTION - BAL SH
|
|
TOTLIFV
|
FTS
|
RC-BAL
|
TOTAL LIAB FV OPTION - BAL SH
|
|
LNRECNFM
|
FTS
|
RC-C
|
1-4 FAM RE CONSTRUCTION LOANS
|
|
LNRECNOT
|
FTS
|
RC-C
|
OTHER RE CONSTRUCTION & LAND LN
|
|
LNREFNAA
|
FTS
|
RC-C
|
RE 1-4 FAM NEG AMORT - TOTAL AMT
|
|
LNREFNAC
|
FTS
|
RC-C
|
RE 1-4 FAM NEG AMORT-CARRY AMT
|
|
LNREFNAM
|
FTS
|
RC-C
|
RE 1-4 FAM NEG AMORT-MAX REM AMT
|
|
LNRENROT
|
FTS
|
RC-C
|
OTHER NONFARM NONRES RE LNS
|
|
LNRENROW
|
FTS
|
RC-C
|
OWNER-OCC NONFARM NONRES RE LNS
|
|
LSCON
|
FTS
|
RC-C
|
CONSUMER LEASES
|
|
LSOTH
|
FTS
|
RC-C
|
ALL OTHER LEASES
|
|
NTRTMLGR
|
FTS
|
RC-E
|
TIME DEP OVER $100M RETIREMENT
|
|
UCCOMREF
|
FTS
|
RC-L
|
UNUSED COMMIT 1-4 FAM CONSTRUCT
|
|
UCCOMREO
|
FTS
|
RC-L
|
UNUSED COMMIT COM RE & OTH CONST
|
|
NALSCON
|
FTS
|
RC-N
|
NONACCRUAL CONSUMER LEASES
|
|
NALSOTH
|
FTS
|
RC-N
|
NONACCRUAL ALL OTHER LEASES
|
|
NARECNFM
|
FTS
|
RC-N
|
NONACCRUAL 1-4 FAM CONSTRUCT LN
|
|
NARECNOT
|
FTS
|
RC-N
|
NONACCRUAL OTHER CONSTR & LAND
|
|
NARENROT
|
FTS
|
RC-N
|
NONACCRUAL OTHER NONFARM NONRES
|
|
NARENROW
|
FTS
|
RC-N
|
NONACCRUAL 0WN-OCC NONFRM NONRS
|
|
NCLSCON
|
CDI
|
RC-N
|
NONCURRENT CONSUMER LEASES
|
|
NCLSOTH
|
CDI
|
RC-N
|
NONCURRENT ALL OTHER LEASES
|
|
NCRECNFM
|
CDI
|
RC-N
|
N/C 1-4 FAMILY CONSTRUCTION LOAN
|
|
NCRECNOT
|
CDI
|
RC-N
|
N/C OTHER CONSTRUCT & LAND DEV
|
|
NCRENROT
|
CDI
|
RC-N
|
N/C OTHER NONFARM NONRES RE LN
|
|
NCRENROW
|
CDI
|
RC-N
|
N/C OWN-OCCUPIED NONFARM NONRES
|
|
P3LSCON
|
FTS
|
RC-N
|
30-89 DAYS P/D CONSUMER LEASES
|
|
P3LSOTH
|
FTS
|
RC-N
|
30-89 DAYS P/D OTHER LEASES
|
|
P3RECNFM
|
FTS
|
RC-N
|
30-89 DAYS P/D 1-4 FAM CONSTR LN
|
|
P3RECNOT
|
FTS
|
RC-N
|
30-89 DAYS P/D OTH CONSTR & LAND
|
|
P3RENROT
|
FTS
|
RC-N
|
30-89 DAYS P/D OTH NONFRM NONRES
|
|
P3RENROW
|
FTS
|
RC-N
|
30-89 DAYS P/D 0WN-OCC NONF NONRS
|
|
P9LSCON
|
FTS
|
RC-N
|
90+ DAYS P/D CONSUMER LEASES
|
|
P9LSOTH
|
FTS
|
RC-N
|
90+ DAYS P/D ALL OTHER LEASES
|
|
P9RECNFM
|
FTS
|
RC-N
|
90+ DAYS P/D 1-4 FAM CONSTRUC LN
|
|
P9RECNOT
|
FTS
|
RC-N
|
90+ DAYS P/D OTHER CONSTR & LAND
|
|
P9RENROT
|
FTS
|
RC-N
|
90+ DAYS P/D OTHER NONFRM NONRES
|
|
P9RENROW
|
FTS
|
RC-N
|
90+ DAYS P/D 0WN-OCC NONFR NONRS
|
|
DEPALLEX
|
FTS
|
RC-O
|
TOTAL ALLOWABLE EXCLUSIONS
|
|
DEPBEFEX
|
FTS
|
RC-O
|
TOTAL DEPOSIT LIAB BEF EXCLUSION
|
|
DEPDAFEX
|
FTS
|
RC-O
|
TOT DAILY AVG FGN DEP ALLOW EXCL
|
|
DEPDAVEX
|
FTS
|
RC-O
|
TOTAL DAILY AVG ALLOW EXCLUSIONS
|
|
DEPDAVG
|
FTS
|
RC-O
|
TOTAL DEPOSIT DAILY AVG BEF EXCL
|
|
DEPFOREX
|
FTS
|
RC-O
|
TOTAL FOREIGN DEPOSIT ALLOW EXCL
|
|
ISALSZFM
|
FTS
|
RC-P
|
NONINT INC SALE CLOSED 1-4 FM-Q
|
|
DEPBFV
|
FTS
|
RC-Q
|
DEPOSITS TOTAL FV ON BAL SHEET
|
|
DEPL2FV
|
FTS
|
RC-Q
|
DEPOSITS LEVEL 2 FV MEASURE
|
|
DEPL3FV
|
FTS
|
RC-Q
|
DEPOSITS LEVEL 3 FV MEASURE
|
|
LNLSBFV
|
FTS
|
RC-Q
|
LOAN & LS TOTAL FV ON BAL SHEET
|
|
LNLSL2FV
|
FTS
|
RC-Q
|
LOAN AND LEASE LEVEL 2 FV MEASURE
|
|
LNLSL3FV
|
FTS
|
RC-Q
|
LOAN AND LEASE LEVEL 3 FV MEASURE
|
|
NTRSCBFV
|
FTS
|
RC-Q
|
NONTR SEC FV CHANGE IN EARN-BAL
|
|
NTRSL2FV
|
FTS
|
RC-Q
|
NONTR SEC FV CHANGE IN EARN - L2
|
|
NTRSL3FV
|
FTS
|
RC-Q
|
NONTR SEC FV CHANGE IN EARN - L3
|
|
OTASL2FV
|
FTS
|
RC-Q
|
OTH FIN & SER ASSET LEVEL 2 FV
|
|
OTASL3FV
|
FTS
|
RC-Q
|
OTH FIN & SER ASSET LEVEL 3 FV
|
|
OTASTBFV
|
FTS
|
RC-Q
|
OTH FIN & SER ASSET TOTAL FV-BAL
|
|
OTLIBFV
|
FTS
|
RC-Q
|
OTH FIN & SER LIAB TOTAL FV-BAL
|
|
OTLIL2FV
|
FTS
|
RC-Q
|
OTH FIN & SER LIAB LEVEL 2 FV
|
|
OTLIL3FV
|
FTS
|
RC-Q
|
OTH FIN & SER LIAB LEVEL 3 FV
|
|
TRDABFV
|
FTS
|
RC-Q
|
TRADING ASSET TOT FV ON BAL SHEET
|
|
TRDAL2FV
|
FTS
|
RC-Q
|
TRADING ASSET LEVEL 2 FV MEASURE
|
|
TRDAL3FV
|
FTS
|
RC-Q
|
TRADING ASSET LEVEL 3 FV MEASURE
|
|
TRDLBFV
|
FTS
|
RC-Q
|
TRADING LIAB TOTAL FV ON BAL SH
|
|
TRDLL2FV
|
FTS
|
RC-Q
|
TRADING LIAB LEVEL 2 FV MEASURE
|
|
TRDLL3FV
|
FTS
|
RC-Q
|
TRADING LIAB LEVEL 3 FV MEASURE
|
|
UCLNBFV
|
FTS
|
RC-Q
|
LOAN COMMIT TOTAL FV - BAL SHEET
|
|
UCLNL2FV
|
FTS
|
RC-Q
|
LOAN COMMIT LEVEL 2 FV MEASURE
|
|
UCLNL3FV
|
FTS
|
RC-Q
|
LOAN COMMIT LEVEL 3 FV MEASURE
|
|
RBCHLIFV
|
FTS
|
RC-R
|
CHANGE IN FAIR VALUE FIN LIAB
|
|
CRLSCON
|
FTS
|
RI-B
|
CONSUMER LEASE - RECOVERIES
|
|
CRLSCONQ
|
CDI
|
RI-B
|
CONSUMER LEASE RECOVERIES - QTR
|
|
CRLSOTH
|
FTS
|
RI-B
|
ALL OTHER LEASES - RECOVERIES
|
|
CRLSOTHQ
|
CDI
|
RI-B
|
ALL OTHER LEASE RECOVERIES - QTR
|
|
CRRECNFM
|
FTS
|
RI-B
|
1-4 FAM CONSTRUCT LN RECOVERIES
|
|
CRRECNFQ
|
CDI
|
RI-B
|
1-4 FAM CONST LN RECOVERY-QTR
|
|
CRRECNOQ
|
CDI
|
RI-B
|
OTHER CONSTRUCT LN RECOVERIES-QTR
|
|
CRRECNOT
|
FTS
|
RI-B
|
OTHER CONSTRUCT LN RECOVERIES
|
|
CRRENOTQ
|
CDI
|
RI-B
|
OTHER NONFARM NONRES RECOV-QTR
|
|
CRRENOWQ
|
CDI
|
RI-B
|
OWN OCC NONFRM NONRS RECOV-QTR
|
|
CRRENROT
|
FTS
|
RI-B
|
OTHER NONFARM NONRES RECOVERIES
|
|
CRRENROW
|
FTS
|
RI-B
|
OWN-OCCUP NONFARM NONRES RECOV
|
|
DRLSCON
|
FTS
|
RI-B
|
CONSUMER LEASE - CHARGE-OFFS
|
|
DRLSCONQ
|
CDI
|
RI-B
|
CONSUMER LEASE CHG-OFF - QTR
|
|
DRLSOTH
|
FTS
|
RI-B
|
ALL OTHER LEASES - CHARGE-OFFS
|
|
DRLSOTHQ
|
CDI
|
RI-B
|
ALL OTHER LEASES CHG-OFF - QTR
|
|
DRRECNFM
|
FTS
|
RI-B
|
1-4 FAM CONSTRUCT LN CHARGE-OFFS
|
|
DRRECNFQ
|
CDI
|
RI-B
|
1-4 FAM CONST LN CHG-OFF-QTR
|
|
DRRECNOQ
|
CDI
|
RI-B
|
OTHER CONSTRUCT LN CHG-OFF-QTR
|
|
DRRECNOT
|
FTS
|
RI-B
|
OTHER CONSTRUCT LN CHARGE-OFFS
|
|
DRRENOTQ
|
CDI
|
RI-B
|
OTHER NONFARM NONRES CHG-OFF-QTR
|
|
DRRENOWQ
|
CDI
|
RI-B
|
OWN OCC NONFRM NONRS CHG-OFF-QTR
|
|
DRRENROT
|
FTS
|
RI-B
|
OTHER NONFARM NONRES RE CHG-OFF
|
|
DRRENROW
|
FTS
|
RI-B
|
OWN-OCCUP NONFARM NONRES CHG-OFF
|
|
NTLSCON
|
CDI
|
RI-B
|
CONSUMER LEASE NET CHG-OFFS
|
|
NTLSCONA
|
CDI
|
RI-B
|
CONSUMER LEASE NET CHG-OFF ANN
|
|
NTLSCONQ
|
CDI
|
RI-B
|
CONSUMER LEASE NET CHG-OFF-QTR
|
|
NTLSOTH
|
CDI
|
RI-B
|
ALL OTHER LEASES NET CHG-OFFS
|
|
NTLSOTHA
|
CDI
|
RI-B
|
ALL OTHER LEASE NET CHG-OFF ANN
|
|
NTLSOTHQ
|
CDI
|
RI-B
|
ALL OTHER LEASES NET CHG-OFF-QTR
|
|
NTRECNFA
|
CDI
|
RI-B
|
1-4 FAM CONST LN NET CHG-OFF-ANN
|
|
NTRECNFM
|
CDI
|
RI-B
|
1-4 FAM CONST LN NET-OFF
|
|
NTRECNFQ
|
CDI
|
RI-B
|
1-4 FAM CONST LN NET CHG-OFF-QTR
|
|
NTRECNOA
|
CDI
|
RI-B
|
OTHER CONSTRUCT NET CHG-OFF-ANN
|
|
NTRECNOQ
|
CDI
|
RI-B
|
OTHER CONSTRUCT NET CHG-OFF-QTR
|
|
NTRECNOT
|
CDI
|
RI-B
|
OTHER CONSTRUCT NET CHG-OFF
|
|
NTRENOTA
|
CDI
|
RI-B
|
OTH NONFRM NONRS NET CHGOFF-ANN
|
|
NTRENOTQ
|
CDI
|
RI-B
|
OTH NONFRM NONRS NET CHGOFF-QTR
|
|
NTRENOWA
|
CDI
|
RI-B
|
OWN OCC NONFRM NONRS NET CHG-ANN
|
|
NTRENOWQ
|
CDI
|
RI-B
|
OWN OCC NONFRM NONRS NET CHG-QTR
|
|
NTRENROT
|
CDI
|
RI-B
|
OTHER NONFARM NONRS NET CHG-OFF
|
|
NTRENROW
|
CDI
|
RI-B
|
OWN OCC NONFRM NONRS NET CHG-OFF
|
|
IFEEANU
|
FTS
|
RI-INC
|
FEE & COMMISSION ANNUTIY SALES
|
|
IFEEANUA
|
CDI
|
RI-INC
|
FEE & COMM ANNUITY SALES - ANN
|
|
IFEEANUQ
|
CDI
|
RI-INC
|
FEE & COMM ANNUITY SALES - QTR
|
|
IGLCDROQ
|
CDI
|
RI-INC
|
G/L CR DER HEDGE - OTHER - QTR
|
|
IGLCDROT
|
FTS
|
RI-INC
|
G/L CR DER HEDGE - OTHER
|
|
IGLCDRTQ
|
CDI
|
RI-INC
|
G/L CR DER HEDGE - TRADING - QTR
|
|
IGLCDRTR
|
FTS
|
RI-INC
|
G/L CR DER HEDGE - TRADING
|
|
IGLCREX
|
FTS
|
RI-INC
|
TRADING REVENUE- CREDIT EXPOSURE
|
|
IGLCREXQ
|
CDI
|
RI-INC
|
TRADING REV CREDIT EXPOSURE- QTR
|
|
IINVBNK
|
FTS
|
RI-INC
|
INVESTMENT BANK & ADVISORY FEES
|
|
IINVBNKA
|
CDI
|
RI-INC
|
INVEST BANK & ADVISORY FEE - ANN
|
|
IINVBNKQ
|
CDI
|
RI-INC
|
INVEST BANK & ADVISORY FEE - QTR
|
|
ILNREFNG
|
FTS
|
RI-INC
|
NONCASH INC 1-4 FAM NEG AMORT
|
|
ILNREFNQ
|
CDI
|
RI-INC
|
NONCASH INC 1-4 FAM NEG AM - QTR
|
|
ISECBROA
|
CDI
|
RI-INC
|
FEE & COMMISSION SEC BROKER ANN
|
|
ISECBROK
|
FTS
|
RI-INC
|
FEES & COMMISSIONS - SEC BROKER
|
|
ISECBROQ
|
CDI
|
RI-INC
|
FEE & COMMISION SEC BROKER - QTR
|
