ALTER TABLE FCT_MODELOCONTRATO ADD TPESTRUTINTEGRAHCM VARCHAR2(1)
/
ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_TPESTRUTINTEGRAHCM CHECK (TPESTRUTINTEGRAHCM IN ('T','P'))
/

UPDATE FCT_MODELOCONTRATO
   SET TPESTRUTINTEGRAHCM = 'T'
 WHERE TPESTRUTINTEGRAHCM IS NULL 
/
COMMIT
/
 

ALTER TABLE FCT_MODELOCONTRATO ADD IDINTEGRAESCALAHCM VARCHAR2(1)
/
ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_IDINTEGRAESCALAHCM CHECK (IDINTEGRAESCALAHCM IN ('S','N'))
/
UPDATE FCT_MODELOCONTRATO
   SET IDINTEGRAESCALAHCM = 'N'
 WHERE IDINTEGRAESCALAHCM IS NULL 
/
COMMIT
/
 
 
ALTER TABLE FCT_MODELOCONTRATO ADD IDAGRUPAESCALAHCM VARCHAR2(1)
/
ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_IDAGRUPAESCALAHCM CHECK (IDAGRUPAESCALAHCM IN ('S','N'))
/
UPDATE FCT_MODELOCONTRATO
   SET IDAGRUPAESCALAHCM = 'N'
 WHERE IDAGRUPAESCALAHCM IS NULL 
/ 
COMMIT
/