Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2012-02-17 : 09:33:32
|
| In my app, the user will enter the patient id and medicine needed (from Doctor). My code needs to check whether this patient's insurance will cover the medicine. This comes from a linkage of several tables: I just want the end result, enter patient id and see if the order is accepted. What sort of query will work here?OEN_FED_M_RXNORM maps GCN_SEQNO codes to the RXCUI code (nds master has the gcn_seqno code) GCN_SEQNO Numeric(6, 0) GCN_SEQNO Varchar(8)OEN_FED_M_PARTD_PLAN maps the plan to a formulary code (patient record has the plan code) CONTRACT_ID Char(5) PLAN_ID Char(3) SEGMENT_ID Char(3) MA_REGION_CODE Char(2) PDP_REGION_CODE Char(2) FORMULARY_ID Char(8) DC_DATE DATETIME CONTRACT_NAME VARCHAR(50) PLAN_NAME VARCHAR(100) PREMIUM NUMERIC (6,2) DEDUCTABLE NUMERIC (6,0) ICL NUMERIC (6,0) SMP CHAR(1) PLAN_SUPPRESSED_YN CHAR(1)OEN_FED_D_BASIC_FORMULARY combines the formulary code and RXCUI code to get the coverage. FORMULARY_ID CHAR(8) FORMULARY_VERSION NUMERIC(3,0) CONTRACT_YEAR CHAR(4) RXCUI CHAR(6) START_DATE DATETIME DC_DATE DATETIME PROXY_NDC CHAR(11) TIER_LEVEL_VALUE NUMERIC(2,0) QUANTITY_LIMIT_YN CHAR(1,0) QUANTITY_LIMIT_AMOUNT NUMERIC(8,4) QUANTITY_LIMIT_DAYS NUMERIC(6,0) |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
How to code a query to get patient coverage?