ColumnsIndexessp1Childsp2rparrpayrpaz

rpa Table: Portfolio
Oracle DBMS

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

Parent-Child: This table has one or more child tables--click here for a listing.

rpa Columns

Description	Column Name	Data Type ?	Characteristics ?
Portfolio	por_s	char	length 2
Record modification stamp	stamp_l	number	precision 10
Default application	def_app_s	char	length 10
Fiscal year end (MMDD)	md_fis_s	char	length 4
Tax reporting deadline for year end (MMDD)	md_tax_s	char	length 4
ITC cutoff date (MMDD)	md_itc_cut_s	char	length 4
Previous fiscal year end (MMDD)	md_prev_fis_s	char	length 4
Effective fiscal year end	d_eff_fis_s	date	format YYYYMMDD
Portfolio interest type	port_typ_s	char	length 4
Invoice heading code	inv_hdg_s	char	length 4
Invoice format code	invo_format_s	char	length 4
Remittance address code	remit_asg_s	char	length 4
Initial direct cost amount code	idc_amt_s	char	length 4
Initial direct cost method	idc_method_s	char	length 4
IDC accounting method	idc_acct_s	char	length 4
Collection team	col_team_s	char	length 4
Collateral team	kol_team_s	char	length 4
Maturing lease team	ml_team_s	char	length 4
Collection supervisor	col_supr_s	char	length 3
Collateral supervisor	kol_supr_s	char	length 3
Maturing lease supervisor	ml_supr_s	char	length 3
Clone to application status	clone_to_status_s	char	length 4
Master application status	master_appl_status_s	char	length 4
Individual invoice laser form code	ind_inv_laser_s	char	length 4
Group invoice laser form code	grp_inv_laser_s	char	length 4
Commission access status code Used by Bell Atlantic - do not delete.	comm_stat_s	char	length 4
Credit approval status code	credit_apprv_stat_s	char	length 4
Prime rate bank number	prim_num_s	char	length 4
Book ITC accrue (Y/N)	itc_accrue_c	char	length 1
Pro-rate income (Y/N)	pro_rate_c	char	length 1
Initial dirct cost exclud from yld (Y/N)	idc_c	char	length 1
Bad debt included in initial direct cost (Y/N)	bad_debt_c	char	length 1
Short payoffs accepted (Y/N)	sh_pyof_c	char	length 1
Generate cashier's checks (Y/N)	cchk_c	char	length 1
Lease date after other dates (Y/N)	ck_lse_d_c	char	length 1
Backdated new leases appear on delinquency report (Y/N)	dlnq_back_c	char	length 1
Warning message for payment for non-delinquent invoice (Y/N)	delq_inv_c	char	length 1
Track automobile options (Y/N)	auto_opt_c	char	length 1
Cycle accruals (Y/N)	cyc_acc_s	varchar2	length 31
Billing cycle (Y/N)	cyc_bil_s	varchar2	length 31
Assessments used (Y/N)	asm_s	char	length 16
Assessments cash or accrual basis (C/A)	assmt_s	char	length 16
Activate approval officer security (Y/N)	ofc_c	char	length 1
Assess late charges to leases less than 60 days old (Y/N)	latch_60_c	char	length 1
Calculate IDC w/o broker fees or bad debt (Y/N)	calc_idc_c	char	length 1
Use stub interest (Y/N)	stub_int_c	char	length 1
Special insurance follow up (Y/N)	insf1_c	char	length 1
Special delinquency (Y/N)	dlnq1_c	char	length 1
Is GL to Compushare used (Y/N)	gl_inter_c	char	length 1
Client receives advance money (R/I/A)	cl_rec_c	char	length 1
User defined lease application fields used (Y/N)	udf_app_c	char	length 1
User defined lease fields used (Y/N)	udf_lse_c	char	length 1
User defined asset fields used (Y/N)	udf_ass_c	char	length 1
User defined customer fields used (Y/N)	udf_cus_c	char	length 1
User defined lessee fields used (Y/N)	udf_les_c	char	length 1
User defined vendor fields used (Y/N)	udf_dlr_c	char	length 1
User defined lease application table used (Y/N)	udt_app_c	char	length 1
User defined lease table used (Y/N)	udt_lse_c	char	length 1
User defined asset table used (Y/N)	udt_ass_c	char	length 1
User defined customer Table used (Y/N)	udt_cus_c	char	length 1
User defined lessee table used (Y/N)	udt_les_c	char	length 1
User defined vendor table used (Y/N)	udt_dlr_c	char	length 1
EOP subtotals (Y/N)	eop_s_subtl_c	char	length 1
EOP grand totals (Y/N)	eop_s_grnd_c	char	length 1
EOP portfolio on grand total (Y/N)	eop_s_por_grnd_c	char	length 1
EOP company on grand total (Y/N)	eop_s_com_grnd_c	char	length 1
EOP region on grand total (Y/N)	eop_s_reg_grnd_c	char	length 1
EOP office on grand total (Y/N)	eop_s_off_grnd_c	char	length 1
EOP customer on grand total (Y/N)	eop_s_cus_grnd_c	char	length 1
EOP lessee on grand total (Y/N)	eop_s_les_grnd_c	char	length 1
EOP portfolio on subtotal (Y/N)	eop_s_por_sub_c	char	length 1
EOP company on subtotal (Y/N)	eop_s_com_sub_c	char	length 1
EOP region on subtotal (Y/N)	eop_s_reg_sub_c	char	length 1
EOP office on subtotal (Y/N)	eop_s_off_sub_c	char	length 1
EOP customer on subtotal (Y/N)	eop_s_cus_sub_c	char	length 1
EOP lessee on subtotal (Y/N)	eop_s_les_sub_c	char	length 1
Portfolio page on grand total (Y/N)	s_por_gbrk_c	char	length 1
Company page on grand total (Y/N)	s_com_gbrk_c	char	length 1
Region page on grand total (Y/N)	s_reg_gbrk_c	char	length 1
Customer page on grand total (Y/N)	s_cus_gbrk_c	char	length 1
Grand total indentation (Y/N)	s_indent_c	char	length 1
Print heading above keys (Y/N)	s_heading_c	char	length 1
Print row titles or names (T/N)	s_titles_c	char	length 1
Transfer payment transaction to historical file (Y/N)	tx_xfer_c	char	length 1
Print payment amount on invoice (Y/N)	lst_pmt_inv_c	char	length 1
Sort invoices by customer (Y/N)	cus_inv_c	char	length 1
Track auxiliary non-vehicle information (Y/N)	nveh_info_c	char	length 1
Track auxiliary vehicle information (Y/N)	veh_info_c	char	length 1
Residual income separated (Y/N)	res_inc_c	char	length 1
Calculate asset yield (Y/N)	calc_ast_yld_c	char	length 1
Reset time outstanding (Y/N)	reset_c	char	length 1
Lease factor - Payment/Rental (P/R)	lse_fac_c	char	length 1
IBL target principal levels used (Y/N)	tar_prn_c	char	length 1
Gross receivable balance (Y/N)	grs_rec_s	varchar2	length 80
Net outstanding balance (Y/N)	net_out_s	varchar2	length 80
Gross outstanding balance (Y/N)	grs_out_s	varchar2	length 80
Portfolio status report watch or grace (W/G)	port_wtch_c	char	length 1
Collection module watch or grace (W/G)	col_wtch_c	char	length 1
Delinquency report interactive watch code or grace (W/G)	del_i_wtch_c	char	length 1
Delinquency report EOP watch code or grace period (W/G)	del_e_wtch_c	char	length 1
Lease discounting used (Y/N)	lse_dsct_c	char	length 1
Updates locked (Y/N)	upd_lck_c	char	length 1
Vendor participating in income (Y/N)	d_inc_c	char	length 1
Include which assessments in delinquency calculation (Y/N)	del_a_s	char	length 16
Session update used (Y/N)	ses_c	char	length 1
Assign cash disbursements through session (Y/N)	ses_disb_c	char	length 1
IDC interest adjustment switch (Y/N)	idc_int_adj_c	char	length 1
Verify field (X/' ')	ver_s	varchar2	length 20
EOP group on grand total (Y/N)	eop_s_grp_grnd_c	char	length 1
EOP group on subtotal (Y/N)	eop_s_grp_sub_c	char	length 1
Use property tax description code (Y/N)	ptax_desc_use_c	char	length 1
Use FHUT description code (Y/N)	fhut_desc_use_c	char	length 1
Clone application status history (Y/N)	clone_appl_his_c	char	length 1
Drawdown history tracking (Y/N)	drawdown_tracking_c	char	length 1
First or last occurrence (F/L/' ') For cloning application status history through first or last occurrence of rpa::clone_to_status_s. This field will be initialized to blank if the history/client cloning module is not purchased	appl_first_last_c	char	length 1
CCA module used (Y/N)	cca_c	char	length 1
Portfolio name	cl_s	varchar2	length 36
Portfolio address	add_s	varchar2	length 36
Portfolio city	cty_s	varchar2	length 25
Portfolio state	st_s	char	length 2
Portfolio zip code	zip_s	char	length 9
Phone number	phn_s	char	length 10
Division name	cl_div_s	varchar2	length 80
Default document letter	doc_lett_s	char	length 6
Batch queue name	batch_que_s	varchar2	length 40
CCA default tax entity	cca_def_ent_s	char	length 4
Assessment name [1]	asm_name1_s	varchar2	length 20
Assessment name [2]	asm_name2_s	varchar2	length 20
Assessment name [3]	asm_name3_s	varchar2	length 20
Assessment name [4]	asm_name4_s	varchar2	length 20
Assessment name [5]	asm_name5_s	varchar2	length 20
Assessment name [6]	asm_name6_s	varchar2	length 20
Assessment name [7]	asm_name7_s	varchar2	length 20
Assessment name [8]	asm_name8_s	varchar2	length 20
Assessment name [9]	asm_name9_s	varchar2	length 20
Assessment name [10]	asm_name10_s	varchar2	length 20
Assessment name [11]	asm_name11_s	varchar2	length 20
Assessment name [12]	asm_name12_s	varchar2	length 20
Assessment name [13]	asm_name13_s	varchar2	length 20
Assessment name [14]	asm_name14_s	varchar2	length 20
Assessment name [15]	asm_name15_s	varchar2	length 20
Assessment name [16]	asm_name16_s	varchar2	length 20
Investor input required for lease discounting (Y/N)	invst_req_c	char	length 1
Track lease level transactions (RTY table) (Y/N)	lse_lvl_trans_c	char	length 1
Disburse Upfront sales tax through [U0449] (Y/N)	dsb_upfrnt_tax_c	char	length 1
Include security deposit in yield (Y/N)	incl_sec_dep_yld_c	char	length 1
ACH prenotes used (Y/N)	ach_prenote_used_c	char	length 1
Corporate standard entry class code is to be prenoted (Y/N)	prenote_ccd_c	char	length 1
Include IDC in NPV and SB payoffs (Y/N)	incl_idc_npv_sb_c	char	length 1
Take income on INV payoff for suspended lease (Y/N)	take_incm_susp_inv_c	char	length 1
Net cost calculation method (A/C)	net_cost_calc_meth_c	char	length 1
Number of months to wait before deleting lease level transactions (RTY table)	del_lse_lvl_trans_l	number	precision 10
Number of months to wait before deleting booked application structures	app_str_l	number	precision 10
Number of months to wait before deleting lease structures	lse_str_l	number	precision 10
Months before cleaning up lease/asset records	cln_lse_l	number	precision 10
Last day of the month	last_day_mth_l	number	precision 10
Grace period in days	grc_l	number	precision 10
Invoice deferral days	grc_invoice_l	number	precision 10
Accrual deferral days	grc_accrual_l	number	precision 10
Suspense limit in days	sus_l	number	precision 10
Delinquency category boundaries [1]	delq1_l	number	precision 10
Delinquency category boundaries [2]	delq2_l	number	precision 10
Delinquency category boundaries [3]	delq3_l	number	precision 10
Maximum days before current date for lease date	b_lsd_l	number	precision 10
Maximum days after current date for lease date	a_lsd_l	number	precision 10
Maximum days before current date for disbursement date	b_dis_l	number	precision 10
Maximum days after current date for disbursement date	a_dis_l	number	precision 10
Maximum days after current date for commencement date	a_com_l	number	precision 10
Days after lease date to begin certificate ownership tracking	oc_l	number	precision 10
Days after lease date to begin UCC tracking	ucc_l	number	precision 10
Days before maturity to begin Matured Lease tracking	matls_l	number	precision 10
Maximum lease term	h_trm_l	number	precision 10
Minimum lease term	l_trm_l	number	precision 10
Approval expiration days	exp_l	number	precision 10
Months after booking to delete application	cln_app_l	number	precision 10
Months after rejection/withdrawal to move application to ROA table	cln_dcln_l	number	precision 10
Months before deleting RPS records	cln_dps_l	number	precision 10
Months before deleting ROA records	cln_doa_l	number	precision 10
Number of days to wait before writing lease letters	lse_ltr_l	number	precision 10
Assessment payment order [1]	asm_pmt_order1_l	number	precision 10
Assessment payment order [2]	asm_pmt_order2_l	number	precision 10
Assessment payment order [3]	asm_pmt_order3_l	number	precision 10
Assessment payment order [4]	asm_pmt_order4_l	number	precision 10
Assessment payment order [5]	asm_pmt_order5_l	number	precision 10
Assessment payment order [6]	asm_pmt_order6_l	number	precision 10
Assessment payment order [7]	asm_pmt_order7_l	number	precision 10
Assessment payment order [8]	asm_pmt_order8_l	number	precision 10
Assessment payment order [9]	asm_pmt_order9_l	number	precision 10
Assessment payment order [10]	asm_pmt_order10_l	number	precision 10
Assessment payment order [11]	asm_pmt_order11_l	number	precision 10
Assessment payment order [12]	asm_pmt_order12_l	number	precision 10
Assessment payment order [13]	asm_pmt_order13_l	number	precision 10
Assessment payment order [14]	asm_pmt_order14_l	number	precision 10
Assessment payment order [15]	asm_pmt_order15_l	number	precision 10
Assessment payment order [16]	asm_pmt_order16_l	number	precision 10
Bad debt percentage	bad_debt_d	number	precision 15, scale 5
Commission rate	comm_rate_d	number	precision 15, scale 5
Tax rate	port_tax_d	number	precision 15, scale 5
Initial direct cost percentage	idc_pct_d	number	precision 15, scale 5
Maximum discount rate	h_disc_d	number	precision 15, scale 5
Minimum discount rate	l_disc_d	number	precision 15, scale 5
Portfolio maximum interest rate	p_max_por_d	number	precision 15, scale 5
Mininum interest rate	p_min_por_d	number	precision 15, scale 5
CCA prescribed rate add-on percentage	p_cca_paddon_d	number	precision 15, scale 5
Grace amount	grc_d	number	precision 15, scale 2
Tolerance amount	tol_d	number	precision 15, scale 2
Maximum shortage on short payoff	max_poff_d	number	precision 15, scale 2
Initial direct cost amount	idc_amt_d	number	precision 15, scale 2
Maximum original acquisition cost	h_org_d	number	precision 15, scale 2
Mininum original acquisition cost	l_org_d	number	precision 15, scale 2
Maximum documentation fee	h_up_d	number	precision 15, scale 2
Minimum documentation fee	l_up_d	number	precision 15, scale 2
Lease extension calculation method (A/C)	l_ext_calc_meth_c	char	length 1
Insurance fee rate	ins_fee_d	number	precision 15, scale 5
Assessment payment order [17]	asm_pmt_order17_l	number	precision 10
Assessment payment order [18]	asm_pmt_order18_l	number	precision 10
Assessment payment order [19]	asm_pmt_order19_l	number	precision 10
Assessment payment order [20]	asm_pmt_order20_l	number	precision 10
Assessment payment order [21]	asm_pmt_order21_l	number	precision 10
Assessment payment order [22]	asm_pmt_order22_l	number	precision 10
Assessment payment order [23]	asm_pmt_order23_l	number	precision 10
Assessment payment order [24]	asm_pmt_order24_l	number	precision 10
Assessment payment order [25]	asm_pmt_order25_l	number	precision 10
Assessment payment order [26]	asm_pmt_order26_l	number	precision 10
Assessment payment order [27]	asm_pmt_order27_l	number	precision 10
Assessment payment order [28]	asm_pmt_order28_l	number	precision 10
Assessment payment order [29]	asm_pmt_order29_l	number	precision 10
Assessment payment order [30]	asm_pmt_order30_l	number	precision 10
Assessment payment order [31]	asm_pmt_order31_l	number	precision 10
Assessment payment order [32]	asm_pmt_order32_l	number	precision 10
Assessment payment order [33]	asm_pmt_order33_l	number	precision 10
Check credit balance on asset add-on (Y/N)	check_cred_bal_c	char	length 1
Calculate days delinquent 30/360 (Y/N)	calc_dd_30_360_c	char	length 1
Allow taxable asset on IBL (Y/N)	allow_taxable_asset_on_ibl_c	char	length 1
Pay tax along with item (Y/N)	pay_tax_with_item_c	char	length 1
Upfront value added tax (IVA) (Y/N)	upf_vat_c	char	length 1
Delayed first payment flag (Y/N)	ern_mth_c	char	length 1
Ignore assessments for prepayments (Y/N)	ignore_assmt_for_prepay_c	char	length 1
Note type used in credit approval report	cred_rpt_note_type_s	char	length 4
Reversal bank code	rev_bank_s	char	length 3
Apply payment to note attached to lease (Y/N)	appl_pay_to_note_c	char	length 1
Number months before cleaning up GL transactions	cln_trx_l	number	precision 10
Default securitization portfolio	def_sec_por_s	char	length 2
Default securitization company	def_sec_com_s	char	length 2
Default securitization region	def_sec_reg_s	char	length 2
Default securitization office	def_sec_off_s	char	length 3
Number of days before tracking insurance	ins_exp_l	number	precision 10
Insurance team	ins_team_s	char	length 4
Insurance supervisor	ins_supr_s	char	length 3

rpa Indexes

Index Name	Piece 1
rpa_idx0	por_s

Child Table Listing

Table Name	Description
rpar	Porfolio Recurring Charge
rpay	Portfolio 2
rpaz	Portfolio 3

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 McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, 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.