
-- 删除薪酬所有元数据：lcs（在HR中台云）、itc（在个税云）、sitbs（在个税云）、sitbp（在个税云）、pcs（在薪酬云）、hspp（在薪酬云）、hpdi（在薪酬云）、hscs（在薪酬云）、hsbp（在薪酬云）、hsbs（在薪酬云）、hcdm（在薪酬云）、hsas（在薪酬云）
if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_OBJECTTYPEREF WHERE FOBJECTTYPEID IN (SELECT FNUMBER FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X')) ;

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_OBJECTTYPEREF WHERE fentityid IN (SELECT fid FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_MAINENTITYINFO_L WHERE FID IN (SELECT FID FROM T_META_MAINENTITYINFO WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_MAINENTITYINFO WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X');

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_ENTITYINFO WHERE FID IN (SELECT FNUMBER FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_ENTITY WHERE FNUMBER IN (SELECT FNUMBER FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_FORM WHERE FNUMBER IN (SELECT FNUMBER FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_BIZUNITRELFORM WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X');

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_FORMDESIGN_L WHERE FID IN (SELECT FID FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_FORMDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X');

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_ENTITYDESIGN_L WHERE FID IN (SELECT FID FROM T_META_ENTITYDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X'));

if not exists(SELECT 1 FROM T_META_ENTITY WHERE FID = '2+QE4JA9QV27')
DELETE FROM T_META_ENTITYDESIGN WHERE FBIZAPPID IN ('198IF7HLNV46','17/+CT1QBPNP','17/+7RIW4SCJ','17/+2YHJLMCB','1ANC8T4UC434','/US+X3ECAB+C','0NXW1VOPH+QV','0B1N=ELCC71V','/YI40TY=OOHN','/UHLXNRR9KPZ','0VO5EV13=I9W','/UHMBBGZQ65X');
