exhibit bb eoscar data fields and rules -...

21
Exhibit BB eOscar data fields and rules

Upload: dinhnga

Post on 20-May-2018

217 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

Exhibit BB

eOscar data fields and rules

Page 2: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

E-OSCAR WEB

Web Field Edits Document

Version 1.0

ACDV/AUD System

Web Field edits Document

Page 3: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

Document Control

Change Record

Date Author Version Change Reference

06/18/2002 Alexander Thomas 1.0 Created

Reviewers

Name Position

Page 4: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

Table of Web field edits with Rules:

All rules from the Metro 2 Format and ACDV Phase 3 Format apply. Additionally:

1. ACDV Field Edits.

FIELD NAME RULE

Last Name • Valid characters: Alpha, "-" or spaces or “/” • Minimum two characters

First Name • Valid Characters : Alpha, “-“ or spaces • Minimum one character

Middle Name • Valid characters: Alpha, "-", or spaces

• Should not be blank. Date of Birth • Numeric, MMDDYYYY

• Numeric, YYYY • Must be valid date

• Must not be a future date i.e. must be less than the current date.

Street Address • Valid characters: Alpha, "-", "/”, #, or spaces, numbers

• Minimum two characters City • Valid characters: Alpha, "-", ”#”, or spaces

• Minimum one character.

• Cannot be blank. State • Must be valid State or Province code (postal abbreviations)

• Should be selected from the pick list and should not be left blank. • Must be valid state if zip is given

Zip • Zip code consists of 2 fields. • The first field must be at least 5 characters long. • The combined fields can be 5, 6 or 9 characters long, meaning

the second field can be zero, 1 or 4 characters long. • Zip code can contain alphanumeric characters but only capital

letters are allowed. • Only alphanumeric and numbers are allowed. • Cannot be blank.

Social security number (SSN)

• Consists of 3 fields. • Combined length of all 3 fields should be at least 9 characters. • Only numbers are allowed. • Zero filled values are not allowed meaning 0 shouldn’t be printed

in at any position in any field.

Page 5: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Phone • Phone consists of 3 fields.

• Length should be less than 10. • Alpha characters are not allowed. • “900” or “000” is not allowed in the first field. • “555” or “976” is not allowed in the second field. • The first character in second field should not be “1”. • Any two characters taken in sequence should not be same. i.e.

sequences like 11,22,33,333,44444,1111,etc are not allowed.

Dispute code 1 • Should not be blank and should be selected from the pick list. Dispute code 1 • Could be blank or selected from the pick list. FCRA relevant information

• Single or double quotes are not allowed. • More than 250 characters not allowed.

Subscriber code • Single or double quotes are not allowed. • Should not be blank.

ECOA code • Should not be blank and should be selected from the list. ACDV control number

• Cannot be blank.

Date No response

• Cannot be blank. • Numeric Valid date field in MMDDYYYY format. • Only future dates should be entered.

Date opened • Cannot be blank. • Numeric Valid date field in MMDDYYYY format. • No future dates should be entered. • Must be < ‘Date closed’ field. • Must be <= ‘Date Of Last Payment’ field. • Must be <= ‘Billing Date’ field. • Must be <= ‘Status Date’ field. • In case ECOA Code = 0(Undesignated), Date Opened is only

valid on accounts opened prior to 1st June 1977. Date of last payment

• Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Date closed • Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Current balance • Current Balance must be a numeric field. • Current balance is always absolute and no decimal places should

be entered, meaning whole dollars and not cents should be reported.

• No negative values. Negative credit balances should be reported as zero.

Activity Date • Cannot be blank. • Numeric Valid date field in MMDDYYYY format. • No future dates should be entered.

Page 6: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Narrative remarks

• Single or double quotes not allowed.

Account number • Cannot be blank. • Valid characters: Alphanumeric, "-"

• Cannot be blank. • Numeric Valid date field in MMDDYYYY format. • No future dates should be entered.

Account type • Either portfolio type or Account type should be selected. Both should not be empty.

Portfolio type • Either portfolio type or Account type should be selected. Both should not be empty.

FCRA Date Of First Delinquency

• Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Amount past due • Amount past due must be a numeric field. • Amount past due is always absolute and no decimal places

should be entered, meaning whole dollars and not cents should be reported.

• No negative values. Negative values should be reported as zero. Highest credit / original amount

• Numeric field. • Absolute and decimal places should not be entered, meaning

whole dollars and not cents should be reported. • No negative values. Negative values should be reported as zero.

Original charge off amount

• Numeric field. • Absolute and decimal places should not be entered, meaning

whole dollars and not cents should be reported. • No negative values. Negative values should be reported as zero.

Scheduled Monthly Payment

• Numeric field. • Absolute and decimal places should not be entered, meaning

whole dollars and not cents should be reported. • No negative values. Negative values should be reported as zero.

Actual payment • Numeric field. • Absolute and decimal places should not be entered, meaning

whole dollars and not cents should be reported. • No negative values. Negative values should be reported as zero.

Account History • Only 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, B, D, E, G, H, J, K, L are valid values.

• Value to be put in each month from when payment history begins to when it ends. Blank months cannot be left in the middle of the Account Payment History.

Balloon payment amount

• Numeric field. • Absolute and decimal places should not be entered, meaning

whole dollars and not cents should be reported. • No negative values. Negative values should be reported as zero.

Page 7: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Deferred Payment start date

• Must be a valid numeric date field. • MMDDYYYY format. • Only future dates are valid. • If this field is given, then Terms frequency should also be ‘D’.

Balloon Payment Due Date

• Must be a valid numeric date field. • MMDDYYYY format. • Only future dates are valid.

Original Creditor Name

• Single or Double quotes are not allowed.

Sold to Name • Single or Double quotes are not allowed. Secondary Marketing Agency Account No.

• Single or Double quotes are not allowed.

Mortgage Identification number (MIN)

• Single or Double quotes are not allowed.

Cumulative Status

• Single or Double quotes are not allowed.

Terms Duration • Valid values consist of either the number of months, 1-999 or LOC (line of credit), or REV (revolving), or 001(open).

2. AUD Field Edits.

FIELD NAME RULE

Last Name • Valid characters: Alpha, "-" or spaces or “/” • Minimum two characters

First Name • Valid Characters: Alpha, “-“ or spaces • Minimum one character

Middle Name • Valid characters: Alpha, "-", or spaces

• Should not be blank. Date of Birth • Numeric, MMDDYYYY

• Numeric, YYYY • Must be valid date

• Must not be a future date i.e. must be less than the current date.

Street Address • Valid characters: Alpha, "-", "/”, #, or spaces, numbers

• Minimum two characters City • Valid characters: Alpha, "-", ”#”, or spaces

• Minimum one character.

• Cannot be blank.

Page 8: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE State • Must be valid State or Province code (postal abbreviations)

• Should be selected from the pick list and should not be left blank. • Must be valid state if zip is given

Zip • Zip code consists of 2 fields. • The first field must be at least 5 characters long. • The combined fields can be 5, 6 or 9 characters long, meaning

the second field can be zero, 1 or 4 characters long. • Zip code can contain alphanumeric characters but only capital

letters are allowed. • Only alphanumeric and numbers are allowed. • Cannot be blank.

Subscriber Code • Single or double quotes are not allowed. • Should not be blank.

ECOA code • Should not be blank and should be selected from the list. Social security number (SSN)

• Consists of 3 fields. • Combined length of all 3 fields should be at least 9 characters. • Only numbers are allowed. • Zero filled values are not allowed meaning 0 shouldn’t be printed

in at any position in any field. Phone • Phone consists of 3 fields.

• Length should be less than 10. • Alpha characters are not allowed. • “900” or “000” is not allowed in the first field. • “555” or “976” is not allowed in the second field. • The first character in second field should not be “1”. • Any two characters taken in sequence should not be same. i.e.

sequences like 11,22,33,333,44444,1111,etc are not allowed.

Occupation • Single or double quotes are not allowed. Portfolio Type • Should not be blank and should be selected from the list. Account Type • Should not be blank and should be selected from the list. Account Number • Cannot be blank.

• Valid characters: Alphanumeric, "-". • Embedded blanks are not allowed.

Page 9: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Date opened • Cannot be blank.

• Must be a valid numeric date field. • MMDDYYYY format.

• No future dates are valid.

• Cannot be < ‘Date of Birth’ field.

• If ECOA Code = 0(Undesignated), Date opened is only valid on accounts opened prior to June 1, 1977 and must be less than that date.

• Date Opened < Date Closed.

• If Account Type ="48" or Account Type = "77" or Account Type ="0C" or DF Type= "1" or DF Type = "2" or DF Type="3", then Date of First Delinquency must be less than Date Opened.

• If the above condition is not met, then Date Opened must be less than Date of First Delinquency.

• Date Opened <= Date Of Last Payment.

• Date Opened <= Billing Date. Activity Date • Must be a valid numeric date field.

• MMDDYYYY format.

• No future dates are valid.

• If AUD correction Indicator is ‘1’ or ‘2’ i.e. Update or Add, then Activity date cannot be blank.

Current balance • Current Balance must be a numeric field. • Current balance is always absolute and no decimal places should

be entered, meaning whole dollars and not cents should be reported.

• No negative values. Negative credit balances should be reported as zero.

• Current Balance >= Amount Past Due. • If AUD correction Indicator is ‘2’ i.e. Add, then Current balance

cannot be blank. Account History • Only 0, 1, 2, 3, 4, 5, 6, B, D, E, G, H, J, K, L are valid values.

• Value to be put in each month from when payment history begins to when it ends. Blank months cannot be left in the middle of the Account Payment History.

• Account History 'B' is only valid at the end of Account Payment History.

Original Creditor Name

• Cannot be blank if DF type = ‘1’.

Date of Last Payment

• Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Date Closed • Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Page 10: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Billing Date • Must be a valid numeric date field.

• MMDDYYYY format. • No future dates are valid.

FCRA Date Of First Delinquency

• Must be a valid numeric date field. • MMDDYYYY format. • No future dates are valid.

Amount Past Due

• Must be a numeric field. • Always absolute and no decimal places should be entered,

meaning whole dollars and not cents should be reported. • No negative values. Negative credit balances should be reported

as zero. Highest Credit Amount

• Must be a numeric field. • Always absolute and no decimal places should be entered,

meaning whole dollars and not cents should be reported. • No negative values. Negative credit balances should be reported

as zero. Original Charge-off Amount

• Must be a numeric field. • Always absolute and no decimal places should be entered,

meaning whole dollars and not cents should be reported. • No negative values. Negative credit balances should be reported

as zero. Scheduled Monthly payment

• Must be a numeric field. • Always absolute and no decimal places should be entered,

meaning whole dollars and not cents should be reported. • No negative values. Negative credit balances should be reported

as zero. Actual Payment • Must be a numeric field.

• Always absolute and no decimal places should be entered, meaning whole dollars and not cents should be reported.

• No negative values. Negative credit balances should be reported as zero.

Balloon Payment Amount

• Must be a numeric field. • Always absolute and no decimal places should be entered,

meaning whole dollars and not cents should be reported. • No negative values. Negative credit balances should be reported

as zero. Deferred Payment Start Date

• Must be a valid numeric date field. • MMDDYYYY format. • Only future dates are valid. • If reporting a Deferred Payment Start Date, Terms Frequency =

‘D’ must be provided. Balloon Payment Due Date

• Must be a valid numeric date field. • MMDDYYYY format. • Only future dates are valid.

Page 11: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Secondary Marketing Agency Account No.

• Single or Double quotes are not allowed.

Account status • Cannot be blank and should be selected from the pick list. • If AUD correction Indicator = ‘3’ i.e. Delete, then Account status

should be ‘DA’ or Delete entire account. • Account Status DA is not allowed with AUD Correction Indicator

2. Terms Duration • Valid values consist of either the number of months, 1-999 or

LOC (line of credit), or REV (revolving), or 001(open). Terms Frequency

• If reporting a Deferred Payment Start Date, Terms Frequency = ‘D’ must be provided.

Specialized Payment Indicator

• If Deferred Payment Date is given or Balloon Payment amount is given or Balloon Payment due date is entered, then Specialized Payment Indicator must be selected from the pick list.

• If Deferred payment date is given, then Specialized Payment Indicator equal to ’01’ must not be given.

• If Balloon Payment due date is given or Balloon Payment amount is given, then Specialized Payment Indicator must not be ‘02’.

Sold to Name • Single or double quotes are not allowed. Secondary Marketing Agency Account No.

• Single or double quotes are not allowed.

Mortgage Identification number (MIN)

• Single or Double quotes are not allowed.

3. Registration field Edits.

FIELD NAME RULE Company Name • Cannot be blank.

• Should be more than 2 characters. • Should not contain special characters except "&" and "-".

Address • Cannot be blank. • Should not contain special characters.

Company Type • Cannot be blank. • Should be selected from the Pick list.

Company City • Cannot be blank. • Should not contain special characters.

Company State • Cannot be blank. • Should not contain special characters.

Page 12: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Company Zip Code

• Must be at least 5 characters long. • Same digits like 11111 or 22222 are not allowed. • Only digits are allowed. • Cannot be blank.

Manager Name • Cannot be blank. • Only characters are allowed. • No special characters are allowed. • Should be more than 2 characters. • Should not be the Alternate Help desk contact name.

Manager Title • Should be more than 2 characters. • No special characters are allowed. • Only spaces and characters are allowed.

Manager Email • Should contain “.” And “@” characters. • ‘.’ should not occur at position 1 in the field. • ‘@’ should not be repeated twice. • ‘.’ Should not occur after ‘@’. • ‘@’ should not occur as first character. • ‘.’ Should not occur at last position. • Spaces are not allowed. • Special characters are not allowed.

Manager Address

• Cannot be blank. • Should not contain special characters.

User name • Must be a minimum of 6 characters and a maximum of 20. • May only contain A through Z (either upper of lower case), and 0

though 9. • Must begin with A Through Z (either upper or lower case). • User ID is case sensitive. • Cannot be blank.

Password • Must be a minimum of 6 characters and a maximum of 20 characters.

• May only contain A through Z (either upper of lower case \), 0 though 9 and any special charters except either single or double quote characters ( ' or \" ).

• Password is case sensitive. • The Password entered in both Confirm Password and Password

fields must match. Manager City • Cannot be blank.

• Should not contain special characters. Manager State • Cannot be blank.

• Should not contain special characters.

Page 13: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Manager Telephone

• Phone consists of 3 fields. • Length should be 10. • Alpha characters are not allowed. • “900” or “000” is not allowed in the first field. • “555” or “976” is not allowed in the second field. • The first character in second field should not be “1”. • Any two characters taken in sequence should not be same. i.e.

sequences like 11,22,33,333,44444,1111,etc are not allowed. Manager Fax • Length should be 10.

• Only digits are allowed. Help Desk Contact Name

• Refer Manager name • Cannot be blank.

Compliance Officer Name

• Refer Manager name • Cannot be blank.

Compliance officer Email

• Refer Manager Email. • Cannot be blank.

Compliance Officer Telephone

• Refer Manager Telephone. • Cannot be blank.

CDV Address • Refer Manager Address. • Cannot be blank.

CDV City • Refer Manager City. • Cannot be blank.

CDV State • Refer Manager State. • Cannot be blank.

CDV Zip Code • Refer Manager Zip Code. • Cannot be blank.

Billing contact Name

• Refer Manager name • Cannot be blank.

Billing Contact Email.

• Refer Manager Email. • Cannot be blank.

Billing Contact Address

• Refer Manager Address. • Cannot be blank.

Billing Contact City

• Refer Manager City. • Cannot be blank.

Billing Contact State

• Refer Manager State. • Cannot be blank.

Billing Contact Telephone

• Refer Manager Telephone • Cannot be blank.

Billing Contact Zip Code

• Refer Manager Zip code • Cannot be blank.

NCRA Affiliation* • At least one Affiliation required. Inquiry Code for Equifax

• If Affiliation for this NCRA is selected, then this field cannot be blank.

• No special characters allowed.

Page 14: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Inquiry Code for Experian

• If Affiliation for this NCRA is selected, then this field cannot be blank.

• No special characters allowed. Inquiry Code for Innovis

• If Affiliation for this NCRA is selected, then this field cannot be blank.

• No special characters allowed. Inquiry Code for Trans Union

• If Affiliation for this NCRA is selected, then this field cannot be blank.

• No special characters allowed. ACB Member Number

• Cannot be blank. • No Special characters.

4. System Admin Create User web field Edits.

FIELD NAME RULE User Id • Cannot be blank.

• Must be minimum of 6 characters and maximum of 20. • May only contain A through Z(either upper or lower case), and 0

through 9. User ID must begin with A through Z(either upper or lower case).

• Case sensitive. First Name • Cannot be blank.

• Valid Characters : Alpha, “-“ or spaces • Minimum one character

Last Name • Cannot be blank. • Valid Characters: Alpha, “-“ or spaces • Minimum two characters.

Phone • Phone consists of 3 fields. • Length should be 10. • Alpha characters are not allowed. • “900” or “000” is not allowed in the first field. • “555” or “976” is not allowed in the second field. • The first character in second field should not be “1”. • Any two characters taken in sequence should not be same. i.e.

sequences like 11,22,33,333,44444,1111,etc are not allowed. Email • Should contain “.” And “@” characters.

• ‘.’ should not occur at position 1 in the field. • ‘@’ should not be repeated twice. • ‘.’ Should not occur after ‘@’. • ‘@’ should not occur as first character. • ‘.’ Should not occur at last position. • Spaces are not allowed. • Special characters are not allowed.

Fax • Length should be 10. • Only digits are allowed.

Page 15: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

June 18th, 2002 Web Fields Edits Document

Proprietary and Confidential

FIELD NAME RULE Cost center name

• Minimum of 2 characters are allowed. • No special characters.

User roles • At least one role should be selected.

Page 16: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

ACB

ACDV/AUD

ACDV REQUEST RECORD

Version 1.1

February 10, 2001

Page 17: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

Document Control

Change Record

Date Author Version Change Reference

01/22/2001 S. Reddy 1.0 Baseline

02/10/2001 S. Reddy 1.1 Added fields 75 and 76

Reviewers

Name Position

Page 18: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

ACDV REQUEST RECORD

The following table lists the field numbers, field names, the corresponding column names in the

database, field lengths and the position of each field in the ACDV Request record. The header and

trailer records are shown in the document ‘Field Formats for Batch Transfer, Header and Trailer

Records, Version 01, dated January 22, 2001.

Note:

1. Column 1 (Field No) is a sequential listing of fields for this record.

2. Column 2 (LDD Field No) is shown to reference the document ‘Logical Database Design,

Version 1.11, dated January 10, 2001’.

3. Column 3 (Field Position in Record) lists the position of each field in the record

4. Column 4 (Field Name) lists the field name for this record (refer to ‘Logical Database

Design, Version 1.11, dated January 10, 2001)

5. Column 5 (Column Name in Database) lists the corresponding column name in the

database tables.

6. Column 6 (Field Length) shows the number of character occupied by the field.

7. Column 7 (Alignment) shows if the data for a given field is left justified (LJ) or right

justified (RJ).

8. Column 8 (Req/Opt) shows if the data for a given field is required or optional.

Page 19: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

ADCV REQUEST RECORD

Field

No

LDD

Field

No.

Field Position in Record

Field Name Column Name in Database Field

Length Alignment Req/Opt

1 1 1 - 2 Record Identifier RECORD_ID 2 LJ REQUIRED

2 2 3 - 3 Data Transaction Description (Doc Type) DOC_TYPE 1 LJ REQUIRED

3 3 4 - 6 Originator Code ORIGINATOR_CODE 3 LJ REQUIRED

4 4 7 - 10 Originator Bureau/Office Code OFFICE_CODE 4 LJ REQUIRED

5 5 11 - 30 Subscriber Code SUBSC_CODE 20 LJ REQUIRED

6 6 31 - 70 Data Furnisher Name DF_NAME 40 LJ REQUIRED

7 7 71 - 100 CRA ACDV Control Number CRA_ACDV_CTRL_NUM 30 LJ REQUIRED

8 8 101 - 114 Date/Time Sent/Created DATE_CREATED 14 RJ REQUIRED

9 9 115 - 122 FCRA Compliance Response Due Date FCRA_COMPL_RESP_DUE_DAT

E

8 RJ REQUIRED

10 10 123 - 130 Date No Response (DNR Date) DNR_DATE 8 RJ REQUIRED

11 11 131 - 133 Originator Dispute Code 1 DISPUTE_CODE_1 3 RJ REQUIRED

12 12 134 - 136 Originator Dispute Code 2 DISPUTE_CODE_2 3 RJ OPTIONAL

13 13 137 - 386 FCRA Relevant Information FCRA_RELV_INFO 250 LJ OPTIONAL

14 14 387 - 388 Consumer Information Indicator CNSUMR_INFO_INDIC_CODE 2 LJ OPTIONAL

15 15 389 - 389 ECOA Code ECOA_CODE 1 LJ REQUIRED

16 16 390 - 414 Surname SURNAME 25 LJ REQUIRED

17 17 415 - 434 First Name FIRST_NAME 20 LJ REQUIRED

18 18 435 - 454 Middle Name MIDDLE_NAME 20 LJ OPTIONAL

19 19 455 - 455 Generation Code GEN_CODE 1 LJ OPTIONAL

20 20 456 - 464 Social Security Number SSN 9 RJ OPTIONAL

21 21 465 - 472 Date of Birth DOB 8 RJ OPTIONAL

22 22 473 - 482 Telephone Number TEL_NUM 10 RJ OPTIONAL

23 23 483 - 546 Street Address STREET_ADDR 64 LJ REQUIRED

24 24 547 - 566 City CITY 20 LJ REQUIRED

25 25 567 - 568 State STATE 2 LJ REQUIRED

26 26 569 - 577 Postal/Zip Code ZIP_CODE 9 LJ REQUIRED

27 27 578 - 602 Previous Surname PREV_SURNAME 25 LJ OPTIONAL

28 28 603 - 622 Previous First Name PREV_FIRST_NAME 20 LJ OPTIONAL

29 29 623 - 642 Previous Middle Name PREV_MIDDLE_NAME 20 LJ OPTIONAL

Page 20: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

ADCV REQUEST RECORD

Field

No

LDD

Field

No.

Field Position in Record

Field Name Column Name in Database Field

Length Alignment Req/Opt

30 30 643 - 643 Previous Generation Code PREV_GEN_CODE 1 LJ OPTIONAL

31 31 644 - 707 Previous Street Address. PREV_STREET_ADDR 64 LJ OPTIONAL

32 32 708 - 727 Previous City PREV_CITY 20 LJ OPTIONAL

33 33 728 - 729 Previous State PREV_STATE 2 LJ OPTIONAL

34 34 730 - 738 Previous Postal/Zip Code PREV_ZIP_CODE 9 LJ OPTIONAL

35 35 739 - 802 Second Previous Address SCND_PREV_ADDR 64 LJ OPTIONAL

36 36 803 - 822 Second Previous City SCND_PREV_CITY 20 LJ OPTIONAL

37 37 823 - 824 Second Previous State SCND_PREV_STATE 2 LJ OPTIONAL

38 38 825 - 833 Second Previous Postal/Zip Code SCND_PREV_ZIP_CODE 9 LJ OPTIONAL

39 39 834 - 863 Consumer Account Number CNSUMR_ACCT_NUM 30 LJ REQUIRED

40 40 864 - 864 Portfolio Type PORTF_TYPE_CODE 1 LJ REQUIRED

41 41 865 - 866 Account Type ACCT_TYPE_CODE 2 LJ REQUIRED

42 42 867 - 874 Date Opened DATE_OPENED 8 RJ OPTIONAL

43 43 875 - 883 Credit Limit CREDIT_LIMIT 9 RJ OPTIONAL

44 44 884 - 892 Highest Credit or Original Loan Amount HIGH_CREDIT_ORIG_AMT 9 RJ OPTIONAL

45 45 893 - 895 Terms Duration TERMS_DURATION_CODE 3 LJ OPTIONAL

46 46 896 - 896 Terms Frequency TERMS_FREQ_CODE 1 LJ OPTIONAL

47 47 897 - 905 Scheduled Monthly Payment Amount SCH_MONTHLY_PYMNT_AMT 9 RJ OPTIONAL

48 48 906 - 914 Actual Payment Amount ACTUAL_PYMNT_AMT 9 RJ OPTIONAL

49 49 915 - 916 Account Status ACCT_STATUS_CODE 2 LJ OPTIONAL

50 50 917 - 917 Payment Rating PYMNT_RATING_CODE 1 LJ OPTIONAL

51 51 918 - 1001 7 Year Payment History Profile SEVEN_YR_PYMNT_HIST_PROF

ILE

84 LJ OPTIONAL

52 52 1002 - 1003 Special Comment SPEC_COMMENT_CODE 2 LJ OPTIONAL

53 53 1004 - 1005 Compliance Condition Code COMPL_COND_CODE 2 LJ OPTIONAL

54 54 1006 - 1014 Current Balance CURRENT_BAL 9 RJ REQUIRED

55 55 1015 - 1023 Amount Past Due AMT_PAST_DUE 9 RJ OPTIONAL

56 56 1024 - 1032 Original Charge-off Amount ORIG_CHARGE_OFF_AMT 9 RJ OPTIONAL

57 58 1033 - 1040 FCRA Compliance/Date of First Delinquency FCRA_COMPL_DATE_OF_FRST_

DLQNCY

8 RJ OPTIONAL

58 59 1041 - 1048 Date Closed DATE_CLOSED 8 RJ OPTIONAL

59 60 1049 - 1056 Date of Last Payment DATE_OF_LAST_PYMNT 8 RJ OPTIONAL

Page 21: Exhibit BB eOscar data fields and rules - CreditCourtforum.creditcourt.com/discus/messages/803/Exh-BB-_eOscar...2002/06/18 · Exhibit BB eOscar data fields and rules June 18th, 2002

January 22, 2001

Field Formats for Batch Transfer (ACDV/AUD System)

Proprietary and Confidential

ADCV REQUEST RECORD

Field

No

LDD

Field

No.

Field Position in Record

Field Name Column Name in Database Field

Length Alignment Req/Opt

60 61 1057 - 1058 Manner of Payment (Equifax Only) MANNER_OF_PYMNT_CODE 2 LJ OPTIONAL

61 62 1059 - 1066 Status Date (Experian Only) STATUS_DATE 8 RJ OPTIONAL

62 63 1067 - 1132 Narrative/Remarks Code REMARKS_CODE 66 LJ OPTIONAL

63 64 1133 - 1162 Original Creditor Name ORIG_CREDITOR_NAME 30 LJ OPTIONAL

64 65 1163 - 1164 Creditor Classification CREDITOR_CLASS 2 LJ OPTIONAL

65 66 1165 - 1165 Portfolio Indicator PORTF_INDIC_CODE 1 RJ OPTIONAL

66 67 1166 - 1195 Purchased Portfolio or Sold To Name PRCH_PORTF_SOLD_NAME 30 LJ OPTIONAL

67 68 1196 - 1197 Agency Identifier AGENCY_ID 2 RJ OPTIONAL

68 69 1198 - 1215 Secondary Marketing Agency Account

Number

SCND_MRKT_AGENCY_ACCT_

NUM

18 LJ OPTIONAL

69 70 1216 - 1233 Mortgage Identification Number (MIN) MIN 18 LJ OPTIONAL

70 71 1234 - 1235 Specialized Payment SPEC_PYMNT_INDIC_CODE 2 RJ OPTIONAL

71 72 1236 - 1243 Deferred Payment Start Date DEF_PYMNT_START_DATE 8 RJ OPTIONAL

72 73 1244 - 1251 Payment Due Date PYMNT_DUE_DATE 8 RJ OPTIONAL

73 74 1252 - 1260 Payment Amount PYMNT_AMT 9 RJ OPTIONAL

74 75 1261 - 1268 Activity Date ACTIVITY_DATE 8 RJ REQUIRED

75 127 1269 - 1298 Condition/Cumulative Status CONDITION_CUMULATIVE_ST

ATUS

30 LJ OPTIONAL

76 -- 1299 – 1348 Reserved ACDV_REQUEST_RESERVED 50 LJ OPTIONAL