EXP_401_VW_LNG (SQL View)	Index Back
Limit Ext Type 01 Rel Lang Related Language View with Exception Limit Extension Types of Adjust Eligible Earns YTD used as prompt for Limit Type 401 in Employee Savings Management component.

EXP_401_VW_LNG

(SQL View)

Limit Ext Type 01 Rel Lang

Related Language View with Exception Limit Extension Types of Adjust Eligible Earns YTD used as prompt for Limit Type 401 in Employee Savings Management component.

SELECT A.FIELDVALUE , A.LANGUAGE_CD ,A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'LIMIT_EXT_TYPE' AND A.FIELDVALUE IN ('E')

Related Language Record for EXP_401_LMT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value

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

3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDVALUE	Character(4)	VARCHAR2(4) NOT NULL	Field Value
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
4	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name