raa Table: Recovery Agency Assignment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

raa Table: Recovery Agency Assignment

Indexes

Name Segment 1 Segment 2 Segment 3
raa_idx0 lse_s d_asgn_s agency_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
d_asgn_s
Assignment date
DATE no
agency_s
Agency code
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
d_next_s
Next agency assignment date
DATE yes
agency_type_s
Agency type
CHAR(4) yes
pol_ltr_sent_c
Policy letter sent (Y/N)
CHAR(1) yes
next_agency_s
Next agency to assign
CHAR(4) yes
days_reassign_l
Number of days to reassignment
NUMBER(10) yes