ColumnsIndexessp1Parentsp2rpa

rpaz Table: Portfolio 3
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rpaz Portfolio 3 table.

Parent-Child: This table has a parent table--click here for a listing.

rpaz Columns

Description	Column Name	Data Type ?	Characteristics ?
Portfolio	por_s	char	length 2
Record number	unique_l	number	precision 10
Record modification stamp	stamp_l	number	precision 10
List of application statuses	app_stat_list_s	varchar2	length 148
Entry requirements	app_ent_s	varchar2	length 148
Display field (X/' ')	disp1_s	varchar2	length 200
Display field (X/' ')	disp2_s	varchar2	length 200
Display field (X/' ')	disp3_s	varchar2	length 200
FMV term [1]	fmv_trm1_l	number	precision 10
FMV term [2]	fmv_trm2_l	number	precision 10
FMV term [3]	fmv_trm3_l	number	precision 10
FMV term [4]	fmv_trm4_l	number	precision 10
FMV term [5]	fmv_trm5_l	number	precision 10
Maximum lease rate - precomputed simple	h_cntr1_d	number	precision 15, scale 5
Maximum lease rate - simple interest	h_cntr2_d	number	precision 15, scale 5
Maximum lease rate - level yield	h_cntr3_d	number	precision 15, scale 5
Maximum lease rate - rule of 12/78ths	h_cntr4_d	number	precision 15, scale 5
Maximum lease rate - straight line	h_cntr5_d	number	precision 15, scale 5
Minimum lease rate - precomputed simple	l_cntr1_d	number	precision 15, scale 5
Minimum lease rate - simple interest	l_cntr2_d	number	precision 15, scale 5
Minimum lease rate - level yield	l_cntr3_d	number	precision 15, scale 5
Minimum lease rate - rule of 12/78ths	l_cntr4_d	number	precision 15, scale 5
Minimum lease rate - straight line	l_cntr5_d	number	precision 15, scale 5
Maximum vendor rate - precomputed simple	h_dlr1_d	number	precision 15, scale 5
Maximum vendor rate - simple interest	h_dlr2_d	number	precision 15, scale 5
Maximum vendor rate - level yield	h_dlr3_d	number	precision 15, scale 5
Maximum vendor rate - rule of 12/78ths	h_dlr4_d	number	precision 15, scale 5
Maximum vendor rate - straight line	h_dlr5_d	number	precision 15, scale 5
Minimum vendor rate - precomputed simple	l_dlr1_d	number	precision 15, scale 5
Minimum vendor rate - simple interest	l_dlr2_d	number	precision 15, scale 5
Minimum vendor rate - level yield	l_dlr3_d	number	precision 15, scale 5
Minimum vendor rate - rule of 12/78ths	l_dlr4_d	number	precision 15, scale 5
Minimum vendor rate - straight line	l_dlr5_d	number	precision 15, scale 5
Maximum investor rate - precomputed simple	h_inv1_d	number	precision 15, scale 5
Maximum investor rate - simple interest	h_inv2_d	number	precision 15, scale 5
Maximum investor rate - level yield	h_inv3_d	number	precision 15, scale 5
Maximum investor rate - rule of 12/78ths	h_inv4_d	number	precision 15, scale 5
Maximum investor rate - straight line	h_inv5_d	number	precision 15, scale 5
Minimum investor rate - precomputed simple	l_inv1_d	number	precision 15, scale 5
Minimum investor rate - simple interest	l_inv2_d	number	precision 15, scale 5
Minimum investor rate - level yield	l_inv3_d	number	precision 15, scale 5
Minimum investor rate - rule of 12/78ths	l_inv4_d	number	precision 15, scale 5
Minimum investor rate - straight line	l_inv5_d	number	precision 15, scale 5
FMV percentage [1]	fmv_per1_d	number	precision 15, scale 2
FMV percentage [2]	fmv_per2_d	number	precision 15, scale 2
FMV percentage [3]	fmv_per3_d	number	precision 15, scale 2
FMV percentage [4]	fmv_per4_d	number	precision 15, scale 2
FMV percentage [5]	fmv_per5_d	number	precision 15, scale 2
Default display payment amount (Y/N)	dflt_displ_pmt_c	char	length 1
Add comment to transaction (Y/N)	add_com_trn_c	char	length 1
Apply payments past due/priority (A/B/N)	past_due_priority_c	char	length 1
Priority assessment (Y/N)	asm_priority_c	varchar2	length 33
Principal/payment interest bank code	waive_bank_s	char	length 3
IDC1 alias - 21 characters	s_idc1_s	varchar2	length 21
IDC2 alias - 21 characters	s_idc2_s	varchar2	length 21
IDC3 alias - 21 characters	s_idc3_s	varchar2	length 21
IDC4 alias - 21 characters	s_idc4_s	varchar2	length 21
IDC5 alias - 21 characters	s_idc5_s	varchar2	length 21
IDR1 alias - 21 characters	s_idr1_s	varchar2	length 21
IDR2 alias - 21 characters	s_idr2_s	varchar2	length 21
IDR3 alias - 21 characters	s_idr3_s	varchar2	length 21
IDR4 alias - 21 characters	s_idr4_s	varchar2	length 21
IDR5 alias - 21 characters	s_idr5_s	varchar2	length 21
IDR6 alias - 21 characters	s_idr6_s	varchar2	length 21
IDR7 alias - 21 characters	s_idr7_s	varchar2	length 21
IDR8 alias - 21 characters	s_idr8_s	varchar2	length 21
IDR9 alias - 21 characters	s_idr9_s	varchar2	length 21
IDRA alias - 21 characters	s_idra_s	varchar2	length 21
IDRB alias - 21 characters	s_idrb_s	varchar2	length 21
IDRC alias - 21 characters	s_idrc_s	varchar2	length 21
IDC1 alias - 9 characters	ss_idc1_s	char	length 9
IDC2 alias - 9 characters	ss_idc2_s	char	length 9
IDC3 alias - 9 characters	ss_idc3_s	char	length 9
IDC4 alias - 9 characters	ss_idc4_s	char	length 9
IDC5 alias - 9 characters	ss_idc5_s	char	length 9
IDR1 alias - 9 characters	ss_idr1_s	char	length 9
IDR2 alias - 9 characters	ss_idr2_s	char	length 9
IDR3 alias - 9 characters	ss_idr3_s	char	length 9
IDR4 alias - 9 characters	ss_idr4_s	char	length 9
IDR5 alias - 9 characters	ss_idr5_s	char	length 9
IDR6 alias - 9 characters	ss_idr6_s	char	length 9
IDR7 alias - 9 characters	ss_idr7_s	char	length 9
IDR8 alias - 9 characters	ss_idr8_s	char	length 9
IDR9 alias - 9 characters	ss_idr9_s	char	length 9
IDRA alias - 9 characters	ss_idra_s	char	length 9
IDRB alias - 9 characters	ss_idrb_s	char	length 9
IDRC alias - 9 characters	ss_idrc_s	char	length 9
Down payment is informational only (Y/N)	dwn_pmt_inf_c	char	length 1
Automatic payoff loss tolerance	auto_payo_loss_tol_d	number	precision 15, scale 2
Automatic payoff gain tolerance	auto_payo_gain_tol_d	number	precision 15, scale 2
Reversal reason code/bank code [1]	rev_cat1_s	char	length 5
Reversal reason code/bank code [2]	rev_cat2_s	char	length 5
Reversal reason code/bank code [3]	rev_cat3_s	char	length 5
Reversal reason code/bank code [4]	rev_cat4_s	char	length 5
Reversal reason code/bank code [5]	rev_cat5_s	char	length 5
Default bank code for auto suspense	cc_auto_sus_bank_s	char	length 3
Default C/R/O for auto suspense	cc_auto_sus_cro_s	char	length 7
Delinquency payment percentage	del_pmt_perc_l	number	precision 10
Delinquency category boundaries [4]	delq4_l	number	precision 10
Delinquency category boundaries [5]	delq5_l	number	precision 10
Delinquency category boundaries [6]	delq6_l	number	precision 10
Default securitization bank code	sec_bank_s	char	length 3
Override late charges for delinquency payment percentage (Y/N)	over_ltchgs_del_pmt_c	char	length 1
Number of payments for first extension/deferment eligibility	pmt_frst_extdef_l	number	precision 10
Number of payments between for next extension/deferment	pmt_btw_extdef_l	number	precision 10

rpaz Indexes

Index Name	Piece 1	Piece 2
rpaz_idx0	por_s	unique_l

Parent Table Listing

Table Name	Description
rpa	Portfolio

Data Type Definitions and Characteristics

Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.

char

Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

date

Oracle date and time, containing century, year, month, day, hour, minute, and second information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

number

Oracle numeric data type. Used for all numbers.
Characteristics:

• precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
• scale - The fractional granularity, meaning the maximum number of places available to the right of the decimal point.

varchar2

Oracle variable length character string. Typically used to store medium and long-length string data such as names, addresses, descriptions, and notebook entries.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

LeasePak Documentation Suite

© by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.