columns: c_avantage_nature: type: numeric default: "1" c_base: type: numeric default: "1" c_brut: type: numeric default: "1" c_cotisation_patronale: type: numeric default: "1" c_cotisation_salarie: type: numeric default: "1" c_frais_imposables: type: numeric default: "1" c_heures_contrat: type: numeric default: "1" c_heures_payees: type: numeric default: "1" c_heures_travaillees: type: numeric default: "1" c_masse_salariale: type: numeric default: "1" c_masse_salariale_provisionnee: type: numeric default: "1" c_montant_provisions: type: numeric default: "1" c_net_a_payer: type: numeric default: "1" c_net_imposable: type: numeric default: "1" c_nombre: type: numeric default: "1" c_nombre_provisions: type: numeric default: "1" c_od_net_patronale: type: numeric default: "1" c_od_net_salarie: type: numeric default: "1" chapitre_bulletin: type: character(1) code: type: character varying(30) default: "''::character varying" code_calcul: type: character(2) default: "0" comment: | * 0 : par défaut * 1 : heures payées * 2 : heures non travaillées code_original: type: text not_null: NOT NULL coefficient: type: numeric(5,2) default: "1" comment: Lorsque la rubrique est exprimé dans une autre unité que les heures, coefficient à appliquer à la rubrique pour obtenir des heures. coefficient_base: type: numeric default: "1" coefficient_nombre: type: numeric default: "1" coefficient_txp: type: numeric default: "1" coefficient_txs: type: numeric default: "1" heures_payees: type: character(1) default: "0" comment: "1" si rubrique correspondant à des heures payées, "0" sinon (par défaut). oid: type: bigint not_null: NOT NULL default: "nextval('s_rubriques'::regclass)" p_avantage_nature: type: boolean default: 'false' p_base: type: boolean default: 'false' p_brut: type: boolean default: 'false' p_cotisation_patronale: type: boolean default: 'false' p_cotisation_salarie: type: boolean default: 'false' p_cumul: type: boolean default: 'false' p_detail: type: boolean default: 'false' p_frais_imposables: type: boolean default: 'false' p_heures_contrat: type: boolean default: 'false' p_heures_payees: type: boolean default: 'false' p_heures_travaillees: type: boolean default: 'false' p_masse_salariale: type: boolean default: 'false' p_masse_salariale_provisionnee: type: boolean default: 'false' p_montant_provisions: type: boolean default: 'false' p_net_a_payer: type: boolean default: 'false' p_net_imposable: type: boolean default: 'false' p_nombre: type: boolean default: 'false' p_nombre_provisions: type: boolean default: 'false' p_od_net_patronale: type: boolean default: 'false' p_od_net_salarie: type: boolean default: 'false' proratiser_conversion: type: boolean default: 'true' comment: Proratiser la conversion jour vers heures selon le type de temps de travail. rang_edition: type: numeric(9,0) s_avantage_nature: type: smallint default: "3" s_base: type: smallint default: "1" s_brut: type: smallint default: "3" s_cotisation_patronale: type: smallint default: "5" s_cotisation_salarie: type: smallint default: "3" s_frais_imposables: type: smallint default: "3" s_heures_contrat: type: smallint default: "0" s_heures_payees: type: smallint default: "0" s_heures_travaillees: type: smallint default: "0" s_masse_salariale: type: smallint default: "5" s_masse_salariale_provisionnee: type: smallint default: "0" s_montant_provisions: type: smallint default: "0" s_net_a_payer: type: smallint default: "3" s_net_imposable: type: smallint default: "3" s_nombre: type: smallint default: "0" s_nombre_provisions: type: smallint default: "0" s_od_net_patronale: type: smallint default: "5" s_od_net_salarie: type: smallint default: "3" section_code: type: 'text[]' section_id: type: 'bigint[]' section_texte: type: 'text[]' texte: type: character varying(255) texte_court: type: character varying(50) unite: type: character(1) default: "0" comment: | * 0 : heures (par défaut) * 1 : autre (jours, mois, ...) user_modified: type: boolean default: 'false' constraints: t_rubriques_pkey: type: PRIMARY KEY column: oid t_rubriques_ukey: type: UNIQUE column: code_original