PFHSTFCO

103 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PMOTMUDFUNCAO.CODCOLIGADA FKPFHSTFCO_PMOTMUDFUNCAOR
PFUNC.CODCOLIGADA FKPFHSTFCO_PFUNCR
PFUNCAO.CODCOLIGADA FKPFHSTFCO_PFUNCAOR
VFAIXASALARIAL.CODCOLIGADA FKPFHSTFCO_VFAIXASALARIALR
VNIVELFUNCAO.CODCOLIGADA FKPFHSTFCO_VNIVELFUNCAOR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTFCO_PFUNCR
DTMUDANCA datetime 16,3 null
MOTIVO varchar 2 null
PMOTMUDFUNCAO.CODCLIENTE FKPFHSTFCO_PMOTMUDFUNCAOR
CODFUNCAO varchar 10 √ null
PFUNCAO.CODIGO FKPFHSTFCO_PFUNCAOR
CODFAIXA varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKPFHSTFCO_VFAIXASALARIALR
CODNIVEL varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKPFHSTFCO_VNIVELFUNCAOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
FUNCAOACUMULAVEL smallint 2 √ null

Indexes

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

Relationships

Close relationships within degrees of separation