| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FIN_ACCOUNT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Financial Account Number
|
| 2 |
APPLICATION_NUMBER |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the application number for Lead, Opportunity, Case and Order Capture
|
| 3 |
ASSET_CATEG_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is the primary key for Asset category table
|
| 4 |
LOAN_PRODUCT |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Product selected for FSI Loan Application
LOC=Line of Credit
MRTG=Mortgage Loan
|
| 5 |
LOAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Loan - used by FSI.
DC=Debt Consolidation
ED=Education
HI=Home Improvement
MD=Medical
MV=Motor Vehicle
NP=New Purchase
PU=Personal Use
RF=Refinance
|
| 6 |
LOAN_PROGRAM |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Program for FSI Loans..........
11A=1/1 ARM
13A=1/3 ARM
15A=1/5 ARM
15F=15 Year Fixed
30F=30 Year Fixed
5B=5 Year Balloon
7B=7 Year Balloon
|
| 7 |
LOAN_TERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Loan Term
10=10 Years
15=15 Years
20=20 Years
30=30 Years
|
| 8 |
LOAN_AMOUNT |
Number(8,0) |
INTEGER NOT NULL |
Proposed Loan Amount
|
| 9 |
LOAN_PROPERTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Property Type
C=2 - Condo
O=4 - Other
S=1 - Single Family Home
T=3 - Town House
|
| 10 |
LOAN_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Loan Interest rate for FSI Loans......
|
| 11 |
LOAN_RATE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Interest Rate Type
IDXD=Indexed
IDXM=Indexed Less
IDXP=Indexed Plus
|
| 12 |
INTEREST_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Only Code on a Loan
N=Not Interest Only
Y=Interest Only
|
| 13 |
P_I_PAYMENT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Principal and Interest amount for Loan
|
| 14 |
LATE_PAY_FEE |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Loan Late Payment Fee charge
|
| 15 |
LATE_PAY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Payment Fee Type
FLAT=Flat Fee
PCT=Percent Fee
|
| 16 |
ACCEL_REPAY_PGM_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Accelerated Repayment Program Indicator
BIMO=Bi Monthly
FLAT=Flat Extra Payment
|
| 17 |
ASSUMED_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumed Loan Code................
N=Not Assumed Loan
Y=Assumed Loan
|
| 18 |
ASSUMABLE_START_DT |
DateTime(26) |
TIMESTAMP |
Assumable Start Date for Loan products...
|
| 19 |
NOTE_DATE |
Date(10) |
DATE |
Note Date on the mortgage or note
|
| 20 |
LOAN_FUNDING_DT |
Date(10) |
DATE |
Loan Funding Date (date the original lender funds were released)
|
| 21 |
PROPERTY_USAGE |
Character(4) |
VARCHAR2(4) NOT NULL |
ABN-AMRO Mortgage Application Form
INVT=Investment Property
PMRS=Primary Residence
SECH=Secondary Home
|
| 22 |
PROPERTY_CUR_VALUE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Current Property Value for FSI Loan Account
|
| 23 |
PROPERTY_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Property Name
|
| 24 |
YEARBUILT |
Number(4,0) |
SMALLINT NOT NULL |
Year Built
|
| 25 |
MORTGAGE_1ST_BAL |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
1st Mortgage balance amount for FSI Loan Account
|
| 26 |
MORTGAGE_1ST_PYMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
1st Mortgage Payment amount for FSI Loan Account
|
| 27 |
MORTGAGE_1ST_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
1st Mortgage Insterest Rate for FSI Loan Accounts
|
| 28 |
MORTGAGE_2ND_BAL |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
2nd Mortgage balance amount for FSI Loan Account
|
| 29 |
MORTGAGE_2ND_PYMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
2nd Mortgage Payment amount for FSI Loan Account
|
| 30 |
MORTGAGE_2ND_RATE |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
2nd Mortgage Insterest Rate for FSI Loan Accounts
|
| 31 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 32 |
EMPLOYER_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Previous Employer
|
| 33 |
BO_ID_COBORROWER |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business object ID Co Borrower....
|
| 34 |
CO_BORROWER_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Co Borrower name on a Loan for FSI Loan Account
|
| 35 |
COMMENTS_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 36 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 37 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 38 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 39 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 40 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 41 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|