Configure PARTIAL_DATE Field Type
You can configure a field ID as PARTIAL_DATE field type. This field type displays the value "??-??-0000" in the control on UI. This field type allows the user to enter the partial date. A valid partial date must comprise either a year, or a year and a month.
To configure the new field ID as PARTIAL_DATE field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-26 Configurations for Field Type PARTIAL_DATE
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
18 |
PARTIAL_DATE |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
START_DATE |
Enter Key as column name configured in CMN_FIELDS.COLUMN_NAME. This is a mandatory column. |
VALUE |
START_DATE_RES |
Enter the column name as replacement of columns name configured in CMN_FIELDS.COLUMN_NAME if partial date is entered by the user. This is a mandatory column. |
Note:
PATIENT > Parent History > Stop Date is an existing field of PARTIAL_DATE type in CMN_FIELD_CONFIGURATION table.Parent topic: Configure CMN_FIELD_CONFIGURATION Table