TAB_PROFIL Class
Resource or candidate.
Properties
- ID_CREATOR
- ID_CRMCONTACT
- ID_CRMSOCIETE
- ID_DT
- ID_EMBAUCHE
- ID_POLE
- ID_PROFIL
- ID_RESPMANAGER
- ID_RESPRH
- ID_SOCIETE
- PARAM_CHANGE
- PARAM_CHANGEAGENCE
- PARAM_CJM_ACTUAL
- PARAM_CJM_MAX
- PARAM_CJM_MIN
- PARAM_COMMENTAIRE
- PARAM_COMMENTAIRE2
- PARAM_CONTRAT
- PARAM_DATEDISPO
- PARAM_DEVISE
- PARAM_DEVISEAGENCE
- PARAM_MOBILITE
- PARAM_SOURCE
- PARAM_TARIF1
- PARAM_TARIF2
- PARAM_TARIF3
- PARAM_TYPEDISPO
- PARAM_TYPESOURCE
- PROFIL_ADR
- PROFIL_ALLOWCHANGE
- PROFIL_CIVILITE
- PROFIL_CP
- PROFIL_CREATIONSOURCE
- PROFIL_DATE
- PROFIL_DATE_LASTPARSING
- PROFIL_DATEGDPR
- PROFIL_DATELASTACTIVITY
- PROFIL_DATENAISSANCE
- PROFIL_DATEUPDATE
- PROFIL_DDCA
- PROFIL_DEPARTURE_CAPPED
- PROFIL_DEPARTURE_DATE
- PROFIL_EMAIL
- PROFIL_EMAIL2
- PROFIL_EMAIL3
- PROFIL_ETAT
- PROFIL_ETATGDPR
- PROFIL_FAX
- PROFIL_FORCEDDCA
- PROFIL_FORECAST_DATEDISPO
- PROFIL_FORECAST_NEXT_MISSION_DATE
- PROFIL_FORECAST_OCCUPATION_RATE
- PROFIL_IC_SINCE
- PROFIL_IC_STATUS
- PROFIL_LIEUNAISSANCE
- PROFIL_MODEL
- PROFIL_NATIONALITE
- PROFIL_NEXT_MISSION_DATE
- PROFIL_NOM
- PROFIL_NUMSECU
- PROFIL_OCCUPATION_RATE
- PROFIL_PAYS
- PROFIL_PRENOM
- PROFIL_REAL_DATEDISPO
- PROFIL_REFERENCE
- PROFIL_SHIELD
- PROFIL_SITUATION
- PROFIL_STATE_REASON
- PROFIL_STATE_REASON_COMMENT
- PROFIL_STATUT
- PROFIL_SUBDIVISION
- PROFIL_TEL1
- PROFIL_TEL2
- PROFIL_TEL3
- PROFIL_THUMBNAIL
- PROFIL_TYPE
- PROFIL_VALIDITYDDCA
- PROFIL_VILLE
- PROFIL_VISIBILITE
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_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
TextMobility area.
cf. key option.id for JSON response data.setting.mobilityArea of API /application/dictionary
Default: ''
PARAM_TARIF1
Decimal(30,10)- If Resource or standardprofile : Average daily price excluding tax
- If Candidate : Current salary
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 :
9: Available after PARAM_DATEDISPO-1: Not defined- or cf. key id for JSON response data.setting.availability of API /application/dictionary
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_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_CREATIONSOURCE
Varchar(20)Creation source. Tracks how the entity was created. Possible values: 'manual', 'import_csv', 'linkedin', 'api', 'other'. NULL for legacy data.
Default: NULL
PROFIL_DATE_LASTPARSING
DatetimeLast resume parsing submission date (CV → DT). Set at dispatch time (batch or task) to ensure idempotence. Refreshed after a successful ParseProfileResume task.
This property can be null.
Default: null
PROFIL_DEPARTURE_CAPPED
Tinyint(1)Whether the scheduled departure caps the availability (BM-57531): availability including forecast falls after PROFIL_DEPARTURE_DATE, or is unknown. Precomputed because a Solr filter query cannot compare two fields with each other.
Only for resources
Default: 0
PROFIL_DEPARTURE_DATE
DateScheduled departure date (BM-57531): MAX(CTR_FIN) of the resource contracts, null as soon as one contract has no end date (open-ended contract, hence no planned departure).
Only for resources
Default: null
PROFIL_ETAT
Int(11)State :
- If Resource : Resource's state_, cf. key id for JSON response data.setting.state.resource of API /application/dictionary_
- If Candidate : Candidate's state_, cf. key id for JSON response data.setting.state.candidate of API /application/dictionary_
Default: 1
PROFIL_FORECAST_DATEDISPO
DateAvailability date including forecast (unsigned) deliveries (BM-57531). Same rule as PROFIL_REAL_DATEDISPO but forecast deliveries are taken into account. This is the date compared to the "soon available" threshold, so it drives the badge label.
Only for resources
Default: null
PROFIL_FORECAST_NEXT_MISSION_DATE
DateStart date of the next delivery, forecast (unsigned) ones included (BM-57531). Only filled when the resource is free today.
Only for resources
Default: null
PROFIL_FORECAST_OCCUPATION_RATE
Tinyint(3) unsignedToday's occupation rate including forecast (unsigned) deliveries (BM-57531). A value above PROFIL_OCCUPATION_RATE means today's occupation partly relies on an unsigned delivery, which the badge reports as an anomaly.
Only for resources
Default: null
PROFIL_NEXT_MISSION_DATE
DateStart date of the next signed delivery (BM-57531). Only filled when the resource is free today, the information being meaningless otherwise.
Only for resources
Default: null
PROFIL_OCCUPATION_RATE
Tinyint(3) unsignedToday's occupation rate, in percent, computed from signed deliveries only (BM-57531). Leaves do not count here: they block availability without adding to the rate. 100 means fully staffed.
Only for resources
Default: null
PROFIL_REAL_DATEDISPO
DateAuto/reference availability date (BM-56382): end of last delivery + 1 day, else hiring date (even past), else null. Independent of any manually forced availability. Drives the availability badge and the "Disponibilité" filter/sort regardless of a forced date.
Only for resources
Default: null
PROFIL_SHIELD
Tinyint(1)Shield status for conditional fields validation.
Indicates the completion level based on conditional fields rules:
0: Uncomplete - Required fields are missing1: Minimum - Required fields OK, recommended fields missing2: Complete - All conditional fields are filled
Default: 0
PROFIL_SITUATION
Int(11)Family situation.
cf. key id for JSON response data.setting.situation of API /application/dictionary
Default: 0
PROFIL_STATUT
Varchar(100)- If Resource : Function/Title
- If Candidate : Evaluation, with :
-1: Not defined- or cf. key id for JSON response data.setting.evaluation of API /application/dictionary
Default: ''
PROFIL_TYPE
Int(11)Type :
cf. key id for JSON response data.setting.typeOf.resource of API /application/dictionary
Caution : in the API, the value of 1 is reserved to design an "External resource".
Default: 0