ddmast_raw
Core Schemas
>
Silverlake
>
ddmast_raw
Column name | Description | Mode | Type | Length |
---|---|---|---|---|
__op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
__op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
__uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
__ver | Mapping and Schema Version | REQUIRED | INTEGER | |
recid | Record ID | CHAR(1) | NULLABLE | STRING | 1 |
branch | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
acctno | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
actype | Account type | CHAR(1) | NULLABLE | STRING | 1 |
argprdcod | ARGO PRODUCT TYPE | CHAR(3) | NULLABLE | STRING | 3 |
sname | Short name | CHAR(20) | NULLABLE | STRING | 20 |
cifno | CIF number | CHAR(7) | NULLABLE | STRING | 7 |
altadd | Alternate Address | CHAR(1) | NULLABLE | STRING | 1 |
addnam | Additional names | CHAR(1) | NULLABLE | STRING | 1 |
altnam | Alternate name | CHAR(1) | NULLABLE | STRING | 1 |
grp | GL Group Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
glcost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
glprod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
officr | Officer | CHAR(6) | NULLABLE | STRING | 6 |
coffcr | Collection Officer | CHAR(6) | NULLABLE | STRING | 6 |
status | Status | DEC(1,0) | NULLABLE | INTEGER | 1 |
noclos | Close on zero balance | CHAR(1) | NULLABLE | STRING | 1 |
alwrop | Allow Closed Status to Reopen | CHAR(1) | NULLABLE | STRING | 1 |
exclud | Exclude | CHAR(1) | NULLABLE | STRING | 1 |
class | Class | CHAR(1) | NULLABLE | STRING | 1 |
spcode | Stop code | CHAR(1) | NULLABLE | STRING | 1 |
hdcode | Hold code | CHAR(1) | NULLABLE | STRING | 1 |
atcode | Alert code | CHAR(1) | NULLABLE | STRING | 1 |
sicode | Special inst code | CHAR(1) | NULLABLE | STRING | 1 |
pcheck | Print int check | CHAR(1) | NULLABLE | STRING | 1 |
pchact | Disposition Account | DEC(16,0) | NULLABLE | INTEGER | 16 |
pchaty | Disposition Acct Type | CHAR(1) | NULLABLE | STRING | 1 |
datop7 | Date Opened | DEC(7,0) | NULLABLE | INTEGER | 7 |
daten7 | Date Entered | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtod7 | Last Overdrawn | DEC(7,0) | NULLABLE | INTEGER | 7 |
dla7 | Last Active | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlc7 | Last Contact | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlinp7 | Last Interest Paid | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlstm7 | Last Statement | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlflm7 | Last Maintenance | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtldp7 | Last Deposit | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtsc7 | Date S/C Waive Expires | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtcls7 | Date Closed | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtdor7 | Date Last Dormant | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtesc7 | Date Last Escheat | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtcho7 | Date Last Charged Off | DEC(7,0) | NULLABLE | INTEGER | 7 |
convdt7 | Conversion Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
clspnd7 | Closed Pending Status Dt | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlsvchg7 | Date Last Service Charge | DEC(7,0) | NULLABLE | INTEGER | 7 |
datop6 | Date Opened | DEC(6,0) | NULLABLE | INTEGER | 6 |
daten6 | Date Entered | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtod6 | Last Overdrawn | DEC(6,0) | NULLABLE | INTEGER | 6 |
dla6 | Last Active | DEC(6,0) | NULLABLE | INTEGER | 6 |
dlc6 | Last Contact | DEC(6,0) | NULLABLE | INTEGER | 6 |
dlinp6 | Last Interest Paid | DEC(6,0) | NULLABLE | INTEGER | 6 |
dlstm6 | Last Statement | DEC(6,0) | NULLABLE | INTEGER | 6 |
dlflm6 | Last Maintenance | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtldp6 | Last Deposit | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtsc6 | Date S/C Waive Expires | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtcls6 | Date Closed | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtdor6 | Date Last Dormant | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtesc6 | Date Last Escheat | DEC(6,0) | NULLABLE | INTEGER | 6 |
dtcho6 | Date Last Charged Off | DEC(6,0) | NULLABLE | INTEGER | 6 |
convdt6 | Conversion Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
clspnd6 | Closed Pending Status Dt | DEC(6,0) | NULLABLE | INTEGER | 6 |
dlsvchg6 | Date Last Service Charge | DEC(6,0) | NULLABLE | INTEGER | 6 |
amtdp | Amt of last deposit | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
amtlwd | Amt of last withdrawal | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
hold | Hold amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
cbal | Current balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ybal | Yesterday balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
stmbal | Previous stmt bal | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
minbal | Minimum balance | DEC(11,0) | NULLABLE | INTEGER | 11 |
hghbal | Maximum balance | DEC(11,0) | NULLABLE | INTEGER | 11 |
colect | Collected balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
yescol | Collected balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
abal | Available balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
aggday | Aggregate days | DEC(5,0) | NULLABLE | INTEGER | 5 |
aggamt | Aggr ledger bal | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggcol | Aggr coll balance | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggdan | Agg days Ledger negative | DEC(5,0) | NULLABLE | INTEGER | 5 |
aggcon | Agg Led balance negative | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggamn | Agg days Colect negative | DEC(5,0) | NULLABLE | INTEGER | 5 |
agcodn | Agg col balance negative | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggdas | Aggregate days this stmt | DEC(3,0) | NULLABLE | INTEGER | 3 |
aggams | Aggregate ledg this stmt | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggcos | Aggregate coll this stmt | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
minbai | Minimum balance Int cyc | DEC(11,0) | NULLABLE | INTEGER | 11 |
hghbai | Maximum balance Int cyc | DEC(11,0) | NULLABLE | INTEGER | 11 |
aggdai | Aggregate days Int cycle | DEC(5,0) | NULLABLE | INTEGER | 5 |
aggami | Aggr ledger bal Int cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggcoi | Aggr coll bal Int cycle | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
accrue | Accrued interest | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
ystacc | Yesterday accrued int. | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
altacr | Alt accrued int | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
odint | Overdraft interest | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
ytdint | YTD interest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ytdsc | YTD S/C | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
ytdodf | YTD OD Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
ytdnsf | YTD NSF Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
rtckcy | Returned ck chg YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
rtckwy | Returned ck wve YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
odwvey | OD charge waived YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atcrny | No. ATM credits YTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
atdrny | No. ATM debits YTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
ytdscw | Y-T-D Service chg waived | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
feeytd | Y-T-D Fees | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
nocrl | Number of credits prv yr | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcrl | Amt of credits prv yr | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nodrl | Number of debits prv yr | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdrl | Amt of debits prv yr | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
rtckcl | Returned ck chg prv yr | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
rtckwl | Returned ck wve prv yr | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
odwvel | OD charge waived prv yr | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atcrnl | No.Onus ATM credit pr yr | DEC(5,0) | NULLABLE | INTEGER | 5 |
atdrnl | No.Onus ATM debits pr yr | DEC(5,0) | NULLABLE | INTEGER | 5 |
lyscw | Service chg waive prv yr | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
feely | Prev Y-T-D Fees | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
lytdin | Previous YTD int | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lytdsc | Previous YTD S/C | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
lytdof | Previous YTD OD Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
lytdnf | Prev YTD NSF Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
lintpd | Amt of last int Pd | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lscamt | Amt of last S/C | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
stcyc | Statement cycle | DEC(2,0) | NULLABLE | INTEGER | 2 |
stcode | Statement code | CHAR(2) | NULLABLE | STRING | 2 |
intcyc | Interest Cr cycle | DEC(2,0) | NULLABLE | INTEGER | 2 |
sccyc | Service charge cycle | DEC(2,0) | NULLABLE | INTEGER | 2 |
sccode | Service charge code | CHAR(2) | NULLABLE | STRING | 2 |
sctype | Service charge type | CHAR(1) | NULLABLE | STRING | 1 |
dduser | USER CODE | CHAR(2) | NULLABLE | STRING | 2 |
nxstm6 | Next statement date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nxstm7 | Next statement date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stmday | Statement day of month | DEC(2,0) | NULLABLE | INTEGER | 2 |
stmfrc | Statement freq. code | CHAR(1) | NULLABLE | STRING | 1 |
stmfrq | Statement frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
stmpr | Statement print | CHAR(1) | NULLABLE | STRING | 1 |
stmsc | Statement service charge | CHAR(1) | NULLABLE | STRING | 1 |
stmin | Statement credit int. | CHAR(1) | NULLABLE | STRING | 1 |
nodr | Number of debits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdr | Amt of debits | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
nocr | Number of credits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcr | Amt of credits | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
scdr | Number S/C debits | DEC(7,0) | NULLABLE | INTEGER | 7 |
scdra | Amount S/C debits | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
sccr | Number S/C credits | DEC(7,0) | NULLABLE | INTEGER | 7 |
sccra | Amount S/C credits | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
nodrm | Number of debits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdrm | Amt of debits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nocrm | Number of credits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcrm | Amt of credits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nodrc | Number of debits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdrc | Amt of debits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nocrc | Number of credits | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcrc | Amt of credits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nocry | Number of credits YTD | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcry | Amt of credits YTD | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nodry | Number of debits YTD | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdry | Amt of debits YTD | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
scdrc | Number S/C debits | DEC(7,0) | NULLABLE | INTEGER | 7 |
scdrac | Amount S/C debits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
sccrc | Number S/C credits | DEC(7,0) | NULLABLE | INTEGER | 7 |
sccrac | Amount S/C credits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nodrp | Number of debits Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtdrp | Amt of debits Prv Cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
nocrp | Number of credit Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtcrp | Amt of credits Prv Cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
onsckp | # Cks Dep-On Us Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
forckp | #Cks Dep-Foreign Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
loclckp | #Cks Dep-Local Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
aggdyp | Aggregate days Prv Cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
aggamp | Aggr ledger bal Prv Cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggcop | Aggr coll bal Prv Cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
ddagdp | Reg DD Agg days Prv Cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddagbp | Reg DD Agg bal Prv Cyc | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
minbalp | Minimum balance Prv Cyc | DEC(13,0) | NULLABLE | INTEGER | 13 |
cbalp | Current balance Prv Cyc | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
scdrcp | Number S/C debits Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
sccrcp | Number S/C credits Prv Cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
atcrno | No. of Onus ATM credits | DEC(5,0) | NULLABLE | INTEGER | 5 |
atcrao | Amt of Onus ATM credits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atdrno | No. of Onus ATM debits | DEC(5,0) | NULLABLE | INTEGER | 5 |
atdrao | Amt of Onus ATM dedits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
attfno | No. of Onus ATM Transfer | DEC(5,0) | NULLABLE | INTEGER | 5 |
attfao | Amt of Onus ATM Transfer | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atiqno | No. of Onus ATM Inquirys | DEC(5,0) | NULLABLE | INTEGER | 5 |
atcrnf | No. of Frgn ATM credits | DEC(5,0) | NULLABLE | INTEGER | 5 |
atcraf | Amt of Frgn ATM credits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atdrnf | No. of Frgn ATM debits | DEC(5,0) | NULLABLE | INTEGER | 5 |
atdraf | Amt of Frgn ATM dedits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
attfnf | No. of Frgn ATM Transfer | DEC(5,0) | NULLABLE | INTEGER | 5 |
attfaf | Amt of Frgn ATM Transfer | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
atiqnf | No. of Frgn ATM Inquirys | DEC(5,0) | NULLABLE | INTEGER | 5 |
atisd6 | ATM card issue date | DEC(6,0) | NULLABLE | INTEGER | 6 |
atisd7 | ATM card issue date | DEC(7,0) | NULLABLE | INTEGER | 7 |
amtnsf | Amount NSF | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
odlmt | Overdraft limit code | DEC(1,0) | NULLABLE | INTEGER | 1 |
odmcde | OD privilege status | CHAR(1) | NULLABLE | STRING | 1 |
sgcode | Signature verify | CHAR(1) | NULLABLE | STRING | 1 |
chkgty | Check guaranty card | CHAR(1) | NULLABLE | STRING | 1 |
atmcrd | ATM card | CHAR(1) | NULLABLE | STRING | 1 |
combin | Include Comb Stmt | CHAR(1) | NULLABLE | STRING | 1 |
malhld | Hold mail | CHAR(1) | NULLABLE | STRING | 1 |
autnsf | Automatic NSF charge | CHAR(1) | NULLABLE | STRING | 1 |
codchg | Charge Continuous OD Fee | CHAR(1) | NULLABLE | STRING | 1 |
codfee | Continuous OD Fee Min. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
codfmx | Continuous OD Fee Max. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
codfpc | Continuous OD Fee Pct. | DEC(3,3) | NULLABLE | FLOAT | 3.3 |
codfdy | No. of Days Before Fee | DEC(3,0) | NULLABLE | INTEGER | 3 |
codfbl | OD Balance Start Fee | DEC(5,0) | NULLABLE | INTEGER | 5 |
hivol | High Volume Acct | CHAR(1) | NULLABLE | STRING | 1 |
timod | Times OD this cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
timod1 | Times OD this qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timod2 | Times OD 2nd qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timod3 | Times OD 3rd qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timod4 | Times OD 4th qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timod5 | Times OD 5th qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
odlsyr | Times OD last yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
odltd | Times OD Life | DEC(5,0) | NULLABLE | INTEGER | 5 |
itmod | Items OD This cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmod1 | Items OD This Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmod2 | Items OD 2nd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmod3 | Items OD 3rd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmod4 | Items OD 4th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmod5 | Items OD 5th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itodly | Items OD Last Year | DEC(7,0) | NULLABLE | INTEGER | 7 |
itodlt | Items OD Life to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
dysod | Days OD This cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysod1 | Days OD This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysod2 | Days OD 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysod3 | Days OD 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysod4 | Days OD 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysod5 | Days OD 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dyodly | Days OD Last Yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dyodlt | Days OD L-T-D | DEC(5,0) | NULLABLE | INTEGER | 5 |
cdyod | Consec days OD | DEC(5,0) | NULLABLE | INTEGER | 5 |
relact | Related Acct No | DEC(16,0) | NULLABLE | INTEGER | 16 |
racttp | Related Acct Type | CHAR(1) | NULLABLE | STRING | 1 |
onusck | # Cks Deposit-On Us | DEC(7,0) | NULLABLE | INTEGER | 7 |
fornck | #Cks Dep - Foreign | DEC(7,0) | NULLABLE | INTEGER | 7 |
loclck | #Cks Deposit-Local | DEC(7,0) | NULLABLE | INTEGER | 7 |
lstpst | List Post Code | CHAR(1) | NULLABLE | STRING | 1 |
rate | Interest Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
rate_num_ | Override Rate Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
pvar | Rate Variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
pvar1 | Rate Variance Code | CHAR(1) | NULLABLE | STRING | 1 |
pfloor | Rate Floor | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
pceil | Rate Ceiling | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
revdt7 | Rate review date | DEC(7,0) | NULLABLE | INTEGER | 7 |
revdt6 | Rate review date | DEC(6,0) | NULLABLE | INTEGER | 6 |
term | Rate review term | DEC(3,0) | NULLABLE | INTEGER | 3 |
termcd | Rate review term cd | CHAR(1) | NULLABLE | STRING | 1 |
dr3 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6 | No Drs up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3ltd | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6ltd | LTD #6 CTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc | # Dr up to 6 Exceed | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3excy | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6excy | YTD # Dr up to 6 Exceed | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3excl | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6excl | LTD # Dr up to 6 Exceed | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc01 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc02 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc03 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc04 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc05 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc06 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc07 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc08 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc09 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc10 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc11 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr3exc12 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc01 | Period 1 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc02 | Period 2 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc03 | Period 3 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc04 | Period 4 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc05 | Period 5 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc06 | Period 6 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc07 | Period 7 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc08 | Period 8 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc09 | Period 9 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc10 | Period10 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc11 | Period11 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr6exc12 | Period12 # Dr up to 6 Ex | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr301 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr302 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr303 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr304 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr305 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr306 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr307 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr308 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr309 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr310 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr311 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr312 | No Longer Used | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr601 | Period 1 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr602 | Period 2 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr603 | Period 3 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr604 | Period 4 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr605 | Period 5 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr606 | Period 6 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr607 | Period 7 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr608 | Period 8 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr609 | Period 9 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr610 | Period 10 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr611 | Period 11 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dr612 | Period 12 # Dr up to 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cashdp | Cash Dep This Cycle | DEC(11,0) | NULLABLE | INTEGER | 11 |
feectd | Cycle-T-D Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
cashpo | Cash Pd This Cycle | DEC(11,0) | NULLABLE | INTEGER | 11 |
qagday | Aggr Days This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
qagbal | Agr Led Bal This Qtr | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
qagcol | Agr Col Bal This Qtr | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aledq1 | Avg Led Bal Pqtr 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
aledq2 | Avg Led Bal Pqtr 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
aledq3 | Avg Led Bal Pqtr 3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
aledq4 | Avg Led Bal Pqtr 4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
acolq1 | Avg Col Bal Pqtr 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
acolq2 | Avg Col Bal Pqtr 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
acolq3 | Avg Col Bal Pqtr 3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
acolq4 | Avg Col Bal Pqtr 4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddaggd | Reg DD Agg days | DEC(5,0) | NULLABLE | INTEGER | 5 |
ddaggb | Reg DD Agg bal | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
ddinte | Reg DD Int earned | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
ddsic1 | Special Info Code 1 | CHAR(1) | NULLABLE | STRING | 1 |
ddsic2 | Special Info Code 2 | CHAR(1) | NULLABLE | STRING | 1 |
ddsic3 | Special Info Code 3 | CHAR(1) | NULLABLE | STRING | 1 |
ddsic4 | Special Info Code 4 | CHAR(1) | NULLABLE | STRING | 1 |
spmesg | Special Message | CHAR(1) | NULLABLE | STRING | 1 |
xmaspl | Club plan | DEC(1,0) | NULLABLE | INTEGER | 1 |
timrt | Times Returned this cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
timrt1 | Times Returned this qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timrt2 | Times Returned 2nd qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timrt3 | Times Returned 3rd qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timrt4 | Times Returned 4th qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
timrt5 | Times Returned 5th qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
rtlsyr | Times Returned last yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
rtltd | Times Returns Life | DEC(5,0) | NULLABLE | INTEGER | 5 |
itmrt | Items Returns This cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmrt1 | Items Returns This Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmrt2 | Items Returns 2nd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmrt3 | Items Returns 3rd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmrt4 | Items Returns 4th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmrt5 | Items Returns 5th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itrtly | Items Returns Last Year | DEC(7,0) | NULLABLE | INTEGER | 7 |
itrtlt | Items Returns L-T-D | DEC(7,0) | NULLABLE | INTEGER | 7 |
dysrt | Days RT This cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysrt1 | Days RT This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysrt2 | Days RT 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysrt3 | Days RT 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysrt4 | Days RT 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysrt5 | Days RT 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dyrtly | Days RT Last Yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dyrtlt | Days RT L-T-D | DEC(5,0) | NULLABLE | INTEGER | 5 |
cdyrt | Consec days RT | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnsf | Times NSF This cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfq1 | Times NSF This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfq2 | Times NSF 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfq3 | Times NSF 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfq4 | Times NSF 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfq5 | Times NSF 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnfly | Times NSF Last Year | DEC(3,0) | NULLABLE | INTEGER | 3 |
tnfltd | Times NSF Life to Date | DEC(5,0) | NULLABLE | INTEGER | 5 |
itmnsf | Items NSF This cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfq1 | Items NSF This Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfq2 | Items NSF 2nd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfq3 | Items NSF 3rd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfq4 | Items NSF 4th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfq5 | Items NSF 5th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmfly | Items NSF Last Year | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmflt | Items NSF Life to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
dysnsf | Days NSF This cyc | DEC(5,0) | NULLABLE | INTEGER | 5 |
dysfq1 | Days NSF This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysfq2 | Days NSF 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysfq3 | Days NSF 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysfq4 | Days NSF 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysfq5 | Days NSF 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysfly | Days NSF Last Yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysflt | Days NSF L-T-D | DEC(5,0) | NULLABLE | INTEGER | 5 |
cdynsf | Consec days NSF | DEC(5,0) | NULLABLE | INTEGER | 5 |
ttflot | Total Accrual Float | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ttflav | Tot Availibility Float | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ttflca | Total Cash Float | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
noencl | # Enclosures | DEC(7,0) | NULLABLE | INTEGER | 7 |
eftflg | EFT Flag | CHAR(1) | NULLABLE | STRING | 1 |
minchg | Minimum Charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
nsfmax | Maximum NSF Charge | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
odimax | Maximum OD Charge | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
fluc_num_m | #-Fluctuation MTD | DEC(2,0) | NULLABLE | INTEGER | 2 |
fluc_num_y | #-Fluctuation YTD | DEC(3,0) | NULLABLE | INTEGER | 3 |
kite_num_ | #-Kite Cycle Suspect Rpt | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_ | #-Kite Daily Suspect Mth | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkityr | #-Kite Daily Suspect YTD | DEC(3,0) | NULLABLE | INTEGER | 3 |
smsa | SMSA Number | DEC(5,0) | NULLABLE | INTEGER | 5 |
craloc | CRA Location | DEC(9,0) | NULLABLE | INTEGER | 9 |
zipcod | Zip Code | DEC(9,0) | NULLABLE | INTEGER | 9 |
indcod | Standard Ind. Code | DEC(4,0) | NULLABLE | INTEGER | 4 |
census | Census Tract | DEC(7,2) | NULLABLE | FLOAT | 7.2 |
whcode | Fed W/H code | DEC(1,0) | NULLABLE | INTEGER | 1 |
whscod | State W/H code | DEC(1,0) | NULLABLE | INTEGER | 1 |
state | State | CHAR(2) | NULLABLE | STRING | 2 |
crasta | CRA State Code | DEC(2,0) | NULLABLE | INTEGER | 2 |
county | County Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
wdate6 | Date W/H code changed | DEC(6,0) | NULLABLE | INTEGER | 6 |
wdate7 | Date W/H code changed | DEC(7,0) | NULLABLE | INTEGER | 7 |
waltac | Alternate acct# | DEC(16,0) | NULLABLE | INTEGER | 16 |
walttp | Alternate acct type | CHAR(1) | NULLABLE | STRING | 1 |
waltrt | Fed W/H alternate rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
waltsr | State W/H alternate rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
whmtd | Fed W/H M-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whqtd | Fed W/H Q-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whytd | Fed W/H Y-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whsmtd | State W/H M-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whsqtd | State W/H Q-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whsytd | State W/H Y-T-D | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whlyr | Fed W/H last year | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
whslyr | State W/H last year | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
nfcode | NSF items exist | CHAR(1) | NULLABLE | STRING | 1 |
afcode | AFT code | CHAR(1) | NULLABLE | STRING | 1 |
aacode | A/A code | CHAR(1) | NULLABLE | STRING | 1 |
mailcd | Mail Code | CHAR(4) | NULLABLE | STRING | 4 |
stmpas | Stmt/passbook code | CHAR(1) | NULLABLE | STRING | 1 |
tlrinq | Special instruction code | CHAR(1) | NULLABLE | STRING | 1 |
prtcko | Print checks in ck order | CHAR(1) | NULLABLE | STRING | 1 |
trunc | Item Truncation | CHAR(1) | NULLABLE | STRING | 1 |
iperpg | Images per Page | DEC(2,0) | NULLABLE | INTEGER | 2 |
ifrobk | Images Front/Back | DEC(1,0) | NULLABLE | INTEGER | 1 |
ickord | Image Check Order | CHAR(1) | NULLABLE | STRING | 1 |
icreds | Image Credits | CHAR(1) | NULLABLE | STRING | 1 |
rpblk_num_ | Repo Block Number | DEC(7,0) | NULLABLE | INTEGER | 7 |
mtdsc | M-T-D Service charge | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
mtdint | M-T-D Interest paid | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
mtdagb | M-T-D Aggregate bals | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
mtdcol | M-T-D Aggregate bals | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
mtdagd | M-T-D Aggregate days | DEC(3,0) | NULLABLE | INTEGER | 3 |
mtdintacc | M-T-D Interest Accrued | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
rtckcm | Returned ck chg MTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
rtckwm | Returned ck wve MTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
odchgm | OD charge MTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
odwvem | OD charge waived MTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
retckm | No.returned check MTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
timodm | Times OD MTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
timnfm | Times NSF MTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
minblm | Minimum balance MTD | DEC(11,0) | NULLABLE | INTEGER | 11 |
hghblm | Maximum balance MTD | DEC(11,0) | NULLABLE | INTEGER | 11 |
mtdscw | M-T-D Service chg waived | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
feemtd | M-T-D Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
cgoamt | Charged-off amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
secure | Account Level Security | CHAR(1) | NULLABLE | STRING | 1 |
prtmmdc | MMD Notice Printed | CHAR(1) | NULLABLE | STRING | 1 |
prtmmdd6 | MMD Notice Date Printed | DEC(6,0) | NULLABLE | INTEGER | 6 |
prtmmdd7 | MMD Notice Date Printed | DEC(7,0) | NULLABLE | INTEGER | 7 |
dt6not_num_1 | Date MMD not/let #1 sent | DEC(6,0) | NULLABLE | INTEGER | 6 |
dt7not_num_1 | Date MMD not/let #1 sent | DEC(7,0) | NULLABLE | INTEGER | 7 |
dt6not_num_2 | Date MMD not/let #2 sent | DEC(6,0) | NULLABLE | INTEGER | 6 |
dt7not_num_2 | Date MMD not/let #2 sent | DEC(7,0) | NULLABLE | INTEGER | 7 |
dt6not_num_3 | Date MMD not/let #3 sent | DEC(6,0) | NULLABLE | INTEGER | 6 |
dt7not_num_3 | Date MMD not/let #3 sent | DEC(7,0) | NULLABLE | INTEGER | 7 |
dt6not_num_4 | Date MMD not/let #4 sent | DEC(6,0) | NULLABLE | INTEGER | 6 |
dt7not_num_4 | Date MMD not/let #4 sent | DEC(7,0) | NULLABLE | INTEGER | 7 |
dt6not_num_5 | Date MMD not/let #5 sent | DEC(6,0) | NULLABLE | INTEGER | 6 |
dt7not_num_5 | Date MMD not/let #5 sent | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddpic1 | Programmer Use #1 | CHAR(2) | NULLABLE | STRING | 2 |
ddpic2 | Programmer Use #2 | CHAR(2) | NULLABLE | STRING | 2 |
ddpdt1 | Programmer DATE #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddpd61 | Programmer DATE #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
ddpdt2 | Programmer DATE #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddpd62 | Programmer DATE #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
ddpam1 | Programmer AMT #1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddpam2 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
usagb1 | User agg balance #1 | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
usagb2 | User agg balance #2 | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
usagd1 | User agg days #1 | DEC(5,0) | NULLABLE | INTEGER | 5 |
usagd2 | User agg days #2 | DEC(5,0) | NULLABLE | INTEGER | 5 |
us1dt6 | User date 6 #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
us1dt7 | User date 7 #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
us2dt6 | User date 6 #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
us2dt7 | User date 7 #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
usalf1 | User alpha #1 | CHAR(30) | NULLABLE | STRING | 30 |
usalf2 | User alpha #2 | CHAR(30) | NULLABLE | STRING | 30 |
usnum1 | User numeric #1 | DEC(11,0) | NULLABLE | INTEGER | 11 |
usnum2 | User numeric #2 | DEC(11,0) | NULLABLE | INTEGER | 11 |
cgibkc | Chg Back Itm cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibkm | Chg Back Itm month | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibk1 | Chg Back Itm qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibk2 | Chg Back Itm p qtr 1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibk3 | Chg Back Itm p qtr 2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibk4 | Chg Back Itm p qtr 3 | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgibk5 | Chg Back Itm p qtr 4 | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgilyr | Chg Back Itm last yr | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgiltd | Chg Back Itm life | DEC(7,0) | NULLABLE | INTEGER | 7 |
cgtbkc | Chg Back Tim cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbkm | Chg Back Tim month | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbk1 | Chg Back Tim qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbk2 | Chg Back Tim p qtr 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbk3 | Chg Back Tim p qtr 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbk4 | Chg Back Tim p qtr 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtbk5 | Chg Back Tim p qtr 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtlyr | Chg Back Tim last yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
cgtltd | Chg Back Tim life | DEC(5,0) | NULLABLE | INTEGER | 5 |
ddregp | Privacy Act opt out | CHAR(1) | NULLABLE | STRING | 1 |
callrep | Call report code | CHAR(8) | NULLABLE | STRING | 8 |
intcalyr | Calendar year interest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
oakbifamt | Oakar purchase from BIF | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
oakbifdt6 | Oakar purchase date | DEC(6,0) | NULLABLE | INTEGER | 6 |
oakbifdt7 | Oakar purchase date | DEC(7,0) | NULLABLE | INTEGER | 7 |
oaksaifamt | Oakar purchase from SAIF | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
oaksaifdt6 | Oakar purchase date | DEC(6,0) | NULLABLE | INTEGER | 6 |
oaksaifdt7 | Oakar purchase date | DEC(7,0) | NULLABLE | INTEGER | 7 |
oakarsold | Oakar sold/transferred | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
oakarsold6 | Oakar sold/transfer date | DEC(6,0) | NULLABLE | INTEGER | 6 |
oakarsold7 | Oakar sold/transfer date | DEC(7,0) | NULLABLE | INTEGER | 7 |
fdicinsurd | FDIC insured institution | CHAR(1) | NULLABLE | STRING | 1 |
bifmember | BIF Member flag | CHAR(1) | NULLABLE | STRING | 1 |
saifmember | SAIF Member flag | CHAR(1) | NULLABLE | STRING | 1 |
ddcycperd_num_ | # cycles current period | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddstmperd_num_ | # stmts curr period | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddstcyrsfq | Stmt/Cyc reset freq | CHAR(1) | NULLABLE | STRING | 1 |
ddstcycgfq | Stmt/Cyc charge freq | CHAR(1) | NULLABLE | STRING | 1 |
ddcycchg_num_ | # chg cycles curr period | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddstmchg_num_ | # chg print curr period | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddstmfmtcd | Format Code | CHAR(10) | NULLABLE | STRING | 10 |
ddctdwaive | Cycle to date Waived | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdwaive | Month to date Waived | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddqtdwaive | Quarter to date Waived | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdwaive | Year to date Waived | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdwaive | Life to date Waived | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddclosedrs | Closed reason Code | CHAR(2) | NULLABLE | STRING | 2 |
ddpyinteom | Pay interest thru end of month | CHAR(1) | NULLABLE | STRING | 1 |
aggdainp | Agg days interest cycle - next period | DEC(5,0) | NULLABLE | INTEGER | 5 |
aggaminp | Agg ledger int cycle - next period | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
aggcoinp | Agg collected int cycle - next period | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
ddaggdnp | Reg DD agg days - next period | DEC(5,0) | NULLABLE | INTEGER | 5 |
ddaggbnp | Reg DD agg bal - next period | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
ddintenp | Reg DD int earned - next' period | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
ddodnotdy1 | OD notice days #1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdy2 | OD notice days #2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdy3 | OD notice days #3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdy4 | OD notice days #4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdy5 | OD notice days #5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdy6 | OD notice days #6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ddodnotdt6 | Last OD notice date 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
ddodnotdt7 | Last OD notice date 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddodnotsnt | Last OD notice # sent | DEC(1,0) | NULLABLE | INTEGER | 1 |
pstaftnsf | Post AFT if NSF | CHAR(1) | NULLABLE | STRING | 1 |
ltdscw | Life to Date SC Waived | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
dkite_num_01 | TIMES KITE SUSPECT MTD01 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_02 | TIMES KITE SUSPECT MTD02 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_03 | TIMES KITE SUSPECT MTD03 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_04 | TIMES KITE SUSPECT MTD04 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_05 | TIMES KITE SUSPECT MTD05 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_06 | TIMES KITE SUSPECT MTD06 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_07 | TIMES KITE SUSPECT MTD07 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_08 | TIMES KITE SUSPECT MTD08 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_09 | TIMES KITE SUSPECT MTD09 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_10 | TIMES KITE SUSPECT MTD10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_11 | TIMES KITE SUSPECT MTD11 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_12 | TIMES KITE SUSPECT MTD12 | DEC(3,0) | NULLABLE | INTEGER | 3 |
dkite_num_st | TIMES KITE SUSPECT STD | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st01 | TIMES KITE SUSPECT STD01 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st02 | TIMES KITE SUSPECT STD02 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st03 | TIMES KITE SUSPECT STD03 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st04 | TIMES KITE SUSPECT STD04 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st05 | TIMES KITE SUSPECT STD05 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st06 | TIMES KITE SUSPECT STD06 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st07 | TIMES KITE SUSPECT STD07 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st08 | TIMES KITE SUSPECT STD08 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st09 | TIMES KITE SUSPECT STD09 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st10 | TIMES KITE SUSPECT STD10 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st11 | TIMES KITE SUSPECT STD11 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_st12 | TIMES KITE SUSPECT STD12 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_q | TIMES KITE SUSPECT QTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_q01 | TIMES KITE SUSPECT QTD01 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_q02 | TIMES KITE SUSPECT QTD02 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_q03 | TIMES KITE SUSPECT QTD03 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_q04 | TIMES KITE SUSPECT QTD04 | DEC(5,0) | NULLABLE | INTEGER | 5 |
dkite_num_ltd | TIMES KITE SUSPECT LTD | DEC(7,0) | NULLABLE | INTEGER | 7 |
dkitepyr | TIMES KITE SUSPECT PREV YEAR | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_m01 | TIMES BALANCE SUSP MTD01 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m02 | TIMES BALANCE SUSP MTD02 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m03 | TIMES BALANCE SUSP MTD03 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m04 | TIMES BALANCE SUSP MTD04 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m05 | TIMES BALANCE SUSP MTD05 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m06 | TIMES BALANCE SUSP MTD06 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m07 | TIMES BALANCE SUSP MTD07 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m08 | TIMES BALANCE SUSP MTD08 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m09 | TIMES BALANCE SUSP MTD09 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m10 | TIMES BALANCE SUSP MTD10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m11 | TIMES BALANCE SUSP MTD11 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_m12 | TIMES BALANCE SUSP MTD12 | DEC(3,0) | NULLABLE | INTEGER | 3 |
fluc_num_st | TIMES BALANCE SUSP STD | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st01 | TIMES BALANCE SUSP STD01 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st02 | TIMES BALANCE SUSP STD02 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st03 | TIMES BALANCE SUSP STD03 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st04 | TIMES BALANCE SUSP STD04 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st05 | TIMES BALANCE SUSP STD05 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st06 | TIMES BALANCE SUSP STD06 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st07 | TIMES BALANCE SUSP STD07 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st08 | TIMES BALANCE SUSP STD08 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st09 | TIMES BALANCE SUSP STD09 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st10 | TIMES BALANCE SUSP STD10 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st11 | TIMES BALANCE SUSP STD11 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_st12 | TIMES BALANCE SUSP STD12 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_q | TIMES BALANCE SUSP QTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_q01 | TIMES BALANCE SUSP QTD01 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_q02 | TIMES BALANCE SUSP QTD02 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_q03 | TIMES BALANCE SUSP QTD03 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_q04 | TIMES BALANCE SUSP QTD04 | DEC(5,0) | NULLABLE | INTEGER | 5 |
fluc_num_ltd | TIMES BALANCE SUSP LTD | DEC(7,0) | NULLABLE | INTEGER | 7 |
fluc_num_pyr | TIMES BALANCE SUSP PREV YEAR | DEC(5,0) | NULLABLE | INTEGER | 5 |
frdalrt | Fraud Alert | CHAR(1) | NULLABLE | STRING | 1 |
chaltacct | Alt. account for chargebacks | DEC(16,0) | NULLABLE | INTEGER | 16 |
chaltacty | Alt. chg. acct. type | CHAR(1) | NULLABLE | STRING | 1 |
allredep | Allow Redeposits | CHAR(1) | NULLABLE | STRING | 1 |
noredep | Number of Redeposits | DEC(1,0) | NULLABLE | INTEGER | 1 |
sndredpno | Send redeposit notice | CHAR(1) | NULLABLE | STRING | 1 |
rditcy | Redeposit Items cycle | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditmo | Redeposit Items month | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditq1 | Redeposit Items QTR | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditq2 | Redeposit Items Prv QR1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditq3 | Redeposit Items PRV QTR2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditq4 | Redeposit Items PRV QTR2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
rditq5 | Redeposit Items PRV QTR3 | DEC(7,0) | NULLABLE | INTEGER | 7 |
rdilyr | Redeposit Items last YR | DEC(7,0) | NULLABLE | INTEGER | 7 |
rdiltd | Redepoits Items LTD | DEC(7,0) | NULLABLE | INTEGER | 7 |
rdtmcy | Redeposit Times cycle | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmmo | Redeposit Times month | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmq1 | Redeposit Times QTR | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmq2 | Redeposit Times Prv QR1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmq3 | Redeposit Times PRV QTR2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmq4 | Redeposit Times PRV QTR2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtmq5 | Redeposit Times PRV QTR3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtlyr | Redeposit Times last YR | DEC(3,0) | NULLABLE | INTEGER | 3 |
rdtltd | Redepoits Times LTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
ddjha1 | User alpha field | CHAR(2) | NULLABLE | STRING | 2 |
ddjha2 | User alpha field | CHAR(2) | NULLABLE | STRING | 2 |
ddjha3 | User alpha field | CHAR(2) | NULLABLE | STRING | 2 |
ddjha4 | User alpha field | CHAR(2) | NULLABLE | STRING | 2 |
ddjha11 | User numeric field | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddjha12 | User numeric field | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddjha13 | User numeric field | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddjha14 | User numeric field | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddjha61 | User date field(6) | DEC(6,0) | NULLABLE | INTEGER | 6 |
ddjha71 | User date field(7) | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddctdrevop | Cycle to date revenue opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdrevop | Month to date revenue opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddqtdrevop | Quarter to date revenue opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdrevop | Year to date revenue opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdrevop | Life to date revenue opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdscrev | Month to date ser. chg. rev. opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdscrev | Year to date ser. chg. rev. opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdscrev | Life to date ser. chg. rev. opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddpyrscrev | Prv. Year to date ser. chg. rev. opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddctdfeecg | Cycle to date fees charged | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdfeecg | Month to date fees charged | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddqtdfeecg | Quarter to date fees charged | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdfeecg | Year to date fees charged | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdfeecg | Life to date fees charged | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdfeesc | Year to date ser. chg. fees chrgd | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdfeesc | Life to date ser. chg. fees chrgd | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddpyrfeesc | Prv. Year to date ser. chg. fees chrgd | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddctdlosop | Cycle to date Lost opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdlosop | Month to date Lost opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddqtdlosop | Quarter to date Lost opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdlosop | Year to date Lost opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdlosop | Life to date Lost opportunity | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdloscg | Month to date ser. chg. lost opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdloscg | Year to date ser. chg. lost opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdloscg | Life to date ser. chg. lost opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddpyrloscg | Prv. Year to date ser. chg. lost opp. | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddctdrefnd | Cycle to date refund | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddmtdrefnd | Month to date refund | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddqtdrefnd | Quarter to date refund | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddytdrefnd | Year to date refund | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ddltdrefnd | Life to date refund | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ucfmax | Maximum UCF Charge | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
tmucf | Times UCF This cyc | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfq1 | Times UCF This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfq2 | Times UCF 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfq3 | Times UCF 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfq4 | Times UCF 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfq5 | Times UCF 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmnucfly | Times UCF Last Year | DEC(3,0) | NULLABLE | INTEGER | 3 |
tnucfltd | Times UCF Life to Date | DEC(5,0) | NULLABLE | INTEGER | 5 |
itmucf | Items UCF This cyc | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfq1 | Items UCF This Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfq2 | Items UCF 2nd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfq3 | Items UCF 3rd Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfq4 | Items UCF 4th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfq5 | Items UCF 5th Qtr | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucfly | Items UCF Last Year | DEC(7,0) | NULLABLE | INTEGER | 7 |
itmucflt | Items UCF Life to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
dysucf | Days UCF This cyc | DEC(5,0) | NULLABLE | INTEGER | 5 |
dysucfq1 | Days UCF This Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucfq2 | Days UCF 2nd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucfq3 | Days UCF 3rd Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucfq4 | Days UCF 4th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucfq5 | Days UCF 5th Qtr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucfly | Days UCF Last Yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
dysucflt | Days UCF L-T-D | DEC(5,0) | NULLABLE | INTEGER | 5 |
cdyucf | Consec days UCF | DEC(5,0) | NULLABLE | INTEGER | 5 |
ytducf | YTD UCF Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
lytducf | Prev YTD UCF Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
amtucf | Amount UCF | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
timucfm | Times UCF MTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
salesac | Sales Associate | CHAR(15) | NULLABLE | STRING | 15 |
odrgrpt | OD Reg Report | CHAR(1) | NULLABLE | STRING | 1 |
odunlimit | OD Unused Limit | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
odcrlimit | OD Credit Limit | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
oduslimit | OD Used Limit | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
odrpttype | OD Report Type | CHAR(1) | NULLABLE | STRING | 1 |
hsatype | HSA Type | CHAR(1) | NULLABLE | STRING | 1 |
stdnsfp | STD NSF Chgs-Paid Items for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
stdnsfr | STD NSF Chgs-Ret Items for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
stdodac | STD OD Accrual Charges for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdnsfp | YTD NSF Chgs-Paid Items for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdnsfr | YTD NSF Chgs-Ret Items for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdodac | YTD OD Accrual Charges for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
tdynsfc | Today NSF Charges for RegDD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
codday | OD charge business or actual days | CHAR(1) | NULLABLE | STRING | 1 |
byracr | Begin. year accrued int. | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
coddaycn | OD count business or actual days | CHAR(1) | NULLABLE | STRING | 1 |
cdyodbus | Consec days OD business days | DEC(5,0) | NULLABLE | INTEGER | 5 |
achcr_mon_ | ACH credits s/c cycle | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
achcr_num_ | ACH credits s/c cycle | DEC(5,0) | NULLABLE | INTEGER | 5 |
achdr_mon_ | ACH debits s/c cycle | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
achdr_num_ | ACH debits s/c cycle | DEC(5,0) | NULLABLE | INTEGER | 5 |
msavltab1 | Available Bal table #1 | DEC(4,0) | NULLABLE | INTEGER | 4 |
msavltab2 | Available Bal table #2 | DEC(4,0) | NULLABLE | INTEGER | 4 |
regagg | Regulatory Agg for Uninsured Deposits | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
pytdpdod | Prev YTD Paid Item/OD Charge | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
pytdrtit | Prev YTD Return Item Charge | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddlang | Language Code | CHAR(3) | NULLABLE | STRING | 3 |
ddpscod | Paper Statement Code | CHAR(2) | NULLABLE | STRING | 2 |
ddpsfecode | Paper Stmt Fee Code | CHAR(2) | NULLABLE | STRING | 2 |
regccnew | RegCC New Trans Acct | CHAR(1) | NULLABLE | STRING | 1 |
ddimgactfe | Image Act Fee | CHAR(1) | NULLABLE | STRING | 1 |
wrwvcode | Waive Reason Code | CHAR(2) | NULLABLE | STRING | 2 |
crdopt | Card Opt in/out | CHAR(1) | NULLABLE | STRING | 1 |
crdoptb | Card Opt in/out current business | CHAR(1) | NULLABLE | STRING | 1 |
crdopte | Card Opt in/out EIP | CHAR(1) | NULLABLE | STRING | 1 |
crdoptdt6 | Card Opt in/out date changed | DEC(6,0) | NULLABLE | INTEGER | 6 |
crdoptdt7 | Card Opt in/out date changed | DEC(7,0) | NULLABLE | INTEGER | 7 |
crdodamt | Card OD Amount Ledger | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
crdodamtc | Card OD Amount Collected | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
crdodctd | Card OD Items Cycle to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
crdodqtd | Card OD Items Quarter to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
crdodytd | Card OD Items Year to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
crdodpytd | Card OD Items Prev Year to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
cdyodchga | Consec actual days OD charge | DEC(5,0) | NULLABLE | INTEGER | 5 |
cdyodchgb | Consec business days OD charge | DEC(5,0) | NULLABLE | INTEGER | 5 |
stmtdm | Statement Delivery Method | CHAR(1) | NULLABLE | STRING | 1 |
dditemsbal | Items OD Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddnsffebal | NSF Fees Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddodchgbal | OD Charge Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddscbal | S/C Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
dducfbal | UCF Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddyitembal | Items OD Balance-yest. | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddynsffbal | NSF Fees Balance-yest. | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddyodcgbal | OD Charge Balance-yest. | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddyscbal | S/C Balance-yest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddyucfbal | UCF Balance-yest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddautocg | Auto Charge Off | CHAR(1) | NULLABLE | STRING | 1 |
dddatecol6 | Date Collected | DEC(6,0) | NULLABLE | INTEGER | 6 |
dddatecol7 | Date Collected | DEC(7,0) | NULLABLE | INTEGER | 7 |
promocode | Promotional Code | CHAR(3) | NULLABLE | STRING | 3 |
promoexp6 | Promo Expiration Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
promoexp7 | Promo Expiration Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
promovar | Promo Variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
promovarc | Promo Variance Code | CHAR(1) | NULLABLE | STRING | 1 |
ddmtsa1 | Finished Posting | CHAR(1) | NULLABLE | STRING | 1 |
ddmtsa2 | Tch Srv use only fld A2 | CHAR(1) | NULLABLE | STRING | 1 |
ddmtsa3 | Tch Srv use only fld A3 | CHAR(2) | NULLABLE | STRING | 2 |
ddmtsa4 | Tch Srv use only fld A4 | CHAR(2) | NULLABLE | STRING | 2 |
ddmtsn1 | Tch Srv use only fld N1 | DEC(5,0) | NULLABLE | INTEGER | 5 |
ddmtsn2 | Tch Srv use only fld A2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
exodcur | OD Guidance Cr Month | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod01 | Excess OD count-Jan | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod02 | Excess OD count-Feb | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod03 | Excess OD count-Mar | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod04 | Excess OD count-Apr | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod05 | Excess OD count-May | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod06 | Excess OD count-June | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod07 | Excess OD count-July | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod08 | Excess OD count-Aug | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod09 | Excess OD count-Sept | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod10 | Excess OD count-Oct | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod11 | Excess OD count-Nov | DEC(3,0) | NULLABLE | INTEGER | 3 |
exod12 | Excess OD count-Dec | DEC(3,0) | NULLABLE | INTEGER | 3 |
exodltd | OD Occasion Reset LTD | DEC(3,0) | NULLABLE | INTEGER | 3 |
exodacdt6 | Excessive OD action date | DEC(6,0) | NULLABLE | INTEGER | 6 |
exodacdt7 | Excessive OD action date | DEC(7,0) | NULLABLE | INTEGER | 7 |
exodlrdt6 | Date OD Occ Lmt Reached | DEC(6,0) | NULLABLE | INTEGER | 6 |
exodlrdt7 | Date OD Occ Lmt Reached | DEC(7,0) | NULLABLE | INTEGER | 7 |
exodreset | Excess OD reset ctrs | CHAR(1) | NULLABLE | STRING | 1 |
exodrevok | Excess OD revoke OD | CHAR(1) | NULLABLE | STRING | 1 |
exodrpt | Excess OD exclude from rpt | CHAR(1) | NULLABLE | STRING | 1 |
exodgcdt6 | Excessive OD grace date | DEC(6,0) | NULLABLE | INTEGER | 6 |
exodgcdt7 | Excessive OD grace date | DEC(7,0) | NULLABLE | INTEGER | 7 |
exodsmdt6 | Date Last Excess OD Stmt Msg | DEC(6,0) | NULLABLE | INTEGER | 6 |
exodsmdt7 | Date Last Excess OD Stmt Msg | DEC(7,0) | NULLABLE | INTEGER | 7 |
ddhighod | Highest OD amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ddprntadnd | Print addenda records | CHAR(1) | NULLABLE | STRING | 1 |
ddadndcnt | # addenda records print | DEC(2,0) | NULLABLE | INTEGER | 2 |
ddchgbfee | Charge bad address fee | CHAR(1) | NULLABLE | STRING | 1 |
ddpsautcod | Paper Stmt Auto Charge Override | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024