P2RF_CTT

Payroll results: contracts | #transactional | Component: France
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
💲 Currency Key (T500C.WAERS):
COSAL Payroll: Reference salary carried by the contract
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
CODEB Payroll: Contract start date
COFIN Payroll: Contract end date
CODAD Payroll: Date of signing
CODDE Payroll: Date of termination
CODEC Payroll: Date of effect of management convention
COFIP Payroll: Planned contract end date
ABARD Payroll: rate, exemption condition date
Column Name Description
AKTIVJN Indicator: Active Show values
MODAL Special Type of Contract Show values
COMRE Employment contract: Reason for recourse to a CDD Show values
COEFF Payroll: staff indicator Show values
REALB Trainee working on actual basis Show values
PPERI Customary period for the payment of remuneration Show values
ABARE Payroll: rate, exemption condition result Show values
PASEX Payroll: DS, exemption condition result Show values
Column Name Description Domain name
NUMCT CT split RAW1
GRCT1 Grouping table CT 1 (Link to table REM) NUMC4
GRCT2 Grouping table CT 2 (Reporting DSN, Block 40 Generation) NUMC4
UIDCT Payroll: Unique contract ID P06_PY_UNIQUE_ID_CONTRACT
SPKEY Payroll: Split key CHAR50
WERKS Personnel Area PERSA
BTRTL Personnel Subarea BTRTL
ANSVH Work Contract ANSVH
CTTYP Contract Type CTTYP
COSIR Work place identifier VDSK1
CONUM Payroll: Contrat number
COSTA Payroll: Employee status (pay scale dependent) CHAR4
COAGI Payroll: Mandatory categorical compl. retirement status code CHAR4
CONAT Payroll: Nature of contract CHAR4
COINT Payroll: Public political facility CHAR4
COUMQ Payroll: Unit of measure for quota P06_PY_UNITE_QUOTITE
COQTC Work contract work amount PRANZHL
COMEX Payroll: Exercise modality of employment contract
COALS Payroll: Local scheme for Alsace Moselle
COCOL DADS-U: Collective agreement indicator CHAR4
COASI SIRET Number VDSK1
COTDF Payroll: Contribution rate P06_PY_TAUX
COSTE Payroll: Status abroad
COCSP PCS code: Nomenclature of professions and socio. categories P06_PCS
COPCS PCS supplement P06_CCPCS
COQTR Payroll: Reference work quota lot of company PRANZHL
COCCP Payroll: Professional paid leave fund code
COROB Payroll: Mandatory sickness plan code
CORIS Payroll: Basic old age pension scheme code
COEXC Payroll: Reason of exclusion DSN
COEST Payroll: Employee employment status
COASC Payroll: Unemployment insurance assgnmnt cde S21.G00.40.027
CONEP Payroll: Internal number for public employer
COGAC Payroll: Type of unemployment insurance management
CONCG Payroll: Number of management convention
CORSA Payroll: Industrial accident risk code
COSCA Payroll: APECITA category status indicator
COSTP Payroll: Part-time employee contributing at full-time rate
COTAT Industrial accident contribution rate DEC4_3
COCCL Payroll: Professional paid leave fund indicator
CDSEC null
COFPP null
CONPO null
COQTT null DEC4_2
COTTP Payroll: Rate of part-time employment DEC4_2
COCCS null
COCIB null P06_PY_FP_IND_BRUT
COCIM null DEC4
CONBI Payroll: [FP] New Grading Bonus Payment (NBI) DEC6_2
COIBO null P06_PY_FP_IND_BRUT
COIES null P06_PY_FP_IND_BRUT
COIBG null
COIBP null P06_PY_FP_IND_BRUT
COIBS null P06_PY_FP_IND_BRUT
COMTC null
TDETA null
COTSA Payroll: Active service rate DEC4_2
CONRX Payroll: Remuneration level CHAR5
COECH Payroll: Pay Scale Level CHAR4
COCOH Payroll: hierarc. factor P06_DEC5_2
COGEN Payroll: Navigation type CHAR4
COSBO Payroll: BOETH status CHAR4
COCDP Payroll: Additional Public Policy Measure CHAR4
CODEI Paie: Case of extern. provision of person assign. to workpl. CHAR4
COCCF Payroll: final assignment to wage group category CHAR4
COCRM Payroll: Depreciated CHAR5
CORVI Payroll: Depreciated CHAR5
COIEM Payroll: Marine committment contract ID
COIEG Payroll: Labor dispute group (CNIEG) CHAR4
COTAP Payroll: working time during part-time employment CHAR4
COXXX Payroll: Depreciated CHAR4
PACRE DS: Income Class 50.014 CHAR3
COEMM Payroll: Concurrent employment code CHAR4
COERM Payroll: Concurrent employment code CHAR4
CORAT Payroll: Code for Compulsory work accident plan
COPCC Payroll: Position. collective agreement
COCO2 Payroll: Hierarchical Factor 40.071
COGRA Payroll: Grade 40.079
COCTI Payroll: [FP] Index CTI 40.080 P06_PY_FP_IND_CTI
COFGE Payroll: Geographical FINESS No 40.081 P06_DSN_CD_20