SAP ABAP Table HRECM00SURVEYMARKETDATA (Survey Market Data of the survey job)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PA-EC-JP (Application Component) Job Pricing
     ⤷ PAOC_ECM_JPR_BL (Package) Job Pricing - Business Logic

Basic Data

Table Category	INTTAB	Structure
Structure	HRECM00SURVEYMARKETDATA	Table Relationship Diagram
Short Description	Survey Market Data of the survey job

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	PROVIDER	☐	ECM_PROVIDER	ECM_PROVIDER	CHAR	4	0	Survey Provider Code	*
2	JOBCODE	☐	ECM_JOBCODE	ECM_JOBCODE	CHAR	8	0	Job Code	*
3	JOBLEVEL	☐	ECM_JOBLEVEL	CHAR2	CHAR	2	0	Job Level
4	SURVEY	☐	ECM_SURVEY	ECM_SURVEY	CHAR	4	0	Survey Code	*
5	SURVEYDATE	☐	ECM_SURVEYDATE	DATUM	DATS	8	0	Survey Date
6	AGEDATE	☐	ECM_AGEDATE	DATUM	DATS	8	0	Age Date
7	AGEFAC	☐	ECM_AGEFAC	DEC3_2	DEC	5	2	Survey Age Factor in Percent
8	MARKETMOVEMENT	☐	ECM_AGEFAC	DEC3_2	DEC	5	2	Survey Age Factor in Percent
9	CREATEDATE	☐	ECM_CREATEDATE	DATUM	DATS	8	0	Date on which Survey Data was Imported or Adjusted
10	LANGU	☐	SPRSL	SPRAS	LANG	1	0	Language Key	*
11	USERNAME	☐	USERNAME	USERNAME	CHAR	12	0	User name
12	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	FREQU	☐	ECM_FREQU	PFREQ	NUMC	2	0	Unit of Time
14	FLSASTAT	☐	ECM_FLSASTAT	CHAR1	CHAR	1	0	Job Status according to FLSA
15	JMATCH	☐	ECM_JMATCH	ECM_JMATCH	CHAR	1	0	Job Matching Degree
16	JMATCHPCT	☐	ECM_JMATCHPCT	DEC3_2	DEC	5	2	Job Matching Percentage
17	RANGEMIN	☐	ECM_RANGEMIN	P_AMT08	CURR	15	2	Salary Range Minimum
18	RANGEMID	☐	ECM_RANGEMID	P_AMT08	CURR	15	2	Salary Range Midpoint
19	RANGEMAX	☐	ECM_RANGEMAX	P_AMT08	CURR	15	2	Salary Range Maximum
20	STIELIG	☐	ECM_STIELIG	CHAR1	CHAR	1	0	Short-Term Incentive Eligibility
21	STITARGET	☐	ECM_STITARGET	DEC3_2	DEC	5	2	Short-Term Incentive Target Percentage of Base Salary
22	STIACTUAL	☐	ECM_STIACTUAL	DEC3_2	DEC	5	2	Short-Term Incentive Actual Percentage of Base Salary
23	STIELIGPCT	☐	ECM_STIELIGPCT	DEC3_2	DEC	5	2	Short-Term Incentive Percentage of Employees eligible
24	STIRCDPCT	☐	ECM_STIRCDPCT	DEC3_2	DEC	5	2	Percentage of Employees Receiving Short-Term Incentive
25	STATSTYPE	☐	ECM_STATSTYPE	ECM_STATSTYPE	CHAR	2	0	Pay Category	*
26	.INCLUDE	☐				0	0	Survey Market Data of the survey job
27	COUNTRY	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
28	INDUSTRY	☐	ECM_INDUSTRY	ECM_INDUSTRY	CHAR	4	0	Survey Industry Code	*
29	REGION	☐	ECM_REGION	ECM_REGION	CHAR	4	0	Survey Region Code	*
30	REVSIZE	☐	ECM_REVSIZE	ECM_REVSIZE	CHAR	4	0	Survey Revenue Size Code	*
31	COMSIZE	☐	ECM_COMSIZE	ECM_COMSIZE	CHAR	4	0	Survey Company Size Code	*
32	COMTYPE	☐	ECM_COMTYPE	ECM_COMTYPE	CHAR	4	0	Survey Company Type Code	*
33	SERVICE	☐	ECM_SERVICE	ECM_SERVICE	CHAR	4	0	Length of Service Code	*
34	.INCLUDE	☐				0	0	Survey Market Data - number and amount fields
35	NUMINCUMBENTS	☐	ECM_NUMINCUMBENTS	DEC7	DEC	7	0	Number of Incumbents Contributing to Survey Data
36	NUMCOMPANIES	☐	ECM_NUMCOMPANIES	DEC7	DEC	7	0	Number of Companies Contributing to Survey Data
37	NUMEMPLOYEES	☐	ECM_NUMEMPLOYEES	DEC7	DEC	7	0	Number of Employees Contributing to Survey Data
38	AVERAGE	☐	ECM_AVERAGE	P_AMT08	CURR	15	2	Average
39	AVERAGEINCS	☐	ECM_AVERAGEINCS	P_AMT08	CURR	15	2	Average of Salary Weighted by Incumbents
40	AVERAGECOS	☐	ECM_AVERAGECOS	P_AMT08	CURR	15	2	Average of Salary Weighted by Companies
41	AVERAGEPCT	☐	ECM_AVERAGEPCT	DEC3_2	DEC	5	2	Average of Salary Expressed as Percentage of Base Salary
42	TARGETPCT	☐	ECM_TARGETPCT	DEC3_2	DEC	5	2	Target Bonus Expressed as Percentage of Base Salary
43	ACTUALPCT	☐	ECM_ACTUALPCT	DEC3_2	DEC	5	2	Actual Bonus Expressed as Percentage of Base Salary
44	PERCENTILE10	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
45	PERCENTILE25	☐	ECM_PERCENTILE25	P_AMT08	CURR	15	2	25th Percentile (25% of Employees are below value)
46	PERCENTILE50	☐	ECM_PERCENTILE50	P_AMT08	CURR	15	2	50th Percentile (50% of Employees are below value)
47	PERCENTILE60	☐	ECM_PERCENTILE60	P_AMT08	CURR	15	2	60th Percentile (60% of Employees are below value)
48	PERCENTILE75	☐	ECM_PERCENTILE75	P_AMT08	CURR	15	2	75th Percentile (75% of Employees are below value)
49	PERCENTILE90	☐	ECM_PERCENTILE90	P_AMT08	CURR	15	2	90th Percentile (90% of Employees are below value)
50	PROVIDER_NAME	☐	ECM_TEXT_PROVIDER	TEXT60	CHAR	60	0	Text of Survey Provider Code
51	SURVEY_NAME	☐	ECM_TEXT_SURVEY	TEXT60	CHAR	60	0	Text of Survey Name
52	JOBFAMILY	☐	ECM_JOBFAMILY	ECM_JOBFAMILY	CHAR	8	0	Survey Job Family	*
53	FAMILY_NAME	☐	ECM_TEXT_JOBFAMILY	TEXT60	CHAR	60	0	Text of Survey Job Family
54	JOB_NAME	☐	ECM_TEXT_JOBCODE	TEXT60	CHAR	60	0	Text of Survey Job
55	WGTFAC	☐	ECM_WGTFAC	DEC2_2	DEC	4	2	Survey Job Weight Factor
56	WGTPCT	☐	ECM_WGTPCT	DEC3_2	DEC	5	2	Weighting Percentage
57	STATSTYPE_NAME	☐	ECM_TEXT_STATSTYPE	TEXT60	CHAR	60	0	Pay Category Text

History

Last changed by/on	SAP	20110901
SAP Release Created in	200