ColumnsIndexessp1

rsc Table: Operator Security
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rsc Operator Security table.

rsc Columns

Description	Column Name	Data Type ?	Characteristics ?
Username	user_name_s	char	length 12
Record modification stamp	stamp_l	number	precision 10
Operator initials	opr_s	char	length 3
Modules (Y/N)	s_mod1_c	varchar2	length 250
Modules (Y/N)	s_mod2_c	varchar2	length 250
Print report detail (Y/N)	s_dtl_c	char	length 1
Print summary totals (Y/N)	s_sum_c	char	length 1
Print last version (Y/N)	s_last_c	char	length 1
Process report in batch (Y/N)	s_btch_c	char	length 1
Subtotals (Y/N)	s_subtl_c	char	length 1
Subtotals by portfolio (Y/N)	s_por_sub_c	char	length 1
Subtotals by company (Y/N)	s_com_sub_c	char	length 1
Subtotals by region (Y/N)	s_reg_sub_c	char	length 1
Subtotals by office (Y/N)	s_off_sub_c	char	length 1
Subtotals by customer (Y/N)	s_cus_sub_c	char	length 1
Subtotals by lessee (Y/N)	s_les_sub_c	char	length 1
Grand totals (Y/N)	s_grnd_c	char	length 1
Grand totals by portfolio (Y/N)	s_por_grnd_c	char	length 1
Grand totals by company (Y/N)	s_com_grnd_c	char	length 1
Grand totals by region (Y/N)	s_reg_grnd_c	char	length 1
Grand totals by office (Y/N)	s_off_grnd_c	char	length 1
Grand totals by customer (Y/N)	s_cus_grnd_c	char	length 1
Grand totals by lessee (Y/N)	s_les_grnd_c	char	length 1
Override auto-assigned application/lease number (Y/N)	s_ovr_appl_c	char	length 1
Override auto-assigned client number (Y/N)	s_ovr_clnt_c	char	length 1
New note notification (Y/N)	s_ntf_note_c	char	length 1
Ability to delete own notes (Y/N)	s_del_own_c	char	length 1
Ability to delete all notes (Y/N)	s_del_all_c	char	length 1
Allow access to notebook (Y/N)	s_ntbk_accs_c	char	length 1
Subtotals by group (Y/N)	s_grp_sub_c	char	length 1
Grand totals by group (Y/N)	s_grp_grnd_c	char	length 1
Update client credit limit (Y/N)	s_upd_crdt_lmt_c	char	length 1
Display older follow-up dates before new dates (Y/N)	s_old_note_first_c	char	length 1
Portfolio access array (Y/N) If the array element is 'Y' then the index of this element is the accessible portfolio.	por_array_c	varchar2	length 99
Portfolio If non-blank, the user may only access this portfolio.	por_s	char	length 2
Company If non-blank, the user may only access this company.	com_s	char	length 2
Region If non-blank, the user may only access this region.	reg_s	char	length 2
Office If non-blank, the user may only access this office.	off_s	char	length 3
Vendor If non-blank, the user may only access this vendor.	dlr_s	char	length 9
Plain paper form type	plain_s	char	length 4
Default 'L' printer symbol	lpr_sym_s	varchar2	length 20
Default 'X' printer symbol	xpr_sym_s	varchar2	length 20
Default note type	def_note_type_s	char	length 4
Report copies	copies_l	number	precision 10
Terminal page size	term_sz_l	number	precision 10
Allow master file delete privilege (Y/N)	allow_mf_del_priv_c	char	length 1
Modules (Y/N)	s_mod3_c	varchar2	length 200
Access to lessee credit scan (Y/N)	s_ux_credit_scan_c	char	length 1
Access notebook private	s_ntbk_private_l	number	precision 10
Late charges waived limit	ltch_waive_limit_d	number	precision 15, scale 2
Collection fees waived limit	coll_waive_limit_d	number	precision 15, scale 2
Assumption fees waived limit	asmf_waive_limit_d	number	precision 15, scale 2
Property tax waived limit	prtx_waive_limit_d	number	precision 15, scale 2
Legal fees waived limit	legf_waive_limit_d	number	precision 15, scale 2
Payment extension fees waived limit	pext_waive_limit_d	number	precision 15, scale 2
Lease extension fees waived limit	lext_waive_limit_d	number	precision 15, scale 2
ITC fees waived limit	itcf_waive_limit_d	number	precision 15, scale 2
Federal highway use tax waived limit	fhut_waive_limit_d	number	precision 15, scale 2
Lease re-write fees waived limit	lsrw_waive_limit_d	number	precision 15, scale 2
Other fees waived limit	othf_waive_limit_d	number	precision 15, scale 2
Sales/Use tax waived limit	stax_waive_limit_d	number	precision 15, scale 2
Recurring charge waived limit [1]	rcr_waive_limit1_d	number	precision 15, scale 2
Recurring charge waived limit [2]	rcr_waive_limit2_d	number	precision 15, scale 2
Recurring charge waived limit [3]	rcr_waive_limit3_d	number	precision 15, scale 2
Recurring charge waived limit [4]	rcr_waive_limit4_d	number	precision 15, scale 2
Recurring charge waived limit [5]	rcr_waive_limit5_d	number	precision 15, scale 2
Recurring charge waived limit [6]	rcr_waive_limit6_d	number	precision 15, scale 2
Recurring charge waived limit [7]	rcr_waive_limit7_d	number	precision 15, scale 2
Recurring charge waived limit [8]	rcr_waive_limit8_d	number	precision 15, scale 2
Recurring charge waived limit [9]	rcr_waive_limit9_d	number	precision 15, scale 2
Recurring charge waived limit [10]	rcr_waive_limit10_d	number	precision 15, scale 2
Recurring charge waived limit [11]	rcr_waive_limit11_d	number	precision 15, scale 2
Recurring charge waived limit [12]	rcr_waive_limit12_d	number	precision 15, scale 2
Recurring charge waived limit [13]	rcr_waive_limit13_d	number	precision 15, scale 2
Recurring charge waived limit [14]	rcr_waive_limit14_d	number	precision 15, scale 2
Recurring charge waived limit [15]	rcr_waive_limit15_d	number	precision 15, scale 2
Payment waived limit	pmt_waive_limit_d	number	precision 15, scale 2
Principal waived limit	prn_waive_limit_d	number	precision 15, scale 2
Interest waived limit	int_waive_limit_d	number	precision 15, scale 2
User account status (Y/P/R/N) Y - User account is enabled as a regular update user P - User account is enabled as a partial update user R - User account is enabled as a report only user N - User account is disabled	enable_c	char	length 1
Size of lstotal map in megabytes	lstotal_size_in_mb_l	number	precision 10
Date display format preference MMDDYY - Mon Day Year DDMMYY - Day Mon Year YYMMDD - Year Mon Day	date_format_pref_s	char	length 6
Allow client record name change (Y/N)	s_chg_client_name_c	char	length 1
Phone number mask preference	phn_format_pref_s	char	length 16
Days before password expires	pwd_expires_l	number	precision 10
Date password last changed	d_pwd_chg_s	date	format YYYYMMDD
Can change all users passwords (Y/N)	chg_all_pwd_c	char	length 1
Can change dealer alert switches (Y/N)	dlr_alrt_chg_s	char	length 6
Dealer alert suspense override (Y/N)	dlr_alrt_susp_ovr_c	char	length 1
Allow file attachment delete (Y/N)	file_attach_del_c	char	length 1
Automatic refresh of notebook work schedule (Y/N)	auto_refresh_nbws_c	char	length 1
Override portfolio security on Lease Summary (Y/N)	por_ovr_lse_summ_c	char	length 1
XML reports (Y/N)	xml_rpts_c	char	length 1
Output device selection (Y/N)	output_device_selection_c	char	length 1
Terminal output only (Y/N)	terminal_only_c	char	length 1
Force password change at next login (Y/N)	force_pwd_chg_c	char	length 1
Lease Summary XSL file name	lse_summ_xsl_filename_s	varchar2	length 25
Launch Pad XSL fle name	launch_pad_xsl_filename_s	varchar2	length 25
Allow access to user defined fields and tables (Y/N)	allow_ud_access_c	char	length 1
Automatic logout time period # - automatically logout an idle user after # seconds 0 - disable automatic logout	auto_logout_l	number	precision 10
Allow assessment description change (Y/N)	assmt_desc_chg_c	char	length 1

rsc Indexes

Index Name	Piece 1
rsc_idx0	user_name_s
rsc_idx1	opr_s

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.