| Name | Segment 1 | Segment 2 | 
|---|---|---|
| rab_idx0 | act_s | act_substat_s | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| act_s | Activity status  | 
char(4) | no | 
| act_substat_s | Activity substatus (ACTSUBSTAT code)  | 
char(4) | no | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| 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 | 
char(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 |