rau Table: Application User Profile
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rau Application User Profile table.

rau Columns

Description	Column Name	Data Type ?	Characteristics ?
Operator initials	opr_s	CHAR(3)
Record modification stamp	stamp_l	NUMBER(10)
Field security code [1]	fld_sec1_s	CHAR(4)
Field security code [2]	fld_sec2_s	CHAR(4)
Field security code [3]	fld_sec3_s	CHAR(4)
Field security code [4]	fld_sec4_s	CHAR(4)
Field security code [5]	fld_sec5_s	CHAR(4)
Field security code [6]	fld_sec6_s	CHAR(4)
Field security code [7]	fld_sec7_s	CHAR(4)
Field security code [8]	fld_sec8_s	CHAR(4)
Field security code [9]	fld_sec9_s	CHAR(4)
Field security code [10]	fld_sec10_s	CHAR(4)
Field security code [11]	fld_sec11_s	CHAR(4)
Field security code [12]	fld_sec12_s	CHAR(4)
Field security code [13]	fld_sec13_s	CHAR(4)
Field security code [14]	fld_sec14_s	CHAR(4)
Field security code [15]	fld_sec15_s	CHAR(4)
Field security code [16]	fld_sec16_s	CHAR(4)
Field security code [17]	fld_sec17_s	CHAR(4)
Field security code [18]	fld_sec18_s	CHAR(4)
Field security code [19]	fld_sec19_s	CHAR(4)
Field security code [20]	fld_sec20_s	CHAR(4)
Field security code [21]	fld_sec21_s	CHAR(4)
Field security code [22]	fld_sec22_s	CHAR(4)
Field security code [23]	fld_sec23_s	CHAR(4)
Field security code [24]	fld_sec24_s	CHAR(4)
Field security code [25]	fld_sec25_s	CHAR(4)
Field security code [26]	fld_sec26_s	CHAR(4)
Field security code [27]	fld_sec27_s	CHAR(4)
Field security code [28]	fld_sec28_s	CHAR(4)
Field security code [29]	fld_sec29_s	CHAR(4)
Field security code [30]	fld_sec30_s	CHAR(4)
Field security code [31]	fld_sec31_s	CHAR(4)
Field security code [32]	fld_sec32_s	CHAR(4)
Field security code [33]	fld_sec33_s	CHAR(4)
Field security code [34]	fld_sec34_s	CHAR(4)
Field security code [35]	fld_sec35_s	CHAR(4)
Field security code [36]	fld_sec36_s	CHAR(4)
Field security code [37]	fld_sec37_s	CHAR(4)
Application flow code	flow_s	CHAR(4)
Application letter code   This array contains only those letters   to which the user has access.	app_let_s	VARCHAR2(80)
User option code   This array contains only those user options   to which the user has access.	usr_opt_s	VARCHAR2(20)
Application status [1]	app_stat1_s	CHAR(4)
Application status [2]	app_stat2_s	CHAR(4)
Application status [3]	app_stat3_s	CHAR(4)
Application status [4]	app_stat4_s	CHAR(4)
Application status [5]	app_stat5_s	CHAR(4)
Application status [6]	app_stat6_s	CHAR(4)
Application status [7]	app_stat7_s	CHAR(4)
Application status [8]	app_stat8_s	CHAR(4)
Application status [9]	app_stat9_s	CHAR(4)
Application status [10]	app_stat10_s	CHAR(4)
Application status [11]	app_stat11_s	CHAR(4)
Application status [12]	app_stat12_s	CHAR(4)
Application status [13]	app_stat13_s	CHAR(4)
Application status [14]	app_stat14_s	CHAR(4)
Application status [15]	app_stat15_s	CHAR(4)
Application status [16]	app_stat16_s	CHAR(4)
Application status [17]	app_stat17_s	CHAR(4)
Application status [18]	app_stat18_s	CHAR(4)
Application status [19]	app_stat19_s	CHAR(4)
Application status [20]	app_stat20_s	CHAR(4)
Application status [21]	app_stat21_s	CHAR(4)
Application status [22]	app_stat22_s	CHAR(4)
Application status [23]	app_stat23_s	CHAR(4)
Application status [24]	app_stat24_s	CHAR(4)
Application status [25]	app_stat25_s	CHAR(4)
Application status [26]	app_stat26_s	CHAR(4)
Application status [27]	app_stat27_s	CHAR(4)
Application status [28]	app_stat28_s	CHAR(4)
Application status [29]	app_stat29_s	CHAR(4)
Application status [30]	app_stat30_s	CHAR(4)
Application status [31]	app_stat31_s	CHAR(4)
Application status [32]	app_stat32_s	CHAR(4)
Application status [33]	app_stat33_s	CHAR(4)
Application status [34]	app_stat34_s	CHAR(4)
Application status [35]	app_stat35_s	CHAR(4)
Application status [36]	app_stat36_s	CHAR(4)
Application status [37]	app_stat37_s	CHAR(4)
Default application status for DR option	dr_def_new_status_s	CHAR(4)
User may access corresponding application menu option (Y/N)	s_app_mod_c	VARCHAR2(30)
Modify address information (Y/N)	s_mod_addr_c	CHAR(1)
Modify document list (Y/N/R)   Y - can modify all list elements   N - cannot modify any list elements   R - can modify only unrestricted list elements	s_mod_doc_c	CHAR(1)
Override rate plan (Y/N)	s_over_rplan_c	CHAR(1)
Auto-approval privilege (Y/N)	s_appr_priv_c	CHAR(1)
Change approval expiration date (Y/N)	s_mod_exp_c	CHAR(1)
Modify effective date (Y/N)	s_mod_eff_c	CHAR(1)
WS default application/vendor (A/V)	s_app_vend_c	CHAR(1)
Approval based on total exposure (Y/N)	s_apprv_tot_exp_c	CHAR(1)
Display newer follow-up dates before old dates (Y/N)	s_new_note_first_c	CHAR(1)
Application status for new applications	new_app_stat_s	CHAR(4)
Default next owner initials [1]	def_nxt_own1_s	CHAR(3)
Default next owner initials [2]	def_nxt_own2_s	CHAR(3)
Default next owner initials [3]	def_nxt_own3_s	CHAR(3)
Default next owner initials [4]	def_nxt_own4_s	CHAR(3)
Default next owner initials [5]	def_nxt_own5_s	CHAR(3)
Default next owner initials [6]	def_nxt_own6_s	CHAR(3)
Default next owner initials [7]	def_nxt_own7_s	CHAR(3)
Default next owner initials [8]	def_nxt_own8_s	CHAR(3)
Default next owner initials [9]	def_nxt_own9_s	CHAR(3)
Default next owner initials [10]	def_nxt_own10_s	CHAR(3)
Default next owner initials [11]	def_nxt_own11_s	CHAR(3)
Default next owner initials [12]	def_nxt_own12_s	CHAR(3)
Default next owner initials [13]	def_nxt_own13_s	CHAR(3)
Default next owner initials [14]	def_nxt_own14_s	CHAR(3)
Default next owner initials [15]	def_nxt_own15_s	CHAR(3)
Default next owner initials [16]	def_nxt_own16_s	CHAR(3)
Default next owner initials [17]	def_nxt_own17_s	CHAR(3)
Default next owner initials [18]	def_nxt_own18_s	CHAR(3)
Default next owner initials [19]	def_nxt_own19_s	CHAR(3)
Default next owner initials [20]	def_nxt_own20_s	CHAR(3)
Default next owner initials [21]	def_nxt_own21_s	CHAR(3)
Default next owner initials [22]	def_nxt_own22_s	CHAR(3)
Default next owner initials [23]	def_nxt_own23_s	CHAR(3)
Default next owner initials [24]	def_nxt_own24_s	CHAR(3)
Default next owner initials [25]	def_nxt_own25_s	CHAR(3)
Default next owner initials [26]	def_nxt_own26_s	CHAR(3)
Default next owner initials [27]	def_nxt_own27_s	CHAR(3)
Default next owner initials [28]	def_nxt_own28_s	CHAR(3)
Default next owner initials [29]	def_nxt_own29_s	CHAR(3)
Default next owner initials [30]	def_nxt_own30_s	CHAR(3)
Default next owner initials [31]	def_nxt_own31_s	CHAR(3)
Default next owner initials [32]	def_nxt_own32_s	CHAR(3)
Default next owner initials [33]	def_nxt_own33_s	CHAR(3)
Default next owner initials [34]	def_nxt_own34_s	CHAR(3)
Default next owner initials [35]	def_nxt_own35_s	CHAR(3)
Default next owner initials [36]	def_nxt_own36_s	CHAR(3)
Default next owner initials [37]	def_nxt_own37_s	CHAR(3)
Default letter1 [1]	def_letter1_1_s	CHAR(6)
Default letter1 [2]	def_letter1_2_s	CHAR(6)
Default letter1 [3]	def_letter1_3_s	CHAR(6)
Default letter1 [4]	def_letter1_4_s	CHAR(6)
Default letter1 [5]	def_letter1_5_s	CHAR(6)
Default letter1 [6]	def_letter1_6_s	CHAR(6)
Default letter1 [7]	def_letter1_7_s	CHAR(6)
Default letter1 [8]	def_letter1_8_s	CHAR(6)
Default letter1 [9]	def_letter1_9_s	CHAR(6)
Default letter1 [10]	def_letter1_10_s	CHAR(6)
Default letter1 [11]	def_letter1_11_s	CHAR(6)
Default letter1 [12]	def_letter1_12_s	CHAR(6)
Default letter1 [13]	def_letter1_13_s	CHAR(6)
Default letter1 [14]	def_letter1_14_s	CHAR(6)
Default letter1 [15]	def_letter1_15_s	CHAR(6)
Default letter1 [16]	def_letter1_16_s	CHAR(6)
Default letter1 [17]	def_letter1_17_s	CHAR(6)
Default letter1 [18]	def_letter1_18_s	CHAR(6)
Default letter1 [19]	def_letter1_19_s	CHAR(6)
Default letter1 [20]	def_letter1_20_s	CHAR(6)
Default letter1 [21]	def_letter1_21_s	CHAR(6)
Default letter1 [22]	def_letter1_22_s	CHAR(6)
Default letter1 [23]	def_letter1_23_s	CHAR(6)
Default letter1 [24]	def_letter1_24_s	CHAR(6)
Default letter1 [25]	def_letter1_25_s	CHAR(6)
Default letter1 [26]	def_letter1_26_s	CHAR(6)
Default letter1 [27]	def_letter1_27_s	CHAR(6)
Default letter1 [28]	def_letter1_28_s	CHAR(6)
Default letter1 [29]	def_letter1_29_s	CHAR(6)
Default letter1 [30]	def_letter1_30_s	CHAR(6)
Default letter1 [31]	def_letter1_31_s	CHAR(6)
Default letter1 [32]	def_letter1_32_s	CHAR(6)
Default letter1 [33]	def_letter1_33_s	CHAR(6)
Default letter1 [34]	def_letter1_34_s	CHAR(6)
Default letter1 [35]	def_letter1_35_s	CHAR(6)
Default letter1 [36]	def_letter1_36_s	CHAR(6)
Default letter1 [37]	def_letter1_37_s	CHAR(6)
Default letter2 [1]	def_letter2_1_s	CHAR(6)
Default letter2 [2]	def_letter2_2_s	CHAR(6)
Default letter2 [3]	def_letter2_3_s	CHAR(6)
Default letter2 [4]	def_letter2_4_s	CHAR(6)
Default letter2 [5]	def_letter2_5_s	CHAR(6)
Default letter2 [6]	def_letter2_6_s	CHAR(6)
Default letter2 [7]	def_letter2_7_s	CHAR(6)
Default letter2 [8]	def_letter2_8_s	CHAR(6)
Default letter2 [9]	def_letter2_9_s	CHAR(6)
Default letter2 [10]	def_letter2_10_s	CHAR(6)
Default letter2 [11]	def_letter2_11_s	CHAR(6)
Default letter2 [12]	def_letter2_12_s	CHAR(6)
Default letter2 [13]	def_letter2_13_s	CHAR(6)
Default letter2 [14]	def_letter2_14_s	CHAR(6)
Default letter2 [15]	def_letter2_15_s	CHAR(6)
Default letter2 [16]	def_letter2_16_s	CHAR(6)
Default letter2 [17]	def_letter2_17_s	CHAR(6)
Default letter2 [18]	def_letter2_18_s	CHAR(6)
Default letter2 [19]	def_letter2_19_s	CHAR(6)
Default letter2 [20]	def_letter2_20_s	CHAR(6)
Default letter2 [21]	def_letter2_21_s	CHAR(6)
Default letter2 [22]	def_letter2_22_s	CHAR(6)
Default letter2 [23]	def_letter2_23_s	CHAR(6)
Default letter2 [24]	def_letter2_24_s	CHAR(6)
Default letter2 [25]	def_letter2_25_s	CHAR(6)
Default letter2 [26]	def_letter2_26_s	CHAR(6)
Default letter2 [27]	def_letter2_27_s	CHAR(6)
Default letter2 [28]	def_letter2_28_s	CHAR(6)
Default letter2 [29]	def_letter2_29_s	CHAR(6)
Default letter2 [30]	def_letter2_30_s	CHAR(6)
Default letter2 [31]	def_letter2_31_s	CHAR(6)
Default letter2 [32]	def_letter2_32_s	CHAR(6)
Default letter2 [33]	def_letter2_33_s	CHAR(6)
Default letter2 [34]	def_letter2_34_s	CHAR(6)
Default letter2 [35]	def_letter2_35_s	CHAR(6)
Default letter2 [36]	def_letter2_36_s	CHAR(6)
Default letter2 [37]	def_letter2_37_s	CHAR(6)
Default manager initials for a higher credit approval	def_mgr_s	CHAR(3)
Default signature name	def_sign_s	VARCHAR2(36)
Default signature title	def_sign_title_s	VARCHAR2(25)
WS default for ALL (X/' ')	ws_def_all_c	CHAR(1)
WS default user initials	ws_def_user_s	CHAR(3)
WS default team	ws_def_team_s	CHAR(4)
WS default status	ws_def_stat_s	CHAR(4)
WS sort order - status	ws_stat_l	NUMBER(10)
WS sort order - outstanding time	ws_time_l	NUMBER(10)
WS sort order - short name	ws_shrt_name_l	NUMBER(10)
WS sort order - application/lease number	ws_number_l	NUMBER(10)
WS sort order - application amount	ws_amt_l	NUMBER(10)
WS sort order - user initials	ws_opr_l	NUMBER(10)
WS sort order - follow-up date	ws_folw_l	NUMBER(10)
WS sort order - note priority	ws_prior_l	NUMBER(10)
Percent tolerance for exceeding credit line	perc_tolerance_d	NUMBER(15,1)
Approval credit limit	appr_lim_d	NUMBER(15,2)
Dollar tolerance for exceeding credit line	dollar_tolerance_d	NUMBER(15,2)
Acquisition cost dollar tolerance	acq_doll_tol_d	NUMBER(15,2)
Acquistion cost percent tolerance	acq_per_tol_d	NUMBER(15,1)
Documentation fee dollar tolerance	doc_doll_tol_d	NUMBER(15,2)
Documentation fee percent tolerance	doc_per_tol_d	NUMBER(15,1)
Down payment dollar tolerance	down_doll_tol_d	NUMBER(15,2)
Down payment percent tolerance	down_per_tol_d	NUMBER(15,1)
Payment amount dollar tolerance	pay_doll_tol_d	NUMBER(15,2)
Payment amount percent tolerance	pay_per_tol_d	NUMBER(15,1)
Residual dollar tolerance	res_doll_tol_d	NUMBER(15,2)
Residual percent tolerance	res_per_tol_d	NUMBER(15,1)
Security deposit dollar tolerance	sec_doll_tol_d	NUMBER(15,2)
Security deposit percent tolerance	sec_per_tol_d	NUMBER(15,1)
Delete document file (Y/N)	del_doc_file_c	CHAR(1)
Override drawdown credit balance and expiration date (Y/N)	override_drawdown_c	CHAR(1)
Email address	email_s	VARCHAR2(50)
Fax dial number	fax_s	CHAR(10)
Phone number	phn_s	CHAR(10)
Default next owner to current operator (Y/N)	def_nxt_own_to_opr_s	VARCHAR2(37)

rau Indexes

Index Name	Piece 1
rau_idx0	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 6.2a Documentation Suite

© 2010 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.