master data pegawai release 3

8/16/2019 Master Data Pegawai Release 3

1/31

Line_Type Employee ID Given Name Last Name Relation

EMP E000001 Anoman Sugria Employee

!AM E000001 Sinta Dei Spouse

!AM E000001 Raana Aleng"a #$il%

EMP E00000& Rama Praira Employee


2/31


3/31


4/31

Se' Date_o(_)irt$ Emp Type *ire Date En%+(#ontra,t

M M 1-.an-/ 1-Permanent 1-.an-0/ 1-De,-

! M 1-.an-1 01

M S 1-.an-10 0&

M S 1-!e2-/3 &-#ontra,t 1-.an-0 1-De,-14

MaritalStatus


5/31


6/31


7/31

Payroll_Group )ran,$ Salary_Type )ene5t_S,$m

#1 #100 1-Mont$ly 1-Mont$ly )EN1

#1 #100 1-Mont$ly 1-Mont$ly )EN1

Pay_!re6uen,y


8/31


9/31


10/31

PP$&1 Met$o% "o%e pt"p Pay Met$o%

GR+SS 781 TRANS!ER 1-Print Paper )an%ung

)an%ung

.a"arta

GR+SS T780 TRANS!ER 1-Print Paper .a"arta

Pay SlipMet$o%

Pla,e o()irt$

NationalID

/&11&010111&1

/311


11/31


12/31


13/31

P$one NP9P A,,ess_#ar%_ID .o2 Title

0&1-134:;/ 1&3&1 Manager

0&1-1114:;/ 1&3&& Sales Supervisor


14/31


15/31


16/31

.o2 Level Dept S! )an" Name

Manager !inan,e )an" )#A

Supervisor Sales )an" Man%iri


17/31


18/31


19/31

)an" )ran,$ or"_s$i(t

#a2 )an%ung 0.123.123344N+ 1

Pla


20/31


21/31


22/31

7eterangan 7olom>EMPL+=EE DATA ?Line_Type@EMP

Line_Type Data Pegaai %iisi %engan BEMPBC untu" %ata "eluarga %iisi %engan B!AMB

NI7 Nomor In%u" 7aryaan

A,,ess_#ar%_ID Nomor 7artu A2sensi

Nama Pegaai Nama Pegaai

Tgl La$ir Tgl La$ir ?%iisi %engan (ormat tanggal> 1-.an-&01&C &/-!e2-&01&C %st@Pla,e o( )irt$ Tempat La$ir

A%%ress Alamat Tempat Tinggal Pegaai

P$one No Telep$one

No 7TP No 7TP

NP9P Nomor NP9P Pegaai

Emp Type Diisi %engan 1-Peg Tetap&-#ontra,tC -#onsultantC -+t$er

Salary_Type Diisi %engan> 1-Mont$ly Rate untu" pa$ )ulanan atau & -Daily 9ages untu" pen

*ire Date Tanggal %iterima 7erFa ??%iisi %engan (ormat tanggal> 1-.an-&010C &/-!e2-&00/C %st@

.o2 Title Nama .a2atan

.o2 Level 7o%e .o2 Level ?Misal> STA!!C ENTR=C INTERMEDIATEC SPERIS+RC EHPERTC MANADept 7o%e Departemen

Pay_!re6uen,y !re6uen,y Pem2ayaran GaFi %alam satu 2ulan ?1)ulananC &Setiap & minggu 3

)an" Name Nama )an" %ari Re"ening Pegaai

)an" )ran,$ 7antor #a2ang )an" Re"ening Pegaai

)an" A%%ress Alamat )an" ters2ut

)an" A,,t Name Nama Re"ening Pegaai

)an" A,,t No Nomor Re"ening Pegaai

Gen%er %iisi %engan M atau ! ?MMale?La"i-la"i@ !!emale?Perempuan@@

Status 7ain Diisi %engan S atau M ?SSingle MMarrie%@

"o%e pt"p Diisi %engan T780C T781C T78&C 780C 781C %st@

$as_overtime Apa"a$ pegaai 2ole$ lem2ur ?Diisi %engan =es8No@

Pay Met$o% Diisi %engan TRANS!ER atau #AS*

En%+(#ontra,t Tanggal 7ontra" 2era"$ir ?%iisi untu" pegaai "ontra" saFa@

or"_s$i(t 7o%e S$i(t ?1C&C atau @

!AMIL= DATA ?Line_Type@!AM

1 No rut !amily Data %itentu"an ole$ sistem se,ara otomatis 2er%asar"an urutan %ata

& Nomor ID %ari !amily Data a%ala$ "om2inasi Employee ID %an Nomor rut !amily ?,o


23/31

rima pa$ *arian

@

ERC DIRE#T+RC %s2@

Mingguan@

(amily yang a%a %alam template ?no urut 01C 0&C %st@

to$ (amily ID> E000001_01C E000001_0&C %st@


24/31


25/31


26/31

Page &

101/3;

Line_Type Employee ID Given Name Last Name Relation Se' Emp Type *ir

EMP E000001 Anoman Sugria Employee M M 1-.an-/ 1-Permanent 1

!AM E000001 Sinta Dei Spouse ! M 1-.an-1 01

!AM E000001 Raana Aleng"a #$il% M S 1-.an-10 0&

EMP E00000& Rama Praira Employee M S 1-!e2-/3 &-#ontra,t 1

MaritalStatus

Date_o(_)irt$


27/31

Page &

101/3;


28/31

Page

101/3

Pla,e o( )irt$ National ID P$one NP9P .o2 Title .o2 Level Dep

1-Print Paper )an%ung 1&01011/&1 0&1-134:;/ 1&3&1 Manager Manager !inan,e

)an%ung 1&010111&1

.a"arta

1-Print Paper .a"arta 1&010&1/311 0&1-1114:;/ 1&3&& Supervisor Sales

Pay SlipMet$o%

A,,ess_#ar%_ID

Sales


29/31

Page &

101/3;


30/31

Mapping !iel% Name Ta2le

NI7 Employee ID Employee

A,,ess_#ar%_ID A,,ess_#ar%_ID Employee

Internal_emp_Num2er Internal_emp_Num2er Employee

Nama Pegaai Given Name Employee

Nama 7eluarga Last Name Employee

Nama Pegaai Employee_Name EmployeeDate o( )irt$ Date o( )irt$ Employee

Date_o(_)irt$ Date_o(_)irt$ Employee

%o2MM %o2MM Employee

Pla,e o( )irt$ Pla,e o( )irt$ Employee

A%%ress A%%ress Employee

P$one P$one Employee

E_mail A%%ress E_mail A%%ress Employee

National ID National ID Employee

Passport ID Passport ID Employee

*as NP9P *as NP9P EmployeeNP9P NP9P Employee

Emp Type Emp Type Employee

Salary_Type Salary_Type Employee

eJ_%ate eJ_%ate Employee

)ran,$ )ran,$ Employee

Lo,ation Lo,ation Employee

.o2_#o%e .o2_#o%e Employee

.o2 Title .o2 Title Employee

.o2 Level .o2 Level Employee

.o2_Type .o2_Type Employee

*ire Date *ire Date Employee

Resign Date Resign Date Employee

Report To Report To Employee

Report_to_Name Report_to_Name Employee

)usiness Group )usiness Group Employee

Dept Dept Employee

S! S! Employee

PL PL Employee

A,,t Pre5' A,,t Pre5' Employee

Pay Group Pay Group Employee

Pay )an% Pay )an% Employee

s"ema_Famsoste" s"ema_Famsoste" Employee

2asis_upa$_Famsoste" 2asis_upa$_Famsoste" Employee

E%u,ation E%u,ation Employee

S,ien,e S,ien,e Employee

Pay Slip Met$o% Pay Slip Met$o% Employee

Pay_!re6uen,y Pay_!re6uen,y Employee

Pay_Slip_template Pay_Slip_template Employee

)an" Name )an" Name Employee

)an" )ran,$ )an" )ran,$ Employee

)an" A%%ress )an" A%%ress Employee)an" A,,t Name )an" A,,t Name Employee

)an" A,,t No )an" A,,t No Employee

Emp Status Emp Status Employee

Se' Se' Employee

Marital Status Marital Status Employee

Nationality Nationality Employee

$as_overtime $as_overtime Employee

2ene5t_s,$m 2ene5t_s,$m Employee

e'tra_2ene5t_1 e'tra_2ene5t_1 Employee

Pengurus_%el Pengurus_%el EmployeeLast_payroll Last_payroll Employee

*as GL Pre5' *as GL Pre5' Employee


31/31

leave_%ays leave_%ays Employee

Pay Met$o% Pay Met$o% Employee

Sear,$ Name Sear,$ Name Employee

Last_p%ate Last_p%ate Employee

NT Login NT Login Employee

.o2_Des, .o2_Des, Employee

Emp_Group_' Emp_Group_' EmployeeP$one_e't P$one_e't Employee

Ta'_#al,_Group_%el Ta'_#al,_Group_%el Employee

In%e' In%e' Employee

En%+(#ontra,t En%+(#ontra,t Employee

En%+(#ontra,tLa2el En%+(#ontra,tLa2el Employee

%2Pass9or% %2Pass9or% Employee

*iring_re( *iring_re( Employee

$ierar,$y_in%e' $ierar,$y_in%e' Employee

Mar" Mar" Employee

Famsoste"_i% Famsoste"_i% Employee5rst_payroll 5rst_payroll Employee

pi, pi, Employee

+T_)ase_amount +T_)ase_amount Employee

Emp_De(_Ta'_Type Emp_De(_Ta'_Type Employee

pi,_name pi,_name Employee

vie_group vie_group Employee

or"_,alen%ar or"_,alen%ar Employee

or"_s$i(t or"_s$i(t Employee

s"ema_Fams s"ema_Fams Employee

religion religion Employee

sal_,urr sal_,urr Employee

mail_a%%ress mail_a%%ress Employee

payroll_group payroll_group Employee

,ost_,entre ,ost_,entre Employee

2an"_2s2_,o%e 2an"_2s2_,o%e Employee

time_stamp time_stamp Employee

5el%_1 5el%_1 Employee

5el%_& 5el%_& Employee

5el%_ 5el%_ Employee

employee_type employee_type Employee

"o%e pt"p "o%e pt"p Employee

(ull_2i

master data pegawai release 3

Documents