APARCOL

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AACORDOSINDICAL.CODCOLIGADA FKAACORDOSINDICAL_APARCOLR
AEVELAN.CODCOLIGADA FKAEVELAN_APARCOLR
AEVEPCOL.CODCOLIGADA FKAEVEPCOL_APARCOLR
AINTHOR.CODCOLIGADA FKAINTHOR_APARCOLR
ALIMBANCOHOR.CODCOLIGADA FKALIMBANCOHOR_APARCOLR
ALIMEXTRASFAIXA.CODCOLIGADA FKALIMEXTRASFAIXA_APARCOLR
APARFUN.CODCOLIGADA FKAPARFUN_APARCOLR
ATABATR.CODCOLIGADA FKATABATR_APARCOLR
ATABEXT.CODCOLIGADA FKATABEXT_APARCOLR
GCOLIGADA.CODCOLIGADA FKAPARCOL_GCOLIGADAR
CODIGO varchar 4 null
AACORDOSINDICAL.CODPARCOL FKAACORDOSINDICAL_APARCOLR
AEVELAN.CODPARCOL FKAEVELAN_APARCOLR
AEVEPCOL.CODPARCOL FKAEVEPCOL_APARCOLR
AINTHOR.CODPARCOL FKAINTHOR_APARCOLR
ALIMBANCOHOR.CODPARCOL FKALIMBANCOHOR_APARCOLR
ALIMEXTRASFAIXA.CODPARCOL FKALIMEXTRASFAIXA_APARCOLR
APARFUN.CODPARCOL FKAPARFUN_APARCOLR
ATABATR.CODPARCOL FKATABATR_APARCOLR
ATABEXT.CODPARCOL FKATABEXT_APARCOLR
DESCRICAO varchar 60 null
TEMPOMINBATIDA int 4 √ null
FAIXAEXTRA1 int 4 √ null
FAIXAEXTRA2 int 4 √ null
FAIXAEXTRA3 int 4 √ null
FAIXAEXTRA4 int 4 √ null
FAIXAEXTRADESC1 int 4 √ null
FAIXAEXTRAFER1 int 4 √ null
VALORFALTA int 4 √ null
CARENCIADSR int 4 √ null
INTERVALODSR smallint 2 √ null
TABATRASODIA smallint 2 √ null
FERIADODSR smallint 2 √ null
CONSIDERAINTERFLEX smallint 2 √ null
DIACONSIDERADSR smallint 2 √ null
FAIXAEXTRACOMP1 int 4 √ null
CONTRSAIDASINT smallint 2 √ null
CODABONOINT varchar 4 √ null
USAPONTOPOREXCECAO smallint 2 √ null
FAIXAEXTRA5 int 4 √ null
BANCOHORASOCORREN smallint 2 √ null
CONTROLALIMHORASDIA smallint 2 √ null
LIMHORASDIA int 4 √ null
CONTROLALIMHORASSEM smallint 2 √ null
LIMHORASSEM int 4 √ null
CONTROLALIMHORASMES smallint 2 √ null
LIMHORASMES int 4 √ null
COMPENSAEXTRADESC smallint 2 √ null
PERCEXTRADESC numeric 17,2 √ null
COMPENSAEXTRACOMP smallint 2 √ null
PERCEXTRACOMP numeric 17,2 √ null
COMPENSAEXTRAFER smallint 2 √ null
PERCEXTRAFER numeric 17,2 √ null
PERCEXTRANORMAL numeric 17,2 √ null
LIMDIASCOMPENSACAO int 4 √ null
ATITUDECOMPENSACAO smallint 2 √ null
RECALCOCORTRAVADAS smallint 2 √ null
ASSUMIROCORAPROVADAS smallint 2 √ null
DISTREXTRAJORNADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USABANCOHORAS smallint 2 √ null
TIPOBANCOHORAS smallint 2 √ null
DESCATRASODSR smallint 2 √ null
PRIMEIRAFAIXA smallint 2 √ null
BANCOOCOR smallint 2 √ null
ATITUDEOCOR smallint 2 √ null
TOLERADIC int 4 √ null
INSEREINTREFADNOT smallint 2 √ null
USALIMITEMINHORAS smallint 2 √ null
NUMHORASLIMITEMIN int 4 √ null
CONSFERNATBAT smallint 2 √ null
OPCAOTABEXTRA smallint 2 √ null
CONSFERSAIJOR smallint 2 √ null
DESCJORPOSFER smallint 2 √ null
CONSDESCNATBAT smallint 2 √ null
TABEXTRABAT smallint 2 √ null
DESCTEMPOMINREF smallint 2 √ null
DESCJORFIMAFAST smallint 2 √ null
CONSJORINICAFAST smallint 2 √ null
PAGAADICEXTRAREAL smallint 2 √ null
DESCINTREFFER smallint 2 √ null
OPEXTRABANCO smallint 2 √ null
OPATRASOBANCO smallint 2 √ null
OPFALTABANCO smallint 2 √ null
OPEXTRAFERBH smallint 2 √ null
OPEXTRADESBH smallint 2 √ null
OPEXTRACOMPBH smallint 2 √ null
CONSEXTRAAUTOPOSCOMP smallint 2 √ null
NUMHORASFALTA int 4 √ null
NONAHBANCO smallint 2 √ null
EXTJORDSCPFER smallint 2 √ null
CONSPERADNOT smallint 2 √ null
CONSNONAHTOT smallint 2 √ null
INTREFREALADNOT smallint 2 √ null
DESCLIMREF smallint 2 √ null
CONSFALTABAT smallint 2 √ null
INICIOPERNOT int 4 √ null
FIMPERNOT int 4 √ null
CONSLIMHORASJOR smallint 2 √ null
CONSTABPOSCOMP smallint 2 √ null
CONSTOLREF smallint 2 √ null
TIPOCARENCIADSR varchar 1 √ null
CONSJORADNOT smallint 2 √ null
CALCULASEMMOVTO smallint 2 √ null
CONSCOMPPORJOR smallint 2 √ null
CONSTOLDIAPONTE smallint 2 √ null
DESCTEMPOMINTRANS smallint 2 √ null
CONSDSRPROPORC smallint 2 √ null
CONTROLALIMEXTRASSEM smallint 2 √ null
LIMEXTRASSEM int 4 √ null
TEMPPARCOL smallint 2 √ null
CONSEXTRAFIMJOR smallint 2 √ null
CONSFALTAFIMPER smallint 2 √ null
CONSJORDISTEXTRA smallint 2 √ null
NAOINSINTREFADNOT smallint 2 √ (0)
CONSEXTRANOTDIF smallint 2 √ (0)
CONSFERDIAANT smallint 2 √ null
ABATTOLADNOT smallint 2 √ null
NAOCONSDSRFERDESC smallint 2 √ null
NAOCONSEXTRAADNOTHORFLEX smallint 2 √ null
CONSLIMEXTRASFAIXA smallint 2 √ null
ACAOEVECALCFORMULA smallint 2 √ (0)
CONSIDERAATRASOFORAJORNADA smallint 2 √ (0)
CONSIDERAEXECEFETIVOADNOT smallint 2 √ (0)
CONSIDERAPERCENTUALSALDO smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CONSIDERAADNOTATEFIMJOR smallint 2 √ null
INICIOJORNADAPARAADNOT int 4 √ null
CONSIDERAATITUDEEVENTO smallint 2 √ ((0))
CONSIDERACOMPENSACAOEVENTO smallint 2 √ ((0))
TIPOFAIXANUMHORASEXTRA smallint 2 √ null
OPCAOLIMITEDIA smallint 2 √ null
OPCAOLIMITESEMANA smallint 2 √ null
OPCAOLIMITEPERIODO smallint 2 √ null
CONSIDERAPERCENTEVEBANCOSALDO smallint 2 √ null
CONSIDERAPERCENTEVEBANCOCOMP smallint 2 √ null
CONSIDERAPERCENTINCIDBANCOHORA int 4 √ null
CONSIDERAPERCENTINCIDMOVIMENTO int 4 √ null
CONSIDERAPERCENTINCIDLIMITE int 4 √ null
LIMEXECDIA int 4 √ null
LIMEXECSEM int 4 √ null
LIMEXECMES int 4 √ null
INICIODEFLIMDIA int 4 √ null
INICIODEFLIMSEM int 4 √ null
INICIODEFLIMMES int 4 √ null
CONSIDERAARREDDIAMOVPER int 4 √ ((0))
CALCULAEXTRAREFEICAO smallint 2 √ null
CONSNONAHORADISTRIBUICAO smallint 2 ((1))
CONSEXTRAFOICOMPENSADADIST smallint 2 ((1))
USAPORTARIA373 smallint 2 ((0))
CONSABONOPOSCOMP smallint 2 √ null
SOBREAVISOGERAEXTRA smallint 2 ((0))
DEDUZIREXTRASSOBREAVISO smallint 2 ((0))
NAOCOMPENSARHORAEXTRASOBREAVIS smallint 2 ((0))
SOLUCAOCONFLITOFERIAS smallint 2 ((0))
SOLUCAOCONFLITOAFASTAMENTO smallint 2 ((0))
SOLUCAOCONFLITOADMISSAO smallint 2 ((0))
SOLUCAOCONFLITODEMISSAO smallint 2 ((0))
CALCULAEXTRAREFEICAOFERIADO smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKAPARCOL Primary key Asc/Asc CODCOLIGADA + CODIGO

Relationships

Close relationships within degrees of separation