account_v1_raw

Pipelined Data Sets > Symitar > account_v1_raw

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
eventtime	Internal use only	NULLABLE	INTEGER
sourcetype	Internal use only; SSDB field	NULLABLE	STRING
operation	Internal use only; SSDB field	NULLABLE	STRING
extractdate	Internal use only	NULLABLE	DATE
processdatetime	Internal use only; SSDB field	NULLABLE	TIMESTAMP
accountuuid	This field stores a JH Platform unique identifier for an account	NULLABLE	STRING
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	NULLABLE	INTEGER
number	This field stores the unique 10-digit account number assigned to the account when it was created	NULLABLE	STRING
type	This field stores the credit union-defined code to define the type of account	NULLABLE	INTEGER
lastfmdate	This field stores the date of the last file maintenance or teller transaction affecting this Account record	NULLABLE	DATE
opendate	This field stores the date the account was opened	NULLABLE	DATE
closedate	This field stores the date the account was closed	NULLABLE	DATE
branch	This field stores the credit union-defined branch number where the account was opened or is currently housed	NULLABLE	INTEGER
restrict	This field stores a code that indicates the type of restriction if access is restricted on this account	NULLABLE	INTEGER
reference	You can use this field to store any account reference information, such as a mother's maiden name	NULLABLE	STRING
warningcode_1	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_2	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_3	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_4	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_5	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_6	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_7	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_8	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_9	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_10	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_11	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_12	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_13	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_14	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_15	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_16	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_17	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_18	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_19	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
warningcode_20	The 20 Warning # Code fields can each contain a code that identifies a different credit union-defined warning to apply to this account	NULLABLE	INTEGER
paymenthistory_1	This field stores the number of loan payments the member has made to date for all loans in the account	NULLABLE	INTEGER
paymenthistory_2	This field stores a count of all loan payments made 11-30 days after the due date	NULLABLE	INTEGER
paymenthistory_3	This field stores a count of all loan payments made 31-60 days after the due date	NULLABLE	INTEGER
paymenthistory_4	This field stores a count of all loan payments made 61-90 days after the due date	NULLABLE	INTEGER
paymenthistory_5	This field stores a count of all loan payments made 91-120 days after the due date	NULLABLE	INTEGER
paymenthistory_6	This field stores a count of all loan payments made 121 and up days after the due date	NULLABLE	INTEGER
memberstatus	This field stores the membership status of an individual or organization	NULLABLE	INTEGER
corresponddate	This field stores the most recent escheatment correspondence from the member regarding this account	NULLABLE	DATE
proxydate	If your credit union allows members to assign their vote to a proxy, this field stores the expiration date or the effective date of the proxy	NULLABLE	DATE
headofhousehold	This field stores a code that specifies whether this account is used as a head of household account to consolidate mailings or target marketing campaigns	NULLABLE	INTEGER
warningexpiration_1	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_2	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_3	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_4	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_5	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_6	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_7	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_8	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_9	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_10	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_11	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_12	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_13	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_14	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_15	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_16	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_17	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_18	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_19	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
warningexpiration_20	The 20 Warning # Expiration fields can each contain a date after which the corresponding warning should no longer apply to the account	NULLABLE	DATE
nsfmonthlycount_1	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_2	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_3	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_4	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_5	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_6	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_7	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_8	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_9	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_10	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_11	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_12	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_13	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_14	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_15	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_16	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_17	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_18	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_19	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_20	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_21	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_22	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_23	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsfmonthlycount_24	Each of these 24 fields stores the number of days the account had a negative balance for that month	NULLABLE	INTEGER
nsftoday	If you indicate at the Count NSFs prompt in your batch posting jobs that you want the system to count NSFs, this field stores the number of times during the current system date an NSF condition or negative balance occurred in the account	NULLABLE	INTEGER
membergroup	This field stores the credit union-defined code to identify the group to which the member belongs	NULLABLE	INTEGER
commercialcode	This field stores a code that indicates whether an account is a consumer account, small business account, or commercial account	NULLABLE	INTEGER
fmlastpurgedate	This field stores the date through which you last purged file maintenance history for the account type with the Purge Transaction Processing batch program	NULLABLE	DATE
statereporting	This field stores the state code to report dividends to for this member	NULLABLE	STRING
householdaccount	This field stores the related head of household account, if the value in the Head of Household field is set to (1) Other family member	NULLABLE	STRING
householdstatement	This field stores a code that indicates if you want to send multiple statements to one household in a single envelope	NULLABLE	INTEGER
frozenmode	This field stores a code that indicates the frozen condition of the Audio Response and home banking systems	NULLABLE	INTEGER
invalidattemptcount	This field stores the number of times someone made an invalid attempt to access the account through the Audio Response or home banking system	NULLABLE	INTEGER
invalidattemptdate	This field stores the last date when someone tried to access this account using an invalid access code	NULLABLE	DATE
invalidattempttime	This field stores the last time (in HHMM format) when someone tried to access this account using an invalid access code	NULLABLE	INTEGER
statementmailcode	This field stores a code that indicates what mail code to use to for mailing statements	NULLABLE	INTEGER
relationshipcode	This field stores a code that specifies the member's base relationship to your credit union	NULLABLE	INTEGER
relationshipoverride	This field stores a code that specifies a relationship code that overrides the base relationship code until the relationship override expires	NULLABLE	INTEGER
relationshipoverrideeffdate	This field stores the date that specifies when the Relationship Override field becomes effective	NULLABLE	DATE
relationshipoverrideexpdate	This field specifies the date that the Relationship Override field expires	NULLABLE	DATE
krholdbaseamount	This field stores the check hold base amount for this account	NULLABLE	NUMERIC
krtotalamount	This field stores a running total of any non-held portions of check deposits for the date stored in the Check Dep Total Date field	NULLABLE	NUMERIC
krtotaldate	This field stores the date of the last check deposit that affected the Account record Check Dep Total Amount field or the Non-Reg CC Check Dep Total Amt field	NULLABLE	DATE
estmtnotify	This field stores a code that specifies whether the member would like to receive e-statements for home banking products	NULLABLE	INTEGER
estmtenable	This field stores a code that indicates if the member would like to receive e-statements for home banking products	NULLABLE	INTEGER
crtotalamount	This field stores the total cash received from a Cash Received (CR) transaction, ATM deposit, or Shared Branch Issuer transactions	NULLABLE	NUMERIC
cdtotalamount	This field stores the total cash distributed with a Cash Disbursed (CD) transaction, ATM withdrawals, or Shared Branch Issuer transactions	NULLABLE	NUMERIC
frcrtotalamount	This field stores the total cash received with a Foreign Received (FR) transaction	NULLABLE	NUMERIC
frcdtotalamount	This field stores the total cash received with a Foreign Disbursed (FD) transaction	NULLABLE	NUMERIC
userchar1	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar2	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar3	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
userchar4	These four custom fields can store any credit union-defined character data	NULLABLE	STRING
useramount1	These two custom fields can store any credit union-defined cash amount	NULLABLE	NUMERIC
useramount2	These two custom fields can store any credit union-defined cash amount	NULLABLE	NUMERIC
userdate1	These two custom fields can store any credit union-defined date	NULLABLE	DATE
userdate2	These two custom fields can store any credit union-defined date	NULLABLE	DATE
enablefloat	This field stores a code that indicates whether to activate credit union floats per account	NULLABLE	INTEGER
frcrunits	This field stores the aggregate of the foreign currency amount total for the day based on Foreign Received (FR) teller transactions	NULLABLE	NUMERIC
frcdunits	This field stores the aggregate of the total in foreign currency for the day based on the Foreign Disbursed (FD) teller transactions during the day. The currency amount is reported in foreign currency, not converted to U.S. dollars	NULLABLE	NUMERIC
prgdrecactivitydt	This field stores the most recent activity date from shares or loans that are purged	NULLABLE	DATE
recordchangedate	This field stores the system date when you create, change, or save the Account record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
cappedfeescountcap	This field stores the number of fee occurrences at which your credit union stops charging capped fees for the account during a time period you specified	NULLABLE	INTEGER
cappedfeesamountcap	This field stores the dollar amount your credit union sets for its capped fees amount	NULLABLE	NUMERIC
createdbyuser	This field stores the user ID and is populated when the record is created	NULLABLE	INTEGER
createdatbranch	This field stores the branch ID of the branch where the Account record is created	NULLABLE	INTEGER
wrtotalamount	This field stores the total amount of incoming wires posted in a wire received transaction	NULLABLE	NUMERIC
wdtotalamount	This field stores the total amount of outgoing wires posted in a wire disbursed transaction	NULLABLE	NUMERIC
nonregcccheckholdbaseamt	This field stores the amount that is immediately available per day to the account holder when making a non-Reg CC check deposit. (Such deposits are usually made remotely through a PC or smartphone)	NULLABLE	NUMERIC
nonregccchecktotalamt	This field stores a running total of all the non-Reg CC check deposits for the date stored in the Check Dep Total Date field	NULLABLE	NUMERIC
limitusagedate	This field stores the last date that transactions were limited by fields in the Account record occurred	NULLABLE	DATE
countlimit_1	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
countlimit_2	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
countlimit_3	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
countlimit_4	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
countlimit_5	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
countlimit_6	Each of these six fields stores a number that places a daily limit for the number of transactions of a particular type and for a particular source code	NULLABLE	INTEGER
limitcount_1	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limitcount_2	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limitcount_3	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limitcount_4	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limitcount_5	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limitcount_6	Each of these six fields stores the current total count of times each day that a member performs a transaction that is affected by this limit	NULLABLE	INTEGER
limit_1	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limit_2	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limit_3	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limit_4	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limit_5	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limit_6	Each of these six fields stores an amount that places a daily limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
limitamount_1	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
limitamount_2	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
limitamount_3	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
limitamount_4	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
limitamount_5	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
limitamount_6	Each of these six fields stores the current total amount of transactions that apply to the corresponding limit	NULLABLE	NUMERIC
peritemlimit_1	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
peritemlimit_2	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
peritemlimit_3	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
peritemlimit_4	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
peritemlimit_5	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
peritemlimit_6	Each of these six fields stores an amount that places a per transaction limit on certain types of transactions with particular source codes	NULLABLE	NUMERIC
versionid		NULLABLE	INTEGER

Have a Question?

Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026