TRN2483_EESL_VW

(SQL View)
 Index Back

Salary Company Cost View

2483 Salary Company Cost View

SELECT A.COMPANY , P.DECL_YR_2483_FRA , A.EMPLID , A.EMPL_RCD , 'EUR' , %Truncate(SUM(%Sql(FUNCLIB_HR_CURRENC_RESULT, A.TRN_FT_GROSS_AMT, CONV)), 2) FROM PS_TRN_EE_SAL_COST A , PS_OPR_DEF_TBL_HR O , PS_TRN_2483_PARM P %Sql(FUNCLIB_HR_CURRENC_FROM) CONV , PS_TRN_BASE_CUR C WHERE P.COMPANY = A.COMPANY AND A.TRAINING_TYPE = 'A' AND A.EFF_STATUS = 'A' AND A.EFFDT <= %DateIn(%NumToChar(P.DECL_YR_2483_FRA) %Concat '-12-31') AND A.EFFDT >= %DateIn(%NumToChar(P.DECL_YR_2483_FRA) %Concat '-01-01') AND %Sql(FUNCLIB_HR_CURRENC_WHERE, A.CURRENCY_CD, 'EUR', O.EXCHNG_TO_RT_TYPE, %CurrentDateIn, CONV) AND O.OPRCLASS = %OperatorClass GROUP BY A.COMPANY, P.DECL_YR_2483_FRA, A.EMPLID, A.EMPL_RCD HAVING SUM(A.TRN_FT_GROSS_AMT) > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 DECL_YR_2483_FRA Number(4,0) SMALLINT NOT NULL French Report 2483 : Declaring Year
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

6 TRN_FT_GROSS_AMT Number(19,3) DECIMAL(18,3) NOT NULL French Report 2483 : Training Full Time Gross Salary