REFERRAL_FLAGS
Description:
The REFERRAL_FLAGS table holds the referral flag information associated with the referral records stored in the REFERRAL table. Each referral record can have any number of flags assigned to it. This table stores every flag associated with each referral record.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The internal ID of the referral that this row of information corresponds to.
2 LINE INTEGER No
The line number of the referral flag that this row of information corresponds to. For instance, if the referral has two flags, the first flag will have a Line value of 1 while the second will have a Line value of 2
3 FLAG_C_NAME VARCHAR No
The category number associated with the flag assigned to the referral
May contain organization-specific values: Yes