Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25">
<Class name="CREPOS.CLAIM">
<Description>
Generated by the Link Table wizard on 2018-10-18 12:33:55. Note that you can access the data in this class only when the external database is accessible.</Description>
<ProcedureBlock>0</ProcedureBlock>
<SqlRowIdPrivate>1</SqlRowIdPrivate>
<SqlTableName>CLAIM</SqlTableName>
<Super>%Library.Persistent,%XML.Adaptor,CREPOS.DBCONFIG</Super>
<TimeCreated>64939,45234.615641</TimeCreated>

<Property name="BILLINGHRCHLLEVELKEY">
<Type>%String</Type>
<SqlColumnNumber>40</SqlColumnNumber>
<SqlFieldName>BILLING_HRCHL_LEVEL_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="BILLING_HRCHL_LEVEL_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="CLAIMKEY">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>2</SqlColumnNumber>
<SqlFieldName>CLAIM_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="CLAIMTYPE">
<Type>%String</Type>
<SqlColumnNumber>34</SqlColumnNumber>
<SqlFieldName>CLAIM_TYPE</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_TYPE"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="12"/>
</Property>

<Property name="CLM01PTACCTNBR">
<Type>%String</Type>
<SqlColumnNumber>13</SqlColumnNumber>
<SqlFieldName>CLM01PT_ACCT_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM01PT_ACCT_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="38"/>
</Property>

<Property name="CLM02CLMCHRGAMT">
<Type>%Numeric</Type>
<SqlColumnNumber>14</SqlColumnNumber>
<SqlFieldName>CLM02CLM_CHRG_AMT</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM02CLM_CHRG_AMT"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9999999999999999.99"/>
<Parameter name="MINVAL" value="-9999999999999999.99"/>
<Parameter name="SCALE" value="2"/>
</Property>

<Property name="CLM05CLMFRQCD">
<Type>%String</Type>
<SqlColumnNumber>17</SqlColumnNumber>
<SqlFieldName>CLM05CLM_FRQ_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM05CLM_FRQ_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM05FCLYCDQUAL">
<Type>%String</Type>
<SqlColumnNumber>16</SqlColumnNumber>
<SqlFieldName>CLM05FCLY_CD_QUAL</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM05FCLY_CD_QUAL"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="CLM05FCLYTYPECD">
<Type>%String</Type>
<SqlColumnNumber>15</SqlColumnNumber>
<SqlFieldName>CLM05FCLY_TYPE_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM05FCLY_TYPE_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="CLM06PRVDSGNIND">
<Type>%String</Type>
<SqlColumnNumber>18</SqlColumnNumber>
<SqlFieldName>CLM06PRVD_SGN_IND</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM06PRVD_SGN_IND"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM07MDCRASGNCD">
<Type>%String</Type>
<SqlColumnNumber>19</SqlColumnNumber>
<SqlFieldName>CLM07MDCR_ASGN_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM07MDCR_ASGN_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM08ASGNOFBNFT">
<Type>%String</Type>
<SqlColumnNumber>20</SqlColumnNumber>
<SqlFieldName>CLM08ASGN_OF_BNFT</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM08ASGN_OF_BNFT"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM09RELINFOCD">
<Type>%String</Type>
<SqlColumnNumber>21</SqlColumnNumber>
<SqlFieldName>CLM09REL_INFO_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM09REL_INFO_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM10PATSIGNCD">
<Type>%String</Type>
<SqlColumnNumber>22</SqlColumnNumber>
<SqlFieldName>CLM10PAT_SIGN_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM10PAT_SIGN_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM11CTRYCD">
<Type>%String</Type>
<SqlColumnNumber>27</SqlColumnNumber>
<SqlFieldName>CLM11CTRY_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM11CTRY_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="3"/>
</Property>

<Property name="CLM11RLTCAUSES1">
<Type>%String</Type>
<SqlColumnNumber>23</SqlColumnNumber>
<SqlFieldName>CLM11RLT_CAUSES1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM11RLT_CAUSES1"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="3"/>
</Property>

<Property name="CLM11RLTCAUSES2">
<Type>%String</Type>
<SqlColumnNumber>24</SqlColumnNumber>
<SqlFieldName>CLM11RLT_CAUSES2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM11RLT_CAUSES2"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="3"/>
</Property>

<Property name="CLM11RLTCAUSES3">
<Type>%String</Type>
<SqlColumnNumber>25</SqlColumnNumber>
<SqlFieldName>CLM11RLT_CAUSES3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM11RLT_CAUSES3"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="3"/>
</Property>

<Property name="CLM11ST">
<Type>%String</Type>
<SqlColumnNumber>26</SqlColumnNumber>
<SqlFieldName>CLM11ST</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM11ST"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="CLM12SPCLPGMCD">
<Type>%String</Type>
<SqlColumnNumber>28</SqlColumnNumber>
<SqlFieldName>CLM12SPCL_PGM_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM12SPCL_PGM_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="3"/>
</Property>

<Property name="CLM16PRVAGMENTCD">
<Type>%String</Type>
<SqlColumnNumber>29</SqlColumnNumber>
<SqlFieldName>CLM16PRV_AGMENT_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM16PRV_AGMENT_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM18EXPLOFBNFT">
<Type>%String</Type>
<SqlColumnNumber>30</SqlColumnNumber>
<SqlFieldName>CLM18EXPL_OF_BNFT</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM18EXPL_OF_BNFT"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="CLM19PREDTERBNFT">
<Type>%String</Type>
<SqlColumnNumber>31</SqlColumnNumber>
<SqlFieldName>CLM19PREDTER_BNFT</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM19PREDTER_BNFT"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="CLM20DELAYRSNCD">
<Type>%String</Type>
<SqlColumnNumber>32</SqlColumnNumber>
<SqlFieldName>CLM20DELAY_RSN_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLM20DELAY_RSN_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="CREATEDBY">
<Type>%String</Type>
<SqlColumnNumber>36</SqlColumnNumber>
<SqlFieldName>CREATED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CREATED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>

<Property name="DATECREATED">
<Type>%Date</Type>
<SqlColumnNumber>37</SqlColumnNumber>
<SqlFieldName>DATE_CREATED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_CREATED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>

<Property name="DATEMODIFIED">
<Type>%Date</Type>
<SqlColumnNumber>39</SqlColumnNumber>
<SqlFieldName>DATE_MODIFIED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_MODIFIED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>

<Property name="FILENUMBER">
<Type>%String</Type>
<SqlColumnNumber>3</SqlColumnNumber>
<SqlFieldName>FILE_NUMBER</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="FILE_NUMBER"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="MODIFIEDBY">
<Type>%String</Type>
<SqlColumnNumber>38</SqlColumnNumber>
<SqlFieldName>MODIFIED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="MODIFIED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>

<Property name="NM109BILLPRVDID">
<Type>%String</Type>
<SqlColumnNumber>7</SqlColumnNumber>
<SqlFieldName>NM109BILL_PRVD_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="NM109BILL_PRVD_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="NM109PAYPRVDID">
<Type>%String</Type>
<SqlColumnNumber>8</SqlColumnNumber>
<SqlFieldName>NM109PAY_PRVD_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="NM109PAY_PRVD_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="PATIENTHRCHLLEVELKEY">
<Type>%String</Type>
<SqlColumnNumber>42</SqlColumnNumber>
<SqlFieldName>PATIENT_HRCHL_LEVEL_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PATIENT_HRCHL_LEVEL_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="PATIENTID">
<Type>%String</Type>
<SqlColumnNumber>12</SqlColumnNumber>
<SqlFieldName>PATIENT_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PATIENT_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="PATIENTINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>5</SqlColumnNumber>
<SqlFieldName>PATIENT_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PATIENT_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="RECEIVERID">
<Type>%String</Type>
<SqlColumnNumber>10</SqlColumnNumber>
<SqlFieldName>RECEIVER_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="RECEIVER_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="SENDERID">
<Type>%String</Type>
<SqlColumnNumber>9</SqlColumnNumber>
<SqlFieldName>SENDER_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SENDER_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="ST02TXNCTLNBR">
<Type>%String</Type>
<SqlColumnNumber>4</SqlColumnNumber>
<SqlFieldName>ST02TXN_CTL_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="ST02TXN_CTL_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="9"/>
</Property>

<Property name="STATUSCODE">
<Type>%String</Type>
<SqlColumnNumber>35</SqlColumnNumber>
<SqlFieldName>STATUS_CODE</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="STATUS_CODE"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="25"/>
</Property>

<Property name="SUBMISSIONINDEX">
<Type>%String</Type>
<SqlColumnNumber>33</SqlColumnNumber>
<SqlFieldName>SUBMISSION_INDEX</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SUBMISSION_INDEX"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="SUBSCRIBERHRCHLLEVELKEY">
<Type>%String</Type>
<SqlColumnNumber>41</SqlColumnNumber>
<SqlFieldName>SUBSCRIBER_HRCHL_LEVEL_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SUBSCRIBER_HRCHL_LEVEL_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="SUBSCRIBERID">
<Type>%String</Type>
<SqlColumnNumber>11</SqlColumnNumber>
<SqlFieldName>SUBSCRIBER_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SUBSCRIBER_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="SUBSCRIBERINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>6</SqlColumnNumber>
<SqlFieldName>SUBSCRIBER_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SUBSCRIBER_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Index name="MainIndex">
<IdKey>1</IdKey>
<PrimaryKey>1</PrimaryKey>
<Properties>CLAIMKEY</Properties>
</Index>

<Storage name="Default">
<Type>%Library.CacheStorage</Type>
<DataLocation>^CREPOS.CLAIMD</DataLocation>
<DefaultData>CLAIMDefaultData</DefaultData>
<IdLocation>^CREPOS.CLAIMD</IdLocation>
<IndexLocation>^CREPOS.CLAIMI</IndexLocation>
<StreamLocation>^CREPOS.CLAIMS</StreamLocation>
<Data name="CLAIMDefaultData">
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>BILLINGHRCHLLEVELKEY</Value>
</Value>
<Value name="3">
<Value>CLAIMTYPE</Value>
</Value>
<Value name="4">
<Value>CLM01PTACCTNBR</Value>
</Value>
<Value name="5">
<Value>CLM02CLMCHRGAMT</Value>
</Value>
<Value name="6">
<Value>CLM05CLMFRQCD</Value>
</Value>
<Value name="7">
<Value>CLM05FCLYCDQUAL</Value>
</Value>
<Value name="8">
<Value>CLM05FCLYTYPECD</Value>
</Value>
<Value name="9">
<Value>CLM06PRVDSGNIND</Value>
</Value>
<Value name="10">
<Value>CLM07MDCRASGNCD</Value>
</Value>
<Value name="11">
<Value>CLM08ASGNOFBNFT</Value>
</Value>
<Value name="12">
<Value>CLM09RELINFOCD</Value>
</Value>
<Value name="13">
<Value>CLM10PATSIGNCD</Value>
</Value>
<Value name="14">
<Value>CLM11CTRYCD</Value>
</Value>
<Value name="15">
<Value>CLM11RLTCAUSES1</Value>
</Value>
<Value name="16">
<Value>CLM11RLTCAUSES2</Value>
</Value>
<Value name="17">
<Value>CLM11RLTCAUSES3</Value>
</Value>
<Value name="18">
<Value>CLM11ST</Value>
</Value>
<Value name="19">
<Value>CLM12SPCLPGMCD</Value>
</Value>
<Value name="20">
<Value>CLM16PRVAGMENTCD</Value>
</Value>
<Value name="21">
<Value>CLM18EXPLOFBNFT</Value>
</Value>
<Value name="22">
<Value>CLM19PREDTERBNFT</Value>
</Value>
<Value name="23">
<Value>CLM20DELAYRSNCD</Value>
</Value>
<Value name="24">
<Value>CREATEDBY</Value>
</Value>
<Value name="25">
<Value>DATECREATED</Value>
</Value>
<Value name="26">
<Value>DATEMODIFIED</Value>
</Value>
<Value name="27">
<Value>FILENUMBER</Value>
</Value>
<Value name="28">
<Value>MODIFIEDBY</Value>
</Value>
<Value name="29">
<Value>NM109BILLPRVDID</Value>
</Value>
<Value name="30">
<Value>NM109PAYPRVDID</Value>
</Value>
<Value name="31">
<Value>PATIENTHRCHLLEVELKEY</Value>
</Value>
<Value name="32">
<Value>PATIENTID</Value>
</Value>
<Value name="33">
<Value>PATIENTINFOKEY</Value>
</Value>
<Value name="34">
<Value>RECEIVERID</Value>
</Value>
<Value name="35">
<Value>SENDERID</Value>
</Value>
<Value name="36">
<Value>ST02TXNCTLNBR</Value>
</Value>
<Value name="37">
<Value>STATUSCODE</Value>
</Value>
<Value name="38">
<Value>SUBMISSIONINDEX</Value>
</Value>
<Value name="39">
<Value>SUBSCRIBERHRCHLLEVELKEY</Value>
</Value>
<Value name="40">
<Value>SUBSCRIBERID</Value>
</Value>
<Value name="41">
<Value>SUBSCRIBERINFOKEY</Value>
</Value>
</Data>
</Storage>
</Class>
</Export>