line_item_form_response

Responses to a codified questionnaire

Primary Key:

• line_item_form_id
• question_number

Foreign Keys:

• line_item_form_id => line_item_form.line_item_form_id

Column	Data Type	Nullable	Indexed	Description
question_number	text	No	Yes	Identifies the question being answered (from FRM01 / NCPDP 378-4B)
response_yes_no	yes_no_response_type	Yes	No	Yes/No response (from FRM02)
response_text	text	No	No	Text response (from FRM03 / NCPDP 383-4K)
response_date	date	Yes	No	Date response (from FRM04 / NCPDP 380-4G)
response_percent	numeric	Yes	No	Percent response (from FRM05 / NCPDP 379-4D)
line_item_form_id	bigint	No	Yes	Snowflake ID assigned to the line item form.
response_dollar_amount	numeric	Yes	No	Dollar amount response (from NCPDP 381-4H)
response_numeric	numeric	Yes	No	Numeric response (from NCPDP 382-4J)