The DECISION_SVC_EPISODES table contains information about decisions associated with service episodes. A decision is associated with a service episode if it was created on that episode or is linked to it via FNT 500-Linked Service Episodes.
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
SERVICE_EPISODE_ID
NUMERIC
No
The unique ID of the service episode linked to this decision.