Appendix H Cornerstone Data and Index Dictionary

This Cornerstone Dictionary, which contains tables, fields and indexes utilized by the Cornerstone software, is useful when developing ad hoc reports with the Foxfire Report Writing Tool:ad hoc reports with the Foxfire Report Writing Tool:

CORNERSTONE DATA AND INDEX DICTIONARY

VERSION 11.40

Choose from the following: 

  1. A
  2. B
  3. C
  4. D
  5. E
  6. F
  7. G
  8. H
  9. I
  10. J
  11. L
  12. M
  13. O
  14. P
  15. R
  16. S
  17. T
  18. U
  19. V
  20. W
  21. Z

A

  • ACTIVITY - ACTIVITY (Shared)
  • ACTLPROC - ACTUAL PROCEDURE (Shared)
  • ACTLSERV - ACTUAL SERVICE (Shared)
  • ADDRESS - ADDRESS (Shared)
  • AGCYRATE - AGENCY RATE (Central Office only)
  • AGENCY - AGENCY (Central Office)
  • ALERT - ALERT COMMENTS (Shared)
  • APPNMNTS - APPOINTMENTS (Shared)
  • ARCTLRPT - ARCHIVE CONTROL REPORT TABLE (Clinic only)
  • ARLOGRPT - ARCHIVE LOG TABLE (Clinic only)
  • ARMSGRPT - ARCHIVE MESSAGE TABLE (Clinic only)
  • ARPRTRPT - ARCHIVE PARTICIPANT TABLE (Clinic only)
  • ARRSTRPT - ARCHIVE RESTORE REPORT (Clinic only)
  • ASSIGNFP - PARTICIPANT ASSIGNED FOOD PACKAGES (Shared)
  • ASSMCODE - ASSESSMENT CODE (Central Office)
  • ASSMGOAL - ASSESSMENT QUESTION TO GOAL (Central Office)
  • ASSMQTS - ASSESSMENT QUESTIONS (Central Office)
  • ASSMRISK - ASSESSMENT QUESTIONS TO RISK (Central Office)
  • ASSMRSLT - ASSESSMENT RESULTS (Shared)
  • AUDIT - AUDIT UPLOAD/DOWNLOAD COUNTS (Shared)
  • AUTHIFSP - AUTHORIZED IFSP TABLE (Shared)
  • AUTHTRAK - AUTH CORRECTIONS AND BACKDATING (Shared)

B

  • B505ERR - ERROR DATABASE FOR PROGRAM HSPB0505 (Central Office only)
  • B590AUTH - AUTHORIZATION FOR CBO INTERFACE (Central Office only)
  • B590CNTS - B590 COUNTS (Central Office only)
  • B590DATA - B590 DATA (Central Office only)
  • B590FEE - FEE HISTORY FOR CBO INTERFACE (Central Office only)
  • B590GRP - EI PARTICIPANT'S GROUP RELATIONSHIP (Central Office only)
  • B590INS - B590 INSURANCE (Central Office only)
  • B590PART - participant DEMOGRAPHIC FOR CBO INTERFACE (Central Office only)
  • B590RIN - EI PARTICIPANT'S RIN INFO FOR CBO (Central Office only)
  • B590TCM - CASE MANAGEMENT DATA FOR CBO INTERFACE (Central Office only)
  • BANKTRAN - BANK TRANSACTION (Central Office only)
  • BCCPROG - BREAST AND CERVICAL CANCER (Shared)
  • BIRTH - BIRTH (Shared)
  • BODMSG - BEGINNING OF DAY MESSAGES (Clinic only)
  • BPUMP - BREAST PUMP TABLE (Shared)

C

  • CASEASGN - CASE ASSIGNMENT (Shared)
  • CASENOTE - CASE NOTES (Clinic only)
  • CATGHIST - CATEGORY HISTORY (Shared)
  • CENTRLCT - CENTRAL OFFICE PROCESS CONTROL (Central Office only)
  • CHIZIPS - CHICAGO ZIP CODE FILE (Central Office only)
  • CHLDEILD - EI LEVELS OF DEVELOPMENT (Shared)
  • CHLDVSIT - INFANT/CHILD VISIT DATA (Shared)
  • CITIES - CITIES (Central Office only)
  • CLINADM - CLINIC ADMINISTRATIVE DATA (Clinic only)
  • CLINCONV - CLINIC CONVERSION (Central Office only)
  • CLINIC - CLINIC TABLE (Central Office)
  • CLINPARM - CLINIC RISK PARAMETER WIEGHTS (Central Office only)
  • CLINRISK - CLINIC RISK (Central Office only)
  • CLINVEND - CLINIC TO VENDOR REDEMPTION RELATIONSHIP (Central Office only)
  • CLMFILE - CLAIM IMPORT TABLE (Central Office only)
  • CMISOPEX - CMIS OPERATING EXPENSES (Central Office only)
  • CODETBL - CODE TABLE (Central Office)
  • COLRSCHM - EMPLOYEE COLOR SCHEME (Clinic only)
  • COUNTIES - HFS MEDICAID MATCH COUNTIES (Central Office only)
  • CURHFS - CURRENT HFS ASSIGNMENT FILE (Central Office only)

D

  • DCFSWARD - DCFS WARD INFORMATION (Shared)
  • DISTRICT - SCHOOL DISTRICT TABLE (Central Office)
  • DOWNLD - DOWNLOAD MESSAGE (Central Office)

E

  • ECSTRANS - ECORNERSTONE\CCORNERSTONE CONVERSION (Central Office only)
  • EIEDTRUL - EI EDIT RULES TABLE (Central Office)
  • EIPGM - EI PROGRAM TABLE (Shared)
  • EITRACK - EI EARLY CHILDHOOD TRACKING (Shared)
  • ELIGFILE - ELIGIBILITY IMPORT TABLE (Central Office only)
  • ELIGRULE - ELIGIBILITY PROGRAM RULES (Central Office)
  • EMPL - EMPLOYEE (Shared)
  • EMPLMSG - EMPLOYEE BOD MESSAGE (Clinic only)
  • EMPLPROG - EMPLOYEE PROGRAM (Shared)
  • EMPLSECR - EMPLOYEE SECURITY (Clinic only)
  • EMPLXREF - EMPLOYEE CROSS REFERENCE (Central Office only)
  • EODBODHS - EOD/BOD HISTORY (Shared)
  • EODBODMS - END OF DAY MESSAGES (Clinic only)
  • EPSDTVST - EPSDT VISIT TABLE (Central Office)

F

  • FAMFEE - FAMILY FEE SCHEDULE (Central Office)
  • FASDINTV - FASD INTERVENTION (Shared)
  • FEEHIST - FAMILY FEE HISTORY TABLE (Shared)
  • FILECNTL - CLINIC ACTIVE COUNT FILE CONTROL (Shared)
  • FIRANGE - FI RANGE (Clinic only)
  • FIREGNL - REGIONAL PRICES FOR FOOD INSTRUMENTS (Central Office)
  • FIREGNL2 - REGIONAL PRICES FOR FOOD INSTRUMENTS (Central Office)
  • FOODPKG - FOOD PACKAGE (Central Office)
  • FOODPKG2 - FOOD PACKAGE (Central Office)
  • FORMTYPE - FORM TYPE TABLE (Central Office)
  • FP25EROR - FP25ERROR (System table)

G

  • GENAGNCY - GENETICS LEAD AGENCY (Central Office only)
  • GENETICS - GENETICS (Shared)
  • GOALSERV - GOALS/SERVICES (Central Office)
  • GRPXREF - GROUP ID CROSS-REFERENCE (Shared)

H

  • HLTHVSIT - HEALTH VISIT DATA (Shared)
  • HOSPITAL - HOSPITAL (Central Office only)
  • HSEHLD - HOUSEHOLD MEMBERS (Clinic only)
  • HSPB0505 - DAILY HSPB0505 ACTIVITY REPORT (Central Office only)
  • HSPB0530 - DAILY HSPB0530 ACTIVITY REPORT (Central Office only)
  • HSPR0778 - HSPR0778 REPORT CONTENTS (Central Office)

I

  • IMMCOMBO - COMBINATION SHOTS TABLE (Central Office)
  • IMMGRPS - IMMUNIZATION GROUPS TABLE (Central Office)
  • IMMNASMT - IMMUNIZATION ASSESSMENT TABLE (Central Office)
  • IMMNINV - IMMUNIZATION INVENTORY (Shared)
  • IMMNLOG - IMMUNIZATION INVENTORY TRANSACTION TABLE (Shared)
  • IMMNRULE - IMMUNIZATION RULES (Central Office)
  • IMMNSNGL - SINGLE SHOTS TABLE (Central Office)
  • IMMUNE - IMMUNIZATION DATA (Shared)
  • IMPRTERR - PROVIDER IMPORT ERROR TABLE (Central Office only)
  • IMPRTRPT - PROVIDER IMPORT REPORT TABLE (Central Office only)

J

  • JTSCRSEC - JOB FUNCTION SCREEN SECURITY (Central Office)

L

  • LAPTOP - LAPTOP (Shared)
  • LEADAGNY - BCCP LEAD AGENCY TABLE (Central Office only)
  • LEADSCRN - LEAD SCREENING (Shared)
  • LOADRSLT - UPLOAD/DOWNLOAD RESULTS (Central Office only)
  • LOCATION - CLINIC LOCATION (Central Office)

M

  • MANGPSUP - MANG P SUPPLEMENTAL TABLE (Central Office)
  • MASTNDX1 - MASTER INDEX TABLE 1(BROWSE DATA) (Central Office)
  • MASTNDX2 - MASTER INDEX TABLE 2(ADDR & FLAGS) (Central Office)
  • MASTNDX3 - MASTER INDEX TABLE 3 (PART. PROGRAMS) (Central Office)
  • MASTRIN - MASTER RIN DETAIL (Central Office)
  • MEDEXTRT - MEDICAID/HFS EXTRACT (Central Office only)
  • MEDINSUR - MEDICARE/INSURANCE (Shared)

O

  • OBLERR - OBLIGATION ERRORS (Central Office only)
  • OBLEXTR - OBLIGATION EXTRACT (Central Office only)
  • OBLGATN - OBLIGATION (Shared)
  • OPEREXPN - OPERATING EXPENSES (Shared)

P

  • PARTACTV - TEEN PARENTS SERVICES ACTIVITIES (Shared)
  • PARTENRL - PARTICIPANT ENROLLMENT (Shared)
  • PARTFORM - PARTICIPANT FORMS TABLE (Clinic only)
  • PARTGOAL - PARTICIPANT GOALS (Shared)
  • PARTRISK - PARTICIPANT RISKS (Shared)
  • PARTRSK2 - PARTICPANT RISKS NON-WIC (Shared)
  • PARTSNDX - PARTICIPANT SOUNDEX (Clinic only)
  • PCCM - PRIMARY CARE CASE MANAGER (Central Office)
  • PERIOD - EPSDT PERIOD TABLE (Central Office)
  • PGMEDITS - PROGRAM EDITS (Central Office)
  • PLANSERV - PLANNED SERVICE (Shared)
  • POSTPART - POSTPARTUM DATA (Shared)
  • POTENDUP - POTENTIAL DUPLICATE TRACKING (Shared)
  • PRENATAL - INITIAL PRENTAL DATA (Shared)
  • PROCEDIT - PROCEDURE EDITS TABLE (Central Office)
  • PROCEDUR - PROCEDURE (Central Office)
  • PROCHIPA - HIPA PROCEDURE (Central Office)
  • PROCLOG - PROCESS LOG (Shared)
  • PROGRAM - PROGRAM INFORMATION (Shared)
  • PRORATE - FOOD PACKAGE PRORATE (Central Office)
  • PRORATE2 - FOOD PACKAGE PRORATE (Central Office)
  • PROVADDR - PROVIDER ADDRESS TABLE (Central Office)
  • PROVCOS - PROVIDER COUNTIES SERVED TABLE (Central Office)
  • PROVDTL - PROVIDER DETAIL TABLE (Central Office)
  • PROVIDER - PROVIDER (Central Office)
  • PROVSERV - PROVIDER SERVICES (Clinic only)
  • PRVHFS - PREVIOUS HFS ASSIGNMENT FILE (Central Office only)
  • PURGARCH - PURGE ARCHIVE (Central Office)

R

  • REFERRAL - REFERRALS (Shared)
  • REPORT - REPORT (Central Office)
  • RUNTIME - DAILY BATCH RUN TIMES (Central Office only)

S

  • SCHDEXCP - SCHEDULE EXCEPTIONS (Shared)
  • SCHDRSRC - SCHEDULE WITH RESOURCE (Clinic only)
  • SCHEDULE - SCHEDULE (Shared)
  • SCHLDIST - SCHOOL DISTRICT CODE TABLE (Central Office)
  • SCREEN - SCREEN (Central Office)
  • SECURITY - AUDIT SECURITY (Shared)
  • SERVCODE - SERVICE CODES (Central Office)
  • SERVERS - LAN SERVER INFORMATION (Central Office)
  • SERVPROC - VALID PROCEDURES FOR SERVICES TABLE (Central Office)
  • SERV_DTL - SERVER DETAIL (Clinic only)
  • SERV_HDR - SERVER HEADER (Clinic only)
  • STAFACTV - STAFF ACTIVITY (Shared)
  • STAFEXPN - CLINIC STAFF EXPENSES (Shared)
  • SYSTEMCL - HSMIS SYSTEM TABLE COLUMNS (Central Office)
  • SYSTEMIX - HSMIS SYSTEM TABLE INDEXES (Central Office)
  • SYSTEMTB - HSMIS SYSTEM TABLES (Central Office)
  • SYSXREF - SYSTEM CROSS-REFERENCE (Shared)

T

  • TRANPEND - TRANSFER PENDING (Central Office only)
  • TRANSLAT - EI TRANSLAT TABLE (Central Office)

U

  • UPDTIDS - UPDATE ID (Central Office only)

V

  • VENDRDMP - VENDOR REDEMPTION (Central Office only)
  • VFPRPT - VISUAL REPORT CONVERSION TABLE (Central Office)

W

  • WIC - WIC (Shared)
  • WICRISKS - WIC RISKS (Central Office)
  • WORDS1 - WORDS 1 (Clinic only)
  • WORDS2 - WORDS 2 (Clinic only)
  • WORDS3 - WORDS 3 (Clinic only)
  • WWFLLWUP - WISEW FOLLOW-UP (Shared)
  • WWOMEN - WISEWOMEN (Shared)

Z

  • ZIPS - HFS MEDICAID MATCH ZIP CODES (Central Office only)

Last updated: Wednesday, October 31, 2007 - 14:45:49