SAP ABAP Table HRECM00BW_IS_SVMARKETDATA (BW Extract for Survey Market Data)

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	HRECM00BW_IS_SVMARKETDATA	Table Relationship Diagram
Short Description	BW Extract for Survey Market Data

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	CALDAY	☐	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	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	FREQU	☐	ECM_FREQU	PFREQ	NUMC	2	0	Unit of Time
10	FLSASTAT	☐	ECM_FLSASTAT	CHAR1	CHAR	1	0	Job Status according to FLSA
11	JMATCHPC	☐	ECM_JMATCHPCT	DEC3_2	DEC	5	2	Job Matching Percentage
12	RANGEMIN	☐	ECM_RANGEMIN	P_AMT08	CURR	15	2	Salary Range Minimum
13	RANGEMID	☐	ECM_RANGEMID	P_AMT08	CURR	15	2	Salary Range Midpoint
14	RANGEMAX	☐	ECM_RANGEMAX	P_AMT08	CURR	15	2	Salary Range Maximum
15	PAYCAT	☐	ECM_STATSTYPE	ECM_STATSTYPE	CHAR	2	0	Pay Category	*
16	COUNTRY	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
17	INDUSTRY	☐	ECM_INDUSTRY	ECM_INDUSTRY	CHAR	4	0	Survey Industry Code	*
18	REGION	☐	ECM_REGION	ECM_REGION	CHAR	4	0	Survey Region Code	*
19	REVSIZE	☐	ECM_REVSIZE	ECM_REVSIZE	CHAR	4	0	Survey Revenue Size Code	*
20	COMSIZE	☐	ECM_COMSIZE	ECM_COMSIZE	CHAR	4	0	Survey Company Size Code	*
21	COMTYPE	☐	ECM_COMTYPE	ECM_COMTYPE	CHAR	4	0	Survey Company Type Code	*
22	SERVICE	☐	ECM_SERVICE	ECM_SERVICE	CHAR	4	0	Length of Service Code	*
23	NUMINCS	☐	ECM_NUMINCUMBENTS	DEC7	DEC	7	0	Number of Incumbents Contributing to Survey Data
24	NUMCOS	☐	ECM_NUMCOMPANIES	DEC7	DEC	7	0	Number of Companies Contributing to Survey Data
25	NUMEMPL	☐	ECM_NUMEMPLOYEES	DEC7	DEC	7	0	Number of Employees Contributing to Survey Data
26	AVERAGE	☐	ECM_AVERAGE	P_AMT08	CURR	15	2	Average
27	PERC_10	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
28	PERC_25	☐	ECM_PERCENTILE25	P_AMT08	CURR	15	2	25th Percentile (25% of Employees are below value)
29	PERC_50	☐	ECM_PERCENTILE50	P_AMT08	CURR	15	2	50th Percentile (50% of Employees are below value)
30	PERC_60	☐	ECM_PERCENTILE60	P_AMT08	CURR	15	2	60th Percentile (60% of Employees are below value)
31	PERC_75	☐	ECM_PERCENTILE75	P_AMT08	CURR	15	2	75th Percentile (75% of Employees are below value)
32	PERC_90	☐	ECM_PERCENTILE90	P_AMT08	CURR	15	2	90th Percentile (90% of Employees are below value)

History

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