Show Hide

 

Feedback

  • Contents
 

RDN Master Table

The Collateral Auction table contains auction data for collateral associated to accounts. Each account can have one auction data record.

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

AccountID

Code that identifies the Latitude account associated to the piece of collateral.

4

Integer

Master/Number

NB, M

CaseID

Code that the RDN system assigned to identify the case.

4

Integer

None

NB, M

CollateralID

Code that identifies the Latitude user who closed the case.

4

Integer

None

NB, M

CollateralName

Name of the collateral item.

300

VarChar

None

NB, M

AccountNumber

Code that identifies the account to which the vehicle is associated.

30

VarChar

None

NB, M

DebtorFirstName

Debtor's first name.

300

VarChar

None

NB, M

DebtorMiddleName

Debtor's middle name.

300

VarChar

None

NB, M

DebtorLastName

Debtor's last name.

300

VarChar

None

NB, M

DebtorSSN

Debtor's social security number.

15

VarChar

None

NB, M

DebtorDOB

Debtor's date of birth.

8

DateTime

None

NB, M

CoDebtorFirstName

 Co-debtor's first name.

300

 VarChar

None

NB, M

CoDebtorMiddleName

 Co-debtor's middle name.

300

 VarChar

None

NB, M

CoDebtorLastName

 Co-debtor's last name.

300

 VarChar

None

NB, M

CoDebtorSSN

 Co-debtor's social security number.

15

 VarChar

None

NB, M

CoDebtorDOB

 Co-debtor's date of birth.

8

 DateTime

None

NB, M

DebtorAddressID

Code that Latitude assigned to identify the debtor's address record in Latitude.

4

Integer

None

NB, M

DebtorCustomAddressID

Indicates whether to use the debtor's address that's on the account or the address that the user specified.

50

VarChar

None

NB, M

DebtorBusinessName

If the debtor is a business, name of the business.

300

VarChar

None

NB, M

DebtorUnit

Debtor's house or apartment number.

300

VarChar

None

NB, M

DebtorAddress1

Line 1 of the debtor's street address.

128

VarChar

None

NB, M

DebtorAddress2

Line 2 of the debtor's street address.

128

VarChar

None

NB, M

DebtorCounty

Debtor's county.

30

VarChar

None

NB, M

DebtorCity

Debtor's city.

30

VarChar

None

NB, M

DebtorState

Debtor's state.

3

VarChar

None

NB, M

DebtorZIP

Debtor's ZIP code.

10

VarChar

None

NB, M

DebtorPhoneHome

Debtor's home phone number.

30

VarChar

None

NB, M

DebtorPhoneMobile

Debtor's cell phone number.

30

VarChar

None

NB, M

DebtorAddressType

Debtor's address type.

4

Integer

None

NB, M

DebtorAddressPriority

N/A

4

Integer

None

NB, M

DebtorAddressIsVerified

Indicates whether the debtor's address is verified as either valid or invalid.

1

Bit

None

NB, M

DebtorAddressIsValid

Indicates whether the debtor's address is valid.

1

Bit

None

NB, M

DebtorAddressCeaseAndDesist

Indicates whether a cease and desist order exists for the debtor's address.

1

Bit

None

NB, M

CoDebtorAddressID

 Code that Latitude assigned to identify the co-debtor's address record in Latitude.

4

 Integer

None

NB, M

CoDebtorCustomAddressID

 Indicates whether to use the co-debtor's address that's on the account or the address that the user specified.

50

VarChar

None

NB, M

CoDebtorBusinessName

 If the co-debtor is a business, name of the business.

300

VarChar

None

NB, M

CoDebtorUnit

 Co-debtor's house or apartment number.

300

VarChar

None

NB, M

CoDebtorAddress1

 Line 1 of the co-debtor's street address.

128

VarChar

None

NB, M

CoDebtorAddress2

 Line 2 of the co-debtor's street address.

128

VarChar

None

NB, M

CoDebtorCounty

 Co-debtor's county.

30

VarChar

None

NB, M

CoDebtorCity

 Co-debtor's city.

30

VarChar

None

NB, M

CoDebtorState

 Co-debtor's state.

3

VarChar

None

NB, M

CoDebtorZIP

 Co-debtor's ZIP code.

10

VarChar

None

NB, M

CoDebtorPhoneHome

 Co-debtor's home phone number.

30

VarChar

None

NB, M

CoDebtorPhoneMobile

 Co-debtor's cell phone number.

30

VarChar

None

NB, M

CoDebtorAddressType

 Co-debtor's address type.

4

Integer

None

NB, M

CoDebtorAddressPriority

 N/A

4

Integer

None

NB, M

CoDebtorAddressIsVerified

 Indicates whether the co-debtor's address is verified as either valid or invalid.

1

Bit

None

NB, M

CoDebtorAddressIsValid

 Indicates whether the co-debtor's address is valid.

1

Bit

None

NB, M

CoDebtorAddressCeaseAndDesist

 Indicates whether a cease and desist order exists for the co-debtor's address.

1

Bit

None

NB, M

OrderType

Type of recovery order.

50

VarChar

None

NB, M

CaseStatus

Status of the RDN case.

50

VarChar

None

NB, M

UpdateDate

Date that the case was updated in the RDN system.

8

DateTime

None

NB, M

UpdateID

Code that the RDN system assigned to identify the update record.

4

Integer

None

NB, M

UpdateType

Type of RDN case update.

4

Integer

None

NB, M

UpdateText

Details about the RDN case update.

-1

VarChar

None

NB, M

Priority

RDN case update priority.

20

VarChar

None

NB, M

AlternativeAddressID

Code that Latitude assigned to identify the alternate address record in Latitude.

4

 Integer

None

NB, M

AlternativeCustomAddressID

Indicates whether to use the debtor's address that's on the account or the address that the user specified.

50

VarChar

None

NB, M

AlternativeBusinessName

If the alternate address is for a business, name of the business.

300

VarChar

None

NB, M

AlternativeUnit

 Alternate address house or apartment number.

300

VarChar

None

NB, M

AlternativeAddress1

 Line 1 of the alternate street address.

128

VarChar

None

NB, M

AlternativeAddress2

 Line 2 of the alternate street address.

128

VarChar

None

NB, M

AlternativeCounty

 Alternate address county.

30

VarChar

None

NB, M

AlternativeCity

 Alternate address city.

30

VarChar

None

NB, M

AlternativeState

 Alternate address state.

3

VarChar

None

NB, M

AlternativeZIP

 Alternate address ZIP code.

10

VarChar

None

NB, M

AlternativePhoneHome

 Alternate home phone number.

30

VarChar

None

NB, M

AlternativePhoneMobile

 Alternative cell phone number.

30

VarChar

None

NB, M

AlternativeAddressType

 Alternate address type.

4

Integer

None

NB, M

AlternativeAddressPriority

 N/A

4

Integer

None

NB, M

AlternativeAddressIsVerified

 Indicates whether the alternate address is verified as either valid or invalid.

1

Bit

None

NB, M

AlternativeAddressIsValid

 Indicates whether the alternate address is valid.

1

Bit

None

NB, M

AlternativeAddressCeaseAndDesist

 Indicates whether a cease and desist order exists for the alternate address.

1

Bit

None

NB, M

AdditionalInformation

Other information regarding the RDN case.

300

VarChar

None

NB, M

AgentID

Code that Latitude assigned to identify the repossession agent in Latitude.

50

VarChar

None

NB, M

AgentName

Name of the repossession agent.

300

VarChar

None

NB, M

AgentPhone

Repossession agent's phone number.

20

VarChar

None

NB, M

AgencyName

Repossession agency's name.

300

VarChar

None

NB, M

AgencyAddress

Repossession agency's street address.

128

VarChar

None

NB, M

AgencyCity

Repossession agency's city.

30

VarChar

None

NB, M

AgencyState

Repossession agency's state.

3

VarChar

None

NB, M

AgencyZIP

Repossession agency's ZIP code.

10

VarChar

None

NB, M

AgencyPhone

Repossession agency's phone number.

20

VarChar

None

NB, M

AgencyFax

Repossession agency's fax number.

50

VarChar

None

NB, M

LPR2AssignmentsOnly

Indicates whether the vendor is only used for LPR assignments.

1

Bit

None

NB, M

StateLicenseNumber

Repossession agency's state license number.

50

VarChar

None

NB, M

IsAlliedMember

Indicates whether the repossession agency is an Allied Member.

1

Bit

None

NB, M

IsARAMember

Indicates whether the repossession agency is a member of the American Recovery Association.

1

Bit

None

NB, M

IsDRNMember

Indicates whether the repossession agency is a member of the Digital Recovery Network.

1

Bit

None

NB, M

IsLRRPMember

Indicates whether the repossession agency is an LRRP member.

1

Bit

None

NB, M

IsNFAMember

Indicates whether the repossession agency is a member of the National Finance Adjusters (NFA) association.

1

Bit

None

NB, M

IsRelianceMember

Indicates whether the repossession agency is a member of the Reliance association.

1

Bit

None

NB, M

VendorBranchName

 

50

VarChar

None

NB, M

AssigneeID

Code that the RDN system assigned to identify the collector on the RDN case.

4

Integer

None

NB, M

AssigneeName

Name of the collector on the RDN case.

50

VarChar

None

NB, M

OrderWorkerID

Code that identifies the company user assigned to the RDN case.

4

Integer

None

NB, M

RecoveryAddress

Address where the agent recovered the vehicle.

128

VarChar

None

NB, M

RecoveryCity

City where the agent recovered the vehicle.

30

VarChar

None

NB, M

RecoveryState

State where the agent recovered the vehicle.

3

VarChar

None

NB, M

RecoveryZIP

ZIP code where the agent recovered the vehicle.

10

VarChar

None

NB, M

StorageLocationID

Code that the RDN system assigned to identify the storage facility where the repossessed vehicle is located.

4

Integer

None

NB, M

StorageLocationAddress

Storage facility address where the repossessed vehicle is located.

128

VarChar

None

NB, M

StorageLocationCity

Storage facility city where the repossessed vehicle is located.

30

VarChar

None

NB, M

StorageLocationState

Storage facility state where the repossessed vehicle is located.

3

VarChar

None

NB, M

StorageLocationZIP

Storage facility ZIP code where the repossessed vehicle is located.

10

VarChar

None

NB, M

StorageLocationName

Name of the storage facility where the repossessed vehicle is located.

300

VarChar

None

NB, M

StorageLocationPhone

Storage facility phone number where the repossessed vehicle is located.

20

VarChar

None

NB, M

StorageLocationFax

Storage facility fax number where the repossessed vehicle is located.

50

VarChar

None

NB, M

StorageLocationSpace

Storage facility unit number where the repossessed vehicle is located.

300

VarChar

None

NB, M

EstimatedDamage

Estimated cost to repair the vehicle.

4

Integer

None

NB, M

TransportReleasedTo

Person to whom the agent released the vehicle upon transport.

4

Integer

None

NB, M

TransportNotes

Comments regarding transport of the vehicle.

300

VarChar

None

NB, M

TransportDate

Date the agent transported the vehicle.

8

DateTime

None

NB, M

DeliveredReleasedTo

Person to whom the repossession agent delivered or released the vehicle.

4

Integer

None

NB, M

Disposition

Disposition of the vehicle after repossession (for example, delivered to auction, stored, sold).

50

VarChar

None

NB, M

PersonalItems

Personal items that the vehicle contains.

200

VarChar

None

NB, M

HasPersonals

Indicates whether the vehicle contains personal items.

1

Bit

None

NB, M

IsDrivable

Indicates whether the vehicle was drivable when the agent repossessed it.

1

Bit

None

NB, M

HasKeys

Indicates whether the vehicle has keys.

1

Bit

None

NB, M

PoliceNotifiedDate

Date the recovery agency notified the police of intent to recover the vehicle.

8

DateTime

None

NB, M

PoliceReportNumber

Police report identifier.

100

VarChar

None

NB, M

SkipFlag

Indicates whether you are using skip tracing to track down the debtor.

1

Bit

None

NB, M

OverallCondition

Overall condition of the vehicle.

30

VarChar

None

NB, M

OdometerType

Type of odometer, such as digital or analog.

40

VarChar

None

NB, M

DMV

 Department of Motor Vehicles.

4

Integer

None

NB, M

KeyType

Type of ignition key, such as single or double cut.

20

VarChar

None

NB, M

KeyCode1

Number that identifies the ignition key.

10

VarChar

None

NB, M

KeyCode2

Number that identifies an extra vehicle key, such as the valet key.

10

VarChar

None

NB, M

VehicleLicenseState

State where the vehicle is licensed.

2

Char

None

NB, M

VehicleLicenseNumber

Vehicle's license plate number.

10

VarChar

None

NB, M

VehicleLicenseExp

Vehicle's license plate expiration date.

4

Integer

None

NB, M

Mileage

Number of miles on the vehicle.

4

Integer

None

NB, M

SubStatusID

Code that identifies the lender's secondary status of the RDN case.

4

Integer

None

NB, M

SubStatus

Secondary status that the lender assigned to the RDN case.

30

VarChar

None

NB, M

CollectorID

Code that Latitude assigned to identify the piece of collateral in Latitude.

50

VarChar

None

NB, M

HoldReason

Reason for placing the case on hold.

150

VarChar

None

NB, M

HoldOtherReason

Comments regarding the reason for placing the case on hold.

150

VarChar

None

NB, M

HoldReasonType

Type of hold reason.

5

VarChar

None

NB, M

Release

Indicates whether to release a case that is on hold.

1

Bit

None

NB, M

ReassignReason

Reason for reassigning the RDN case to another agency.

150

VarChar

None

NB, M

CloseReason

Reason for closing the RDN case.

150

VarChar

None

NB, M

CloseOtherReason

Comments regarding closing the RDN case.

150

VarChar

None

NB, M

CloseReasonType

Type of reason for closing the RDN case.

5

VarChar

None

NB, M

NewVendor

Agent or agency to whom you reassigned the RDN case. You can also use the Lender_Vendor_ID or Repo_Vendor fields to identify the new vendor.

50

VarChar

None

NB, M

LenderVendorID

Code that the lender assigned to identify the agent or agency assigned to the RDN case.

50

VarChar

None

NB, M

RepoVendor

Repossession agent or agency assigned to the RDN case.

50

VarChar

None

NB, M

Related Topics

Destination Fields