T5FDSNCT - Temp table for PAYFR_RESULT-CT

Temp table for PAYFR_RESULT-CT information is stored in SAP table T5FDSNCT.
It is part of development package P06_DSN in software component PY-FR. This development package consists of objects that can be grouped under "Package for Nominative Social Declaration (DSN)".

Fields for table T5FDSNCT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
PERNR	Personnel Number	X	P_PERNR	NUMC	16
FPPER	For-Period for Payroll (YYYYMM)	X	FAPER	CHAR	12
FPBEG	Start date of payroll period (FOR period)	X	FPBEG	DATS	16
FPEND	End of payroll period (for-period)	X	FPEND	DATS	16
INPER	In-period for payroll	X	IPERI	CHAR	12
IPEND	End of payroll period (IN period)	X	IPEND	DATS	16
NUMCT	Payroll: Split for contracts	X	P06_PY_NUM_CONTRACT	RAW	1
.INCLUDE	DATA			HRPAYFR_S_PY_CT_DATA	0
GRCT1	Grouping table CT 1 (Link to table REM)		P06_PY_GROUPING_CT_1	NUMC	8
GRCT2	Grouping table CT 2 (Reporting DSN, Block 40 Generation)		P06_PY_GROUPING_CT_2	NUMC	8
UIDCT	Payroll: Unique contract ID		P06_PY_UNIQUE_ID_CONTRACT	CHAR	66
BEGDA	Start Date		BEGDA	DATS	16
ENDDA	End Date		ENDDA	DATS	16
AKTIVJN	Indicator: Active		AKTIVJN	CHAR	2
SPKEY	Payroll: Split key		P06_PY_SPLIT_KEY	CHAR	100
WERKS	Personnel Area		PERSA	CHAR	8	*
BTRTL	Personnel Subarea		BTRTL	CHAR	8	*
ANSVH	Work Contract		ANSVH	CHAR	4	*
CTTYP	Contract Type		CTTYP	CHAR	4	*
MODAL	Special Type of Contract		P06_MODAL	CHAR	4
CODEB	Payroll: Contract start date		P06_PY_DATE_BEGDA_CONTRACT	DATS	16
COFIN	Payroll: Contract end date		P06_PY_DATE_ENDDA_CONTRACT	DATS	16
COSIR	Work place identifier		P06_CONTRAT_ID_LIEU_TRAVAIL	CHAR	28	*
CONUM	Payroll: Contrat number		P06_PY_NUMERO_CONTRAT	CHAR	66
COSTA	Payroll: Employee status (pay scale dependent)		P06_PY_STATCATEG	CHAR	8
COAGI	Payroll: Mandatory categorical compl. retirement status code		P06_PY_STATCATEG_AGIRC	CHAR	8
CONAT	Payroll: Nature of contract		P06_PY_NATURE_CONTRAT	CHAR	8
COINT	Payroll: Public political facility		P06_PY_CD_INTITULE_CONTRAT	CHAR	8
COUMQ	Payroll: Unit of measure for quota		P06_PY_UNITE_QUOTITE	CHAR	8
COQTC	Work contract work amount		P06_PY_QUOTITE_CONTRAT	DEC	8
COMEX	Payroll: Exercise modality of employment contract		P06_PY_MODALITE_CONTRAT	CHAR	8
COSAL	Payroll: Reference salary carried by the contract		P06_PY_SALAIRE_REF_CONTRAT	CURR	8
WAERS	Currency Key		WAERS	CUKY	10	*
COALS	Payroll: Local scheme for Alsace Moselle		P06_PY_REGIME_ALSACE	CHAR	8
COCOL	DADS-U: Collective agreement indicator		P06_PY_CD_CONV_COLLECTIVE	CHAR	8
COASI	SIRET Number		P06_SIRET	CHAR	28	*
COMRE	Employment contract: Reason for recourse to a CDD		P06_CONTRAT_MOTIF_RECOURS_CDD	CHAR	4
COTDF	Payroll: Contribution rate		P06_PY_TAUX	DEC	3
COSTE	Payroll: Status abroad		P06_PY_STATUS_ETRANGER	CHAR	8
COCSP	PCS code: Nomenclature of professions and socio. categories		P06_PCS	CHAR	8	*
COPCS	PCS supplement		P06_CCPCS	CHAR	12
COQTR	Payroll: Reference work quota lot of company		P06_PY_QUOTITE_REF	DEC	8
COCCP	Payroll: Professional paid leave fund code		P06_PY_CD_CAISSE_PROF_CONGE_P	CHAR	8
COROB	Payroll: Mandatory sickness plan code		P06_PY_CD_REGIME_MALADIE	CHAR	8
CORIS	Payroll: Basic old age pension scheme code		P06_PY_CD_RISQUE_VIEILLESSE	CHAR	8
COEXC	Payroll: Reason of exclusion DSN		P06_PY_CD_DSN_MOTIF_EXCL	CHAR	8
COEST	Payroll: Employee employment status		P06_PY_CD_COEST	CHAR	8
COASC	Payroll: Unemployment insurance assgnmnt cde S21.G00.40.027		P06_PY_CD_COASC	CHAR	16
CONEP	Payroll: Internal number for public employer		P06_PY_NUM_CONEP	CHAR	32
COGAC	Payroll: Type of unemployment insurance management		P06_PY_CD_COGAC	CHAR	8
CODAD	Payroll: Date of signing		P06_PY_DATE_CODAD	DATS	16
CODDE	Payroll: Date of termination		P06_PY_DATE_CODDE	DATS	16
CODEC	Payroll: Date of effect of management convention		P06_PY_DATE_CODEC	DATS	16
CONCG	Payroll: Number of management convention		P06_PY_NUM_CONCG	CHAR	24
COEFF	Payroll: staff indicator		P06_PY_CD_EFFECTIVE	CHAR	2
COFIP	Payroll: Planned contract end date		P06_PY_DATE_PRE_ENDDA_CONTRACT	DATS	16
CORSA	Payroll: Industrial accident risk code		P06_PY_CODRIS	CHAR	16
COSCA	Payroll: APECITA category status indicator		P06_PY_STAT_CAT_APECITA	CHAR	8
COSTP	Payroll: Part-time employee contributing at full-time rate		P06_PY_SAL_COT_TPS_PLEIN	CHAR	8
REALB	Trainee working on actual basis		P06_PY_TRAINEE_REAL_BASE	CHAR	2
COTAT	Industrial accident contribution rate		P06_PY_DSN_TAUX_AT	DEC	4
COCCL	Payroll: Professional paid leave fund indicator		P06_PY_CD_CAISSE_PROF_CONGE_PL	CHAR	60
PPERI	Customary period for the payment of remuneration		P06_PY_PAYMENT_PERIODICITY	CHAR	8
ABARE	Payroll: rate, exemption condition result		P06_PY_BAREME_ABATTEMENT_COND	CHAR	2
PASEX	Payroll: DS, exemption condition result		P06_PY_PAS_EXEMPTION_COND	CHAR	2
.INCLUDE	P19V01			HRPAYFR_S_PY_CTT_DATA_P19V01	0
CDSEC			P06_PY_CODE_SECTEUR	CHAR	4
COFPP			P06_PY_FP_COMP_PCS_NNE	CHAR	8
CONPO			P06_PY_FP_NAT_POSTE	CHAR	4
COQTT			P06_PY_NBHRS_FP_QUOT_TRAV	DEC	4
COTTP	Payroll: Rate of part-time employment		P06_PY_RATE_TAUX_TRAV_TPART	DEC	4
COCCS			P06_PY_FP_CCAT_SERV	CHAR	4
COCIB			P06_PY_FP_IND_BRUT	CHAR	8
COCIM			P06_PY_RATE_FP_IND_MAJ	DEC	3
CONBI	Payroll: [FP] New Grading Bonus Payment (NBI)		P06_PY_NUM_FP_NOUV_BONI_IND	DEC	5
COIBO			P06_PY_FP_IND_BRUT_ORI	CHAR	8
COIES			P06_PY_FP_IND_BRUT_ES	CHAR	8
COIBG			P06_PY_FP_ANC_EMPLOYEUR_PUBLIC	CHAR	4
COIBP			P06_PY_FP_IND_BRUT_ORI_EMPL	CHAR	8
COIBS			P06_PY_FP_IND_BRUT_SPP	CHAR	8
COMTC			P06_PY_FP_MAINT_ORIG_CT	CHAR	8
ABARD	Payroll: rate, exemption condition date		P06_PY_BAREME_ABATTEMENT_DATE	DATS	16
TDETA			P06_PY_FP_TYPE_DETACHEMENT	CHAR	4
COTSA	Payroll: Active service rate		P06_PY_DSN_COTSA	DEC	4
CONRX	Payroll: Remuneration level		P06_PY_DSN_CONRX	CHAR	10
COECH	Payroll: Pay Scale Level		P06_PY_DSN_COECH	CHAR	8
COCOH	Payroll: hierarc. factor		P06_PY_DSN_COCOH	DEC	4
COGEN	Payroll: Navigation type		P06_PY_DSN_COGEN	CHAR	8
COSBO	Payroll: BOETH status		P06_PY_DSN_COSBO	CHAR	8
COCDP	Payroll: Additional Public Policy Measure		P06_PY_DSN_COCDP	CHAR	8
CODEI	Paie: Case of extern. provision of person assign. to workpl.		P06_PY_DSN_CODEI	CHAR	8
COCCF	Payroll: final assignment to wage group category		P06_PY_DSN_COCCF	CHAR	8
COCRM	Payroll: Depreciated		P06_PY_DSN_COCRM	CHAR	10
CORVI	Payroll: Depreciated		P06_PY_DSN_CORVI	CHAR	10
COIEM	Payroll: Marine committment contract ID		P06_PY_DSN_COIEM	CHAR	66
COIEG	Payroll: Labor dispute group (CNIEG)		P06_PY_DSN_COIEG	CHAR	8
COTAP	Payroll: working time during part-time employment		P06_PY_DSN_COTAP	CHAR	8
COXXX	Payroll: Depreciated		P06_PY_DSN_DEPREC	CHAR	8
PACRE	DS: Income Class 50.014		P06_PY_PAS_CD_EARNING_CLASS	CHAR	6
COEMM	Payroll: Concurrent employment code		P06_PY_COEMM	CHAR	8
COERM	Payroll: Concurrent employment code		P06_PY_COERM	CHAR	8
CORAT	Payroll: Code for Compulsory work accident plan		P06_PY_CORAT	CHAR	8
COPCC	Payroll: Position. collective agreement		P06_PY_COPCC	CHAR	200
COCO2	Payroll: Hierarchical Factor 40.071		P06_PY_DSN_COCO2	CHAR	20
COGRA	Payroll: Grade 40.079		P06_PY_DSN_CONTRAT_GRADE	CHAR	16
COCTI	Payroll: [FP] Index CTI 40.080		P06_PY_DSN_CONTRAT_CTI	CHAR	8
COFGE	Payroll: Geographical FINESS No 40.081		P06_PY_DSN_CO_FINESSGEOGRAPHI	CHAR	40