*-------------------------------------------------------------------*;
* RX2006.TXT                                                        *;
*                                                                   *;
* SAS INPUT STATEMENTS FOR MAX 2006 RX FILE - ALL VARIABLES         *;
*                                                                   *;
* ALL VARIABLES ARE DEFINED USING LONG VARNAMES                     *;
*                                                                   *;
* MODIFICATIONS:                                                    *;
* -------------                                                     *;
* 2009/02/17: JSYKES                                                *;        
*  - RENAMED MDCR-COINSUR-PYMT-AMT TO FILLER                        *;           
*  - RENAMED MDCR-DED-PYMT-AMT TO FILLER                            *;           
*-------------------------------------------------------------------*;
    INPUT			
        @1     MSIS_ID                      $CHAR20.
        @21    STATE_CD                     $CHAR02.
        @23    EL_SSN                       $CHAR09.
        @32    MDCD_HIC_NUM                 $CHAR12.
        @44    EL_DOB                            08.
        @52    EL_SEX_CD                    $CHAR01.
        @53    EL_RACE_ETHNCY_CD            $CHAR01.
        @54    RACE_CODE_1                  $CHAR01.
        @55    RACE_CODE_2                  $CHAR01.
        @56    RACE_CODE_3                  $CHAR01.
        @57    RACE_CODE_4                  $CHAR01.
        @58    RACE_CODE_5                  $CHAR01.
        @59    ETHNICITY_CODE               $CHAR01.
        @60    EL_SS_ELGBLTY_CD_LTST        $CHAR06.
        @66    EL_SS_ELGBLTY_CD_MO          $CHAR06.
        @72    EL_MAX_ELGBLTY_CD_LTST       $CHAR02.
        @74    EL_MAX_ELGBLTY_CD_MO         $CHAR02.
        @76    MSNG_ELG_DATA                $CHAR01.
        @77    EL_MDCR_ANN_XOVR_99          $CHAR02.
        @79    MSIS_TOS                          02.
        @81    MSIS_TOP                          01.
        @82    MAX_TOS                           02.
        @84    PRVDR_ID_NMBR                $CHAR12.
        @96    NPI                          $CHAR12.
        @108   TAXONOMY                     $CHAR12.
        @120   TYPE_CLM_CD                       01.
        @121   ADJUST_CD                         01.
        @122   PHP_TYPE                          02.
        @124   PHP_ID                       $CHAR12.
        @136   MDCD_PYMT_AMT                   ZD08.
        @144   TP_PYMT_AMT                     ZD08.
        @152   PYMT_DT                           08.
        @160   CHRG_AMT                        ZD08.
        @168   PHP_VAL                         ZD08.
        @176   FILLER1                      $CHAR08.
        @184   FILLER2                      $CHAR08.
        @192   PRES_PHYSICIAN_ID_NUM        $CHAR12.
        @204   PRSC_WRTE_DT                      08.
        @212   PRSCRPTN_FILL_DT                  08.
        @220   NEW_REFILL_IND                    02.
        @222   NDC                          $CHAR12.
        @234   QTY_SRVC_UNITS                    05.
        @239   DAYS_SUPPLY                       03.
        @242   NDC_FORMT_IND                $CHAR01.
        @243   DRUG_CLASS_CD                $CHAR01.
        @244   MULTI_SRCE_CD                $CHAR01.
        @245   HICL_THRTPC_CTGRY            $CHAR54.
        @299   THRTPC_CLASS_CD_SPCFC        $CHAR03.
        @302   THRTPC_CLASS_CD_GENERIC      $CHAR02.
        @304   AMER_HSPTL_FRMLRY_SYS_CD     $CHAR06.
        @310   SMART_KEY                    $CHAR24.
        @334   MEDISPAN_DRG_CTGRY           $CHAR14.
        @348   OVER_COUNTER_IND             $CHAR01.
        ;

LABEL
 MSIS_ID                    = "MSIS identification number"
 STATE_CD                   = "State"
 EL_SSN                     = "Social Security Number (SSN)"
 MDCD_HIC_NUM               = "Medicare HIC number"
 EL_DOB                     = "Birth date"
 EL_SEX_CD                  = "Sex"
 EL_RACE_ETHNCY_CD          = "Race/ethnicity (from MSIS)"
 RACE_CODE_1                = "Race - White (from MSIS)"
 RACE_CODE_2                = "Race - Black (from MSIS)"
 RACE_CODE_3                = "Race - Am Indian/Alaskan (from MSIS)"
 RACE_CODE_4                = "Race - Asian (from MSIS)"
 RACE_CODE_5                = "Race - Hawaiian/Pac) Islands (from MSIS)"
 ETHNICITY_CODE             = "Ethnicity - Hispanic (from MSIS)"
 EL_SS_ELGBLTY_CD_LTST      = "State specific eligiblity - most recent"
 EL_SS_ELGBLTY_CD_MO        = "State specific eligiblity - mo of svc"
 EL_MAX_ELGBLTY_CD_LTST     = "MAX eligibility - most recent"
 EL_MAX_ELGBLTY_CD_MO       = "MAX eligibility - mo of svc"
 MSNG_ELG_DATA              = "Missing eligibility data"
 EL_MDCR_ANN_XOVR_99        = "Crossover code (Annual)"
 MSIS_TOS                   = "MSIS Type of Service (TOS)"
 MSIS_TOP                   = "MSIS Type of Program (TOP)"
 MAX_TOS                    = "MAX Type of Service (TOS)"
 PRVDR_ID_NMBR              = "Billing provider identification number"
 NPI                        = "National Provider Identifier"
 TAXONOMY                   = "Provider Taxonomy"
 TYPE_CLM_CD                = "Type of claim"
 ADJUST_CD                  = "Adjustment code"
 PHP_TYPE                   = "Managed care type of plan code"
 PHP_ID                     = "Managed care plan identification code"
 MDCD_PYMT_AMT              = "Medicaid payment amount"
 TP_PYMT_AMT                = "Third party payment amount"
 PYMT_DT                    = "Payment/adjudication date"
 CHRG_AMT                   = "Charge amount"
 PHP_VAL                    = "Prepaid plan value"
 PRES_PHYSICIAN_ID_NUM      = "Prescribing physician id number"
 PRSC_WRTE_DT               = "Prescribed date"
 PRSCRPTN_FILL_DT           = "Prescription fill date"
 NEW_REFILL_IND             = "New or refill indicator"
 NDC                        = "National Drug Code (NDC)"
 QTY_SRVC_UNITS             = "Quantity of service"
 DAYS_SUPPLY                = "Days supply"
 NDC_FORMT_IND              = "NDC Format"
 DRUG_CLASS_CD              = "Drug Class"
 MULTI_SRCE_CD              = "Multi Source Code"
 HICL_THRTPC_CTGRY          = "HICL"
 THRTPC_CLASS_CD_SPCFC      = "Therapeutic Class-Specific"
 THRTPC_CLASS_CD_GENERIC    = "Therapeutic Class-Generic"
 AMER_HSPTL_FRMLRY_SYS_CD   = "American Hospital Formulary code"
 SMART_KEY                  = "Smart Key"
 MEDISPAN_DRG_CTGRY         = "Medispan code"
 OVER_COUNTER_IND           = "Over-the-counter indicator"
 ;
