rip Table: Insurance User Profile
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rip Table: Insurance User Profile

Indexes

Name Segment 1
rip_idx0 opr_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
opr_s
Operator initials
char(3) no
timestamp
Record modification stamp
timestamp yes
s_new_note_first_c
Display newer follow-up dates before old dates (Y/N)
char(1) yes
all_ins_c
Access all insurance user accounts (Y/N)
char(1) yes
alpha_c
Alpha assign by short name (X/' ')
  X - Allow access
char(26) yes
alpha_type_c
Alpha assign by tracking type
char(26) yes
sign_s
Default signature name
char(36) yes
title_s
Default signature title
char(25) yes
let_cd_s
Letter code
  This array contains only those letters
  to which the user has access.
char(80) yes
usr_opt_s
User option code
  This array contains only those user options
  to which the user has access.
char(20) yes
ws_def_all_c
WS default for ALL (X/' ')
char(1) yes
ws_def_team_s
WS default team
char(4) yes
ws_def_user_s
WS default user initials
char(3) yes
ws_lse_num_l
WS sort order - lease number
integer yes
ws_pol_num_l
WS sort order - insurance policy
integer yes
ws_exp_date_l
WS sort order - expiration date
integer yes
ws_shrt_name_l
WS sort order - short name
integer yes
ws_opr_l
WS sort order - user initials
integer yes
ws_folw_l
WS sort order - follow-up date
integer yes
ws_prior_l
WS sort order - note priority
integer yes
s_ins_mod_c
User has access to corresponding insurance menu option (Y/N)
char(30) yes
email_s
Email address
char(50) yes
fax_s
Fax dial number
char(10) yes
phn_s
Phone number
char(10) yes
xsl_filename_s
XSL file name
char(25) yes