PDADOSRESCISAO

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPDADOSRESCISAO_PFUNCR
PSECAO.CODCOLIGADA FKPDADOSRESCISAO_PSECAOR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPDADOSRESCISAO_PFUNCR
CUMPRIUJORNADAINTEGRAL smallint 2 √ null
JORNADASEMANA smallint 2 √ null
CALCMEDIA13SAL smallint 2 √ null
APURABASE13SAL smallint 2 √ null
QTDMESES13SAL smallint 2 √ null
MAIORES13SAL smallint 2 √ null
CALCMEDIAFERIAS smallint 2 √ null
APURABASEFERIAS smallint 2 √ null
QTDMESESFERIAS smallint 2 √ null
MAIORESFERIAS smallint 2 √ null
CALCMEDIAAVPREVIO smallint 2 √ null
QTDMESESAVPREVIO smallint 2 √ null
MAIORESAVPREVIO smallint 2 √ null
DURACAOAVPREVIO smallint 2 √ null
DTAVISOPREVIO datetime 16,3 √ null
DTAFASTAMENTO datetime 16,3 √ null
CAUSAAFASTAMENTO varchar 5 √ null
TIPOCONTRATO smallint 2 √ null
TEMNOVOEMPREGO smallint 2 √ null
DISPENSAAVPREVIO smallint 2 √ null
PERCPENSAOALIM RMDVALOR2 17,2 √ null
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKPDADOSRESCISAO_PSECAOR
NDSRMES smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPDADOSRESCISAO Primary key Asc/Asc CODCOLIGADA + CHAPA

Relationships

Close relationships within degrees of separation