PFHSTFALTA

321 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTFALTADSP.CODCOLIGADA FKPFHSTFALTADSP_PFHSTFALTAR
PFUNC.CODCOLIGADA FKPFHSTFALTA_PFUNCR
CHAPA DCHAPA 16 null
PFHSTFALTADSP.CHAPA FKPFHSTFALTADSP_PFHSTFALTAR
PFUNC.CHAPA FKPFHSTFALTA_PFUNCR
DATAINICIO datetime 16,3 null
PFHSTFALTADSP.DATAINICIO FKPFHSTFALTADSP_PFHSTFALTAR
DATAFINAL datetime 16,3 √ null
HORASATRASO int 4 √ null
DESCONTADSR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ABONA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OBSERVACAO varchar 100 √ null
STATUS int 4 √ null
MESCOMPFALTA int 4 null
ANOCOMPFALTA int 4 null
USUARIO varchar 20 √ null
DATAESTORNO DDATETIME 16,3 √ null
BLOQUEADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
FRACAODIAFALTA RMDVALOR2 17,2 √ null
DESCONSIDERAFERIAS smallint 2 √ ((0))
DESCONSIDERADECIMOTERCEIRO smallint 2 √ ((0))

Indexes

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

Relationships

Close relationships within degrees of separation