Salary Plan

• CAMDCountryCodes: nvarchar(4000) - Country codes associated with CAMD scope data.
• StructureCodesForGrade: nvarchar(500) - Structure codes associated with the grade.
• StructureCodesForPlan: nvarchar(max) - Structure codes associated with the plan.
• GradeCodes: nvarchar(500) - Codes identifying the grade.
• SalaryPlanCodes: nvarchar(max) - Codes identifying the salary plan.
• LTI1s: int - Field that specifies if the organizational job is eligible for incentive stock options. 1=yes; 0=no.
• LTI2s: int - Field that specifies if the organizational job is eligible for non-qualified stock options. 1=yes; 0=no.
• LTI3s: int - Field that specifies if the organizational job is eligible for restricted stock. 1=yes; 0=no.
• LTI4s: int - Field that specifies if the organizational job is eligible for phantom stock. 1=yes; 0=no.
• LTI5s: int - Field that specifies if the organizational job is eligible for stock appreciation rights (SARs). 1=yes; 0=no.
• LTI6s: int - Field that specifies if the organizational job is eligible for performance units. 1=yes; 0=no.
• LTI7s: int - Field that specifies if the organizational job is eligible for performance shares. 1=yes; 0=no.
• LTI8s: int - Field that specifies if the organizational job is eligible for long-term cash. 1=yes; 0=no.
• LTI9s: int - Field that specifies if the organizational job is eligible for other Long-term incentives. 1=yes; 0=no.
• IsBonusEligibles: nvarchar(1000) - Indicator for bonus eligibility.Yes=1,No=0.
• BonusTargetPercents: nvarchar(max) - Target percentages for bonuses.
• JobPointss: nvarchar(max) - Field that specifies the internal job point value of the organizational job.
• BasePhilPercentiles: Field that specifies the organizational job’s market-pricing default comparison field for base salary.
• TCCPhilPercentiles: Field that specifies the organizational job’s market-pricing default comparison field for total cash compensation.
• SalaryRangeMins: The Salary Range Minimum on the Job level.
• SalaryRangeMids: The Salary Range Midpoint on the Job level.
• SalaryRangeMaxs: The Salary Range Maximum on the Job level.
• CurrencyCodes: Field used to designate what currency the compensation data is displayed in.
• DefaultComparisonCodes: Field that specifies if the CompAnalyst interface for market-pricing defaults to CompAnalyst Market data, or Survey Library data. 1=CompAnalyst, 2=Composite, 3=Composite, if not available then CompAnalyst.
• IsUseDefaultMarketDatas: Indicator for using default market data. Along with having the ability to setup job scoping on the CompanyJob level, you can designate different scoping in a structure to a job based on the different salary plans it belongs to.
• IndustryFamilyCodes: Codes identifying CAMD Industry.
• I00-All Industries
• I10-Business Services
• I15-Biotechnology
• I16-Chemicals
• I17-Pharmaceuticals
• I20-Construction
• I25-Edu., Gov't. & Nonprofit
• I30-Financial Services
• I31-Insurance
• I35-Healthcare
• I40-Internet
• I45-Media
• I46-Hospitality & Leisure
• I50-MFG Durable
• I51-Aerospace & Defense
• I55-MFG Nondurable
• I60-Energy & Utilities
• I65-Retail & Wholesale
• I70-Software & Networking
• I75-Telecom
• I80-Transportation
• RangeTypeCodes: Codes identifying range types.1=Assets, 3=FTEs, 4=Revenues.
• RangeCodes: Codes identifying ranges for different range type codes.0 is a universal value for All.
• FTERangeCode: 1=< 100, 2=100 - 200, 3=200 - 500, 4=500 - 1,000, 5=1,000 - 3,000, 6=3,000 - 7,500, 7=> 7,500.
• AssetRangeCode: 1=< $1B, 2=$1B - $2B, 3=$2B - $5B, 4=$5B - $10B, 5=$10B - $25B, 6=> $25B.
• RevRangeCode: 1=< $50M, 2=$50M - $200M, 3=$200M - $500M, 4=$500M - $1B, 5=$1B - $3B, 6=$3B - $5B, 7=> $5B
• GeoTypeCodes: Codes identifying geographic types. 31=GeoRegion, 32=GeoState, 33=GeoMetro
• GeoCodes: Geographic codes. Please see table below for details.

• PlansUsingDefaultPlan: The default plan a user defined in the CompAnalyst UI.
• StructuresUsingDefaultPlan: The default structure a user defined in the CompAnalyst UI.
• UDFCmjMNY01s to UDFCmjMNY15s: money - User defined fields.
• UDFCmjDCM06s to UDFCmjDCM15s: decimal(18,5) - User defined fields.
• UDFCmjITG01s to UDFCmjITG10s: int - User defined fields.
• UDFCmjTXS09s to UDFCmjTXS10s: nvarchar(50) - User defined fields.
• UDFCmjDTM01s to UDFCmjDTM05s: datetime - User defined fields.
• UDFCmjdRng01Mins to UDFCmjdRng05Mins: SalaryRange - User defined fields.
• UDFCmjdRng01Mids to UDFCmjdRng05Mids: SalaryRange - User defined fields.
• UDFCmjdRng01Maxs to UDFCmjdRng05Maxs: SalaryRange - User defined fields.