externalloan_name_raw

Pipelined Data Sets > Symitar > externalloan_name_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
externalloannameuuid	This field stores a JH Platform unique identifier for an external loan name record	NULLABLE	STRING
memberrecuuid	This field stores a JH Platform unique identifier for a memberrec	NULLABLE	STRING
mbraddressuuid	This field stores a JH Platform unique identifier for a mbraddress	NULLABLE	STRING
externalloannameaddressuuid	This field stores a JH Platform unique identifier for an external loan name address	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
externalloanlocator	This field stores the external loan locator	NULLABLE	STRING
externalloannamekey	Internal use only; SSDB field	NULLABLE	INTEGER
externalloankey	Internal use only; SSDB field	NULLABLE	INTEGER
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
namehdrlastaddrchgdate		NULLABLE	DATE
namehdrcrnamechgdate		NULLABLE	DATE
namehdrcraddrchgdate		NULLABLE	DATE
namehdrcrssnchgdate		NULLABLE	DATE
namehdrcurrmthpaychgdate		NULLABLE	DATE
dobssn		NULLABLE	STRING
emailinternal		NULLABLE	STRING
altemailinternal		NULLABLE	STRING
type	This field stores a code that identifies the type of name of this Name record	NULLABLE	INTEGER
subtype	This field stores a credit union-defined code that further identifies the type of Name record	NULLABLE	INTEGER
mailoverride	This field stores a code that specifies whether the address in the Name record should override the mailing address in the primary Name record	NULLABLE	INTEGER
ssnoverride	This field stores a code that determines if the Social Security Number (SSN) or Individual Taxpayer Identification Number (TIN) in this Name record should override the SSN or TIN in the primary Name record or not	NULLABLE	INTEGER
ssncertification	This field stores a code that helps ensure that your credit union handles dividend withholding correctly	NULLABLE	INTEGER
ssntype	This field stores a code that identifies the type of number in the SSN/TIN field in the Name record	NULLABLE	INTEGER
effectivedate	This field stores the date that indicates when the information in this Name record should be used	NULLABLE	DATE
expirationdate	This field stores the date that indicates when the information in this Name record should no longer be used	NULLABLE	DATE
birthdate	This field stores the birth date of the person identified in the Name record	NULLABLE	DATE
title	This field stores the title that should precede the name of the person identified in this Name record	NULLABLE	STRING
first	This field stores the first name of the person identified in this Name record	NULLABLE	STRING
middle	This field stores the middle name or middle initial of the person identified in the Name record	NULLABLE	STRING
last	This field stores the last name of the person or non-individual name identified in the Name record	NULLABLE	STRING
suffix	This field stores the suffix that should follow the name of the person identified in the Name record	NULLABLE	STRING
extraaddress	This field stores extra address information to save with the mailing address of the person identified in the Name record	NULLABLE	STRING
street	This field stores the street address of the person identified in the Name record	NULLABLE	STRING
city	This field stores the name of the city where the person identified in the Name record resides	NULLABLE	STRING
state	This field stores the name or postal abbreviation of the state where the person identified in the Name record resides	NULLABLE	STRING
zipcode	This field stores the domestic ZIP code where the person identified in the Name record resides	NULLABLE	STRING
homephone	This field stores the home telephone number of the person identified in the Name record	NULLABLE	STRING
ssn	This field stores the individual SSN (Social Security Number), ITIN (Individual Taxpayer Identification Number), or the organizational EIN (Employer Identification Number) of the person identified in the Name record	NULLABLE	STRING
workphone	This field stores the business telephone number of the person identified in the Name record	NULLABLE	STRING
lastfmdate	The system stores the date in this field of the last file maintenance to the Name record	NULLABLE	DATE
carrierroute	This field stores the carrier route number for the person identified in the Name record	NULLABLE	STRING
addresstype	This field stores a code that specifies whether the address of the person identified in the Name record is domestic or foreign	NULLABLE	INTEGER
beneficiarypercent	This field stores the percentage of funds allocated to the beneficiary identified in the Name record	NULLABLE	NUMERIC
irscorrection	This field stores a code that identifies the IRS type of error being corrected	NULLABLE	INTEGER
workphoneextension	This field stores the business telephone extension for the person identified in the Name record	NULLABLE	STRING
ctrexempt	This field stores a code that specifies whether the account is to be exempt from reporting	NULLABLE	INTEGER
deathdate	This field stores the date of death in the primary Name record, or in the Share Name record if the tax-deferred share is not owned by the primary member	NULLABLE	DATE
ecoacode	This field contains an Equal Credit Opportunity Act (ECOA) code that indicates how the system should report loans to credit bureaus	NULLABLE	INTEGER
country	This field stores the foreign country where the person identified in the Name record resides	NULLABLE	STRING
countrycode	This field stores the 2-character code that best describes the applicable limitation on benefits (LOB) category that qualifies the member for requested benefits	NULLABLE	STRING
email	This field stores the email address of the person identified in this Name record	NULLABLE	STRING
mothersmaidenname	This field stores the maiden name of the mother of the person identified in this Name record	NULLABLE	STRING
employername	This field stores the name of the employer of the person identified in this Name record	NULLABLE	STRING
altemail	This field stores an alternate email address of the person identified in this Name record	NULLABLE	STRING
locator	The system stores a unique number within each member account in this field that can be used as a unique identification of this record	NULLABLE	INTEGER
mobilephone	This field stores the number for the member's cell phone or other mobile phone device (if any)	NULLABLE	STRING
pagernumber	This field stores the number for a member's pager (if any)	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. Choose one of the following:	NULLABLE	INTEGER
identdocflag_1	These fields each store a code that indicates whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_2	These fields each store a code that indicates whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_3	These fields each store a code that indicates whether the first, second, or third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identidtype_1	These fields each 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 each 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 each 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 each store further detail about the corresponding first, second, or third form of identification	NULLABLE	STRING
identiddescription_2	These fields each store further detail about the corresponding first, second, or third form of identification	NULLABLE	STRING
identiddescription_3	These fields each store further detail about the corresponding first, second, or third form of identification	NULLABLE	STRING
identidnumber_1	These fields each store the value of the type of identification specified by the corresponding first, second, or third form of identification	NULLABLE	STRING
identidnumber_2	These fields each store the value of the type of identification specified by the corresponding first, second, or third form of identification	NULLABLE	STRING
identidnumber_3	These fields each store the value of the type of identification specified by the corresponding first, second, or third form of identification	NULLABLE	STRING
identidissuedate_1	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was issued, if known	NULLABLE	DATE
identidissuedate_2	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was issued, if known	NULLABLE	DATE
identidissuedate_3	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was issued, if known	NULLABLE	DATE
identidexpiredate_1	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification expires, if known	NULLABLE	DATE
identidexpiredate_2	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification expires, if known	NULLABLE	DATE
identidexpiredate_3	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification expires, if known	NULLABLE	DATE
identidverifydate_1	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was verified	NULLABLE	DATE
identidverifydate_2	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was verified	NULLABLE	DATE
identidverifydate_3	These fields each store the date the type of identification specified by the corresponding first, second, or third form of identification was verified	NULLABLE	DATE
occupation	This field stores the current occupation of the person identified in this Name record	NULLABLE	STRING
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
lastaddrverifdate	The system stores the date of the most recent address verification for the member	NULLABLE	DATE
creditreportconsumerinfo	This field stores a 2-character code that identifies the individual bankruptcy status used for the Metro 2® Format Credit Reporting system	NULLABLE	STRING
nameformat	This field stores a code that specifies whether the name is for an individual or a not	NULLABLE	INTEGER
extendedname	The system stores the characters over 40 entered in the Last Name/Non Indiv Name field in this field when the Name Format field value is set to (1) Non-Individual	NULLABLE	STRING
creditreportconsumerinfodate	This field stores the date when you last performed file maintenance on the Credit Report Consumer Info field	NULLABLE	DATE
extrainfo	This field stores a character string related to the beneficiary	NULLABLE	STRING
recordchangedate	The system stores the system date in this field when you create, change, or save this Name record if the change is made from this Name 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
membernumber	The system stores the unique value in this field assigned within each Member record when it is created	NULLABLE	STRING
mbrstatus	This field stores a code that determines the type of member represented in this Name record	NULLABLE	INTEGER
mbrstatusfmdate	The system stores the system date in this field when the MBR Status field is changed by the system or the user	NULLABLE	DATE
mbrcreatedate	The system stores the system date in this field when you create the Member record	NULLABLE	DATE
mbrfmlastdate	The system stores the date in this field of the last file maintenance to the Member record	NULLABLE	DATE
mbrexpdate	The system stores an expiration date in this field for the Member record	NULLABLE	DATE
mbractivitydate	The system stores the system date in this field when any transaction activity occurs on the Member record	NULLABLE	DATE
phonetype	This field stores a code that specifies whether the phone number field values are a domestic or foreign phone number type	NULLABLE	INTEGER
mbraddrnumber	The system stores the unique value in this field assigned within each Member Address record when it is created	NULLABLE	STRING
addrcreatedate	The system stores the system date in this field when you create the Member Address record	NULLABLE	DATE
addrfmlastdate	The system stores the date in this field of the last file maintenance to the Member Address record	NULLABLE	DATE
addrexpdate	The system stores an expiration date in this field for the Member Address record	NULLABLE	DATE
nonacctnamenum	The system stores the unique value in this field assigned within each Non-Account Name record when it is created	NULLABLE	STRING
membernumlink	The system stores a pointer in this field to the MBR Number field in the Member record linked with this Name record	NULLABLE	STRING
mbraddrnumlink	The system stores a pointer in this field to the ADDR Number field in the Member Address record linked with this Name record	NULLABLE	STRING
currgrossmonthpay	This field stores the members' current monthly gross pay	NULLABLE	NUMERIC
currnetmonthpay	This field stores the member's current monthly net pay	NULLABLE	NUMERIC
mbrfmlastpurgedate	The system stores the date in this field through which file maintenance history for Member records was last purged by the Purge Transaction Processing batch program	NULLABLE	DATE
addrfmlastpurgedate	The system stores the date in this field through which file maintenance history for Member Address records was last purged by the Purge Transaction Processing batch program	NULLABLE	DATE
fmlastpurgedate	The system stores the date in this field through which file maintenance history for Name records was last purged by the Purge Transaction Processing batch program	NULLABLE	DATE
membernumlinkchgdate	The system stores the current system date when the MBR Number Link field changes	NULLABLE	DATE
mbraddrnumlinkchgdate	The system stores the current system date when the ADDR Number Link field changes	NULLABLE	DATE
mbrrecordchangedate	The system stores the system date in this field when a user changes a field value on the Member record	NULLABLE	DATE
mbrdisconnectdate	The system stores the date in this field when a Member record is no longer linked with any Name or Non-account Name records due to a merge situation	NULLABLE	DATE
addrrecordchangedate	The system stores the system date in this field when a user changes a field value on the Member Address record	NULLABLE	DATE
addrdisconnectdate	The system stores the date in this field when a Member Address record is no longer linked with any Name records due to a merge situation	NULLABLE	DATE
mbrfiletype	This field stores a code that indicates whether the Member record is linked to a Name or Non-account Name record	NULLABLE	INTEGER
mbraddrfiletype	This field stores a code that indicates whether the Member Address record is linked to a Name or Non-account Name record	NULLABLE	INTEGER
restrict	This field stores a code that identifies the type of number in the SSN/TIN field in the Name record	NULLABLE	INTEGER
confidential	This field stores a code that indicates a member has an Account that they wish to keep private or not	NULLABLE	INTEGER
marketingaddress	This field stores a code that specifies whether to use the address associated with this Name record for marketing a not	NULLABLE	INTEGER
creditreportaddrindicator	This field stores a 1-character code that causes a Share or Loan Note record to be posted with information about the address reported in the Name record	NULLABLE	STRING
creditreportaddrindicatordate	This field stores the date when the Credit Rpt Address Indicator field is updated with an address indicator value or any non-blank value	NULLABLE	DATE
dbanameformat	This field stores a code that specifies whether the DBA (doing business as) name is for an individual or a not	NULLABLE	INTEGER
dbatitle	This field stores any title that should precede the name of the DBA (doing business as) person in the Name record	NULLABLE	STRING
dbafirst	This field stores the first name of the DBA (doing business as) person identified in the Name record	NULLABLE	STRING
dbamiddle	This field stores the middle name or middle initial of the DBA (doing business as) person identified in the Name record	NULLABLE	STRING
dbalast	This field stores the last name of the DBA (doing business as) information identified in the Name record	NULLABLE	STRING
dbasuffix	This field stores any suffix that should follow the DBA (doing business as) person identified in the Name record	NULLABLE	STRING
dbaextendedname	The system stores the characters over 40 entered in the DBA Last Name/Non Indiv Name field in this field when the DBA Name Format field value is set to (1) Non-Individual	NULLABLE	STRING
sex	This field stores a character that identifies the sex of the person identified in the Name record	NULLABLE	STRING
irscountrycode	This field stores the two-character IRS country 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	NUMERIC
nraexemptioncode	This field stores the two-character code that indicates the reason income is exempt from tax withholding	NULLABLE	STRING
formw8onfile	This field stores a code that indicates whether the credit union has a W-8 form on file for the member	NULLABLE	INTEGER
w8expirationdate	This field stores the expiration date of the W-8 form on file for a member that does not have a Social Security Number (SSN) or Individual Taxpayer Identification Number (ITIN)	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 Global Intermediary Identification Number (GIIN)	NULLABLE	STRING
substantialowner	This field stores a code that determines if an entity account holder has documentation as a Foreign Financial Institution (FFI) or Non-Financial Foreign Entity (NFFE)	NULLABLE	INTEGER
chapter4statuscode	This field stores the 2-character code that indicates the type of recipient	NULLABLE	STRING
preferredcontactmethod	This field contains a code that indicates how the member wants to receive information from the credit union	NULLABLE	INTEGER
activeduty	This field stores a code that indicates whether the member is on active duty with the military or a dependent of someone who is	NULLABLE	INTEGER
activedutyverificationdate	This field stores the date on which the user verified the information that was entered in the Active Duty field	NULLABLE	DATE
activedutystartdate	This field stores the date on which the member (or the person on whom the member is dependent) began active military duty	NULLABLE	DATE
activedutyseparationdate	This field stores 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 2-character 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
beneficialowner	This field stores a code that identifies if this person is a beneficial owner of a legal entity	NULLABLE	INTEGER
beneficialpercent	This field stores the percentage of the equity interests of the legal entity customer that this person owns	NULLABLE	NUMERIC
irs1042samendnum	This field stores a code that identifies the number of times you submitted a corrected 1042-S form	NULLABLE	INTEGER
headquarters	This field indicates if the record pertains to the entity's main base of operations or headquarters	NULLABLE	INTEGER
mbrversionid		NULLABLE	INTEGER
mbraddrversionid		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