rab Table: Activity Status/Substatus
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rab Table: Activity Status/Substatus

Indexes

Name Segment 1 Segment 2
rab_idx0 act_s act_substat_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
act_s
Activity status
CHAR(4) no
act_substat_s
Activity substatus (ACTSUBSTAT code)
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
proc_task_s
Processing task (Y/N)
  Position and corresponding task:
    1 - Accrue interest when less than 60 days delinquent
    2 - Assess late charge
    3 - Allow payoff quote
    4 - Add to collection queue
    5 - Automated collection letter
    6 - Unused position
    7 - Include asset gain/loss in deficiency
    8 - Stop credit bureau reporting
    9 - Allow invoicing
    10 - Write-off reason code can be blank
    11 - Report scheduled monthly payment amount to CB
         as zero
    12 - Use D in CB payment history profile
    13 - Freeze CB account status and payment rating
    14 - Freeze CB current balance
    15 - Freeze CB amount past due
    16 - Freeze CB date of first delinquency
    17 - Report current balance to CB as zero
    18 - Report amount past due to CB as zero
    19 - Require payoff reason code
    20 - Unused position
VARCHAR2(20) yes
cb_account_stat_s
Credit bureau account status (CB.ACCSTAT code)
  11 = Current (0-29 days past due date)
  13 = Paid or closed with zero balance
  61 = Paid in full, was a voluntary surrender
  62 = Paid in full, was a collection account
  63 = Paid in full, was a repossession
  64 = Paid in full, was a charge-off
  71 = 30-59 days past due date
  78 = 60-89 days past due date
  80 = 90-119 days past due date
  82 = 120-149 days past due date
  83 = 150-179 days past due date
  84 = 180 or more days past due date
  93 = Assigned to collections
  95 = Voluntary surrender, there may be a balance due
  96 = Repossession, there may be a balance due
  97 = Charge-off (unpaid balance reported as a loss)
  DA = Delete account for reason other than fraud
  DF = Delete account due to confirmed fraud
CHAR(2) yes