SAP Table PA0061

HR Master Record Infotype 0061 (Social Insurance - Spain)

PA0061 (HR Master Record Infotype 0061 (Social Insurance - Spain)) 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 PA0061 to other SAP tables.

PA0061 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
NATSS Employee's Social insurance number NATSS NUMC 12 0
EPIGR Epigraph EPIGR NUMC 3 0
GRCOT Key for the contribution group GRCOT T5E4J NUMC 2 0
BERKT Professional category BERK1 CHAR 3 0
TICON Contract type key TICON NUMC 2 0
DICON Monthly workdays (part-time contracts) DICON DEC 2 0
HOCON Working hours in month (part-time contracts) HOCON DEC 5 2
NRHIJ Number of children NRHIJ DEC 2 0
NRHMI Number of challenged children NRHMI DEC 2 0
PEPFI Previous family allowance PEPFI CURR 9 2
PETPC Percentage for non-industrial risks (min.) PETPC DEC 5 2
PENSS Authorization number for multiple employment PENSS CHAR 13 0
PESOC Contract type key PESOC CHAR 15 0
SOILT Healthcare company for ind. accidents and ind. disease SOILT T5E03 CHAR 3 0
SOASV Healthcare company for non-industrial disease SOASV T5E03 CHAR 3 0
EPIG2 Epigraph 114 EPIG2 CHAR 1 0
X Yes
NULL No
INDRE Employee special status code PES_CONSE CHAR 1 0
X Advisor/Administrator
1 Foreigner
FERED Start date for reduction/allowance FERED DATS 8 0
INDFN Indicator for large family INDFN CHAR 1 0
NOMAT Employee registration number NRMAT NUMC 6 0
PLNSS Pay scale code PES_CON11 NUMC 11 0
PPCG2 Percentage for non-industrial risks PPCG2 DEC 5 2
PPAT1 IA and ID risk percentage (min.) PPAT1 DEC 5 2
PPAT2 IA and ID risk percentage (max.) PPAT2 DEC 5 2
PCILT Temporary incapcity grace period indicator PCILT CHAR 1 0
X Total
E Non-industrial risks
A IA/ID risks
PCMAT Surcharge exemption in extra payroll runs PES_EXREC CHAR 1 0
NULL W/o surcharge exemption
T Wage processing
I Wage increase
EXESS Exemption indicator EXESS CHAR 1 0
X Yes
NULL No
CUOAD Additional contribution indicator PES_CUOAD CHAR 1 0
X Yes
NULL No
CODES Unemployed PES_CODES CHAR 1 0
1 Registered in employment office
2 Registered in employment office > 12 months
3 Agrarian special regulation subsidy
4 Unemployment assistance benefit > 1 year
5 Registered in employment office > 6 meses
6 One year or more remains Unemployment Benefit
7 Person entitled to unemployment assistance (over 52 years)
9 Not registered in employment office
F Registered in the unemployment office. Dependant relatives
G Reg. in the unemployment office > 6 mo. Dependant relatives
A Unemployment benefit recipient
M Unemployed work contract CTP < 333
B Unemployed worker with employability problems
C Unemployed 1-1-2011
D Unemployed 1-1-2011. 12 months in 18 months
E Unemployed 16-08-2011
H Unemployed with no working experience or less than 3 months
I Unemployed from another activity sector
J Unemployed w/o job experience or < 3 months.Youth employment
FEINI Contracts start date PES_FECH_I DATS 8 0
INDSU Partial subrogation indicator PES_INDSUB CHAR 1 0
RELAB Special work relationship PES_RELLAB CHAR 4 0
0301 Prisoners in Penitentiary Institutions. Learn/Training
0302 Prisoners in Penitentiary Institutions. Labour Activity
0303 Prisoners in Penitentiary Institutions. Community Service
0304 Prisoners in Penitentiary Institutions. Minors.
0409 Professional sportspeople.
0500 Sales representatives.
0501 Sales representatives - sellers of ONCE lottery tickets-
0601 Handicapped person from a labour enclave.
9901 Investigation of Span. system for Scien & Tech -cont. prac-.
9903 Public University - Assistant Lecturer
9904 Public University - Lecturer Doctor Assistant
9905 Public University- Collaborating Lecturer
9906 Public University - Hired Lecturer Doctor
9907 Public University - Associated Lecturer
9908 Public University -Visiting Lecturer
0100 Senior management staff
0300 Convicts in penitentiary institutions
0401 Footballers
0402 Basketball players
0403 Handball players
0404 Cyclists
0600 Challenged persons in special work centers
0700 Dockers
0800 Artists in shows
0900 Lawyers in lawyer offices
9902 Acting Resident Doctors
9909 Trainee scholars -scholarship-
9910 Trainee scholars -work experience contract-
9911 Student-workers in educational workshop programs
9912 Student-workers in trade workshop programs
9913 Student-workers in employment workshop programs
9914 Social insurance disability pensioner
9915 Passive category disability pensioner
9916 R&D Research staff
9918 Training contracts - Subsequent rollover 18-06-2010
9921 Predoctoral contract
9920 Not subsidized training contract. After 06/18/2011
9922 Partic. in Prog. for Training/Part. Prog. Train.
9923 Unpaid intern. in Company/Unpaid intern.Comp.
0421 Training contract. Transitional arrangement
9924 Company partner
9925 Is not a company partner
0602 ONCE disabled person
9926 Student taking part in Employment-Training Projects
NUSST Replaced employee Social Insurance number PES_NUSS NUMC 12 0
CAUSU Reason for substitution PES_CAUSAS CHAR 2 0
01 Due to familiar care leave
02 Leave due to maternity leave or risk during pregnancy
03 Substitution of early retired person at the age of 64
04 Substitution of challenged person
05 Substitution of challenged person in TI situtation
06 Gender-based violence victims
07 Fixed employment reduction vacancy coverage
PLPOR FOGASA percentage multiple employment PES_PLPOR DEC 5 2
METOD Contract process method PES_METODO T5ES3 CHAR 4 0
RACIN Active Insertion Income PES_RACIN CHAR 1 0
X Yes
NULL No
ALUMB Contract after giving birth PES_ALUMB CHAR 1 0
X Yes
NULL No
REDJB Retirement age reduction coefficient PES_REDJB NUMC 2 0
METO2 Contract processing method (other methods) PES_METO2 T5ES3 CHAR 4 0
FERE2 Start date for reduction/allowance (other methods) PES_FERE2 DATS 8 0
RELEV Relief contract PES_RELEV CHAR 1 0
RESOL Legal regulation applicable PES_RESOL NUMC 5 0
RESO2 Legal regulation applicable PES_RESOL NUMC 5 0
PLPDE Percentage of Unemployment concurrent employees PES_PLPDE DEC 5 2
COLTR Worker group PES_COLTR NUMC 3 0
016 Legal guardian due to minor
017 Legal guardian due to disability
018 Legal guardian due to family
019 Reduced working hours due to post-natal care
020 Reduced working hours due to violence
025 Reduced working hours due to premature child
026 Reduction in working hours child with serious illness
027 Reduct. in wk. hrs child w/serious illness + Oth.wk hrs red.
951 Counseling Administrator with work contract
952 Counseling Administrator with commercial contract
MREIN Rehired female employee PES_MREIN CHAR 1 0
S Female employee rehired after maternity leave
2 Overlap due to 2nd rehiring
3 5 years of inactivity
4 Female employee rehired after parental leave
AUTTR Authorization to work (foreigners) PES_AUTTR1 CHAR 3 0
AUTVI Validity of authorization to work (foreigners) PES_AUTVI DATS 8 0
NISSE Company CA code NISS1 NUMC 11 0
OCUPA Employment (IA and ID contribution) PES_OCUPA T5E4C CHAR 2 0
PTPAR Part-time percentage of the normal working time PES_PTPAR DEC 5 2
CNAEC National classification of business activities PES_CNAEC T5E4F CHAR 5 0
DTRTP Days worked part-time PES_DTRTP NUMC 2 0
CPTRA Change of work center PES_CPTRA NUMC 2 0
METO3 Contract processing method (other methods) PES_METO2 T5ES3 CHAR 4 0
METO4 Contract processing method (other methods) PES_METO2 T5ES3 CHAR 4 0
FERE3 Start date for reduction/allowance (other methods) PES_FERE2 DATS 8 0
FERE4 Start date for reduction/allowance (other methods) PES_FERE2 DATS 8 0
RESO3 Legal regulation applicable PES_RESOL NUMC 5 0
RESO4 Legal regulation applicable PES_RESOL NUMC 5 0
PLNS2 Pay scale code PES_CON20 T5E3A NUMC 20 0

PA0061 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0061 CNAEC SYST MANDT T5E4F CNAES entity table MANDT
PA0061 CNAEC PA0061 CNAEC T5E4F CNAES entity table CNAEC
PA0061 GRCOT * T5E4J Contribution groups TPCCC
PA0061 GRCOT PA0061 GRCOT T5E4J Contribution groups GRCOT
PA0061 GRCOT SYST MANDT T5E4J Contribution groups MANDT
PA0061 MANDT PA0061 MANDT T000 Clients MANDT
PA0061 METO2 SYST MANDT T5ES3 Contract processing methods MANDT
PA0061 METO2 Q0061 IDSEG T5ES3 Contract processing methods IDSEG
PA0061 METO2 PA0061 METO2 T5ES3 Contract processing methods METOD
PA0061 METO2 * T5ES3 Contract processing methods ENDDA
PA0061 METO3 SYST MANDT T5ES3 Contract processing methods MANDT
PA0061 METO3 Q0061 IDSEG T5ES3 Contract processing methods IDSEG
PA0061 METO3 PA0061 METO3 T5ES3 Contract processing methods METOD
PA0061 METO3 * T5ES3 Contract processing methods ENDDA
PA0061 METO4 Q0061 IDSEG T5ES3 Contract processing methods IDSEG
PA0061 METO4 PA0061 METO4 T5ES3 Contract processing methods METOD
PA0061 METO4 * T5ES3 Contract processing methods ENDDA
PA0061 METO4 SYST MANDT T5ES3 Contract processing methods MANDT
PA0061 METOD PA0061 METOD T5ES3 Contract processing methods METOD
PA0061 METOD * T5ES3 Contract processing methods ENDDA
PA0061 METOD SYST MANDT T5ES3 Contract processing methods MANDT
PA0061 METOD Q0061 IDSEG T5ES3 Contract processing methods IDSEG
PA0061 OCUPA PA0061 OCUPA T5E4C Employments (IA and ID contribution) OCUPA
PA0061 OCUPA * T5E4C Employments (IA and ID contribution) ENDDA
PA0061 OCUPA SYST MANDT T5E4C Employments (IA and ID contribution) MANDT
PA0061 PERNR PA0061 MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0061 PERNR PA0061 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0061 PLNS2 SYST MANDT T5E3A Pay scale codes MANDT
PA0061 PLNS2 PA0061 PLNS2 T5E3A Pay scale codes CONSS
PA0061 PREAS '0061' T530E Reasons for Changes INFTY
PA0061 PREAS PA0061 PREAS T530E Reasons for Changes PREAS
PA0061 PREAS PA0061 MANDT T530E Reasons for Changes MANDT
PA0061 SOASV * T5E03 IA/ID and NID healthcare companies MANDT
PA0061 SOASV '2' T5E03 IA/ID and NID healthcare companies INDIC
PA0061 SOASV PA0061 SOASV T5E03 IA/ID and NID healthcare companies COSOC
PA0061 SOILT '1' T5E03 IA/ID and NID healthcare companies INDIC
PA0061 SOILT PA0061 SOILT T5E03 IA/ID and NID healthcare companies COSOC
PA0061 SOILT * T5E03 IA/ID and NID healthcare companies MANDT