Resource or candidate.

Show:

ID_CREATOR

Int(11)


Default: 0

ID_CRMCONTACT

Int(11)

TAB_CRMCONTACT.ID_CRMCONTACT.

Provider contact.

Only for candidates or external resources.


Default: 0

ID_CRMSOCIETE

Int(11)

TAB_CRMSOCIETE.ID_CRMSOCIETE.

Provider company.

Only for candidates or external resources.


Default: 0

ID_DT

Int(11)

TAB_DT.ID_DT.

Technical document.


Default: 0

ID_EMBAUCHE

Int(11)

ID_PROFIL.

Resource hired from this candidate.

Candidate only


Default: 0

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

Unique Identifier.

ID_RESPMANAGER

Int(11)

TAB_USER.ID_USER.

Main manager.


Default: 0

ID_RESPRH

Int(11)

TAB_USER.ID_USER.

HR manager.


Default: 0

ID_SOCIETE

Int(11)


Default: 0

PARAM_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

PARAM_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

PARAM_CJM_ACTUAL

Decimal(30,10)

Actual CJM.

Candidate only


Default: 0

PARAM_CJM_MAX

Decimal(30,10)

Maximum desired CJM.

Candidate only


Default: 0

PARAM_CJM_MIN

Decimal(30,10)

Minimum desired CJM.

Candidate only


Default: 0

PARAM_COMMENTAIRE

Text

Information comments.

PARAM_COMMENTAIRE2

Text

Administrative comments.

PARAM_CONTRAT

Int(11)

Contract's type cf. key id for JSON response data.setting.typeOf.contract of API /application/dictionary

Only for candidates


Default: -1

PARAM_DATEDISPO

Date

Availability's date.

PARAM_DEVISE

Int(11)

Currency.

cf. key id for JSON response data.setting.currency of API /application/dictionary


Default: 0

PARAM_DEVISEAGENCE

Int(11)

Agency's currency.

cf. key id for JSON response data.setting.currency of API /application/dictionary


Default: 0

PARAM_MOBILITE

Text

Mobility area.

cf. key option.id for JSON response data.setting.mobilityArea of API /application/dictionary


Default: ''

PARAM_SOURCE

Varchar(100)

Source's detail.

Only for candidates


Default: ''

PARAM_TARIF1

Decimal(30,10)

  • If Resource : Average daily price excluding tax
  • If Candidate : Current salary


Default: 0

PARAM_TARIF2

Decimal(30,10)

Minimum desired salary.

Candidate only


Default: 0

PARAM_TARIF3

Decimal(30,10)

Maximum desired salary.

Candidate only


Default: 0

PARAM_TYPEDISPO

Int(11)

Availability's type.

  • If Resource :

    • 1: Available immediately (Availability is synced with project updates)
    • 2: Available after PARAM_DATEDISPO (Availability is synced with project updates)
    • 3: Available immediately (Availability is not sync with project updates)
    • 4: Available after PARAM_DATEDISPO (Availability is not synced with project updates)
  • If Candidate :


Default: 0

PARAM_TYPESOURCE

Int(11)

Source's type. cf. key id for JSON response data.setting.source of API /application/dictionary

Only for candidates


Default: -1

PROFIL_ADR

Varchar(250)

Address.


Default: ''

PROFIL_ALLOWCHANGE

Tinyint(1)

Enable or disable this resource to modify its TD from its intranet.

Resource only


Default: 0

PROFIL_CIVILITE

Int(11)

Civility.

cf. key id for JSON response data.setting.civility of API /application/dictionary.


Default: 0

PROFIL_CP

Char(10)

Postcode.


Default: ''

PROFIL_DATE

Datetime

Creation date.

PROFIL_DATEGDPR

Date

GDPR's expiration date.

PROFIL_DATELASTACTIVITY

Datetime

Last activity date.

PROFIL_DATENAISSANCE

Date

Birth date.

This property can be null.

PROFIL_DATEUPDATE

Datetime

Update date.

PROFIL_DDCA

Date

Seniority Date

This property can be null.


Default: null

PROFIL_EMAIL

Varchar(100)

Email 1.

It is used for all communication with the user.


Default: ''

PROFIL_EMAIL2

Varchar(100)

Email 2.


Default: ''

PROFIL_EMAIL3

Varchar(100)

Email 3.


Default: ''

PROFIL_ETAT

Int(11)

State :


Default: 1

PROFIL_ETATGDPR

Tinyint(1)

GDPR's state : 0 : No GDPR consent 1 : GDPR consent's obtained

PROFIL_FAX

Char(20)

Fax.


Default: ''

PROFIL_FORCEDDCA

Tinyint(1)

DDCA is forced :

  • 0 : not force
  • 1 : Force


Default: 0

PROFIL_LIEUNAISSANCE

Varchar(100)

Place of birth.


Default: ''

PROFIL_NATIONALITE

Varchar(100)

Nationality.


Default: 'France'

PROFIL_NOM

Varchar(100)

Last name.


Default: ''

PROFIL_NUMSECU

Char(21)

Social Security Number.


Default: ''

PROFIL_PAYS

Varchar(100)

Country.


Default: 'France'

PROFIL_PRENOM

Varchar(100)

First name.


Default: ''

PROFIL_REFERENCE

Varchar(250)

Reference.

Resource only


Default: ''

PROFIL_SITUATION

Int(11)

Family situation.

cf. key id for JSON response data.setting.situation of API /application/dictionary


Default: 0

PROFIL_STATE_REASON

Int(11)

End of process.


Default: 0

PROFIL_STATE_REASON_COMMENT

Text

Reason end of process.


Default: ''

PROFIL_STATUT

Varchar(100)

  • If Resource : Function/Title
  • If Candidate : Evaluation, with :


Default: ''

PROFIL_TEL1

Char(20)

Phone 1.


Default: ''

PROFIL_TEL2

Char(20)

Phone 2.


Default: ''

PROFIL_TEL3

Char(20)

Phone 3.


Default: ''

PROFIL_THUMBNAIL

Unknown

Photo (Candidate & Ressource)

This property can be null.


Default: null

PROFIL_TYPE

Int(11)

Type :

Caution : in the API, the value of 1 is reserved to design an "External resource".


Default: 0

PROFIL_TYPE_CANDIDAT

Int(11)

Type of Candidate:

Caution : in the API, the value of 1 is reserved to design an "External resource".


Default: -1

PROFIL_VALIDITYDDCA

Date

Validity date of Seniority Date

This property can be null.


Default: null

PROFIL_VILLE

Varchar(100)

Town.


Default: ''

PROFIL_VISIBILITE

Tinyint(1)

Enable/disable resource/candidate's visibility :

  • 1 : Enable
  • 0 : Disable


Default: 1