SAP Table HCMT_BSP_PA_ES_R0480_SUB_C

INEM (employment office)

HCMT_BSP_PA_ES_R0480_SUB_C (INEM (employment office)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link HCMT_BSP_PA_ES_R0480_SUB_C to other SAP tables.

HCMT_BSP_PA_ES_R0480_SUB_C table fields

Field Data element Checktable Datatype Length Decimals
OFFIN Spanish Office of Employment (INEM): Enrollment code PES_OFFIN T5E70 NUMC 10 0
TOFFI Text (30 Characters) TEXT30 CHAR 30 0
OFFRG Office where contract is filed PES_OFFRG T5E70 NUMC 10 0
TOFFR Text (30 Characters) TEXT30 CHAR 30 0
REGNR Spanish Office of Employment (INEM) record number PES_REGNR NUMC 10 0
FECRG INEM: Date of registration PES_FECRG DATS 8 0
ICDESP Dismissal costs indicator PES_ICDESP CHAR 1 0
1 The contract complies with the Employment Promotion Act
2 The contract does not comply
3 Royal Decree-Law 10/2010
4 35 / 2010 Act
CCDESP Dismissal collective code PES_CCDESP NUMC 2 0
01 Young persons between 18 to 30
02 Persons over 45
03 Unemployed persons registered uo for 12 months or more
04 Challenged persons
05 Not in legal framework
06 Young persons between 16 and 30, both inclusive
07 Unemployed women empl. < employment rate
08 Unemployed persons registered ue 6 months or more
09 Conversion to permanent covering dismissal
10 Unemployed persons registered eo 3 more months
11 Unemployed persons only w/fixed-term contract last two 2 yrs
12 Unemployed persons with permanent cont. expired last 2 years
13 Conversion with dismissal, until 31-12-2010
14 Conversion with dismissal, until 31-12-2011
15 Unemployed workers registered in EO during one or more mo.
16 Unemployed women sec. 3.2a) of the 23/2010 Act
17 Source contract with reduction RDL 1/2011
18 Temporary contract started up to 28-08-2011
19 Temporary contract started as of 28-08-2011
CAUIN Temporary status object cause code PES_CAUIN CHAR 1 0
A Employee entitled to job reservation
B Employee maternity without quota bonus
C Parental leave recipient prepared
D Parental leave recipient not prepared
E Employee selection process/promotion
F Maternity with quota bonus
G Adoption
H Fostering
I Risk during pregnancy
J Worker in training prepare recipient
K Challenged people unemployed due to temp. incapacity
L Benefit payments for leave absence for family care reasons
M Substitution of gender violence victims
N Paternity
O Risk during natural post-natal care
TIACA Academic title code PES_TIACA CHAR 12 0
CONCOL Collective agreement indicator PES_CONCOL CHAR 1 0
NFORM Level of training according to INEM PES_NFORM NUMC 2 0
11 Incomplete primary education
22 1st stage ESO without school certificate or equivalent
23 1st stage ESO with school certificate or equivalent
32 High school
33 Medium vocational training (FP) in Arts, design, sports
51 Superior vocational training (FP) equiv. Arts and design
54 With general degree or 3 years of study
55 With honours degree or equivalent (2nd cycle)
61 University doctorate
80 Without school certificate
59 University undergraduate studies
60 University post-graduate studies
12 Primary education completed
21 Pr.tr./labor int. not req. 1st stage Secondary ed.AQ(+300 h)
31 Pr. tr./labor int. req. 1st stage Secondary educ. AQ (+300h)
34 Middle grade education in music and dance
41 Pr. tr./labor int. req. 2nd stage Secondary educ. AQ (+300h)
52 University degrees/other secondary education (2 and + yr)
53 Traning/Insertion into work. life w/h. voc. tain. (+ 300 h)
56 Professional speciality official degrees
57 Postgradute prog. taught by universities or other institut.
58 Traning/Insertion into work. life prog. requiring unv. deg.
ICPRO Indicator of certificate of profesional standard PES_ICPRO CHAR 1 0
X Yes
NULL No
CODOCU Work center commitment code PES_CODOCU CHAR 8 0
TTEXT Text (30 Characters) TEXT30 CHAR 30 0
COLBON Discount group (output with 3 characters) PES_COLBON_NC3 CHAR 2 0
IDDISC Gap indicator PES_IDDISC CHAR 1 0
ACMAEX Indicator of belonging to Maternity Leave allowance group PES_ACMAEX CHAR 1 0
MODAEXCL Category of exclusion contracts PES_MOD_ATT CHAR 5 0
401 Specific project or service
402 Temporary depending on production circumstances
410 Supply labour
421 Educ/Training
420 Practical
990 Other contracts
501 Specific project or service
502 Temporary depending on production circumstances
510 Supply labour
520 Practical

HCMT_BSP_PA_ES_R0480_SUB_C foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HCMT_BSP_PA_ES_R0480_SUB_C OFFIN * T5E70 INEM offices MANDT
HCMT_BSP_PA_ES_R0480_SUB_C OFFIN HCMT_BSP_PA_ES_R0480_SUB_C OFFIN T5E70 INEM offices COOFF
HCMT_BSP_PA_ES_R0480_SUB_C OFFRG * T5E70 INEM offices MANDT
HCMT_BSP_PA_ES_R0480_SUB_C OFFRG HCMT_BSP_PA_ES_R0480_SUB_C OFFRG T5E70 INEM offices COOFF