This table contains the account status data for each account. Account Status is a multiple response item, that is, an account in your system can have more than one status, such as Returned Mail, Payment Plan, or Collections. Therefore, one row in this table contains one line of account status information for an account. Each row is uniquely identified by the Account ID and line number combination.
Primary Key
Column Name
Ordinal Position
ACCOUNT_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
ACCOUNT_ID
NUMERIC
No
This column stores the unique identifier for the guarantor record. This identifier could be encrypted if you have implemented enterprise reporting’s encryption security function.
2
LINE
INTEGER
No
Line number to identify the status information within the account.
3
ACCOUNT_STATUS_C_NAME
VARCHAR
No
The category value associated with the status of the account, such as Returned Mail, Collections, and so on.