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 |