ColumnsIndexessp1

rsc Table: Operator Security
Sybase DBMS

Specifies the columns and rows with Sybase 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	timestamp	timestamp
Operator initials	opr_s	char	length 3
Modules (Y/N)	s_mod1_c	char	length 250
Modules (Y/N)	s_mod2_c	char	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	char	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	char	length 20
Default 'X' printer symbol	xpr_sym_s	char	length 20
Default note type	def_note_type_s	char	length 4
Report copies	copies_l	integer
Terminal page size	term_sz_l	integer
Allow master file delete privilege (Y/N)	allow_mf_del_priv_c	char	length 1
Modules (Y/N)	s_mod3_c	char	length 200
Access to lessee credit scan (Y/N)	s_ux_credit_scan_c	char	length 1
Access notebook private	s_ntbk_private_l	integer
Late charges waived limit	ltch_waive_limit_d	double	scale 2
Collection fees waived limit	coll_waive_limit_d	double	scale 2
Assumption fees waived limit	asmf_waive_limit_d	double	scale 2
Property tax waived limit	prtx_waive_limit_d	double	scale 2
Legal fees waived limit	legf_waive_limit_d	double	scale 2
Payment extension fees waived limit	pext_waive_limit_d	double	scale 2
Lease extension fees waived limit	lext_waive_limit_d	double	scale 2
ITC fees waived limit	itcf_waive_limit_d	double	scale 2
Federal highway use tax waived limit	fhut_waive_limit_d	double	scale 2
Lease re-write fees waived limit	lsrw_waive_limit_d	double	scale 2
Other fees waived limit	othf_waive_limit_d	double	scale 2
Sales/Use tax waived limit	stax_waive_limit_d	double	scale 2
Recurring charge waived limit [1]	rcr_waive_limit1_d	double	scale 2
Recurring charge waived limit [2]	rcr_waive_limit2_d	double	scale 2
Recurring charge waived limit [3]	rcr_waive_limit3_d	double	scale 2
Recurring charge waived limit [4]	rcr_waive_limit4_d	double	scale 2
Recurring charge waived limit [5]	rcr_waive_limit5_d	double	scale 2
Recurring charge waived limit [6]	rcr_waive_limit6_d	double	scale 2
Recurring charge waived limit [7]	rcr_waive_limit7_d	double	scale 2
Recurring charge waived limit [8]	rcr_waive_limit8_d	double	scale 2
Recurring charge waived limit [9]	rcr_waive_limit9_d	double	scale 2
Recurring charge waived limit [10]	rcr_waive_limit10_d	double	scale 2
Recurring charge waived limit [11]	rcr_waive_limit11_d	double	scale 2
Recurring charge waived limit [12]	rcr_waive_limit12_d	double	scale 2
Recurring charge waived limit [13]	rcr_waive_limit13_d	double	scale 2
Recurring charge waived limit [14]	rcr_waive_limit14_d	double	scale 2
Recurring charge waived limit [15]	rcr_waive_limit15_d	double	scale 2
Payment waived limit	pmt_waive_limit_d	double	scale 2
Principal waived limit	prn_waive_limit_d	double	scale 2
Interest waived limit	int_waive_limit_d	double	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	integer
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	integer
Date password last changed	d_pwd_chg_s	datetime	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	char	length 25
Launch Pad XSL fle name	launch_pad_xsl_filename_s	char	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	integer
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 Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

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

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

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 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.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
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 number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

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.