Importing Experian Custom Strategist
Importing Experian Custom Strategist data will require you to format the imported data fields in a specific manner. Each data field can contain many data elements. Each data element within a data field is separated by a slash “/.”
SSI Codes (XPRSSI)
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| PRD | Example: P/2/1000/800 | |||
| Loan Use |
N
|
A
|
1
|
B = Business P = Personal |
| Association Code |
N
|
A/N
|
1
|
1 = Individual 2 = Joint Account 3 = Authorized User 4 = Joint Account 5 = Cosigner 6 = On Behalf Of 7 = Signer A = Terminated – undesignated B = Terminated – 2 (Joint Acct) C = Terminated – 3 (Authorized User) D = Terminated – 4 (JOINT ACCOUNT) E = Terminated – 5 (CO-SIGNER) F = Terminated – 6 (ON BEHALF OF) G = Terminated – 7 (SIGNER) H = Terminated – 1 (INDIVIDUAL) X = Terminated – individual deceased |
| New Monthly Payment Amount |
N
|
N
|
7
|
Whole dollar amount |
| Old Monthly Payment Amount |
N
|
N
|
7
|
Whole dollar amount |
Product Codes (XPRProd)
The Customer and Experian set up these codes. Contact your Experian representative for more information.
You can enter up to 10 Product Codes.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| PRD | Example: 01/A/02/X/03/A/04/X/05/A/06/X/07/A/08/X/09/X/10/A | |||
| ProductCode |
N
|
N
|
2
|
It must be 2 digits |
| DecisionType |
N
|
A/N
|
1
|
Must be entered for each Product Code entered. A = Account opening X = Cross-sell |
Automobile Information (XPRInfo)
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| AUTO | Example: R/N/2003/FORD/RANGER/20000/19000/1000/2000/4000/1000/36/300/299/5500/299/ | |||
| Loan Type |
N
|
A
|
1
|
R = Retail L = Lease B = Balloon |
| Vehicle Status |
N
|
A
|
2
|
N = New U = Used |
| Vehicle Year |
N
|
N
|
4
|
Year of the vehicle. Format = CCYY |
| Vehicle Make |
N
|
A
|
15
|
Make of vehicle |
| Vehicle Model |
N
|
A/N
|
10
|
Model type |
| MSRP |
N
|
N
|
7
|
Whole dollar amount |
| Vehicle Sales Price |
N
|
N
|
7
|
Whole dollar amount |
| Downpayment Amount |
N
|
N
|
7
|
Whole dollar amount |
| Rebate |
N
|
N
|
7
|
Whole dollar amount |
| Trade Loan Balance |
N
|
N
|
7
|
Whole dollar amount |
| Trade Allowance |
N
|
N
|
7
|
Whole dollar amount |
| Term Of Lease |
N
|
N
|
3
|
Term of the lease in months |
| Capitalized Cost |
N
|
N
|
7
|
Whole dollar amount |
| Residual Factor |
N
|
N
|
8
|
nn.nnnnnn (implied decimal point) |
| Residual Value |
N
|
N
|
7
|
Whole dollars |
| Money Factor |
N
|
N
|
8
|
n.nnnnnnn (implied decimal point) |
Job Information (XPRJob, XPRJob1, XPRJob2)
Some data fields allow for information to be entered in a variety of formats. For example, for the JOB1 and JOB2 employment fields, you can enter one of the following for length of employment: Time on Current Job in Months, Current Job Start Date, or Current Job For-Period. In the example below, Time on Current Job in Months was used. The additional slashes “/” are used to hold data element positions within the data field.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| JOB, JOB1, JOB2 | example: S/60///S/120// | |||
| Current Job Type |
N
|
A/N
|
1
|
E = Student H = Homemaker L = Salaried R = Retired S = Self-employed U = Unemployed |
| Current Job Duration |
N
|
Current job information | ||
| Duration In Months |
N
|
N
|
3
|
Total months at the job |
| Duration Since CCYY |
N
|
N
|
4
|
Format = CCYY |
| Duration Since CCYYMM |
N
|
N
|
6
|
Format = CCYYMM |
| Duration Since CCYYMMDD |
N
|
N
|
8
|
Format = CCYYMMDD |
| Duration For Period YY |
N
|
N
|
2
|
Format = YY |
| Duration For Period YYMM |
N
|
N
|
4
|
Format = YYMM |
| Previous Job Type |
N
|
A/N |
1
|
E = Student H = Homemaker L = Salaried R = Retired S = Self-employed U = Unemployed |
| Previous Job Duration |
N
|
Previous job information | ||
| Duration In Months |
N
|
N
|
3
|
Total months at the job |
| Duration Since CCYY |
N
|
N
|
4
|
Format = CCYY |
| Duration Since CCYYMM |
N
|
N
|
6
|
Format = CCYYMM |
| Duration Since CCYYMMDD |
N
|
N
|
8
|
Format = CCYYMMDD |
| Duration For Period YY |
N
|
N
|
2
|
Format = YY |
| Duration For Period YYMM |
N
|
N
|
4
|
Format = YYMM |
Income Information (XPRInc, XPRInc1, XPRInc2)
Gross Income can be entered using either a Total Gross Income or a combination of Gross Salary and Other Gross Income. Income information can be entered for the Primary applicant (INC1) and the Secondary applicant (INC2), or both can be combined in the Global section (INC) on Joint Inquiries.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| INC, INC1, INC2 | example: M/3000/M/2500/M/500 If used, Total Gross Income must equal Salary + Other Gross Income |
|||
| Total Gross Income Freq |
N
|
A/N
|
1
|
Total gross income frequency: H = Hourly W = Weekly B = Biweekly (every 2 weeks) M = Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
| TotGross Income Amt |
N
|
N
|
7
|
Total gross income whole dollar amount |
| Salary Freq |
N
|
A/N
|
1
|
Total gross income frequency: H = Hourly W = Weekly B = Biweekly (every 2 weeks) M = Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
| Salary Amt |
N
|
N
|
7
|
Total salary whole dollar amount |
| Other Gross Income Freq |
N
|
A/N
|
1
|
Total gross income frequency: H = Hourly W = Weekly B = Biweekly (every 2 weeks) M = Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
| Other Gross Income Amt |
N
|
N
|
7
|
Other gross income whole dollar amount |
Residence Information (XPRRes, XPRRes1, XPRRes2)
Residence information can be entered for the Primary applicant (RES1) and the Secondary applicant (RES2), or both can be combined in the Global section (RES) on Joint Inquiries. The additional slashes “/” are used to hold data element positions within the data field.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| RES, RES1, RES2 | example: 01/24///04/12// | |||
| Housing Type |
N
|
N
|
2
|
Current housing type: 01 = mortgaged house/condominium 02 = owned house/condo/apartment 03 = mortgages/owns mobile home 04 = rents house/condo/apartment 05 = rents mobile home 06 = lives with parents/relatives 07 = boards 08 = other |
| Duration Of Stay |
N
|
Provide only one of the following six duration items. |
||
| Duration In Months |
N
|
N
|
3
|
Total months at residence |
| Duration Since CCYY |
N
|
N
|
4
|
Format = CCYY |
| Duration Since CCYYMM |
N
|
N
|
6
|
Format = CCYYMM |
| Duration Since CCYYMMDD |
N
|
N
|
8
|
Format = CCYYMMDD |
| Duration For Period YY |
N
|
N
|
2
|
Format = YY |
| Duration For Period YYMM |
N
|
N
|
4
|
Format = YYMM |
| Prev Residence Type |
N
|
N
|
2
|
Previous housing type: 01 = mortgaged house/condominium 02 = owned house/condo/apartment 03 = mortgages/owns mobile home 04 = rents house/condo/apartment 05 = rents mobile home 06 = lives with parents/relatives 07 = boards 08 = other |
| PrevResidence DurationOfStay |
N
|
Provide only one of the following six duration items. |
||
| DurationInMonths |
N
|
N
|
3
|
Total months at residence |
| DurationSinceCCYY |
N
|
N
|
4
|
Format = CCYY |
| DurationSinceCCYYMM |
N
|
N
|
6
|
Format = CCYYMM |
| DurationSinceCCYYMMDD |
N
|
N
|
8
|
Format = CCYYMMDD |
| DurationForPeriodYY |
N
|
N
|
2
|
Format = YY |
| DurationForPeriodYYMM |
N
|
N
|
4
|
Format = YYMM |
Expense Information (XPRExp, XPRExp1, XPRExp2)
Expense information can be entered for the Primary applicant (EXP1) and the Secondary applicant (EXP2), or both can be combined in the Global section (EXP) on Joint Inquiries. Expenses can further be separated into Residence Expenses and Other Expenses.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| EXP, EXP1, EXP2 | Example: M/2000/1/M/1200/M/800 If used, Total Expense must equal Residence + Other Expenses |
|||
| Total Expenses Freq |
N
|
A/N
|
1
|
Expense frequency: H = Hourly W= Weekly B = Biweekly (every 2 weeks) M= Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
| TotalExpensesAmt | N | N | 7 | Total expenses whole dollar amount |
| ResidenceExpenseType | N | N | 1 | Residence expense type: 1 = Mortgage 2 = Rent |
| ResidenceExpenseFreq | N | A/N | 1 | Expense frequency: H = Hourly W= Weekly B = Biweekly (every 2 weeks) M= Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
| ResidenceExpenseAmt | N | N | 7 | Residence expenses the whole dollar amount |
| OtherExpenseFreq | Other expense frequencies: H = Hourly W= Weekly B = Biweekly (every 2 weeks) M= Monthly T = Semi-Monthly Q = Quarterly S = Semi-Annually Y = Yearly |
|||
| OtherExpenseAmt | N | N | 7 | All other expenses whole dollar amount |
Banking Relationship (XPRBre, XPRBre1, XPRBre2)
Banking relationship information can be entered for the Primary applicant (BRE1) and the Secondary applicant (BRE2), or both can be combined in the Global section (BRE) on Joint Inquiries. Values range from 0 to 4.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| BRE, BRE1, BRE2 | ||||
| Banking Relationship |
N
|
N
|
1
|
0 – No Relationship 1 – Checking Account 2 – Savings Account 3 – Checking and Savings 4 – Accounts of unknown type |
Dependents (XPRDep, XPRDep1, XPRDep2)
Dependent information can be entered for the Primary applicant (DEP1) and the Secondary applicant (DEP2), or both can be combined in the Global section (DEP) on Joint Inquiries.
| Field name |
Required
|
Data Type
|
Max Length
|
Description |
| DEP, DEP1, DEP2 | ||||
| Dependents |
N
|
N
|
2
|
Total number of dependents excluding applicants |