line_item_form_response
Responses to a codified questionnaire
Primary Key: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) Generated through expression: |
response_yes_no | yes_no_response_type | Yes | No | Yes/No response (from FRM02) Generated through expression: |
response_text | text | No | No | Text response (from FRM03 / NCPDP 383-4K) Generated through expression: |
response_date | date | Yes | No | Date response (from FRM04 / NCPDP 380-4G) Generated through expression: |
response_percent | numeric | Yes | No | Percent response (from FRM05 / NCPDP 379-4D) Generated through expression: |
line_item_form_id | bigint | No | Yes | Snowflake ID assigned to the line item form. Generated through expression: |
response_dollar_amount | numeric | Yes | No | Dollar amount response (from NCPDP 381-4H) Generated through expression: |
response_numeric | numeric | Yes | No | Numeric response (from NCPDP 382-4J) Generated through expression: |