PFFERPROG

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFFERPROG_PFUNCR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFFERPROG_PFUNCR
DTVENCFERIAS datetime 16,3 null
INICPROGFERIAS datetime 16,3 null
FIMPROGFERIAS datetime 16,3 √ null
NRODIASFERIAS RMDVALOR2 17,2 √ null
DTPAGTOFERIAS datetime 16,3 √ null
DTAVISOFERIAS datetime 16,3 √ null
QUERABONO smallint 2 √ null
NRODIASABONO RMDVALOR2 17,2 √ null
QUER1APARC13O smallint 2 √ null
NRODIASADIANTFER smallint 2 √ null
EVTADIANTFERIAS varchar 4 √ null
FERIASCOLETIVAS smallint 2 √ null
OBSFERIAS varchar 80 √ null
NDIASLICREM1 RMDVALOR2 17,2 √ null
NDIASLICREM2 RMDVALOR2 17,2 √ null
DTINICIOLICENCA datetime 16,3 √ null
NUMVEZESDESCEMPRESTIMO smallint 2 √ null
DATAINICIODESCEMPRESTIMO datetime 16,3 √ null
QUERADIANTAMENTO smallint 2 √ (0)
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)
PKPFFERPROG Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DTVENCFERIAS + INICPROGFERIAS

Relationships

Close relationships within degrees of separation