ALTER TABLE FCT_MODELOCONTRATO ADD IDINTEGRACAOHCM CHAR(1)
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_IDINTEGRACAOHCM 
	CHECK (IDINTEGRACAOHCM IN ('S', 'N'))
/

UPDATE FCT_MODELOCONTRATO
   SET IDINTEGRACAOHCM = 'N'
 WHERE IDINTEGRACAOHCM IS NULL
/
COMMIT
/


ALTER TABLE FCT_CONTRATO ADD IDINTEGRACAOHCM CHAR(1)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_IDINTEGRACAOHCM_CONT 
	CHECK (IDINTEGRACAOHCM IN ('S', 'N'))
/

UPDATE FCT_CONTRATO
   SET IDINTEGRACAOHCM = 'N'
 WHERE IDINTEGRACAOHCM IS NULL
/
COMMIT
/