LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rip Table: Insurance User Profile

Description Column Datatype
Operator initials opr_s char (3)
Oracle row stamp stamp_l number (10)
Display newer follow-up dates before old dates (Y/N) s_new_note_first_c char (1)
Access all insurance user accounts (Y/N) all_ins_c char (1)
Alpha assign by short name (X/' ')
  X - Allow access
alpha_c varchar2 (26)
Alpha assign by tracking type alpha_type_c varchar2 (26)
Default signature name sign_s varchar2 (36)
Default signature title title_s varchar2 (25)
Letter code
  This array contains only those letters
  to which the user has access.
let_cd_s varchar2 (80)
User option code
  This array contains only those user options
  to which the user has access.
usr_opt_s varchar2 (20)
WS default for ALL (X/' ') ws_def_all_c char (1)
WS default team ws_def_team_s char (4)
WS default user initials ws_def_user_s char (3)
WS sort order - lease number ws_lse_num_l number (10)
WS sort order - insurance policy ws_pol_num_l number (10)
WS sort order - expiration date ws_exp_date_l number (10)
WS sort order - short name ws_shrt_name_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)

rip Indexes:

Index name Piece 1
rip_idx0 opr_s


HomeTableIndexes