Fidlll
Typ'
Lengt!J
KeteJ'tmgll:lll
'
SGw.rcc
Da
ltbase
Table
JF'idd
v
luc
DlAGNOSIS
KD(PK)
l>lAGNDSlS_
DESC
Char
VarChar
so
ID
unt.uk
diagnosis
Keterangan
diagn.os{s
Medicare
Medicare
M
!1fAGNOSiS
M_DIAGNOSIS
DiAGNOSIS
lD
D1AGN0SJS_
DESC
Transform
, Trarrsform
-
-
--
--
Al<1HR
Ill
17.
Mcladala label
DIAGNOSIS
Sumbcr; basis
data
opmasional no.
29
PK:
DIAGNOSIS
ID
FK:-
-
18.
Mctadata
label PROMOSl
Sumber: basis
data optmtsLonai no.15, 1
PK:PROMO
ID
FK: LDC
ID,
LBU m, T!Vff! ID
MULA!, TlME
ID
AKHJR
Field
'fype
PROMO_
lD!.PK)
LBU_
Chw
10
lD
unt.lk
promcst
ID Wll!.lk
GENERAL
MS'I
PROMOSI
PROMO
-
lD
ID{FK)
'
cab!!Ilg
MST_PROMOSl
LBUJD
Tmnsfonn
LDC_ID(FK)
Char
3
IDuntuk
Colieclion
MST
DET
SALES
LDC
D
Tnmsfonn
---
-·--
+
,
--
+=
c
ab ang
--}------t------i!-c:-c:-c-+---l
PROMO
VarCh
Keterll!lgrur
GENERAL
MST PROMOSI
:PROMO_
NOTE
ar
WOO
promDsi
-
NOTE
Transform
BTAYA
PROMO
Money
18
lli ya
prcmosi
Tanggal
GENERAL
MST
PROMOSI
BIAYA
PROMO
Tnmsfonn
TITvfE
m
MU.LAl(FK)
Int
4
m.ulu:i
pmrnos1
Tanggal
GENERAL
I
MST PROMOSI
TJME_ID_
MULA!
Transform
TIME
ID
AKHTR(FK)
Jnt
4
a.khir
promosi
I
GENERAL
MST PROMOSI
'CfME fD
Trausform
19.
Metadata !abel
SALES
Sumbcr :
basis data operasional no.l
PK
TllViE
ID, MCL
lD
 |