DECISION_LETTERS
Description:
This table stores letters generated from decisions.

Primary Key
Column Name Ordinal Position
FIN_ASST_TRACKER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FIN_ASST_TRACKER_ID NUMERIC No
The unique identifier for the program tracker 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 LETTER_PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number of the encounter the decision letter was created in.
4 LETTER_JOB_ID VARCHAR No
The unique ID of the job associated with the decision letter in the list of encounter communications.