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
⤷ 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 |