1 files changed, 14 insertions, 17 deletions

diff --git a/lib/shi-api/shi-api-utils.ts b/lib/shi-api/shi-api-utils.ts
index ddbc186f..280a2fcb 100644
--- a/lib/shi-api/shi-api-utils.ts
+++ b/lib/shi-api/shi-api-utils.ts
@@ -57,12 +57,9 @@ export const getAllNonsapUser = async () => {
         // S = 정직원
         const isRegularEmployee = (u.REGL_ORORD_GB || '').toUpperCase() === 'S';
 
-        return {
-          // upsert key = USR_ID
-          nonsapUserId: u.USR_ID || undefined,
-
-
+        return {          
           // mapped fields
+          nonsapUserId: u.USR_ID || undefined,
           employeeNumber: u.EMPNO || undefined,
           knoxId: u.MYSNG_ID || undefined,
           name: u.USR_NM || undefined,
@@ -88,18 +85,18 @@ export const getAllNonsapUser = async () => {
         .onConflictDoUpdate({
           target: users.nonsapUserId,
           set: {
-            name: sql`excluded.name`,
-            employeeNumber: sql`excluded.employeeNumber`,
-            knoxId: sql`excluded.knoxId`,
-            epId: sql`excluded."epId"`,
-            deptCode: sql`excluded."deptCode"`,
-            deptName: sql`excluded."deptName"`,
-            phone: sql`excluded.phone`,
-            nonsapUserId: sql`excluded."nonsapUserId"`,
-            isAbsent: sql`excluded."isAbsent"`,
-            isDeletedOnNonSap: sql`excluded."isDeletedOnNonSap"`,
-            isActive: sql`excluded."isActive"`,
-            isRegularEmployee: sql`excluded."isRegularEmployee"`,
+            name: users.name,
+            employeeNumber: users.employeeNumber,
+            knoxId: users.knoxId,
+            epId: users.epId,
+            deptCode: users.deptCode,
+            deptName: users.deptName,
+            phone: users.phone,
+            nonsapUserId: users.nonsapUserId,
+            isAbsent: users.isAbsent,
+            isDeletedOnNonSap: users.isDeletedOnNonSap,
+            isActive: users.isActive,
+            isRegularEmployee: users.isRegularEmployee,
             updatedAt: sql`now()`,
           },
         });