Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

HTTPS

Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

LTCare Data Warehouse Frequently Asked Questions

Frequently Asked Questions

External partners can request access to their organization’s data through the ForwardHealth Partner Portal.

External Managed Care Organization users can obtain access to their organization’s data by contacting their local security administrator.

Department of Health Services employees can obtain access by completing a Security Access Request form (F-13644).

LDAP

The LTCare Data Warehouse has a weekly load schedule:

  • The Audit and Archive load process runs every Friday night.
  • The Data Mart Extract Transform and Load (ETL) process runs every Sunday night.
  • The CLTS Claims Extract load runs every Thursday night.

See our Data Warehouse Help page for help contacts by topic.

NR stands for not reported. In the data marts, any code field that was empty will have a value of NR, any one-character field like a Y/N field will have a value of U, any empty date field will have a value of 1/1/1500, a number field will be 0, and any empty long description field will have a value of Value Unknown / Not Reported.

We made a design decision to stay away from null or empty values because they will cause people trouble as they use the data. For example, if you were adding two COB amounts, such as Medicare COB plus Other Payer Primary COB, where Medicare COB amounts to $100 and Other Payer Primary COB equals null then the sum of the two amounts equals null ($100+null=null). To complicate matters, null and an empty string ('') are also two different results.  If you have a criteria where you want all blank values, you have to specifically ask for null values or empty strings or you won't get what you expect.

We wanted to avoid all that complicated confusion, so we defaulted empty strings and null values to NR or the equivalent.

You can use any of the universes available to you in Web Intelligence. The universes with a name that includes LTCare...Datamart Universe do enable combining data. In some cases, it may be reasonable and possible to combine LTCare data with data from other universes. In order to do this, you will need to know the data very well and have advanced skills in using Web Intelligence or get technical help.

Last revised June 16, 2022