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