rsc Table: Operator Security
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rsc Table: Operator Security

Child Tables

Name Description
rsca Operator Security 2

Indexes

Name Segment 1
rsc_idx0 user_name_s
rsc_idx1 opr_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
user_name_s
Username (uppercase)
CHAR(12) no
stamp_l
Record modification stamp
NUMBER(10) no
opr_s
Operator initials
CHAR(3) no
s_mod1_c
Modules (Y/N)
VARCHAR2(250) yes
s_mod2_c
Modules (Y/N)
VARCHAR2(250) yes
s_dtl_c
Print report detail (Y/N)
CHAR(1) yes
s_sum_c
Print summary totals (Y/N)
CHAR(1) yes
s_last_c
Print last version (Y/N)
CHAR(1) yes
s_btch_c
Process report in batch (Y/N)
CHAR(1) yes
s_subtl_c
Subtotals (Y/N)
CHAR(1) yes
s_por_sub_c
Subtotals by portfolio (Y/N)
CHAR(1) yes
s_com_sub_c
Subtotals by company (Y/N)
CHAR(1) yes
s_reg_sub_c
Subtotals by region (Y/N)
CHAR(1) yes
s_off_sub_c
Subtotals by office (Y/N)
CHAR(1) yes
s_cus_sub_c
Subtotals by customer (Y/N)
CHAR(1) yes
s_les_sub_c
Subtotals by lessee (Y/N)
CHAR(1) yes
s_grnd_c
Grand totals (Y/N)
CHAR(1) yes
s_por_grnd_c
Grand totals by portfolio (Y/N)
CHAR(1) yes
s_com_grnd_c
Grand totals by company (Y/N)
CHAR(1) yes
s_reg_grnd_c
Grand totals by region (Y/N)
CHAR(1) yes
s_off_grnd_c
Grand totals by office (Y/N)
CHAR(1) yes
s_cus_grnd_c
Grand totals by customer (Y/N)
CHAR(1) yes
s_les_grnd_c
Grand totals by lessee (Y/N)
CHAR(1) yes
s_ovr_appl_c
Override auto-assigned application/lease number (Y/N)
CHAR(1) yes
s_ovr_clnt_c
Override auto-assigned client number (Y/N)
CHAR(1) yes
s_ntf_note_c
New note notification (Y/N)
CHAR(1) yes
s_del_own_c
Ability to delete own notes (Y/N)
CHAR(1) yes
s_del_all_c
Ability to delete all notes (Y/N)
CHAR(1) yes
s_ntbk_accs_c
Allow access to Notebook (Y/N)
CHAR(1) yes
s_grp_sub_c
Subtotals by group (Y/N)
CHAR(1) yes
s_grp_grnd_c
Grand totals by group (Y/N)
CHAR(1) yes
s_upd_crdt_lmt_c
Update client credit limit (Y/N)
CHAR(1) yes
s_old_note_first_c
Display older follow-up dates before new dates (Y/N)
CHAR(1) yes
por_array_c
Portfolio access array (Y/N)
  If the array element is 'Y' then the index of this
  element is the accessible portfolio.
VARCHAR2(99) yes
por_s
Portfolio
  If non-blank, the user may only access this portfolio.
CHAR(2) yes
com_s
Company
  If non-blank, the user may only access this company.
CHAR(2) yes
reg_s
Region
  If non-blank, the user may only access this region.
CHAR(2) yes
off_s
Office
  If non-blank, the user may only access this office.
CHAR(3) yes
dlr_s
Vendor
  If non-blank, the user may only access this vendor.
CHAR(9) yes
plain_s
Plain paper form type
CHAR(4) yes
lpr_sym_s
Default 'L' printer symbol
VARCHAR2(20) yes
xpr_sym_s
Default 'X' printer symbol
VARCHAR2(20) yes
def_note_type_s
Default note type
CHAR(4) yes
copies_l
Report copies
NUMBER(10) yes
term_sz_l
Terminal page size
NUMBER(10) yes
allow_mf_del_priv_c
Allow master file delete privilege (Y/N)
CHAR(1) yes
s_mod3_c
Modules (Y/N)
VARCHAR2(200) yes
s_ux_credit_scan_c
Access to lessee credit scan (Y/N)
CHAR(1) yes
s_ntbk_private_l
Private note access level in Notebook
  0 - No access
  1 - Read access
  2 - Read and create access
        (Notebook screen does not default to private)
  3 - Read and create access
        (Notebook screen defaults to private)
  4 - Read, create, edit, and delete access
        (Notebook screen defaults to private)
NUMBER(10) yes
ltch_waive_limit_d
Late charges waived limit
NUMBER(15,2) yes
coll_waive_limit_d
Collection fees waived limit
NUMBER(15,2) yes
asmf_waive_limit_d
Assumption fees waived limit
NUMBER(15,2) yes
prtx_waive_limit_d
Property tax waived limit
NUMBER(15,2) yes
legf_waive_limit_d
Legal fees waived limit
NUMBER(15,2) yes
pext_waive_limit_d
Payment extension fees waived limit
NUMBER(15,2) yes
lext_waive_limit_d
Lease extension fees waived limit
NUMBER(15,2) yes
itcf_waive_limit_d
ITC fees waived limit
NUMBER(15,2) yes
fhut_waive_limit_d
Federal highway use tax waived limit
NUMBER(15,2) yes
lsrw_waive_limit_d
Lease re-write fees waived limit
NUMBER(15,2) yes
othf_waive_limit_d
Other fees waived limit
NUMBER(15,2) yes
stax_waive_limit_d
Sales/Use tax waived limit
NUMBER(15,2) yes
rcr_waive_limit1_d
Recurring charge waived limit [1]
NUMBER(15,2) yes
rcr_waive_limit2_d
Recurring charge waived limit [2]
NUMBER(15,2) yes
rcr_waive_limit3_d
Recurring charge waived limit [3]
NUMBER(15,2) yes
rcr_waive_limit4_d
Recurring charge waived limit [4]
NUMBER(15,2) yes
rcr_waive_limit5_d
Recurring charge waived limit [5]
NUMBER(15,2) yes
rcr_waive_limit6_d
Recurring charge waived limit [6]
NUMBER(15,2) yes
rcr_waive_limit7_d
Recurring charge waived limit [7]
NUMBER(15,2) yes
rcr_waive_limit8_d
Recurring charge waived limit [8]
NUMBER(15,2) yes
rcr_waive_limit9_d
Recurring charge waived limit [9]
NUMBER(15,2) yes
rcr_waive_limit10_d
Recurring charge waived limit [10]
NUMBER(15,2) yes
rcr_waive_limit11_d
Recurring charge waived limit [11]
NUMBER(15,2) yes
rcr_waive_limit12_d
Recurring charge waived limit [12]
NUMBER(15,2) yes
rcr_waive_limit13_d
Recurring charge waived limit [13]
NUMBER(15,2) yes
rcr_waive_limit14_d
Recurring charge waived limit [14]
NUMBER(15,2) yes
rcr_waive_limit15_d
Recurring charge waived limit [15]
NUMBER(15,2) yes
pmt_waive_limit_d
Payment waived limit
NUMBER(15,2) yes
prn_waive_limit_d
Principal waived limit
NUMBER(15,2) yes
int_waive_limit_d
Interest waived limit
NUMBER(15,2) yes
enable_c
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
CHAR(1) yes
date_format_pref_s
Date display format preference
  MMDDYY - Mon Day Year
  DDMMYY - Day Mon Year
  YYMMDD - Year Mon Day
CHAR(6) yes
s_chg_client_name_c
Allow client record name change (Y/N)
CHAR(1) yes
phn_format_pref_s
Phone number mask preference
CHAR(16) yes
pwd_expires_l
Days before password expires
NUMBER(10) yes
d_pwd_chg_s
Date password last changed
DATE yes
chg_all_pwd_c
Can change all users passwords (Y/N)
CHAR(1) yes
dlr_alrt_chg_s
Can change dealer alert switches (Y/N)
CHAR(6) yes
dlr_alrt_susp_ovr_c
Dealer alert suspense override (Y/N)
CHAR(1) yes
file_attach_del_c
Allow file attachment delete (Y/N)
CHAR(1) yes
auto_refresh_nbws_c
Automatic refresh of notebook work schedule (Y/N)
CHAR(1) yes
por_ovr_lse_summ_c
Override portfolio security on Lease Summary (Y/N)
CHAR(1) yes
xml_rpts_c
XML reports (Y/N)
CHAR(1) yes
output_device_selection_c
Output device selection (Y/N)
CHAR(1) yes
terminal_only_c
Terminal output only (Y/N)
CHAR(1) yes
force_pwd_chg_c
Force password change at next login (Y/N)
CHAR(1) yes
lse_summ_xsl_filename_s
Lease Summary XSL file name
VARCHAR2(25) yes
launch_pad_xsl_filename_s
Launch Pad XSL fle name
VARCHAR2(25) yes
allow_ud_access_c
Allow access to user defined fields and tables (Y/N)
CHAR(1) yes
auto_logout_l
Automatic logout time period
  # - automatically logout an idle user after # seconds
  0 - disable automatic logout
NUMBER(10) yes
assmt_desc_chg_c
Allow assessment description change (Y/N)
CHAR(1) yes
ss_disp_mask_s
Mask type to apply to SSN/Business ID numbers (DISP.MASK
  code)
CHAR(4) yes
pap_disp_mask_s
Mask type to apply to PAP-ACH transit ids and account
  numbers (DISP.MASK code)
CHAR(4) yes
asmf_man_limit_d
Assumption fees manual limit
NUMBER(15,2) yes
coll_man_limit_d
Collection fees manual limit
NUMBER(15,2) yes
fhut_man_limit_d
Federal highway use tax manual limit
NUMBER(15,2) yes
itcf_man_limit_d
ITC fees manual limit
NUMBER(15,2) yes
legf_man_limit_d
Legal fees manual limit
NUMBER(15,2) yes
lext_man_limit_d
Lease extension fees manual limit
NUMBER(15,2) yes
lsrw_man_limit_d
Lease re-write fees manual limit
NUMBER(15,2) yes
ltch_man_limit_d
Late charges manual limit
NUMBER(15,2) yes
othf_man_limit_d
Other fees manual limit
NUMBER(15,2) yes
pext_man_limit_d
Payment extension fees manual limit
NUMBER(15,2) yes
prtx_man_limit_d
Property tax manual limit
NUMBER(15,2) yes
stax_man_limit_d
Sales/Use tax manual limit
NUMBER(15,2) yes
rcr_man_limit1_d
Recurring charge manual limit [1]
NUMBER(15,2) yes
rcr_man_limit2_d
Recurring charge manual limit [2]
NUMBER(15,2) yes
rcr_man_limit3_d
Recurring charge manual limit [3]
NUMBER(15,2) yes
rcr_man_limit4_d
Recurring charge manual limit [4]
NUMBER(15,2) yes
rcr_man_limit5_d
Recurring charge manual limit [5]
NUMBER(15,2) yes
rcr_man_limit6_d
Recurring charge manual limit [6]
NUMBER(15,2) yes
rcr_man_limit7_d
Recurring charge manual limit [7]
NUMBER(15,2) yes
rcr_man_limit8_d
Recurring charge manual limit [8]
NUMBER(15,2) yes
rcr_man_limit9_d
Recurring charge manual limit [9]
NUMBER(15,2) yes
rcr_man_limit10_d
Recurring charge manual limit [10]
NUMBER(15,2) yes
rcr_man_limit11_d
Recurring charge manual limit [11]
NUMBER(15,2) yes
rcr_man_limit12_d
Recurring charge manual limit [12]
NUMBER(15,2) yes
rcr_man_limit13_d
Recurring charge manual limit [13]
NUMBER(15,2) yes
rcr_man_limit14_d
Recurring charge manual limit [14]
NUMBER(15,2) yes
rcr_man_limit15_d
Recurring charge manual limit [15]
NUMBER(15,2) yes
reltree_opt_l
Relationship Tree options (bit flags)
  1 - Customer/Group/Lessee/Lease/Asset
  2 - Customer/Lessee/Group/Lease/Asset
  4 - Customer/Lessee/Lease/Asset
  8 - Lessee/Lease/Asset
  16 - Vendor/Lease/Asset
NUMBER(10) yes
reltree_disp_grp_c
Display group number with lease on Relationship Tree (Y/N)
CHAR(1) yes
rsc_flg_c
RSC flag (O/R/S)
  O - operator with own credentials
  R - role with no credentials
  S - shared credentials operator
CHAR(1) yes
role_s
Role
CHAR(12) yes
credent_user_pwd_s
Hashed key for user of shared credentials
CHAR(18) yes
allow_lpak_api_access_c
Allow LeasePak API access (Y/N)
CHAR(1) yes