ACCT_WORK_PHONE_HX
Description:
This table contains the guarantor's work phone history.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
The unique identifier for the account record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CHANGE_DATE DATETIME No
The date the work phone number was changed.
4 PHONE_NUMBER VARCHAR No
The work phone number on the account.
5 CHANGE_SOURCE_C_NAME VARCHAR No
The source of the change of the work phone number.
May contain organization-specific values: No
Category Entries:
Bridges
EpicCare
Cadence
Professional Billing
ManagedCare
Chronicles