113
Th'\lli_lD
(FK)
ILDC_JD
(FK)
4
, Char
3
UJuntuk
wsktu
lD nntnk
cliliru::g
MRU/
Marine/
Fire/
\
Medicare
MBU/
Marine/
Fire/
Mcdicn.re
I'lffiU/
MST_KLAlM/
TCLAIN'J
T_CLATM/
T_CLAIM
MST_SI'AK/
TS\''1-'A/
T_POUCUlS/
: T SPPL\
MST_SI'AK!
MKL
TGL
KLAIM!
REG-=-DATfij
REPORT_DATEI
REGTSTER_DATE
LOC_m/LDC_
lD/
LOC
ID/LDC
ID
LBU_ID/LBU_LD/
Transform
T
rllill!form
Char
2
IDunruk
hisni=it
Marine/
Fire!
Medicare
TSPPA/
T_FOLICIES/
T
SPPA
BUSIN"ESS_ID/
LBU ID
Transform
MCL_1D
(FK)
Cillrr
rn unrnk
[3
nassb h
hffiU/
Mlliil.le!
Fire/
MOOi.care
MST_SPAK!
TSPPN
T_?OLICES/
T_'SPPA
C\Jf'.NTJD/
CLlEN'I'_ID/
CLIENT_IDJ
MCL
ID
Tnmsfonn
MTL ill
(Fl()
Char
4
illuntuk
condition
!Marine
TCLAI:M
MTL ID
Tnmsforro
DIAGNOSIS
_ID(FK)
I
TOTAL_
ID
lll11.u.\.
5
dizgnosis
perryabt
Medicare
T CL\L\1
TCLAIM/
lDIAGNOS1S_JD
:MKL_TN_AKSEP/
T1<1nsform
19
Tol.al.premi
MEU/
Ma.rinc/
MST
KLAIM!
TOTAL_ACCEPT/
TOTAL
Tram:form j
T·
KLAIM:
Money
i_i'iref
T
CLA.::!IA!
ACCEPTED/
I
Medicare
I
T_C-LAL'Vl
'l'OT_ACCEPTED_
CLATIVf
21.
Mctadata !abel
RENEWAL
Swnbcr: basisdata opemsional no.
16,
20,
21,22
PK:
NO
POLIS
FK: LDC_ID,
LBU_ID,MCL_ID
Wield
Tyoe
Length
KcieU""dD:[ JUll
illln:e
Oatab.ilse
1f'ahie
Hiicld
Value
NO
POLlS
(PK)
lil.t
14
ID
polldmi
r:rurulmh
MBU/
Marine/
Fi.rd
'Mcili .owr.:
MST_KLAtWJ
TCLAIM!
T_CLJIJMJ
T_CLAlM
MKL_NO]Ol,lS/
NO POLlS/
POLJCY
"-JO/
POUCY_NO
TrlillSfurm
LDC_ID
Ch
MBU/
Marine/
F1;e/
MOOicare
MST SPAKJ
TS PA!
T
POLICIES/
,-CSPPA
LOC_ID/
LDC
ID/
LDC_lDi LDC_ID
Transform
'I
b=,.
 |