Configure PARENT_HISTORY Field Type
You can configure a field ID as PARENT_HISTORY field type, if the field is based on information about the patient's parent. This field type adds an additional condition as PARENT = 1 in the WHERE clause of final SQL query for the field. To configure the new field ID as PARENT_HISTORY field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-28 Configurations for Field Type PARENT_HISTORY
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
20 |
PARENT_HISTORY |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
NULL |
Enter Key as NULL. |
VALUE |
NULL |
Enter value as NULL. |
Note:
You can also refer to existing field PATIENT > Parent History > Relevant History Parent Information, (CMN_FIELDS.Field_ID - 205050009) of PARENT_HISTORY.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table