COMP_BEL_VW

(SQL View)
 Index Back

View on Company Table BEL

Company default values used for Claeys-Formule

SELECT A.COMPANY ,A.EFFDT ,A.MY_FACT_BEL ,A.HY_FACT_BEL ,A.WY_FACT_BEL ,A.YY_FACT_BEL ,A.FACT_AGE_BEL ,A.FACT_CORRECT_BEL ,A.FACT_SERVT_BEL ,A.FACT_YEAR_BASE_BEL ,A.TERM_CORRECT_BEL , A.CLAEYS_SAL_LMT_BEL , A.FACT_CORRECT2_BEL , A.CLAEYS_SALLMT2_BEL FROM PS_COMPANY_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL B WHERE B.COMPANY = A.COMPANY AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 MY_FACT_BEL Number(12,7) DECIMAL(11,7) NOT NULL Month/Year factor
4 HY_FACT_BEL Number(11,6) DECIMAL(10,6) NOT NULL Hour/Year Factor
5 WY_FACT_BEL Number(11,7) DECIMAL(10,7) NOT NULL Week/Year Factor
6 YY_FACT_BEL Number(11,7) DECIMAL(10,7) NOT NULL Year/Year Factor
7 FACT_AGE_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Age
8 FACT_CORRECT_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Correction Factor
9 FACT_SERVT_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Seniority
10 FACT_YEAR_BASE_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Yearly Base
11 TERM_CORRECT_BEL Signed Number(6,2) DECIMAL(4,2) NOT NULL Number of Months to Reduce
12 CLAEYS_SAL_LMT_BEL Number(19,6) DECIMAL(18,6) NOT NULL Salary Limit Lower Range
13 FACT_CORRECT2_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Correct. Factor Higher Range
14 CLAEYS_SALLMT2_BEL Number(19,6) DECIMAL(18,6) NOT NULL Salary Limit Higher Range