Special - Remove Schedules While Employee is Terminated (more notes in report)
This utility removes schedule entries for employees while they are in terminated status. Additional notes are included in the report.
Encoded Report Data
0x0DF0ADDE7B17000078DAD5584B6F2B49156EDF5C8919CFB48605426257BA4824D17D25574848686648C76EC70DB6DBD7DD8973D9A04A77C52EA5FA413F9298D1486C59B1E207B04282DFC00221F107D8B21CF13380538FEEAE6EFBE6C2701760298A7DEA54D5F9CE39F59D536515C5789392EC7549B28D61FED5308C21C983CCE87D025FA7244A904FEE0B34261931EC281D5156902C371E3F36E4C789035686C48DD9C60A0A7A4B4089251B427263AF07E3BD198E885C6D46EE90B6999B85241B51C2426D3921A4F14A4A1E69126E965C12447EB222C59A649A45726841F222A36048126BAB9ED2252137A7644541FAC1074A7AF2ABBF9D9C9630DD8917244DB2C21936530649946624CF8765CA68808B1A4F854FEEEBDE922CA3218C9A9F8859655C348BD831BE62C4BEE78BDBF701616A8DB32C29533F2930CB3DA28C357F002356EEE15B122AB5CE6ACB0CA74E5C243EBEBA22E11CAF6A9BC6048393C684AED64AFF08FEA4D45BE3B076E8A75C4C61D1DEA9705694DC12F4E4F9F327A848509E92805E6F1056DF68802AB088C6A8828A0E5EA139C301C90F0D2D9C3D9327CC0635F19FE038CC039C12159B09B92EA6388320786B88E88DF161856C8AEF87E0E226344248E36D21E490701EFCE70E502BCFF1664EB201C3B9167490D024F4C0E9752E2D704A43196BC364209129EB15B828B59983358E576492AC76475546FE1D4AC2CAD38D0CF2B618FCA69F21582FC66C3B0B27342FDCEB2AC577ED23359C90C40544EC61AD2A82EF5ECF1F80EB71939BBB1493154472B56DB30A8D1B57B152492A9CDF06BE20016681DCACD282CC4B29A0C98D9E3AD1D7C03D7140B677EA0E1524122B690A5C0ECC51D0187328DD219F160CD8E923C54E2A35BC604DC2929109DE24A582FC4FF8C051E24C344D420D8377431829F4A5BD1B9AC229C8DDEB59D220E33B125CC843B943D4CAE8DE8E9151467E5E02DA8DDCA95783904E1614EB6D727082C291B741BE684E7C053047776BCA4873CC9D1CE83E8BB8B78085BC7572271398D3BBB2190E4B1CE22CDC0E87575EEDA09C7E6D16F785E27BF3B7E643AC0CF60C2966C98A9FCCB771EB7FC2C34AF7758959754A7EBD43ED5ED4B221DE682776946451C9708B5702C84F8808D09614CFDB62AA92E115FCF96BA822EB8485B5B2D192D2B85B2EAAE0F0A322C129CFF30A92F22CD661FC6E270CA9E7F3E5FE77E001187243366F215546EEA9A82413724B584D5107DBAA70ECF9F282356FB1A2F767E0A231A465ED1B451F0F5628D5BC9C6590D28AA9A5ABD580134524A49082D655CE79A61A9ED08816CB33AF8CA2DC4F96675600635531DE2A6627FB5F9D6C15B35F7EF7AB13D91A7D53918FF00052BD5109D8DA71B4F23C09A864B1BAEA01B5E9C9F0BD6D67292416639CD9ABD6E22D15B311B612AF53494D5149EFBCD793DDC60333F0F6208274113A064CF26C1F5933CFF9D9D25ACC9CD99987DCD1C8EC73F1CC1DB8E7331FB933B36FF687F660622D6C74E2F9967FEEA15B9C0540BB07DF3F3A3A3AE41326F6C0AF473F43FBFB7CD6F97C68F936B2A7F389FBC6B63DC417F606E3B9E5FBA0748496631B16AD249F83C49A0D9135F09D0BBB5EEB982FB5B583FAF6746079FEC1C9C9C25D4A7B2D0F5D588BC1D85A1C1C1F1D1E3EDD17D449C226BF5026E83644D75912A1392E7899CF9FA17D09746283C99ED91F2DDC2937CD1E9E4FB8E9CF341CB6D997A6DB2F46CEC4FE89FD062CF2AAEF669FA3F05EC06481FF7350D331D9A311974BB5F69084FBFCB91C7186B3F3E967FB979797FBEFDB074DAD19F24249C2367EFBD2EC0BF76898C10197037BEE3BEE6CEC78BED0B9836E9FB4BC605FB6DD00BFEB691CDDD15BE071D18186D277E7E8184980321866FFA01E9572B048BA12896081ADE04B39242C9431D26C6B4C3B9F393CB3D5727A089EA11DB1AA3750CE7860E54364D5D9A1267F2ADC625FD8335F06DE5D0CED053A7D536B0C6D6FC0C11FBEBF7CAFC8B10AF08E1432761435AD6F8822D9170C29BFBD5D751AAC32B5435AE83CF7649BE7C630B553EFB6BB8EBF3C6ECDEB89A204431E293CE038A271A1E4E66F55F4A6B490525B2477DA3A2127442569EAA41CFB8E36D66E7E3BE61D19E63FF6C03C2C28DFE87D43F65AFC623248D89286C55ACE45A0C56B09AFDCB890CD6B14BD0CC3971BF818BCBCCF29097430C384319CA909DB7DC2FF693FA1F61F017BC0B5BF6445DE344A7C00DCEE5CFF9464492D865680F2B2A47A03E1F7AA83ED55B733E85CAD82A721D4E0CEC50D8678B2E26CF36E0D1ED876C0C716A3AB584F59693C14FB14AE19D2C87152667937524E1C93ECC7890E1EEE26FA19E2E90AB3ACEAD6241A08684CBA4D436F8E43B8B94277F448BC12C0CFA655973D40E8D15F90E6CEFCDF7419A21F98E262EDA686399221E08F2A22C17927F4C5D1974FBF38FED2A80EE88EC6D085A075EF6EFCE65DED01518686035685B8263AAB28C6691A42F3DB52CCA3928F1856A8F7B814BC1E90E616EDC421B9D72E7E700E69708159492AC709D2EA84C9A7517D2A3F86DFEBF50FE318E1E8651A19CB24BB59F10C99263105437783959C503D793DE095F39CB4BB5DE90C1077BA2F1975EDA255277B6D11F0DAEE4D389E01ECD27E0B7077BC53651966FC694A768AD539FCB7DFAFB8D9DAD34C8D2513D767DE6F1A1794DC35C749D8FF10A6C6CBBF79D432646F871650EF1FF92B61495928785FC1122F3C6EDA794C6CB3B1D1BC987E285E450299AC36DC28C07DB2E1FFC3EFF9E7EF3F9245A5A5374F722DD9C40994B9DCC9F9E599B8176950CF6665A48D77301D1BE69FDE03A68FC4D7146785E0CD07507534BF16AE47EFC6F5CA30FFFC1E707D2C06F3020D08BF463E04ACABFAB590ED6D23FB17C598DDEEContent Inventory
- Doc File:
content/docs/utilities/special_remove_schedules_while_employee_is_terminated.mdx - SQL Script:
SQL/utilities/GaryandLeoTrigger_SchedulesTable.sql