TRW_STATE_VL (SQL View)	Index Back
TRW State Table View Lang This view is the related language table for TRW State Table View (TRW_STATE_VW) used to retrieve State code for a Reward Item Filter.

TRW_STATE_VL

(SQL View)

TRW State Table View Lang

This view is the related language table for TRW State Table View (TRW_STATE_VW) used to retrieve State code for a Reward Item Filter.

SELECT STATE , LANGUAGE_CD , DESCR FROM PS_STATE_TBL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE Character(6) VARCHAR2(6) NOT NULL State

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description