SAP ABAP Table HRECM00MARKETDATAWITHTEXT (Market data with text)

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	HRECM00MARKETDATAWITHTEXT	Table Relationship Diagram
Short Description	Market data with text

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

History

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