SAP ABAP Table HCMT_BSP_PA_ES_R0480_VIEW (Contract identifier according to Social Insurance)

Hierarchy

☛ EA-HRCES (Software Component) Sub component EA-HRCES of EA-HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PAOC_PAD_UI_INFTY_0016_ES (Package) Infotype 0016 user interface Spain

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_ES_R0480_VIEW	Table Relationship Diagram
Short Description	Contract identifier according to Social Insurance

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLCON	☐	PES_CLCON	PES_IDSEG	CHAR	3	0	Contract Key for Social Insurance
2	IDSEG	☐	PES_IDSEG	PES_IDSEG	CHAR	3	0	Main contract key	T5E66
3	TIDSE	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
4	.INCLUDE	☐				0	0	Part-time
5	HORAS	☐	PES_HORAS	DEC4_2	DEC	6	2	Contracts: Working hours in part-time contracts
6	UNIHO	☐	PES_UNIHO	PES_UNIHO	NUMC	1	0	Contracts: Unit for number of hours of part-time working day
7	DIAS	☐	PES_DICON	DEC3	DEC	3	0	Working days in part-time contracts
8	UNIDI	☐	PES_UNIDI	PES_UNIDI	NUMC	1	0	Contracts: Time unit for number of part-time days
9	HOFOR	☐	PES_HOFOR	DEC4_2	DEC	6	2	Training hours
10	COLEF	☐	PES_COLEF	PES_COLEF	NUMC	2	0	Training age group
11	PJUPA	☐	PES_PJUPA	PES_PJUPA	NUMC	2	0	Working time percentage, partial retirement contracts
12	CCRED	☐	PES_CCRED	PES_CCRED	CHAR	2	0	Reduction group code
13	PORRD	☐	PES_PORRD	PES_PORRD	DEC	5	2	Contribution reduction percentage
14	PORJR	☐	PES_PORJR	PES_PORJR	DEC	5	2	Percentage of contract work schedule with reduction
15	.INCLUDE	☐				0	0	Administrative data
16	REPRS	☐	PES_REPRS	PERNR	NUMC	8	0	Person responsible for hiring
17	REPRS01	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
18	MOTIF	☐	PES_MOTIVO	TEXT70	CHAR	70	0	Contract reason and/or other comments
19	COD_LOC	☐	PES_CODLOC	NUM5	NUMC	5	0	Town code according to INEM
20	ICONTE	☐	PES_ICONTE	CHAR1	CHAR	1	0	Written contract indicator
21	ALTDIR	☐	PES_ALTDIR	CHAR1	CHAR	1	0	Senior management contract indicator
22	TIPOFI	☐	PES_TIPOF	PES_TIPOF	CHAR	1	0	Basic copy signature type. Notification of contracts to INEM
23	IDOFER	☐	PES_IDOFER	CHAR17	CHAR	17	0	Offer identifier
24	IEAPU	☐	PES_IEAPU	XFELD	CHAR	1	0	Company ID
25	.INCLUDE	☐				0	0	INEM (employment office)
26	OFFIN	☐	PES_OFFIN	PES_INEM	NUMC	10	0	Spanish Office of Employment (INEM): Enrollment code	T5E70
27	TOFFI	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
28	OFFRG	☐	PES_OFFRG	PES_INEM	NUMC	10	0	Office where contract is filed	T5E70
29	TOFFR	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
30	REGNR	☐	PES_REGNR	NUM10	NUMC	10	0	Spanish Office of Employment (INEM) record number
31	FECRG	☐	PES_FECRG	DATE	DATS	8	0	INEM: Date of registration
32	ICDESP	☐	PES_ICDESP	PES_ICDESP	CHAR	1	0	Dismissal costs indicator
33	CCDESP	☐	PES_CCDESP	PES_CCDESP	NUMC	2	0	Dismissal collective code
34	CAUIN	☐	PES_CAUIN	PES_CAUIN	CHAR	1	0	Temporary status object cause code
35	TIACA	☐	PES_TIACA	CHAR12	CHAR	12	0	Academic title code
36	CONCOL	☐	PES_CONCOL	CHAR1	CHAR	1	0	Collective agreement indicator
37	NFORM	☐	PES_NFORM	PES_NFORM	NUMC	2	0	Level of training according to INEM
38	ICPRO	☐	PES_ICPRO	XFELD	CHAR	1	0	Indicator of professional standard certificate
39	CODOCU	☐	PES_CODOCU		CHAR	8	0	Work center commitment code
40	TTEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
41	COLBON	☐	PES_COLBON_NC3	PES_COLBON_NC3	CHAR	2	0	Discount group (output with 3 characters)
42	IDDISC	☐	PES_IDDISC	CHAR1	CHAR	1	0	Gap indicator
43	ACMAEX	☐	PES_ACMAEX	CHAR1	CHAR	1	0	Indicator of belonging to Maternity Leave allowance group
44	MODAEXCL	☐	PES_MOD_ATT	PES_MODALIDAD	CHAR	5	0	Category of exclusion contracts
45	.INCLUDE	☐				0	0	Printout
46	FOLNAME	☐	HR99S_FORMLOGC	HR99S_FLNAME	CHAR	30	0	Logical form name	*
47	SCOIN	☐	PES_SCOIN		CHAR	40	0	INEM contract print status
48	.INCLUDE	☐				0	0	Contract
49	STACOM	☐	PES_STACOM	PES_STACOM	CHAR	1	0	Status of contracts communication to employment office
50	IDCONTR	☐	PES_CODIDCONTR		CHAR	14	0	Employment office contract identifier
51	FECCOM	☐	PES_FECCOM	DATS	DATS	8	0	Date of communication
52	LEGBON	☐	PES_LEGBON	NUM02	NUMC	2	0	Legislation applying to the right to bonuses
53	LEGFOM	☐	PES_LEGFOM	NUM02	NUMC	2	0	Law promoting indefinate term contracts
54	USUCOM	☐	PES_USACOM	CHAR10	CHAR	10	0	User making the communication
55	FECABD	☐	PES_FECABD	DATS	DATS	8	0	Entry date on employment office database
56	FEGENV	☐	PES_FEGENV	DATS	DATS	8	0	Date the notification send was generated
57	HOGENV	☐	PES_HOGENV		TIMS	6	0	Time (HHMMSS) the notification send was generated
58	PERCR	☐	PES_PERCR	PERSNO	NUMC	8	0	Relief contract person	*
59	.INCLUDE	☐				0	0	Extension
60	STACOP	☐	PES_STACOM	PES_STACOM	CHAR	1	0	Status of contracts communication to employment office
61	NUMPRO	☐	PES_NUMPRO	NUM2	NUMC	2	0	Extension sequential number
62	FECCOP	☐	PES_FECCOM	DATS	DATS	8	0	Date of communication
63	USUCOP	☐	PES_USACOM	CHAR10	CHAR	10	0	User making the communication
64	FEABDP	☐	PES_FECABD	DATS	DATS	8	0	Entry date on employment office database
65	IPADU	☐	PES_IPADU	XFELD	CHAR	1	0	Duration authorization indicator
66	.INCLUDE	☐				0	0	Basic Copy
67	OBLCB	☐	PES_OBLCB	PES_OBLCB	CHAR	1	0	Obligatory to present basic copy to employment office
68	STACOC	☐	PES_STACOM	PES_STACOM	CHAR	1	0	Status of contracts communication to employment office
69	FECCOC	☐	PES_FECCOM	DATS	DATS	8	0	Date of communication
70	USUCOC	☐	PES_USACOM	CHAR10	CHAR	10	0	User making the communication
71	.INCLUDE	☐				0	0	Call up
72	MLLAM	☐	PES_MLLAM	PES_MLLAM	CHAR	2	0	Call Up Type
73	STACOL	☐	PES_STACOM	PES_STACOM	CHAR	1	0	Status of contracts communication to employment office
74	FECCOL	☐	PES_FECCOM	DATS	DATS	8	0	Date of communication
75	USUCOL	☐	PES_USACOM	CHAR10	CHAR	10	0	User making the communication
76	IDLLAM	☐	PES_IDLLAM	PES_IDLLAM	CHAR	12	0	Calling identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_ES_R0480_VIEW	IDSEG	T5E66	IDSEG
2	HCMT_BSP_PA_ES_R0480_VIEW	OFFIN	T5E70	COOFF
3	HCMT_BSP_PA_ES_R0480_VIEW	OFFRG	T5E70	COOFF

History

Last changed by/on	SAP	20130529
SAP Release Created in	100