EARN_CLR_LNG_VW (SQL View)	Index Back
Related Lang - EARNINGS_CLR_VW This is the view used in Retro Pay processing that selects from PS_EARNINGS_TBL all the Earnings Codes that have been set up as 'Used to pay Retro'.

EARN_CLR_LNG_VW

(SQL View)

Related Lang - EARNINGS_CLR_VW

This is the view used in Retro Pay processing that selects from PS_EARNINGS_TBL all the Earnings Codes that have been set up as 'Used to pay Retro'.

SELECT ERNCD , LANGUAGE_CD , EFFDT , DESCR FROM PS_EARNINGS_LANG

Related Language Record for EARNINGS_CLR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE Effective Date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE	Effective Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description