GRN_FREQ_VWLNG (SQL View)	Index Back
Garn Freq View - Related Lang This record gives the view of the Frequency Table for frequency id maintained by PeopleSoft., except daily frequency, for Garnishment schedule. This is the related language record.

GRN_FREQ_VWLNG

(SQL View)

Garn Freq View - Related Lang

This record gives the view of the Frequency Table for frequency id maintained by PeopleSoft., except daily frequency, for Garnishment schedule. This is the related language record.

SELECT B.FREQUENCY_ID ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR50 ,B.DESCRSHORT FROM PS_FREQUENCY_TBL A , PS_FREQ_TBL_LANG B WHERE A.FREQUENCY_ID = B.FREQUENCY_ID

Related Language Record for GRN_FREQ_TBL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %Date

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description