CREDIT_PUBLIC_RECORD

CREDIT_PUBLIC_RECORD_DETAIL

EntityType	Dependent
Logical Entity Name	CREDIT_PUBLIC_RECORD_DETAIL
Default Table Name	DEAL/SERVICES/SERVICE/CREDIT/CREDIT_REQUEST/CREDIT_PUBLIC_RECORDS/CREDIT_PUBLIC_RECORD/CREDIT_PUBLIC_RECORD_DETAIL
Definition
Note

CREDIT_PUBLIC_RECORD_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

CreditPublicRecordAccountOwnershipType CreditPublicRecordAccountOwnershipEnum VARCHAR(0) YES Describes the ownership relation of the borrower(s) to the public record (i.e. are they individually responsible, jointly responsible, terminated).

CreditPublicRecordAttorneyName MISMOString VARCHAR(0) NO The name of the attorney (normally the plaintiff) reported in the public record.

CreditPublicRecordConsumerDisputeIndicator MISMOIndicator BIT NO This element indicates whether or not the consumer (borrower) disputes information reported for this public record and has filed a FCRA dispute form.

CreditPublicRecordCourtName MISMOString VARCHAR(0) NO The name of the court reporting the public record.

CreditPublicRecordDefendantName MISMOString VARCHAR(0) NO The name of the defendant in a public record.

CreditPublicRecordDerogatoryDataIndicator MISMOIndicator BIT NO This element indicates whether or not the public record contains adverse or derogatory information.

CreditPublicRecordDispositionDate MISMODate DATE NO This element provides the date that the Public Record Disposition Type first became effective.

CreditPublicRecordDispositionType CreditPublicRecordDispositionEnum VARCHAR(0) YES This is the enumerated disposition or the public record as of the Disposition Date. If the disposition does not fit one of the enumerated categories, select Other, and enter it in the Credit Public Record Disposition Type Other Description element.

CreditPublicRecordDispositionTypeOtherDescription MISMOString VARCHAR(0) NO If the Credit Public Record Disposition Type is set to Other, enter the disposition in this element.

CreditPublicRecordDocketIdentifier MISMOIdentifier VARCHAR(0) NO The Docket Identifier can be a Case Number, Docket Number, Public Record Book, Page or Sequence Number.

CreditPublicRecordFiledDate MISMODate DATE NO The date that the public record was filed by the court.

CreditPublicRecordLegalObligationAmount MISMOAmount DECIMAL(0, 2) NO This is the amount listed in the public record that the defendant is obligated to pay.

CreditPublicRecordManualUpdateIndicator MISMOIndicator BIT NO This element indicates whether or not the data in the public record has been manually updated by the credit bureau based on an investigation.

CreditPublicRecordPaidDate MISMODate DATE NO The date that the Legal Obligation Amount was paid to zero.

CreditPublicRecordPaymentFrequencyType CreditPublicRecordPaymentFrequencyEnum VARCHAR(0) YES This element indicates the frequency of payments allowed for the Legal Obligation Amount.

CreditPublicRecordPaymentFrequencyTypeOtherDescription MISMOString VARCHAR(0) NO A free form text field used to collect additional information when Other is selected for Credit Public Record Payment Frequency Type.

CreditPublicRecordPlaintiffName MISMOString VARCHAR(0) NO The name of the plaintiff in a public record.

CreditPublicRecordReportedDate MISMODate DATE NO The date that the public record data was last reported by the court to the credit repository bureau.

CreditPublicRecordSettledDate MISMODate DATE NO The date that the public record case was settled.

CreditPublicRecordType CreditPublicRecordEnum VARCHAR(0) YES This is the enumerated type of public record reported by the credit bureau. If the type does not fit one of the enumerated categories, enter the type in the Credit Public Record Type Other Description element.

CreditPublicRecordTypeOtherDescription MISMOString VARCHAR(0) NO If the Public Record Type is set to Other, enter the type in this element.

DuplicateGroupIdentifier MISMOIdentifier VARCHAR(0) NO Data records with the same Duplicate Group Identifier value have been identified as being duplicate records from different sources. Within a set of records that have the same Duplicate Group Identifier, one record is marked with a Primary Record Indicato

PrimaryRecordIndicator MISMOIndicator BIT NO If this indicator is missing or if this indicator is set to "True", the data element is the primary record to be used for output and evaluation. Most mortgage credit report data is collected from multiple sources (i.e. Equifax, Experian and Trans Union),

CREDIT_PUBLIC_RECORD_DETAIL Keys

Key Name Key Type Keys

CREDIT_PUBLIC_RECORD_DETAIL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

CREDIT_PUBLIC_RECORD Identifying One to Zero or One NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

CREDIT_PUBLIC_RECORD_DETAIL Check Constraints

Check Constraint Name CheckConstraint

CREDIT_PUBLIC_RECORD_DETAIL Bound Attachments

Name Current Value

CREDIT_PUBLIC_RECORD_DETAIL User-Defined Mappings

Model Name Description

CREDIT_PUBLIC_RECORD_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
CreditPublicRecordAccountOwnershipType	CreditPublicRecordAccountOwnershipEnum	VARCHAR(0)	YES	Describes the ownership relation of the borrower(s) to the public record (i.e. are they individually responsible, jointly responsible, terminated).
CreditPublicRecordAttorneyName	MISMOString	VARCHAR(0)	NO	The name of the attorney (normally the plaintiff) reported in the public record.
CreditPublicRecordConsumerDisputeIndicator	MISMOIndicator	BIT	NO	This element indicates whether or not the consumer (borrower) disputes information reported for this public record and has filed a FCRA dispute form.
CreditPublicRecordCourtName	MISMOString	VARCHAR(0)	NO	The name of the court reporting the public record.
CreditPublicRecordDefendantName	MISMOString	VARCHAR(0)	NO	The name of the defendant in a public record.
CreditPublicRecordDerogatoryDataIndicator	MISMOIndicator	BIT	NO	This element indicates whether or not the public record contains adverse or derogatory information.
CreditPublicRecordDispositionDate	MISMODate	DATE	NO	This element provides the date that the Public Record Disposition Type first became effective.
CreditPublicRecordDispositionType	CreditPublicRecordDispositionEnum	VARCHAR(0)	YES	This is the enumerated disposition or the public record as of the Disposition Date. If the disposition does not fit one of the enumerated categories, select Other, and enter it in the Credit Public Record Disposition Type Other Description element.
CreditPublicRecordDispositionTypeOtherDescription	MISMOString	VARCHAR(0)	NO	If the Credit Public Record Disposition Type is set to Other, enter the disposition in this element.
CreditPublicRecordDocketIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The Docket Identifier can be a Case Number, Docket Number, Public Record Book, Page or Sequence Number.
CreditPublicRecordFiledDate	MISMODate	DATE	NO	The date that the public record was filed by the court.
CreditPublicRecordLegalObligationAmount	MISMOAmount	DECIMAL(0, 2)	NO	This is the amount listed in the public record that the defendant is obligated to pay.
CreditPublicRecordManualUpdateIndicator	MISMOIndicator	BIT	NO	This element indicates whether or not the data in the public record has been manually updated by the credit bureau based on an investigation.
CreditPublicRecordPaidDate	MISMODate	DATE	NO	The date that the Legal Obligation Amount was paid to zero.
CreditPublicRecordPaymentFrequencyType	CreditPublicRecordPaymentFrequencyEnum	VARCHAR(0)	YES	This element indicates the frequency of payments allowed for the Legal Obligation Amount.
CreditPublicRecordPaymentFrequencyTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Credit Public Record Payment Frequency Type.
CreditPublicRecordPlaintiffName	MISMOString	VARCHAR(0)	NO	The name of the plaintiff in a public record.
CreditPublicRecordReportedDate	MISMODate	DATE	NO	The date that the public record data was last reported by the court to the credit repository bureau.
CreditPublicRecordSettledDate	MISMODate	DATE	NO	The date that the public record case was settled.
CreditPublicRecordType	CreditPublicRecordEnum	VARCHAR(0)	YES	This is the enumerated type of public record reported by the credit bureau. If the type does not fit one of the enumerated categories, enter the type in the Credit Public Record Type Other Description element.
CreditPublicRecordTypeOtherDescription	MISMOString	VARCHAR(0)	NO	If the Public Record Type is set to Other, enter the type in this element.
DuplicateGroupIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Data records with the same Duplicate Group Identifier value have been identified as being duplicate records from different sources. Within a set of records that have the same Duplicate Group Identifier, one record is marked with a Primary Record Indicato
PrimaryRecordIndicator	MISMOIndicator	BIT	NO	If this indicator is missing or if this indicator is set to "True", the data element is the primary record to be used for output and evaluation. Most mortgage credit report data is collected from multiple sources (i.e. Equifax, Experian and Trans Union),

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
CREDIT_PUBLIC_RECORD	Identifying	One to Zero or One					NO