AGE_LMT_TYP_VW (SQL View)	Index Back
Age Extension Limit Types VW Age Extention Limit Types used to prompt valid limit types for Savings Extensions and Overrides.

AGE_LMT_TYP_VW

(SQL View)

Age Extension Limit Types VW

Age Extention Limit Types used to prompt valid limit types for Savings Extensions and Overrides.

SELECT A.FIELDVALUE ,A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'LIMIT_TYPE' AND A.FIELDVALUE IN ('415','415Z','402','457')

Related Language Record: AGE_LMT_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LIMIT_TYPE Character(4) VARCHAR2(4) NOT NULL Limit Type
401=401(a) Limit
401G=401(a) Limit Grandfather Plan
402=402(g) Limit
403=403(b) Limit
415=415(c) Limit
415Z=415(c) Limit for 403(b) plans
457=457 Limit
CH01=User Defined Per Check Limit 1
CH02=User Defined Per Check Limit 2
CH03=User Defined Per Check Limit 3
CH04=User Defined Per Check Limit 4
CH05=User Defined Per Check Limit 5
USER=User Defined Limit

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	LIMIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Limit Type 401=401(a) Limit 401G=401(a) Limit Grandfather Plan 402=402(g) Limit 403=403(b) Limit 415=415(c) Limit 415Z=415(c) Limit for 403(b) plans 457=457 Limit CH01=User Defined Per Check Limit 1 CH02=User Defined Per Check Limit 2 CH03=User Defined Per Check Limit 3 CH04=User Defined Per Check Limit 4 CH05=User Defined Per Check Limit 5 USER=User Defined Limit
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name