ssdb_loan_app_person_cdc

Pipelined Data Sets > Symitar > ssdb_loan_app_person_cdc

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
sourceeventtime	The timestamp of the change event from the source system (e.g., Debezium's ts_ms field).	NULLABLE	INTEGER
sourceeventdate	The UTC date of the change event, derived from sourceeventtime.	NULLABLE	DATE
operation	The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field.	NULLABLE	STRING
loanapppersonkey	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
loanappkey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
personcode	This field stores a code that indicates the relationship of this person to the application	NULLABLE	INTEGER
accountnumber	This field stores the person's account number	NULLABLE	STRING
birthdate	This field stores the person's date of birth	NULLABLE	DATE
maritalstatus	This field stores a code that indicates the person's marital status	NULLABLE	INTEGER
educationyears	This field stores the total number of years of education the person has completed	NULLABLE	INTEGER
sex	This field stores a code that indicates the person's sex	NULLABLE	STRING
title	This field stores the person's title	NULLABLE	STRING
first	This field stores the person's first name	NULLABLE	STRING
middle	This field stores the person's middle name	NULLABLE	STRING
last	This field stores the person's last name or the non-individual description	NULLABLE	STRING
suffix	This field stores any suffix to the person's name	NULLABLE	STRING
extraaddress	This field stores an extra address line	NULLABLE	STRING
street	This field stores the person's street address	NULLABLE	STRING
city	This field stores the person's city	NULLABLE	STRING
state	This field stores the person's state	NULLABLE	STRING
zipcode	This field stores the person's city	NULLABLE	STRING
homephone	This field stores the person's home telephone number	NULLABLE	STRING
workphone	This field stores the person's work telephone number	NULLABLE	STRING
workphoneextension	This field stores the person's telephone extension number at work	NULLABLE	STRING
ssn	This field stores the person's Social Security Number or individual Taxpayer Identification Number	NULLABLE	STRING
previousaddress	This field stores the person's previous address	NULLABLE	STRING
dependentcount	This field stores the number of dependents this person claims	NULLABLE	INTEGER
dependentage_1	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_2	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_3	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_4	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_5	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_6	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_7	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_8	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_9	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
dependentage_10	These fields each store the age of one of this person's dependents	NULLABLE	INTEGER
othercreditname	This field stores any other name the person uses for credit accounts	NULLABLE	STRING
derogstatus_1	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogstatus_2	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogstatus_3	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogstatus_4	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogstatus_5	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogstatus_6	These fields each store a credit union-defined code to indicate a derogatory status	NULLABLE	INTEGER
derogexplanation	This field stores any additional derogatory information or the name of a member for whom this person is a cosigner	NULLABLE	STRING
employmentstatus	This field stores a code that indicates the person's employment status	NULLABLE	INTEGER
employmentreturndate	This field stores the date you expect the person to return to work if not currently employed	NULLABLE	DATE
currempname	This field stores the name of this person's current employer	NULLABLE	STRING
currempaddress	This field stores the address of this person's current employer	NULLABLE	STRING
currempstartdate	This field stores the date this person's current employment began	NULLABLE	DATE
currempenddate	This field stores the date this person's current employment is expected to end	NULLABLE	DATE
currempoccupation	This field stores a description of this person's current occupation	NULLABLE	STRING
currempsupervisor	This field stores the name of this person's current supervisor	NULLABLE	STRING
currempgrossmonthlypay	This field stores the amount of this person's current monthly gross pay	NULLABLE	INTEGER
currempnetmonthlypay	This field stores the amount of this person's current monthly net pay	NULLABLE	INTEGER
prevempname	This field stores the name of this person's previous employer	NULLABLE	STRING
prevempaddress	This field stores the address of this person's previous employer	NULLABLE	STRING
prevempstartdate	This field stores the date this person's previous employment began	NULLABLE	DATE
prevempenddate	This field stores the date this person's previous employment ended	NULLABLE	DATE
prevempoccupation	This field stores a description of this person's previous occupation	NULLABLE	STRING
prevempsupervisor	This field stores the name of this person's previous supervisor	NULLABLE	STRING
prevempgrossmonthlypay	This field stores the amount of this person's previous monthly gross pay	NULLABLE	INTEGER
ref1code	This field stores a code that specifies the relationship of this first reference to the person	NULLABLE	INTEGER
ref1name	This field stores the name of this first reference	NULLABLE	STRING
ref1address	This field stores the address of this first reference	NULLABLE	STRING
ref1phone	This field stores the telephone number of this first reference	NULLABLE	STRING
ref1relationship	This field stores a description of the relationship of this first reference to the person	NULLABLE	STRING
ref2code	This field stores a code that specifies the relationship of this second reference to the person	NULLABLE	INTEGER
ref2name	This field stores the name of this second reference	NULLABLE	STRING
ref2address	This field stores the address of this second reference	NULLABLE	STRING
ref2phone	This field stores the telephone number of this second reference	NULLABLE	STRING
ref2relationship	This field stores a description of the relationship of this second reference to the person	NULLABLE	STRING
ref3code	This field stores a code that specifies the relationship of this third reference to the person	NULLABLE	INTEGER
ref3name	This field stores the name of this third reference	NULLABLE	STRING
ref3address	This field stores the address of this third reference	NULLABLE	STRING
ref3phone	This field stores the telephone number of this third reference	NULLABLE	STRING
ref3relationship	This field stores a description of the relationship of this third reference to the person	NULLABLE	STRING
monthscurraddress	This field stores the number of months the person has resided at the current address	NULLABLE	INTEGER
monthsprevaddress	This field stores the number of months the person resided at the previous address	NULLABLE	INTEGER
ownrentcurraddress	This field stores a code that specifies whether the person owns or rents the residence at the current address	NULLABLE	INTEGER
ownrentprevaddress	This field stores a code that specifies whether the person owns or rents the residence at the previous address	NULLABLE	INTEGER
addresstype	This field stores a code that indicates whether the address should be in the U.S. Postal Service standard format or a foreign format	NULLABLE	INTEGER
type	This field stores a code that identifies the kind of Person record	NULLABLE	INTEGER
mothersmaidenname	This field stores the maiden name of the person's mother	NULLABLE	STRING
citizenship	This field stores a code that indicates whether the individual is a U.S. citizen	NULLABLE	INTEGER
currempyearsemp	This field stores the number of years the person has been employed at their current job	NULLABLE	INTEGER
currempmonthsemp	This field stores the number of months the person has been employed at their current job	NULLABLE	INTEGER
prevempyearsemp	This field stores the number of years the person was employed at their previous job	NULLABLE	INTEGER
prevempmonthsemp	This field stores the number of months the person was employed at their previous job	NULLABLE	INTEGER
county	This field stores the county in which the person resides	NULLABLE	STRING
country	This field stores the country in which the person resides	NULLABLE	STRING
countrycode	This field stores the two-character country code where the person resides	NULLABLE	STRING
email	This field stores the person's email address	NULLABLE	STRING
emphoursperweek	This field stores the number of hours the person works per week	NULLABLE	INTEGER
judgement	This field stores a code that identifies a judgement status	NULLABLE	INTEGER
bankruptcy	This field stores a code that identifies a bankruptcy status	NULLABLE	INTEGER
pastforeclosure	This field stores a code that identifies a past foreclosure status	NULLABLE	INTEGER
pastrepossession	This field stores a code that identifies a past repossession status	NULLABLE	INTEGER
partyinlawsuit	This field stores a code that identifies a party in a lawsuit status	NULLABLE	INTEGER
incomemaydecline	This field stores a code that identifies an income likely to decline status	NULLABLE	INTEGER
cosignotherloan	This field stores a code that identifies a cosigner on another loan status	NULLABLE	INTEGER
cosignforwhom	This field can store the name of the individual for whom this person is a cosigner	NULLABLE	STRING
cosigntowhom	This field can store the name of the creditor to whom this person is a cosigner	NULLABLE	STRING
ref1addresstype	This field stores a code that determines the format of the corresponding Ref 1 Address field for the person defined in Ref 1 Name	NULLABLE	INTEGER
ref2addresstype	This field stores a code that determines the format of the corresponding Ref 2 Address field for the person defined in Ref 2 Name	NULLABLE	INTEGER
ref3addresstype	This field stores a code that determines the format of the corresponding Ref 3 Address field for the person defined in Ref 3 Name	NULLABLE	INTEGER
altemail	This field stores the person's alternate email address	NULLABLE	STRING
locator	This field stores a unique number within each member account that can be used as a unique identification of this record	NULLABLE	INTEGER
mobilephone	This field stores the number for the person's cell phone or other mobile phone device (if any)	NULLABLE	STRING
pagernumber	This field stores the number for the person's pager (if any)	NULLABLE	STRING
uspersonflag	This field stores a code that specifies whether the person 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	This field stores a code that specifies whether the first form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_2	This field stores a code that specifies whether the second form of identification was supported with documentary evidence	NULLABLE	INTEGER
identdocflag_3	This field stores a code that specifies whether the third form of identification was supported with documentary evidence	NULLABLE	INTEGER
identidtype_1	This field stores a code that specifies the type of documentation (if any) that was used to support the first form of identification	NULLABLE	INTEGER
identidtype_2	This field stores a code that specifies the type of documentation (if any) that was used to support the second form of identification	NULLABLE	INTEGER
identidtype_3	This field stores a code that specifies the type of documentation (if any) that was used to support the third form of identification	NULLABLE	INTEGER
identiddescription_1	This field stores further detail about the corresponding ID type to support the first form of identification	NULLABLE	STRING
identiddescription_2	This field stores further detail about the corresponding ID type to support the second form of identification	NULLABLE	STRING
identiddescription_3	This field stores further detail about the corresponding ID type to support the third form of identification	NULLABLE	STRING
identidnumber_1	This field stores the value of the type of identification specified by the corresponding ID type to support the first form of identification	NULLABLE	STRING
identidnumber_2	This field stores the value of the type of identification specified by the corresponding ID type to support the second form of identification	NULLABLE	STRING
identidnumber_3	This field stores the value of the type of identification specified by the corresponding ID type to support the third form of identification	NULLABLE	STRING
identidissuedate_1	This field stores the date the type of identification specified by the corresponding ID type was issued, if known, to support the first form of identification	NULLABLE	DATE
identidissuedate_2	This field stores the date the type of identification specified by the corresponding ID type was issued, if known, to support the second form of identification	NULLABLE	DATE
identidissuedate_3	This field stores the date the type of identification specified by the corresponding ID type was issued, if known, to support the third form of identification	NULLABLE	DATE
identidexpiredate_1	This field stores the date the type of identification specified by the corresponding ID type expires, if known, to support the first form of identification	NULLABLE	DATE
identidexpiredate_2	This field stores the date the type of identification specified by the corresponding ID type expires, if known, to support the second form of identification	NULLABLE	DATE
identidexpiredate_3	This field stores the date the type of identification specified by the corresponding ID type expires, if known, to support the third form of identification	NULLABLE	DATE
identidverifydate_1	This field stores the date the type of identification specified by the corresponding ID type was verified to support the first form of identification	NULLABLE	DATE
identidverifydate_2	This field stores the date the type of identification specified by the corresponding ID type was verified to support the second form of identification	NULLABLE	DATE
identidverifydate_3	This field stores the date the type of identification specified by the corresponding ID type was verified to support the third form of identification	NULLABLE	DATE
nameformat	This field stores a code that indicates whether the name is an individual or not	NULLABLE	INTEGER
extendedname	If you enter more than 40 characters (up to 80 characters) in the Last Name/Non Indiv Name field, Symitar Quest stores the second 40 characters in this field	NULLABLE	STRING
extrainfo	This field stores a line of miscellaneous information	NULLABLE	STRING
recordchangedate	This field stores the system date in this field when you create, change, or save the Application Person record. Sometimes Symitar Quest updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
phonetype	This field stores a code that indicates a domestic or foreign phone number type	NULLABLE	INTEGER
preferredcontactmethod	This field stores a code that indicates how the member wants to receive information from the credit union	NULLABLE	INTEGER
hmdaethnicity_1	These fields each store a code that indicates the ethnicity of the applicant or borrower	NULLABLE	INTEGER
hmdaethnicity_2	These fields each store a code that indicates the ethnicity of the applicant or borrower	NULLABLE	INTEGER
hmdaethnicity_3	These fields each store a code that indicates the ethnicity of the applicant or borrower	NULLABLE	INTEGER
hmdaethnicity_4	These fields each store a code that indicates the ethnicity of the applicant or borrower	NULLABLE	INTEGER
hmdaethnicity_5	These fields each store a code that indicates the ethnicity of the applicant or borrower	NULLABLE	INTEGER
hmdaethnicityother_1	These fields each store the specific other Hispanic or Latino ethnicity not listed in the Ethnicity of Applicant 1-5 fields	NULLABLE	STRING
hmdaethnicityother_2	These fields each store the specific other Hispanic or Latino ethnicity not listed in the Ethnicity of Applicant 1-5 fields	NULLABLE	STRING
hmdaethnicityother_3	These fields each store the specific other Hispanic or Latino ethnicity not listed in the Ethnicity of Applicant 1-5 fields	NULLABLE	STRING
hmdaethnicityvisind	This field stores a code that indicates whether the ethnicity of the applicant or borrower was collected based on visual observation or surname	NULLABLE	INTEGER
hmdarace_1	These fields each store a code that indicates the race of the applicant or borrower	NULLABLE	INTEGER
hmdarace_2	These fields each store a code that indicates the race of the applicant or borrower	NULLABLE	INTEGER
hmdarace_3	These fields each store a code that indicates the race of the applicant or borrower	NULLABLE	INTEGER
hmdarace_4	These fields each store a code that indicates the race of the applicant or borrower	NULLABLE	INTEGER
hmdarace_5	These fields each store a code that indicates the race of the applicant or borrower	NULLABLE	INTEGER
hmdaraceother1_1	These fields each store the specific American Indian or Alaska Native enrolled, or principal tribes if option (1) American Indian or Alaska Native was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother1_2	These fields each store the specific American Indian or Alaska Native enrolled, or principal tribes if option (1) American Indian or Alaska Native was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother1_3	These fields each store the specific American Indian or Alaska Native enrolled, or principal tribes if option (1) American Indian or Alaska Native was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother27_1	These fields each store the specific other Asian races if option (27) Other Asian was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother27_2	These fields each store the specific other Asian races if option (27) Other Asian was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother27_3	These fields each store the specific other Asian races if option (27) Other Asian was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother44_1	These fields each store the specific other Pacific Islander races if option (44) Other Pacific Islander was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother44_2	These fields each store the specific other Pacific Islander races if option (44) Other Pacific Islander was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaraceother44_3	These fields each store the specific other Pacific Islander races if option (44) Other Pacific Islander was selected at any of the Race of Applicant 1-5 fields	NULLABLE	STRING
hmdaracevisind	This field stores a code that indicates whether the race of the applicant or borrower was collected based on visual observation or surname	NULLABLE	INTEGER
hmdasexind	This field stores a code that indicates the sex of the applicant or borrower	NULLABLE	INTEGER
hmdasexvisind	This field stores a code that indicates whether the sex of the applicant was collected based on visual observation or surname	NULLABLE	INTEGER
hmdaage	This field stores, in numeral form, the age of the applicant	NULLABLE	INTEGER
hmdacreditscore	This field stores, in numeral form, the credit score, or scores used in making the credit decision	NULLABLE	INTEGER
hmdaappscoringmodel	This field stores a code that indicates the name and version of the credit scoring model used to generate the credit score, or scores, relied on in making the credit decision	NULLABLE	INTEGER
hmdaappscoringmodelother_1	These fields each store the specific other credit scoring model if option (8) Other credit scoring model was selected at the Applicant Scoring Model field	NULLABLE	STRING
hmdaappscoringmodelother_2	These fields each store the specific other credit scoring model if option (8) Other credit scoring model was selected at the Applicant Scoring Model field	NULLABLE	STRING
hmdaappscoringmodelother_3	These fields each store the specific other credit scoring model if option (8) Other credit scoring model was selected at the Applicant Scoring Model field	NULLABLE	STRING
activeduty	This field stores a code that identifies whether the borrower, or a family member, is in active military service	NULLABLE	INTEGER
activedutyverificationdate	This field stores the date when you verify that the borrower is on active duty or is the dependent of someone on active duty	NULLABLE	DATE
activedutystartdate	This field stores the date when the borrower begins active duty or is the dependent of someone who begins active duty	NULLABLE	DATE
activedutyseparationdate	This field stores the date when the borrower is no longer on active duty or is the dependent of someone no longer on active duty	NULLABLE	DATE
beneficialowner	This field stores a code that specifies whether the person directly or indirectly owns 25% or more of the equity interests or has significant responsibility to control, manage, or direct the legal entity customer	NULLABLE	INTEGER
beneficialpercent	This field stores the percentage of the equity interests of the legal entity customer that this person owns	NULLABLE	INTEGER
lei	This field stores the unique alpha-numeric code associated with a single corporate entity for international financial market record keeping	NULLABLE	STRING
headquarters	This field indicates if the record pertains to the entity's main base of operations or headquarters	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