*-------------------------------------------------------------------*;
* RX2011V2.TXT                                                      *;
*                                                                   *;
* SAS INPUT STATEMENTS FOR MAX 2011 RX FILE - ALL VARIABLES         *;
*                 AND BETA-MAX 2012 RX FILE - ALL VARIABLES         *;
*                                                                   *;
* NOTE: THE ICNO AND ICNA ARE NOT INCLUDED IN THIS FILE             *;
*                                                                   *;
* LRECL = 348                                                       *;
*                                                                   *;
* MODIFICATIONS:                                                    *;
* -------------                                                     *;
* 2009/02/17: JSYKES                                                *;
*  - RENAMED MDCR-COINSUR-PYMT-AMT TO FILLER                        *;
*  - RENAMED MDCR-DED-PYMT-AMT TO FILLER                            *;
* 2009/09/24: JSYKES                                                *;
* - RENAMED EL_MDCR_ANN_XOVR_99 TO EL_MDCR_DUAL_ANN                 *;
* 2009/12/04: JSYKES                                                *;
* FDB SOURCE FILES CHANGED DRAMATICALLY, CONSEQUENTLY               *;
* - REPLACED HICL-THRTPC-CTGRY WITH FILLER3                         *;
* - REPLACED THRTPC-CLASS-CD-SPCFC WITH HIC3 (NOT THE SAME DEFN)    *;
* - REPLACED AMER-HSPTL-FRMLRY-SYS-CD WITH FILLER4                  *;
* - REPLACED SMART-KEY WITH THESE FOUR VARS (NOT THE SAME DEFN):    *;
*   -- GCN-SEQNO                                                    *;
*   -- HICL-SEQNO                                                   *;
*   -- HIC3-SEQN                                                    *;
*   -- FILLER5                                                      *;
* - NO CHANGE TO THE RECORD LENGTH                                  *;
* 2011/01/18: JSYKES                                                *;
* - TYPE-CLM-CD IS NOW CHARACTER                                    *;
*-------------------------------------------------------------------*;
    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_DUAL_ANN             $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                  $CHAR01.
        @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   FILLER3                      $CHAR54.
        @299   HIC3                         $CHAR03.
        @302   THRTPC_CLASS_CD_GENERIC      $CHAR02.
        @304   FILLER4                      $CHAR06.
        @310   GCN_SEQNO                    $CHAR06.
        @316   HICL_SEQNO                   $CHAR06.
        @322   HIC3_SEQN                    $CHAR06.
        @328   FILLER5                      $CHAR06.
        @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_DUAL_ANN           = "Medicare dual 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"
 HIC3                       =
 "Hierarchical Specific Therapeutic Class Code"
 THRTPC_CLASS_CD_GENERIC    = "Therapeutic Class-Generic"
 GCN_SEQNO                  = "Clinical Formulation ID"
 HICL_SEQNO                 = "Ingredient List Identifier"
 HIC3_SEQN                  =
 "Hierarchical Specific Therapeutic Class Code Sequence Number"
 MEDISPAN_DRG_CTGRY         = "Medispan code"
 OVER_COUNTER_IND           = "Over-the-counter indicator"
 ;
