ACCOUNT_STATUS

Description:

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. May contain organization-specific values: Yes Category Entries: Returned Mail Payment Plan Collections Contested Accounts