TAB_CONTRAT Class
Contract.
Properties
- CTR_AVANTAGES
- CTR_CATEGORIE
- CTR_CHANGE
- CTR_CHANGEAGENCE
- CTR_CHARGE
- CTR_CJMCONTRAT
- CTR_CJMPRODUCTION
- CTR_CLASSIFICATION
- CTR_COMMENTAIRES
- CTR_CREATEDAT
- CTR_DATEPE1
- CTR_DATEPE2
- CTR_DEBUT
- CTR_DEVISE
- CTR_DEVISEAGENCE
- CTR_DUREEHEBDOMADAIRE
- CTR_ETAT_PE
- CTR_FIN
- CTR_FORCECJMPRODUCTION
- CTR_FORCESALAIREHEURE
- CTR_FRSJOUR
- CTR_FRSMENSUEL
- CTR_MOTIF_FIN_CONTRAT
- CTR_NBJRSOUVRE
- CTR_REGLESTEMPSEXCEPTION
- CTR_SALAIREHEURE
- CTR_SALAIREMENSUEL
- CTR_TPSTRAVAIL
- CTR_TYPE
- CTR_UPDATEDAT
- ID_CONTRAT
- ID_CREATOR
- ID_PARENT
- ID_PROFIL
- ID_SOCIETE
CTR_AVANTAGES
TextList of advantages.
Each advantage is described by :
- Reference : cf. TAB_TYPEAVANTAGE.TYPEA_REF
- Frequency : cf. TAB_TYPEAVANTAGE.TYPEA_TYPE
- Category : cf. TAB_TYPEAVANTAGE.TYPEA_CATEGORIE
- Participation amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTAPARTICIPATION
- Employee amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTARESSOURCE
- Agency amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTASOCIETE
- Reference, frequency, category, participation amount, employee amount, agency amount are listed in this order and separated by
|
character
Advantages are separated by #
character.
CTR_CATEGORIE
Int(11)Employee's type.
cf. key id for JSON response data.setting.typeOf.employee of API /application/dictionary
Default: -1
CTR_CLASSIFICATION
Varchar(250)Classification.
cf. key id for JSON response data.setting.classification of API /application/dictionary
Default: ''
CTR_DEVISE
Int(11)Currency.
cf. key id for JSON response data.setting.currency of API /application/dictionary
Default: 0
CTR_DEVISEAGENCE
Int(11)Agency's currency.
cf. key id for JSON response data.setting.currency of API /application/dictionary
Default: 0
CTR_ETAT_PE
SmallintPractice period state.
cf. key id for JSON response data.setting.state.probation of API /application/dictionary
Default: 0
CTR_FORCECJMPRODUCTION
Tinyint(1)Enable/disable to manually define CTR_CJMPRODUCTION :
1
: Enable0
: Disable_, CTR_CJMPRODUCTION = CTR_CJMCONTRAT_
Default: 0
CTR_FORCESALAIREHEURE
Tinyint(1)Enable/disable to manually define CTR_SALAIREHEURE :
1
: Enable0
: Disable
Default: 0
CTR_REGLESTEMPSEXCEPTION
TextList of exceptional scales.
Each scale is described by :
- Scale information :
- Unique identifier : cf. TAB_GROUPECONFIG.GRPCONF_BAREMESEXCEPTION
0
- Agency's identifier : cf. TAB_GROUPECONFIG.ID_SOCIETE
- Unique identifier,
0
& agency's identifier are listed in this order and separated by_
character
- List of rules :
- Each rule is described by :
- Reference : TAB_REGLEEXCEPTION.REGLE_REF, with TAB_REGLEEXCEPTION.REGLE_BAREMEREF =
Scale's unique identifier
& TAB_REGLEEXCEPTION.PARENT_TYPE =Entity's type
& TAB_REGLEEXCEPTION.ID_PARENT =Entity's identifier
- Price excluding tax or price rate : If
not empty
then replace TAB_REGLEEXCEPTION.REGLE_TARIF
- Reference : TAB_REGLEEXCEPTION.REGLE_REF, with TAB_REGLEEXCEPTION.REGLE_BAREMEREF =
- Gross cost or salary rate : If
not empty
then replace TAB_REGLEEXCEPTION.REGLE_COUT- Reference, Price excluding tax or price rate & Gross cost or salary rate are listed in this order and separated by
_
character
- Reference, Price excluding tax or price rate & Gross cost or salary rate are listed in this order and separated by
- Rules are separated by
|
character
- Each rule is described by :
- Scale information & Liste of rules are listed in this order and separated by
|
character - Price excluding tax or price rate & Gross cost or salary rate can not be both
empty
Scales are separated by #
character.
Example:
"1_0_1#2_0_1|2|100|"
CTR_TPSTRAVAIL
Int(11)Working time's type.
cf. key id for JSON response data.setting.typeOf.workingTime of API /application/dictionary
Default: -1
CTR_TYPE
Int(11)Type.
cf. key id for JSON response data.setting.typeOf.contract of API /application/dictionary
Default: 0