{"id":5460,"date":"2021-06-25T16:55:43","date_gmt":"2021-06-25T09:55:43","guid":{"rendered":"http:\/\/helpamiscb.misa.local\/?post_type=ht_kb&p=5460"},"modified":"2026-06-08T15:08:47","modified_gmt":"2026-06-08T08:08:47","slug":"quan-ly-khoan-muc-luong","status":"publish","type":"ht_kb","link":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/quan-ly-khoan-muc-luong\/","title":{"rendered":"Qu\u1ea3n l\u00fd Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng"},"content":{"rendered":"

\n

<\/span><\/p>\n

1. T\u1ed5ng quan<\/b><\/h3>\n
<\/div>
\nM\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn HR c\u00e1ch qu\u1ea3n l\u00fd th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m AMIS Nh\u00e2n s\u1ef1 \u0111\u1ec3 ph\u1ee5c v\u1ee5 x\u00e2y d\u1ef1ng m\u1eabu b\u1ea3ng l\u01b0\u01a1ng v\u00e0 t\u00ednh l\u01b0\u01a1ng.
\nN\u1ed9i dung:<\/b>
\n– Qu\u1ea3n l\u00fd danh m\u1ee5c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng
\n– Th\u00eam m\u1edbi, nh\u00e2n b\u1ea3n, s\u1eeda, x\u00f3a, chuy\u1ec3n tr\u1ea1ng th\u00e1i th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng
\n– C\u00e1c th\u00f4ng tin c\u1ea7n l\u01b0u \u00fd: t\u00ednh ch\u1ea5t, lo\u1ea1i th\u00e0nh ph\u1ea7n, \u0111\u1ecbnh m\u1ee9c, gi\u00e1 tr\u1ecb th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng
\nPh\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> HR, Qu\u1ea3n tr\u1ecb nh\u00e2n s\u1ef1<\/p>\n<\/div><\/div>\n<\/div>\n
\n
<\/span><\/p>\n
2. H\u01b0\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n<\/b><\/h3>\n
<\/div>
\n\n\n\n
<\/div><\/div>\n
<\/span><\/p>\n
2.1 Qu\u1ea3n l\u00fd danh m\u1ee5c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/b><\/h4>\n
<\/div>
\nCh\u01b0\u01a1ng tr\u00ecnh \u0111\u00e3 t\u1ea1o s\u1eb5n c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng b\u1eaft bu\u1ed9c c\u1ea7n hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3ng l\u01b0\u01a1ng, bao g\u1ed3m: T\u1ed5ng thu nh\u1eadp, T\u1ed5ng kh\u1ea5u tr\u1eeb, L\u01b0\u01a1ng k\u1ef3 n\u00e0y, T\u1ea1m \u1ee9ng, Th\u1ef1c l\u0129nh.<\/p>\n
Ngo\u00e0i ra, t\u1ea1i Danh m\u1ee5c c\u1ee7a h\u1ec7 th\u1ed1ng c\u0169ng cung c\u1ea5p s\u1eb5n h\u00e0ng lo\u1ea1t c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng ph\u1ed5 bi\u1ebfn m\u00e0 h\u1ea7u h\u1ebft doanh nghi\u1ec7p n\u00e0o c\u0169ng c\u1ea7n s\u1eed d\u1ee5ng. V\u00ed d\u1ee5 nh\u01b0: L\u01b0\u01a1ng c\u01a1 b\u1ea3n, L\u01b0\u01a1ng \u0111\u00f3ng BH, Thu\u1ebf TNCN, BHXH, BHYT, BHTN,… \u0111\u1ec3 HR c\u00f3 th\u1ec3 \u0111\u01b0a v\u00e0o d\u00f9ng lu\u00f4n m\u00e0 kh\u00f4ng c\u1ea7n m\u1ea5t c\u00f4ng t\u1ef1 khai b\u00e1o.<\/p>\n
B\u01b0\u1edbc 1:<\/strong>\u00a0Truy c\u1eadp ph\u00e2n h\u1ec7\u00a0Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong> tr\u00ean AMIS Ti\u1ec1n l\u01b0\u01a1ng.<\/strong><\/p>\n
B\u01b0\u1edbc 2:<\/strong>\u00a0Xem danh m\u1ee5c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng h\u1ec7 th\u1ed1ng cung c\u1ea5p s\u1eb5n (L\u01b0\u01a1ng c\u01a1 b\u1ea3n, L\u01b0\u01a1ng \u0111\u00f3ng BH, Thu\u1ebf TNCN, BHXH, BHYT, BHTN\u2026).<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0\u0110\u01b0a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng v\u00e0o danh s\u00e1ch s\u1eed d\u1ee5ng theo\u00a02 c\u00e1ch<\/strong>:<\/p>\n
\n
\n
\n
C\u00e1ch 1 \u2013 Chuy\u1ec3n l\u1ea7n l\u01b0\u1ee3t: <\/strong>Di chu\u1ed9t \u0111\u1ebfn th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u1ea7n chuy\u1ec3n, click v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng +<\/span> \\\u0110\u1ed3ng \u00fd.<\/strong><\/li>\n
C\u00e1ch 2 \u2013 Chuy\u1ec3n h\u00e0ng lo\u1ea1t:<\/strong> T\u00edch ch\u1ecdn c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u1ea7n chuy\u1ec3n, sao \u0111\u00f3 nh\u1ea5n “\u0110\u01b0a v\u00e0o danh s\u00e1ch s\u1eed d\u1ee5ng”.<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
Ngo\u00e0i ra, \u0111\u1ec3 xem – t\u00ecm ki\u1ebfm nhanh th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng theo c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3, HR c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ti\u1ec7n \u00edch:<\/p>\n
\n
T\u00ecm ki\u1ebfm theo m\u00e3 th\u00e0nh ph\u1ea7n, t\u00ean th\u00e0nh ph\u1ea7n, lo\u1ea1i th\u00e0nh ph\u1ea7n, t\u00ednh ch\u1ea5t.<\/li>\n
Xem theo tr\u1ea1ng th\u00e1i, c\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c (tr\u00ean danh m\u1ee5c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng doanh nghi\u1ec7p \u0111ang s\u1eed d\u1ee5ng).<\/li>\n
S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc<\/li>\n
T\u00f9y ch\u1ec9nh hi\u1ec3n th\u1ecb c\u1ed9t<\/li>\n<\/ul>\n<\/div><\/div>\n
<\/span><\/p>\n
2.2 Th\u00eam m\u1edbi th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/b><\/h4>\n
<\/div>
\nTr\u01b0\u1eddng h\u1ee3p doanh nghi\u1ec7p s\u1eed d\u1ee5ng c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng kh\u00e1c ch\u01b0a c\u00f3 tr\u00ean danh s\u00e1ch, HR ti\u1ebfn h\u00e0nh th\u00eam m\u1edbi th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng b\u1eb1ng 2 c\u00e1ch:<\/p>\n
C\u00e1ch 1: Ch\u1ecdn t\u1eeb danh m\u1ee5c h\u1ec7 th\u1ed1ng<\/strong>\u00a0gi\u00fap HR s\u1eed d\u1ee5ng ngay c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e3 cung c\u1ea5p s\u1eb5n, kh\u00f4ng c\u1ea7n m\u1ea5t th\u1eddi gian khai b\u00e1o.<\/p>\n
B\u01b0\u1edbc 1:<\/strong>\u00a0V\u00e0o ph\u00e2n h\u1ec7\u00a0Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong>.<\/p>\n
B\u01b0\u1edbc 2:<\/strong>\u00a0M\u1edf danh m\u1ee5c h\u1ec7 th\u1ed1ng, ch\u1ecdn th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u00e3 c\u00f3 s\u1eb5n \u0111\u1ec3 s\u1eed d\u1ee5ng ngay.<\/p>\n
$\"\"$ <\/p>\n
C\u00e1ch 2:<\/strong> Th\u00eam m\u1edbi tr\u00ean ph\u00e2n h\u1ec7 Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng.<\/strong><\/p>\n
B\u01b0\u1edbc 1:<\/strong>\u00a0V\u00e0o ph\u00e2n h\u1ec7\u00a0Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong>\u00a0\u2192 nh\u1ea5n\u00a0Th\u00eam m\u1edbi<\/strong>.<\/p>\n
B\u01b0\u1edbc 2:<\/strong>\u00a0Khai b\u00e1o c\u00e1c th\u00f4ng tin:\u00a0M\u00e3, T\u00ean, T\u00ednh ch\u1ea5t, Lo\u1ea1i th\u00e0nh ph\u1ea7n, \u0110\u1ecbnh m\u1ee9c, Gi\u00e1 tr\u1ecb<\/strong>.<\/p>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0N\u1ebfu doanh nghi\u1ec7p cho ph\u00e9p\u00a0v\u01b0\u1ee3t \u0111\u1ecbnh m\u1ee9c<\/strong>, t\u00edch ch\u1ecdn ngay tr\u00ean giao di\u1ec7n khai b\u00e1o.<\/p>\n
B\u01b0\u1edbc 4:<\/strong>\u00a0T\u1ea1i m\u1ee5c\u00a0\u0110\u1ecbnh m\u1ee9c<\/strong>, c\u00f3 th\u1ec3 \u0111i\u1ec1n\u00a0\u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong>\u00a0ho\u1eb7c\u00a0c\u00f4ng th\u1ee9c<\/strong>.<\/p>\n
B\u01b0\u1edbc 5:<\/strong>\u00a0Nh\u1ea5n\u00a0L\u01b0u<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n
$\"\"$ <\/p>\n
Tr\u01b0\u1eddng h\u1ee3p doanh nghi\u1ec7p c\u00f3 quy \u0111\u1ecbnh th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng t\u00ednh ra \u0111\u01b0\u1ee3c ph\u00e9p v\u01b0\u1ee3t \u0111\u1ecbnh m\u1ee9c, HR c\u00f3 th\u1ec3 t\u00edch ch\u1ecdn ngay tr\u00ean giao di\u1ec7n khai b\u00e1o. T\u1ea1i m\u1ee5c \u0111\u1ecbnh m\u1ee9c, HR c\u00f3 th\u1ec3 \u0111i\u1ec1n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c c\u00f4ng th\u1ee9c.<\/p>\n
$\"\"$ <\/p>\n<\/div><\/div>\n
<\/span><\/p>\n
2.3 Nh\u00e2n b\u1ea3n\/s\u1eeda\/x\u00f3a\/chuy\u1ec3n tr\u1ea1ng th\u00e1i th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/b><\/h4>\n
<\/div>
\n
B\u01b0\u1edbc 1:<\/strong>\u00a0Truy c\u1eadp ph\u00e2n h\u1ec7\u00a0Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong>.<\/p>\n
B\u01b0\u1edbc 2:<\/strong>\u00a0Di chu\u1ed9t \u0111\u1ebfn\u00a0th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/strong>\u00a0c\u1ea7n ch\u1ec9nh s\u1eeda.<\/p>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0L\u1ef1a ch\u1ecdn\u00a01 trong 4 ti\u1ec7n \u00edch<\/strong>\u00a0tr\u00ean d\u00f2ng t\u01b0\u01a1ng \u1ee9ng:<\/p>\n
\n
\n
\n
Nh\u00e2n b\u1ea3n:<\/strong>\u00a0t\u1ea1o b\u1ea3n sao th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u1ec3 ch\u1ec9nh s\u1eeda nhanh.<\/li>\n
S\u1eeda:<\/strong>\u00a0c\u1eadp nh\u1eadt l\u1ea1i th\u00f4ng tin (tr\u1eeb m\u00e3 th\u00e0nh ph\u1ea7n).<\/li>\n
X\u00f3a:<\/strong>\u00a0lo\u1ea1i b\u1ecf th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng kh\u1ecfi danh s\u00e1ch s\u1eed d\u1ee5ng.<\/li>\n
Chuy\u1ec3n tr\u1ea1ng th\u00e1i:<\/strong>\u00a0chuy\u1ec3n sang\u00a0Ng\u1eebng theo d\u00f5i<\/strong>\u00a0khi kh\u00f4ng c\u00f2n d\u00f9ng.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
L\u01b0u \u00fd:<\/strong><\/em><\/p>\n
\n
HR ch\u1ec9 chuy\u1ec3n th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng sang tr\u1ea1ng th\u00e1i ng\u1eebng theo d\u00f5i khi kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng \u0111\u1ebfn, \u0111\u1ec3 tr\u00e1nh r\u00e1c d\u1eef li\u1ec7u.<\/em><\/li>\n
C\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng th\u00ec kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p x\u00f3a.<\/em><\/li>\n
N\u1ebfu th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u00e3 ph\u00e1t sinh d\u1eef li\u1ec7u, HR c\u1ea7n x\u00f3a h\u1ebft c\u00e1c d\u1eef li\u1ec7u li\u00ean quan r\u1ed3i m\u1edbi x\u00f3a \u0111\u01b0\u1ee3c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u00f3. V\u00ed d\u1ee5: \u0110\u00e3 \u0111\u01b0\u1ee3c khai b\u00e1o trong m\u1eabu b\u1ea3ng l\u01b0\u01a1ng, ch\u00ednh s\u00e1ch ph\u1ee5 c\u1ea5p\/kh\u1ea5u tr\u1eeb, l\u1ecbch s\u1eed l\u01b0\u01a1ng nh\u00e2n vi\u00ean,…<\/em><\/li>\n
M\u00e3 th\u00e0nh ph\u1ea7n kh\u00f4ng s\u1eeda \u0111\u01b0\u1ee3c sau khi l\u01b0u.<\/em><\/strong><\/li>\n
\u0110\u1ec3 bi\u1ebft th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng ch\u1ea1y theo c\u00f4ng th\u1ee9c n\u00e0o, c\u00f3 th\u1ec3 ki\u1ec3m tra b\u1eb1ng c\u00e1ch: M\u1edf chi ti\u1ebft th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng v\u00e0 xem \u1edf m\u1ee5c Gi\u00e1 tr\u1ecb ho\u1eb7c M\u00f4 t\u1ea3.<\/em><\/li>\n
C\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u01b0\u1ee3c th\u00eam t\u1eeb thi\u1ebft l\u1eadp tr\u01b0\u1eddng m\u1edf r\u1ed9ng s\u1ebd c\u00f3 lo\u1ea1i th\u00e0nh ph\u1ea7n l\u00e0 Th\u00f4ng tin nh\u00e2n vi\u00ean v\u00e0 s\u1ebd kh\u00f4ng th\u1ec3 s\u1eeda \u0111\u01b0\u1ee3c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng n\u00e0y sang lo\u1ea1i th\u00e0nh ph\u1ea7n, t\u00ednh ch\u1ea5t, ki\u1ec3u gi\u00e1 tr\u1ecb kh\u00e1c.<\/em><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n
\n
<\/span><\/p>\n
3. L\u01b0u \u00fd<\/b><\/h3>\n
<\/div>
\n\n\n\n
<\/div><\/div>
<\/span><\/p>\n
3.1 T\u00ednh ch\u1ea5t th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/b><\/h4>\n
<\/div>
\nTr\u01b0\u1edbc khi x\u00e2y d\u1ef1ng ch\u00ednh s\u00e1ch l\u01b0\u01a1ng, t\u00ednh to\u00e1n b\u1ea3n l\u01b0\u01a1ng, HR c\u1ea7n \u0111\u1ecbnh ngh\u0129a t\u00ednh ch\u1ea5t c\u1ee7a c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng m\u00e0 doanh nghi\u1ec7p \u0111ang s\u1eed d\u1ee5ng.<\/p>\n
$\"\"$ <\/p>\n
T\u1ea1i \u0111\u00e2y, ch\u01b0\u01a1ng tr\u00ecnh m\u1eb7c \u0111\u1ecbnh lo\u1ea1i 3 t\u00ednh ch\u1ea5t:<\/p>\n
\n
T\u00ednh ch\u1ea5t Thu nh\u1eadp <\/strong>(ch\u1ecbu thu\u1ebf ho\u1eb7c kh\u00f4ng ch\u1ecbu thu\u1ebf TNCN).\u00a0V\u00ed d\u1ee5: L\u01b0\u01a1ng KPI, Ph\u1ee5 c\u1ea5p \u0111i\u1ec7n tho\u1ea1i, Ph\u1ee5 c\u1ea5p ch\u1ee9c v\u1ee5, Th\u01b0\u1edfng nh\u00e2n vi\u00ean xu\u1ea5t s\u1eafc,…<\/li>\n
T\u00ednh ch\u1ea5t Kh\u1ea5u tr\u1eeb <\/strong>(c\u00f3 \u0111\u01b0\u1ee3c gi\u1ea3m tr\u1eeb khi t\u00ednh thu\u1ebf TNCN hay kh\u00f4ng). V\u00ed d\u1ee5: BHXH, BHTN, Thu\u1ebf TNCN, Ph\u1ea1t \u0111i mu\u1ed9n,…<\/li>\n
T\u00ednh ch\u1ea5t Kh\u00e1c:<\/strong> l\u00e0 c\u00e1c th\u00f4ng tin b\u1ed5 sung, c\u00e1c c\u0103n c\u1ee9 t\u00ednh l\u01b0\u01a1ng nh\u01b0 s\u1ed1 ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c, t\u1ef7 l\u1ec7 ho\u00e0n th\u00e0nh KPIs,\u2026 C\u00e1c th\u00f4ng tin n\u00e0y c\u00f3 nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb kh\u00e1c nhau (d\u1ea1ng s\u1ed1, d\u1ea1ng ch\u1eef, d\u1ea1ng %,\u2026)<\/li>\n<\/ul>\n<\/div><\/div>\n
<\/span><\/p>\n
3.2 Lo\u1ea1i th\u00e0nh ph\u1ea7n<\/b><\/h4>\n
<\/div>
\nLo\u1ea1i th\u00e0nh ph\u1ea7n n\u00e0y s\u1ebd \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn vi\u1ec7c t\u1ea1o c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng, th\u00e0nh ph\u1ea7n lo\u1ea1i n\u00e0o th\u00ec s\u1ebd \u0111\u01b0\u1ee3c ph\u00e9p \u0111\u01b0a v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng t\u01b0\u01a1ng \u1ee9ng, bao g\u1ed3m: Th\u00f4ng tin nh\u00e2n vi\u00ean, Ch\u1ea5m c\u00f4ng, Doanh s\u1ed1, KPI, S\u1ea3n ph\u1ea9m, L\u01b0\u01a1ng, Thu\u1ebf TNCN, B\u1ea3o hi\u1ec3m – C\u00f4ng \u0111o\u00e0n, Kh\u00e1c<\/p>\n
V\u00ed d\u1ee5:<\/strong> Mu\u1ed1n \u0111\u01b0a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng l\u00e0 T\u1ed5ng c\u00f4ng h\u01b0\u1edfng l\u01b0\u01a1ng v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng th\u00ec ph\u1ea3i ch\u1ecdn \u0111\u00fang lo\u1ea1i th\u00e0nh ph\u1ea7n l\u00e0 Ch\u1ea5m c\u00f4ng.<\/em><\/p>\n<\/div><\/div>\n
<\/span><\/p>\n
3.3 \u0110\u1ecbnh m\u1ee9c tr\u00ean Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng <\/b><\/h4>\n
<\/div>
\n\u0110\u1ecbnh m\u1ee9c \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 l\u00e0 m\u1ee9c tr\u1ea7n c\u1ee7a kho\u1ea3n l\u01b0\u01a1ng, khi ph\u1ea7n m\u1ec1m t\u00ednh to\u00e1n s\u1ebd \u0111\u1ed1i chi\u1ebfu gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf t\u00ednh ra theo c\u00f4ng th\u1ee9c v\u1edbi \u0111\u1ecbnh m\u1ee9c, n\u1ebfu k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n \u0111\u1ecbnh m\u1ee9c th\u00ec s\u1ebd ch\u1ec9 l\u1ea5y \u0111\u00fang b\u1eb1ng \u0111\u1ecbnh m\u1ee9c \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n<\/div><\/div>\n
<\/span><\/p>\n
3.4 Gi\u00e1 tr\u1ecb th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng<\/b><\/h4>\n
<\/div>
\nL\u01b0u \u00fd:<\/em><\/strong><\/p>\n
\n
N\u1ebfu th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u00f3 gi\u00e1 tr\u1ecb, c\u00f4ng th\u1ee9c c\u1ed1 \u0111\u1ecbnh, HR c\u00f3 th\u1ec3 khai b\u00e1o ngay t\u1ea1i ph\u00e2n h\u1ec7 Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng.<\/em><\/li>\n
N\u1ebfu th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u00f3 gi\u00e1 tr\u1ecb kh\u00f4ng c\u1ed1 \u0111\u1ecbnh m\u00e0 t\u00f9y thu\u1ed9c v\u00e0o ch\u00ednh s\u00e1ch l\u01b0\u01a1ng\u00a0 c\u1ee7a t\u1eebng \u0111\u01a1n v\u1ecb, v\u1ecb tr\u00ed c\u00f4ng vi\u1ec7c hay nh\u00e2n vi\u00ean th\u00ec \u0111\u1ec3 tr\u1ed1ng, khai b\u00e1o sau t\u1ea1i ph\u00e2n h\u1ec7 M\u1eabu b\u1ea3ng l\u01b0\u01a1ng.<\/em><\/li>\n<\/ul>\n
Ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e1p \u1ee9ng c\u00e1c h\u00e0m t\u00ednh nh\u01b0 sau:<\/p>\n
\n
T\u00ean h\u00e0m: SUM(X1,X2,…)<\/strong>\n
\n
M\u00f4 t\u1ea3: T\u00ednh t\u1ed5ng c\u00e1c tham s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n
Tham s\u1ed1 X1, X2,…: ch\u1ecdn t\u1eeb th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111ang theo d\u00f5i ho\u1eb7c nh\u1eadp \u0111\u1ecbnh d\u1ea1ng s\u1ed1.<\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: IF(logical_test,[value_if_true],[value_if_false])<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: T\u00ednh gi\u00e1 tr\u1ecb theo \u0111i\u1ec1u ki\u1ec7n: Tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb, t\u00f9y thu\u1ed9c v\u00e0o \u0111i\u1ec1u ki\u1ec7n logic: n\u1ebfu \u0111i\u1ec1u ki\u1ec7n logic \u0111\u00fang th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 value_if_true, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n logic sai th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 value_if_false.\n
\n
Logical_test: \u0111i\u1ec1u ki\u1ec7n logic.<\/li>\n
Value_if_true: gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
Value_if_false: gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n<\/li>\n
V\u00ed d\u1ee5:\u00a0<\/em>\n
\n
IF(8>7,1,0) -> Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1.<\/em><\/li>\n
IF(AND(DOANH_SO>1000000000,SO_KHACH_HANG>50),0.5,0) => Hi\u1ec3u l\u00e0: N\u1ebfu Doanh s\u1ed1 l\u1edbn h\u01a1n 100.000.000 v\u00e0 s\u1ed1 kh\u00e1ch h\u00e0ng l\u1edbn h\u01a1n 50 th\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 = 0.5, c\u00f2n n\u1ebfu kh\u00f4ng \u0111\u1ea1t \u0111i\u1ec1u ki\u1ec7n tr\u00ean th\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 0.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: AND (logical1,logical2,…)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 TRUE n\u1ebfu c\u00f3 \u00edt nh\u1ea5t 1 \u0111i\u00eau ki\u1ec7n \u0111\u00fang.<\/li>\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 FALSE n\u1ebfu c\u00f3 \u00edt nh\u1ea5t 1 trong s\u1ed1 c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00fang.<\/li>\n
V\u00ed d\u1ee5: AND(1<2,2<3) th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 True.<\/em><\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: OR(logical1, logical2,…)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 TRUE n\u1ebfu c\u00f3 \u00edt nh\u1ea5t 1 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 FALSE kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00fang.<\/li>\n
V\u00ed d\u1ee5: OR(2>1:3>5) th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 True.<\/em><\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: ROUND(number, num_digits)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: L\u00e0m tr\u00f2n tham s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ecdn v\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1. Tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb, t\u00f9y thu\u1ed9c v\u00e0o \u0111\u1ed1i s\u1ed1 Num_digits (N):\n
\n
N=0 :L\u00e0m tr\u00f2n t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/li>\n
N>0: L\u00e0m tr\u00f2n t\u1edbi v\u1ecb tr\u00ed th\u1eadp ph\u00e2n ch\u1ec9 \u0111\u1ecbnh<\/li>\n
N<0: L\u00e0m tr\u00f2n sang b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n<\/li>\n<\/ul>\n<\/li>\n
V\u00ed d\u1ee5:<\/em>\n
\n
ROUND(398,15257; 0) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 398 => Hi\u1ec3u l\u00e0: L\u00e0m tr\u00f2n 398.15257 t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/em><\/li>\n
ROUND(398,15257; 2) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 398,15=> Hi\u1ec3u l\u00e0: L\u00e0m tr\u00f2n 398.15257 t\u1edbi 2 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n.<\/em><\/li>\n
ROUND(398,15257; -2) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 400 => Hi\u1ebfu l\u00e0: N= -1 th\u00ec l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c, N= -2 th\u00ec l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng tr\u0103m.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: DATE(year, month, day)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u1ea1ng ng\u00e0y\/th\u00e1ng n\u0103m.<\/li>\n
V\u00ed d\u1ee5:<\/em>\n
\n
DATE(2021,5,10) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 10\/5\/2021.<\/em><\/li>\n
IF(DATE(2021,5,10)>DATE(2020,5,10), 1,0) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1.<\/em><\/li>\n
IF(NGAY_THU_VI\u1ec6C>DATE(2021,5,10), 1,0) => Hi\u1ec3u l\u00e0: N\u1ebfu Ng\u00e0y th\u1eed vi\u1ec7c sau ng\u00e0y 10\/5\/2021 th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb b\u1eb1ng 1, c\u00f2n n\u1ebfu kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb b\u1eb1ng 0.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: MONTH(serial_number)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u00e1ng trong chu\u1ed7i ng\u00e0y\/th\u00e1ng\/n\u0103m.<\/li>\n
V\u00ed d\u1ee5:<\/em>\n
\n
MONTHDATE(2020,8,3)) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 8.<\/em><\/li>\n
MONTH(TODAY)) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 9 (th\u00e1ng hi\u1ec7n t\u1ea1i l\u00e0 th\u00e1ng 9).<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: TODAY()<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ng\u00e0y\/th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i<\/li>\n
V\u00ed d\u1ee5: TODAY() th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 03\/09\/2021<\/em><\/li>\n<\/ul>\n<\/li>\n
T\u00ean h\u00e0m: INT(number)<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
M\u00f4 t\u1ea3: L\u1ea5y ra ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 v\u00e0 l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/li>\n
V\u00ed d\u1ee5:<\/em>\n
\n
INT(5.2) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 5.<\/em><\/li>\n
INT(5.9) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 5.<\/em><\/li>\n
INT(-5.2) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -6.<\/em><\/li>\n
INT(-5.9) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -6.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
HR s\u1eed d\u1ee5ng h\u00e0m nh\u1eadp v\u00e0o \u00f4 gi\u00e1 tr\u1ecb c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng t\u01b0\u01a1ng t\u1ef1 c\u00e1ch nh\u1eadp c\u00f4ng th\u1ee9c trong excel.<\/p>\n
$\"\"$ <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":112,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[153],"ht-kb-tag":[],"class_list":["post-5460","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-xay-dung-chinh-sach-luong"],"_links":{"self":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/5460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/112"}],"replies":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=5460"}],"version-history":[{"count":7,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/5460\/revisions"}],"predecessor-version":[{"id":20699,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/5460\/revisions\/20699"}],"wp:attachment":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=5460"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=5460"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=5460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}