CASE_RATE
Description:
This table contains information about case rate and dental treatment plan.

Primary Key
Column Name Ordinal Position
CASE_RATE_ID 1

Column Information
Name Type Discontinued?
1 CASE_RATE_ID VARCHAR No
The unique identifier for a case rate record.
2 ACTIVE_YN VARCHAR No
Indicates whether the case is active. Y indicates the case is active. There will be no null value for this column.
May contain organization-specific values: No
Category Entries:
No
Yes
3 CASE_RATE_TYPE_C_NAME VARCHAR No
The category value representing the type of transplant for the case rate.
May contain organization-specific values: Yes
4 ACCOUNT_ID NUMERIC No
The guarantor account ID associated with this case rate.
5 FROM_SVC_DATE DATETIME No
The first service date in the inclusion period for the case rate procedures.
6 T0_SVC_DATE DATETIME No
The last service date in the inclusion period for the case rate procedures.
7 BATCH_PRC_FLAG_C_NAME VARCHAR No
A flag that indicates the charging status of the case rate record. This flag can be set to indicate that the holding period is complete, the inclusion period is complete, or neither is complete.
May contain organization-specific values: No
Category Entries:
Finish Hold Period
Finish Inclusion Period