Exclusion of Company

This procedure excludes the company (R030EMP table) and all tables which references the NumEmp field.

This routine is intended to clients on phase of system deployment and can also be used in cases of database separation.

When confirming the company exclusion, the information can be recovered only through backup, which must be done before running the routine.

Criteria for excluding the detail registers from R030EMP table.

All table that has the NumEmpwill field be excluded:

R000USC, R008LIM, R008SAL, R010SAF, R010SAL, R018CCR, R018CCU, R020DRA,

R020EXC, R020RMO, R024SAL, R027VLG, R027VLR, R028PVT, R030ANU, R030CAR,

R030DAR, R030FIL, R030GRC, R030GRE, R030GRP, R030LOG, R030ORG, R030RAT,

R030SIM, R032OPG, R032OPR, R032RCB, R032TPG, R032TPR, R034ANU, R034CPL,

R034DOC, R034FGT, R034FIL, R034FOT, R034FUN, R034LCO, R034LOT, R034PLI,

R034REF, R034SEG, R034SEL, R034SIN, R034USO, R036DEP, R036EDU, R036IRF,

R036PJD, R036PJF, R036PJL, R036PJN, R036PJP, R036PJU, R038AFA, R038HAD, R038HCA,

R038HCC, R038HCH, R038HEB, R038HES, R038HFI, R038HFU, R038HLO, R038HPP,

R038HSA, R038HSV, R038HTI, R038LAC, R038LAD, R038NOT, R040ACU, R040ASD,

R040FEM, R040FEV, R040INV, R040PER, R040PRG, R042RCD, R042RCM, R042RCR,

R042RCS, R042RCV, R044BAS, R044CAL, R044ENV, R044EXC, R044FIX, R044MOV,

R044VAL, R045CHE, R045SEQ, R046AFC, R046AFM, R046FFR, R046IRF, R046PRR,

R046PRV, R046VER, R047CIF, R047EFI, R047EMP, R047HIS, R047PEN, R048CON,

R048DEE, R050AIF, R050CIF, R050CMG, R050CMS, R050FDA, R050RIF, R052GRC,

R054ATR, R054CMG, R054CMS, R054CTD, R054GRA, R054GRP, R054RED, R056DEP,

R056MAF, R056RCS, R056SFG, R060DIN, R060PDS, R060PFE, R064ASA, R064CCU,

R064CMP, R064EXT, R064LOC, R064PAR, R064PON, R064RAT, R064TES, R064THR,

R064TPE, R066APU, R066SIT, R067LAC, R068CNR, R068DRF, R068RSR, R068TRF,

R068VDR, R068VRF, R070CRC, R070CRO, R070HCH, R070MSC, R070MSO, R070OCR,

R070PEC, R070PEO, R075SAL, R076PCA, R076PSA, R076RNI, R077ACN, R077ACT,

R077AHN, R077APA, R077APP, R077CHG, R077HHT, R077MHT, R078ACR, R078ACT,

R078AHC, R078AHT, R078CHT, R078CTI, R078DEF, R078HHT, R078LTI, R078MHT,

R079AEA, R079AEC, R079AEP, R079AEN, R079AHN, R079AHP, R079MHP, R080CLO,

R080EFE, R080EXC, R080PRO, R080QUA, R080SUB, R081EFE, R081PRO, R081QUA,

R083AGT, R083ARI, R083CAR, R083EPI, R083EXA, R083FGL, R083LAU, R083NLE,

R083PLN, R086OPA, R083TIM, R084EPL, R084PLN, R085BAS, R085ORC, R085ORV,

R085PAR, R085POC, R085POE, R085POL, R085PRC, R085PRE, R085PRL, R086ACT,

R086PLN, R088VEF, R090AGA, R090AGG, R090AGV, R090MGV, R090MVI, R092AGC,

R092PAS, R092QAV, R092RDE, R092REV, R092RPA, R092RRE, R094LOC, R094LOF,

R094LOP, R096DIE, R096ECA, R096ECO, R096ELC, R096ELO, R098EQP, R098HLC,

R096MED, R098REV, R100CAN, R100MAN, R100MEB, R100PLN, R100REC, R100REP,

R100REU, R102EPB, R102GRU, R102PLN, R102RCO,R102RBI,R102RBP, R102REB,

R102TBR, R102TRB, R104AUJ, R104FIC, R104PED, R104PRJ, R104REC, R104TES, ,

R104DEF, R104PCD, R104PDI, R104BCA, R104BCH, R104BFE, R104BHV, R104BPA,

R104BPE, R104BSC, R104BSP, R104BSR, R104PSQ, R104PSR, R104RES, R104PDC,

R108EXC, R108EXE, R108EXL, R108EXO, R108RER, R108TAT, R109FIL, R110DEF,

R110FIC, R110MPR, R112GRI, R112GRU, R122EMP, R124CSL, R124HCA, R124HCF,

R124HCN, R124HCR, R124HEA, R124HEC, R124HED, R124HEP, R124HET, R124HLA,

R124HPA, R124HRA, R124HRF, R124HRQ, R124HTI, R124HTR, R126CAN, R126CIN,

R126CPE, R126HSE, R126RQU, R126SBS, R128INS, R129DEF, R129DTU, R130CEV,

R130CLI, R130CLO, R130DLI, R130DLO, R130DPA, R130DPI, R130OCC, R130OCU,

R130OLO, R130OLV, R131AUT, R131HTE, R132REC, R132RES, R134CNF, R134COM,

R134DCI, R134DRE, R134DTL, R134EDR, R134EIN, R134INS, R135DCC, R135DCO,

R135DIC, R135DIN, R135OCC, R135OCO, R135OIC, R135OIN, R140NCU, R140NPA,

R140NPC, R142DPA, R144ATE, R144INT, R150ANI, R150DIF, R150ELE, R150LAZ,

R150MOR, R150NUT, R150OIM, R150ORC, R150PES, R150VEI, R152DEA, R152DEF,

R152DEP, R152PES, R158CTR, R158DAF, R158DCA, R158DDE, R158DEM, R158DFE,

R158DFI, R158DLO, R158DNO, R158DPR, R158MCT, R160EPT, R160PAG, R160PAR,

R162ASS, R162SOC, R162SOV, R164ASS, R164DEP, R164DES, R166AUX, R166DEF,

R166LAN, R166SOL, R170ESC, R170PDI, R170PHA, R170TMB, R171APF, R171APR,

R171DPF, R171DPR, R172CCO, R172CND, R172DCO, R172GER, R174CCU, R174CND,

R174GER, R176CLO, R176CND, R176DLO, R176GER, R178CND, R178CTO, R178DTO,

R178GER, R180CND, R180COE, R180DOE, R180GER, R182DEF, R184OCF, R184OCO,

R184OLF, R184OLO, R184PCO, R184PLO, R184QCO, R184QLO, R186VLR, R188PAR,

R188PDC, R188PDL, R188MAQ, R194AGC, R194DIA, R194FIS, R196ADI, R196MOV,

R196MRT, R198TER, R198TES, R204DEB, R204PER, R206CAR, R206DEF, R206DML,

R206LOJ, R206PLR, R206QCA, R206QCO, R206QLO, R700CAL, R185DUS.

 

Table

R000USE when the EmpAti field is equal to the company selected, the register will be deleted;

R038HFI and R158DFI when the EmpAtu field is equal to the company selected, the register will be deleted;

R132REC and R134CNF when the EmpPar field is equal to the company selected, the register will be deleted;

R126CIN and R126CPE when the EmpRqu field is equal to the company selected, the register will be deleted;

R400FIL when the EmpOri or EmpDes fields are equal to the company selected, the register will be deleted;

R122CEX when the EmpInd field is equal to the company selected, the EmpInd, TipInd and CadInd fields will be zeroed;

When the NumEmp field is equal to the company selected, the NumEmp, TipCol and NumCad fields will be zeroed;

When the EmpCon field is equal to the company selected, this field will be zeroed;

R140SLA when the NumEmp field is equal to the company selected, the NumEmp and CodFil fields will be zeroed;

R018CCU when the OutEmp field is equal to the company selected, will be zeroed;

R034FUN when the field OutEmp or OutFil field is equal to the company selected, the corresponding field will be zeroed;

R070OCR when the EmpOri field is equal to the company selected, will be zeroed;

R122CPA and R124HPA when the EmpCsi field is equal to the company selected, the EmpCsi, OriCsi and NumCsi fields will be zeroed;

When the EmpCse field is equal to the company selected, theEmpCse, OriCse and NumCse fields will be zeroed;

When the EmpCsu field is equal to the company selected, the EmpCsu, OriCsu and NumCsu will be zeroed;

R124HLA when the field EmpPsi field is equal to the company selected, the EmpPsi, OriPsi and NumPsi fields will be zeroed;

R129DEF when the EmpRes field is equal to the company selected, the EmpRes, TipRes and CadRes fields will be zeroed;

R176DLO and R178DTO when the OutEmp field is equal to the company selected, will be zeroed;

R058DCR when the field EmpVis field is equal to the company selected, will be zeroed;

R070ACC for each worker from the company selected, the NumEmp, TipCol, NumCad, DatApu, CodRef and UsoRef fields will be zeroed;

R142DIA for each worker from the company selected, the NumEmp, TipCol, NumCad, TabOrg and CodLoc fields will be zeroed;

R142ANA, R142AAC and R122CLA for each worker from the company selected, it zeroes the NumEmp, TipCol and NumCad fields;

Exclusion of tables which have detail registers

R110FIC before deleting registers from this table, deletes the R108RES, R110ENC, R110FIE, R110MAM, R110MAT, R110MGQ, R110MHR, R110MRC, R110IAM, R110IAT tables;

R090MVI before deleting registers from this table, will delete registers from R090ACO table;

R047CIF before deleting registers from this table, will delete the R047CIB table;

R126RQU before deleting registers from this table, will delete the R122CET, R126ETA, R126EXA, R126EXP, R126ITA, R126ITQ, R126RCA, R126RCF, R126RCN, R126RQS, R126EQV tables;

R108TAT the R110ENC, R110MAM, R110MHR, R110MRC tables will be previously deleted. Will be also deleted the detail from the R110MRC - R110MRM table;

Delete Clocking Events

Report if the registers from R070ACC table must be deleted, or if the association among the registers and workers must be undone.