CVG_CCS_AUTH
Description:
Table to extract California Children's Services (CCS) authorization information.

Primary Key
Column Name Ordinal Position
CVG_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CVG_ID NUMERIC No
The unique ID assigned to the coverage record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2 LINE INTEGER No
The line number used to identify each row of California Children's Services (CCS) authorization information for a coverage record.
3 CCS_AUTH_NUM VARCHAR No
Stores the Authorization Numbers for California Children's Services (CCS).
4 CCS_EFF_FROM_DT DATETIME No
Stores the effective from date for a California Children's Services (CCS) Authorization Number.
5 CCS_EFF_TO_DT DATETIME No
Stores the effective to date for a California Children's Services (CCS) Authorization Number.
6 CCS_AUTH_PROV VARCHAR No
Stores the authorized provider for a given California Children's Services (CCS) Authorization Number.