|
| Inorder to insert records into the Database from the updategram and the AIC
component should we stick to the schema which was provided? I am confused
because when I created a custom schema and an XML sample, it doesn't pass
through this component. The XML is validating with the schema correctly and
it shows no errors, but records are not geting inserted into the database.
Thanks for any help.
Below is what I am trying, my database table matches correctly and schema
validates correctly.
<ROOT>
<block>
<before />
<after>
<UEP_834_MEMBER
FILE_NBR="{C36E3FEB-8297-4DCE-BE94-B08B0DD4BD86}"
REC_NO="{C36E3FEB-8297-4DCE-BE94-B08B0DD4BD86}"
LAST_NAME="LN1"
FIRST_NAME="FN1"
MID_INIT="JM"
TITLE="Mr"
EMPLOY_ID="222222222"
HIRE_DT="5/20/2002"
RETIRE_DT="5/20/2042"
FAMILY_INDICATOR=""
TERM_DT="1/1/1900"
COVERED_MEMBER="3"
RECEIVED_DT="5/20/2003"
DOB="10/13/1983"
SSN="317605331"
GENDER="M"
MARITAL_STATUS="S"
HICN="304341948A"
MEDCD_NO=""
CONTRACT_CODE=""
COVG_TIER=""
PARTICIPANT_TYPE=""
OVERALL_ACTION_CODE="A"
ACTION_CODE_IND="A"
SUB_GROUP="0001"
NETWORK=""
TERM_CODE=""
RELATIONSHIP_CODE="S"
MDCR_PARTA_START_DT=""
MDCR_PARTA_END_DT=""
MDCR_PARTB_START_DT=""
MDCR_PARTB_END_DT=""
MDCR_PARTA_IND=""
MDCR_PARTB_IND=""
MDCR_COUNT=""
DISABILITY_IND="N"
DISABILITY_EFF_DT=""
DISABILITY_TERM_DT=""
DISABILITY_TYPE=""
STUDENT_IND="N"
STUDENT_EFF_DT=""
STUDENT_TERM_DT=""
STUDENT_SCHOOL="">
<UEP_834_COB
REC_NO="{C36E3FEB-8297-4DCE-BE94-B08B0DD4BD86}"
INSURANCE_TYPE=""
CARRIER_ID=""
POLICY=""
EFF_DT=""
TERM_DT=""
TERM_REASON=""
COB_IND="N">
</UEP_834_COB>
</UEP_834_MEMBER>
</after>
</block>
</ROOT>
|
|