TAB_OBJECTIF Class

Objective.

Show:

ID_OBJECTIF

Int(11)

Unique identifier.

ID_USER

Int(11)

TAB_USER.ID_USER.

User.


Default: 0

OBJ_CATEGORIE

Tinyint(1)

Category of activity reports :

  • 0 : Commercial reporting
  • 1 : Human resources reporting
  • 2 : Recruiment reporting
  • 3 : Activity & expenses reporting
  • 4 : Global reporting
  • 5 : Billing reporting


Default: 0

OBJ_DATE

Varchar(30)

Period's date :

  • "" : All dates calculated into activity reports for TAB_OBJECTIF.OBJ_PERIODE are concerned
  • "SX YYYY" : Date calculated into activity reports is a week, where X is the week's number and YYYY the year, only if TAB_OBJECTIF.OBJ_PERIODE = 0
  • "MX YYYY" : Date calculated into activity reports is a month, where X is the month's number and YYYY the year, only if TAB_OBJECTIF.OBJ_PERIODE = 1
  • "TX YYYY" : Date calculated into activity reports is a quarter, where X is the quarter's number and YYYY the year, only if TAB_OBJECTIF.OBJ_PERIODE = 2
  • "SX YYYY" : Date calculated into activity reports is a half-year, where X is the half-year's number and YYYY the year, only if TAB_OBJECTIF.OBJ_PERIODE = 3
  • "SX" : Date calculated into activity reports is a week, where X is the week's number, only if TAB_OBJECTIF.OBJ_PERIODE = 0
  • "MX" : Date calculated into activity reports is a month, where X is the month's number, only if TAB_OBJECTIF.OBJ_PERIODE = 1
  • "TX" : Date calculated into activity reports is a quarter, where X is the quarter's number, only if TAB_OBJECTIF.OBJ_PERIODE = 2
  • "SX" : Date calculated into activity reports is a half-year, where X is the half-year's number, only if TAB_OBJECTIF.OBJ_PERIODE = 3


Default: ''

OBJ_OPERATEUR

Char(2)

Operator used to compare :


Default: '<'

OBJ_PERIODE

Tinyint(1)

Period :

  • 0 : Weekly
  • 1 : Monthly
  • 2 : Quaterly
  • 3 : Biannual
  • 4 : Annual


Default: 0

OBJ_VALUE

Int(11)

Value to compare.


Default: 0