EXP_415_LMT_VW (SQL View)	Index Back
Limit Extension Types for 401a View with Exception Limit Extension Types of Age Extend Limit used as prompt for Limit Type 415(c) and 415(c) for 403(b) in Employee Savings Management component.

EXP_415_LMT_VW

(SQL View)

Limit Extension Types for 401a

View with Exception Limit Extension Types of Age Extend Limit used as prompt for Limit Type 415(c) and 415(c) for 403(b) in Employee Savings Management component.

SELECT A.FIELDVALUE ,A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'LIMIT_EXT_TYPE' AND A.FIELDVALUE IN ('B')

Related Language Record: EXP_415_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name