Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Please estimate the number of data elements in C-IV and CalWIN?

April 26, 2017c-iv calwin Data elements estimate

0

Posted

Please estimate the number of data elements in C-IV and CalWIN?

1 Answer

0

Posted

C-IV C-IV contains a total of 4,949 elements in 340 tables. Of the total number of data elements, the C-IV database includes 1,821 unduplicated data elements. These elements are shared across all programs. CalWIN CalWIN contains approximately 8810 unduplicated data elements. These data elements are shared across all programs if applicable. This number was based on analysis of the database and represents all columns in all CalWIN tables except the history tables, overhead columns, primary key and foreign key columns from each table. This is not the number of unduplicated fields in CalWIN, as some data elements are derived and stored in the database to be used by the functions of CalWIN and may not appear on any window.