2024/11/01 오픈

　2024/11/07 접수

　crec_recfile에서 tbl_record에 트리거로 Insert 할 때 조직도 부분이 정상적으로 insert되지 않는 부분 확인 후 트리거 수정하여 전달완료

　Rocky 8.10 / PostgreSQL 14

　crec_main

　티플리스

　수정한 트리거 bpart_code, bpart_name, mpart_code, mpart_name, spart_code, spart_name 부분

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT bpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id) END) END) as bpart_code

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT part_name FROM tbl_user_group

WHERE bpart_code = (SELECT bpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND part_depth = 1) END)

END) as bpart_name

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT mpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id) END) END) as mpart_code

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT part_name FROM tbl_user_group

WHERE bpart_code = (SELECT bpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND mpart_code = (SELECT mpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND part_depth = 2) END)

END) as mpart_name

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT spart_code FROM tbl_user WHERE cti_id = cr.rec_user_id) END) END) as spart_code

,(CASE COALESCE(tu.user_id, '') WHEN '' THEN

(CASE COALESCE(cr.rec_user_id, '') WHEN '' THEN ''

ELSE (SELECT part_name FROM tbl_user_group

WHERE bpart_code = (SELECT bpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND mpart_code = (SELECT mpart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND spart_code = (SELECT spart_code FROM tbl_user WHERE cti_id = cr.rec_user_id)

AND part_depth = 3) END)

END) as spart_name