| 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 |
| 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 |