memberrec_v1_raw

Pipelined Data Sets > Symitar > memberrec_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
memberrecuuid	This field stores a JH Platform unique identifier for a member	NULLABLE	STRING
memberreckey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	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
mbrlastaddrchgdate		NULLABLE	DATE
mbrcrnamechgdate		NULLABLE	DATE
mbrcrssnchgdate		NULLABLE	DATE
membernumber	This field value is unique within each Member record, which means that you can use this field value as a unique identification of a specific record	NULLABLE	STRING
mbrstatus	This field determines the type of Member record	NULLABLE	INTEGER
mbrstatusfmdate	Symitar Quest updates this field to the current system date when the MBR Status field in the Member record is changed by Symitar Quest or the user	NULLABLE	DATE
mbrcreatedate	Symitar Quest updates this field with the current system date when you create the Member record	NULLABLE	DATE
mbrfmlastdate	Symitar Quest updates this field with the system date whenever you perform file maintenance of the Member record	NULLABLE	DATE
mbrexpdate	This field stores the expiration date of the Member record	NULLABLE	DATE
mbractivitydate	Symitar Quest updates this field to the current system date when any transaction activity occurs on the Member record	NULLABLE	DATE
nameformat	This field is used to indicate whether a member is an individual or non-individual	NULLABLE	INTEGER
title	This field stores the title of the member identified in this record (for example MR, MS, DR, etc.)	NULLABLE	STRING
first	This field stores the first name of the person identified in the Member record	NULLABLE	STRING
middle	This field stores the middle name or middle initial of the person identified in the Member record	NULLABLE	STRING
last	This field stores the last name of the person identified in the Member record	NULLABLE	STRING
suffix	This field stores any suffix that should follow the name of the person identified in the Member record (for example, JR or SR)	NULLABLE	STRING
extendedname		NULLABLE	STRING
ssn	This field stores the Social Security Number, Individual Taxpayer Identification Number (ITIN), or the organizational Employer Identification Number (EIN) of the person identified in the Member record	NULLABLE	STRING
ssntype	This field indicates the type of identification number that is stored in the SSN/TIN field	NULLABLE	INTEGER
mbrrecordchangedate	This field stores the date when a user changes a field value on the Member record from within the Member record	NULLABLE	DATE
mbrdisconnectdate	This field stores the date when a Member record is no longer linked with any Name records	NULLABLE	DATE
birthdate	This field stores the birth date of the person identified in the Member record	NULLABLE	DATE
deathdate	This field stores the death date of the person identified in the Member record	NULLABLE	DATE
phonetype	This field determines whether the phone number has a domestic format or a free-form foreign phone number format	NULLABLE	INTEGER
homephone	This field stores the home phone number of the person identified in the Member record	NULLABLE	STRING
workphone	This field stores the business telephone number of the person identified in the Member record	NULLABLE	STRING
workphoneextension	This field stores the work phone extension of the person identified in the Member record	NULLABLE	STRING
mobilephone	This field stores the mobile phone number of the person identified in the Member record	NULLABLE	STRING
pagernumber	This field stores the pager number of the person identified in the Member record	NULLABLE	STRING
email	This field stores the email address of the person identified in the Member record	NULLABLE	STRING
altemail	This field stores the alternate email address of the person identified in the Member record	NULLABLE	STRING
employername	This field stores the name of the employer who employs the person identified in the Member record	NULLABLE	STRING
occupation	This field stores the occupation of the person identified in the Member record	NULLABLE	STRING
ctrexempt	This field is used to exempt a person from the Currency Transaction Report (CTR)	NULLABLE	INTEGER
mothersmaidenname	This field stores the maiden name of the mother of the person identified in the Member record	NULLABLE	STRING
uspersonflag	This field specifies whether the person defined in this record is a citizen of the United States or whether the business identified is established or organized under the laws of a state or the United States	NULLABLE	INTEGER
identdocflag_1	These fields specify whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_2	These fields specify whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_3	These fields specify whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identidtype_1	These fields specify the type of documentation (if any) that was used to support the first, second, or third form of identification	NULLABLE	INTEGER
identidtype_2	These fields specify the type of documentation (if any) that was used to support the first, second, or third form of identification	NULLABLE	INTEGER
identidtype_3	These fields specify the type of documentation (if any) that was used to support the first, second, or third form of identification	NULLABLE	INTEGER
identiddescription_1	These fields provide further detail about the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identiddescription_2	These fields provide further detail about the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identiddescription_3	These fields provide further detail about the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identidnumber_1	These fields contain the value of the type of identification specified by the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identidnumber_2	These fields contain the value of the type of identification specified by the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identidnumber_3	These fields contain the value of the type of identification specified by the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3)	NULLABLE	STRING
identidissuedate_1	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was issued, when applicable	NULLABLE	DATE
identidissuedate_2	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was issued, when applicable	NULLABLE	DATE
identidissuedate_3	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was issued, when applicable	NULLABLE	DATE
identidexpiredate_1	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) expires, when applicable	NULLABLE	DATE
identidexpiredate_2	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) expires, when applicable	NULLABLE	DATE
identidexpiredate_3	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) expires, when applicable	NULLABLE	DATE
identidverifydate_1	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was verified	NULLABLE	DATE
identidverifydate_2	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was verified	NULLABLE	DATE
identidverifydate_3	These fields contain the date the corresponding first, second, or third form of identification (see ID Type 1-ID Type 3) was verified	NULLABLE	DATE
userchar1	You can use these fields to store any user-defined character data	NULLABLE	STRING
userchar2	You can use these fields to store any user-defined character data	NULLABLE	STRING
userchar3	You can use these fields to store any user-defined character data	NULLABLE	STRING
userchar4	You can use these fields to store any user-defined character data	NULLABLE	STRING
useramount1	You can use these fields to store any cash amount defined by your financial institution	NULLABLE	NUMERIC
useramount2	You can use these fields to store any cash amount defined by your financial institution	NULLABLE	NUMERIC
userdate1	You can use these fields to store any date defined by your financial institution	NULLABLE	DATE
userdate2	You can use these fields to store any date defined by your financial institution	NULLABLE	DATE
currgrossmonthpay	This field stores the member's current monthly gross pay	NULLABLE	NUMERIC
currnetmonthpay	This field stores the member's current monthly net pay	NULLABLE	NUMERIC
mbrfmlastpurgedate	This field stores the date through which file maintenance history for Member records was last purged by the Purge Transaction Processing batch program	NULLABLE	DATE
mbrfiletype	This field indicates whether this member record is linked with any Name record or Non-Account Name record	NULLABLE	INTEGER
restrict	This field indicates the type of restriction if access is restricted on this account	NULLABLE	INTEGER
mbrcurrmthpaychgdate	This field reflects the date the Curr Gross Mo Pay and Curr Net Mo Pay fields were last updated	NULLABLE	DATE
dbanameformat	This field indicates whether the "doing business as" information in the Member record is for an individual or non-individual	NULLABLE	INTEGER
dbatitle	This field stores the title that proceeds the name of the "doing business as" person identified in the Member record	NULLABLE	STRING
dbafirst	This field stores the first name of the "doing business as" person identified in the Member record	NULLABLE	STRING
dbamiddle	This field stores the middle name of the "doing business as" person identified in the Member record	NULLABLE	STRING
dbalast	This field stores the last name of the "doing business as" person identified in the Member record	NULLABLE	STRING
dbasuffix	This field stores the suffix of the "doing business as" person identified in the Member record (for example, JR or SR)	NULLABLE	STRING
dbaextendedname	This field stores the extended name of the "doing business as" person in the Member record	NULLABLE	STRING
sex	This field stores the gender of the person identified in the Member record	NULLABLE	STRING
irscountrycode	This field stores the code for the member's country of residence	NULLABLE	STRING
nrataxrate	This field stores the NRA tax rate that applies to a member's tax withholding	NULLABLE	INTEGER
nraexemptioncode	This field stores the code that indicates the reason income is exempt from tax withholding	NULLABLE	STRING
formw8onfile	This field indicates whether the credit union has a W-8 form on file for the member	NULLABLE	INTEGER
w8expirationdate	This field stores the expiration date if the member does not have a Social Security Number (SSN) or Individual Taxpayer Identification Number (ITIN) and the member has a W-8 form on file	NULLABLE	DATE
foreigntin	This field stores the taxpayer identification number used in the country of residence for tax purposes	NULLABLE	STRING
giin	This field stores the recipient GIIN (Global Intermediary Identification Number) if there is a Chapter 4 withholding	NULLABLE	STRING
substantialowner	This field determines an entity account holder that has documentation as a Foreign Financial Institution (FFI) or Non-Financial Foreign Entity (NFFE)	NULLABLE	INTEGER
chapter4statuscode	This field indicates the type of recipient	NULLABLE	STRING
preferredcontactmethod	This drop-down field stores a list of options you can choose from to indicate how the member wants to receive information from your financial institution	NULLABLE	INTEGER
activeduty	This field indicates whether the member is on active duty or is a dependent of someone on active duty	NULLABLE	INTEGER
activedutyverificationdate	This field indicates the date on which the user verified that the member is either on active duty or is the dependent of someone on active duty	NULLABLE	DATE
activedutystartdate	This field indicates the date on which the member (or the person on whom the member is dependent) began active military duty	NULLABLE	DATE
activedutyseparationdate	This field indicates the date on which the member (or the person on whom the member is dependent) ended active military duty	NULLABLE	DATE
lob	This field stores the code that best describes the applicable limitation on benefits (LOB) category that qualifies the member for requested benefits	NULLABLE	STRING
lei	This field stores the unique alpha-numeric code associated with a single corporate entity for international financial market record keeping	NULLABLE	STRING
mbrversionid		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