CreditCommentCode |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentCode |
Logical Rolename | |
ColumnName | CreditCommentCode |
RoleName | |
Domain | MISMOCode |
Definition | This is a code value that may be associated with Credit Comment Text data. This could be a repository bureau code (Equifax, Experian, Trans Union), or it could be a code provided by a lender, credit bureau or other source that is specified in the Credit C |
Note |
CreditCommentCode Logical Attribute Properties |
Logical Attribute Name | CreditCommentCode |
Datatype | VARCHAR(0) |
Nullable | NO |
CreditCommentCode Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentCode Bound Attachments |
Name | Current Value |
CreditCommentCode User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentCode Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCode Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCode Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCode Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber |
Base Entity | CREDIT_COMMENT |
Attribute Name | SequenceNumber |
Logical Rolename | |
ColumnName | SequenceNumber |
RoleName | |
Domain | XSD:Integer |
Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
Note |
SequenceNumber Logical Attribute Properties |
Logical Attribute Name | SequenceNumber |
Datatype | INTEGER |
Nullable | YES |
SequenceNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SequenceNumber Bound Attachments |
Name | Current Value |
SequenceNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SequenceNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceType |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentCodeSourceType |
Logical Rolename | |
ColumnName | CreditCommentCodeSourceType |
RoleName | |
Domain | CreditCommentCodeSourceEnum |
Definition | This data element provides an enumerated list of sources for the Credit Comment data. |
Note |
CreditCommentCodeSourceType Logical Attribute Properties |
Logical Attribute Name | CreditCommentCodeSourceType |
Datatype | VARCHAR(0) |
Nullable | YES |
CreditCommentCodeSourceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentCodeSourceType Reference Value (Bound to Domain) |
Name | ValidationRule87 |
Description | |
Type | By List |
Value | Value Description |
EquifaxBankruptcy | Code List Found In: Equifax STS V5/V6 Guide / Attachment 2 – Equifax Bankruptcy Intent/Disposition Codes. Data Source: Segment 13 (BP Record) / Current Intent Disposition Code. |
EquifaxCollectionStatus | Code List Found In: Equifax STS V5/V6 Guide / Attachment 3 – Equifax Collection Status Codes Data Source: Segment 14 (CO Record) / Collection Status Code |
EquifaxLegalStatus | Code List Found In: Equifax STS V5/V6 Guide / Attachment 17 – Equifax Legal Item Status Codes Data Source: Segment 16 (LI Record) / Status Code |
EquifaxNarrative | Code List Found In: Equifax STS V5/V6 Guide / Attachment 6 – Equifax Narrative Codes Data Source: Segment 13 (BP Record) / Narrative Code #1, #2 Data Source: Segment 14 (CO Record) / Narrative Code #1, #2 Data Source: Segment 16 (LI Record) / Narrative Code #1, #2 Data Source: Segment 20 (TL Record) / Narrative Code #1, #2 Data Source: Segment 23 (TC/PT Record) / Narrative Code #1, #2 |
ExperianAccountPurpose | Code List Found In: Experian File One Appendix G – Account Purpose Type Codes Data Source: 357 Segment / Type Code Data Source: 357 Segment – F3 Sub-segment / Enhanced Type Code Data Source: 359 Segment / Type Code |
ExperianAccountStatus | Code List Found In: Experian File One Appendix L – Account Condition and Payment Status Codes Data Source: 357 Segment / Status Code Data Source: 357 Segment – F3 Sub-segment / Account Condition Code Data Source: 357 Segment – F3 Sub-segment / Enhanced Payment Status |
ExperianLegalStatus | Code List Found In: Experian File One Appendix C – Legal Status Codes and Designators Data Source: 350 Segment / Status Code |
ExperianSpecialComment | Code List Found In: Experian File One Appendix B – Special Comment Codes Data Source: 357 Segment / Special Comment Code Data Source: 357 Segment – F3 Sub-segment / Enhanced Special Comment Code |
Other | Code List is from another source that is identified in Credit Comment Code Source Type Other Description. |
TransUnionLoanType | Code List Found In: Trans Union 4.0 User Guide – Appendix C. Loan Type Codes Data Source: IN01 Segment / Loan Type Code Data Source: TR01 Segment / Loan Type Code |
TransUnionPublicRecordType | Code List Found In: Trans Union 4.0 User Guide – Appendix D. Public Record Type Codes Data Source: PR01 Segment / Public Record Type |
TransUnionRemarks | Code List Found In: Trans Union 4.0 User Guide – Appendix C. Remarks Codes Data Source: TR01 Segment / Remarks Code |
CreditCommentCodeSourceType Bound Attachments |
Name | Current Value |
CreditCommentCodeSourceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentCodeSourceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceTypeOtherDescription |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentCodeSourceTypeOtherDescription |
Logical Rolename | |
ColumnName | CreditCommentCodeSourceTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | When Credit Comment Source Type is set to Other, enter its value in this data element. |
Note |
CreditCommentCodeSourceTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | CreditCommentCodeSourceTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
CreditCommentCodeSourceTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentCodeSourceTypeOtherDescription Bound Attachments |
Name | Current Value |
CreditCommentCodeSourceTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentCodeSourceTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentCodeSourceTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentReportedDate |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentReportedDate |
Logical Rolename | |
ColumnName | CreditCommentReportedDate |
RoleName | |
Domain | MISMODate |
Definition | Indicates the date that the credit bureaus added the comment to the file of the borrower. |
Note |
CreditCommentReportedDate Logical Attribute Properties |
Logical Attribute Name | CreditCommentReportedDate |
Datatype | DATE |
Nullable | NO |
CreditCommentReportedDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentReportedDate Bound Attachments |
Name | Current Value |
CreditCommentReportedDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentReportedDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentReportedDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentReportedDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentReportedDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentSourceType |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentSourceType |
Logical Rolename | |
ColumnName | CreditCommentSourceType |
RoleName | |
Domain | CreditCommentSourceEnum |
Definition | This data element provides an enumerated list of sources for the Credit Comment data. |
Note |
CreditCommentSourceType Logical Attribute Properties |
Logical Attribute Name | CreditCommentSourceType |
Datatype | VARCHAR(0) |
Nullable | YES |
CreditCommentSourceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentSourceType Reference Value (Bound to Domain) |
Name | ValidationRule89 |
Description | |
Type | By List |
Value | Value Description |
Borrower | The comment was from the borrower or coborrower. |
CreditBureau | The comment text was from the credit bureau that prepared the credit report. |
Equifax | Equifax - the credit data repository provided the comment and/or code. |
Experian | Experian - the credit data repository provided the comment and/or code. |
Lender | The lender provided the comment and/or code. |
RepositoryBureau | One of the repository bureaus - not specified - provided the comment and/or code. |
TransUnion | Trans Union - the credit data repository provided the comment and/or code. |
CreditCommentSourceType Bound Attachments |
Name | Current Value |
CreditCommentSourceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentSourceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentSourceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentSourceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentSourceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentText |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentText |
Logical Rolename | |
ColumnName | CreditCommentText |
RoleName | |
Domain | MISMOString |
Definition | This data element holds comment text data that can appear in various locations on a credit report. The Credit Comment Source Type describes the source of the comment - borrower, credit bureau, lender, or repository bureau. |
Note |
CreditCommentText Logical Attribute Properties |
Logical Attribute Name | CreditCommentText |
Datatype | VARCHAR(0) |
Nullable | NO |
CreditCommentText Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentText Bound Attachments |
Name | Current Value |
CreditCommentText User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentText Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentText Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentText Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentText Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentType |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentType |
Logical Rolename | |
ColumnName | CreditCommentType |
RoleName | |
Domain | CreditCommentEnum |
Definition | Allows the credit bureau to identify the type of credit comment (e.g. Consumer Statement). |
Note |
CreditCommentType Logical Attribute Properties |
Logical Attribute Name | CreditCommentType |
Datatype | VARCHAR(0) |
Nullable | YES |
CreditCommentType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentType Reference Value (Bound to Domain) |
Name | ValidationRule88 |
Description | |
Type | By List |
Value | Value Description |
BureauRemarks | Additional text comments provided by the credit bureau or repository bureau. See Credit Comment Source Type attribute for the exact source. Equifax Narrative codes are listed in Attachment 6 of the Equifax System-to-System V5/V6 Manuals. Experian Comment Codes are listed in Appendix B of the Experian Technical Manual. Trans Union Remarks Codes are listed in Appendix C of the TU Release 4 User Guide. |
ConsumerStatement | Comments from the borrower regarding their credit report data. |
Instruction | Request for Update of credit information are normally accompanied by special instruction comments. |
Other | See Credit Comment Type Other Description. |
PublicRecordText | Additional text regarding public record data. See Credit Comment Source Type attribute for the exact source. |
StatusCode | The comment text matches the status code listed in the specification for the entity listed in the Credit Comment Source Type attribute. Experian Status Codes are listed in Appendix N of the Experian Technical Manual. |
Warning | The comment text indicates information being reported that may warrant additional investigation or consideration. |
CreditCommentType Bound Attachments |
Name | Current Value |
CreditCommentType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentTypeOtherDescription |
Base Entity | CREDIT_COMMENT |
Attribute Name | CreditCommentTypeOtherDescription |
Logical Rolename | |
ColumnName | CreditCommentTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | When Credit Comment Type is set to Other, enter its value in this data element. |
Note |
CreditCommentTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | CreditCommentTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
CreditCommentTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditCommentTypeOtherDescription Bound Attachments |
Name | Current Value |
CreditCommentTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditCommentTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditCommentTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |