GPNL_COMM_EE_VW (SQL View)	Index Back
EE Commuting Details Commuting Details for Employees

GPNL_COMM_EE_VW

(SQL View)

EE Commuting Details

Commuting Details for Employees

SELECT A.EMPLID , A.EFFDT , A.FREQUENCY_ID , C.FREQ_ANNUAL_FACTOR , A.GPNL_COMM_AMT , B.GPNL_COMM_AMT_WEEK , B.GPNL_COMM_AMT_MNTH FROM PS_GPNL_COMM_DTL A , PS_GPNL_COMM_CLNG B , PS_FREQUENCY_TBL C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPNL_COMM_DTL A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.GPNL_COMM_TYPE = A_ED.GPNL_COMM_TYPE AND A.GPNL_COMM_DISTANCE = A_ED.GPNL_COMM_DISTANCE AND A.GPNL_COMM_DAYS_WK = A_ED.GPNL_COMM_DAYS_WK AND A.GPNL_COMM_TYPE = B.GPNL_COMM_TYPE ) AND A.GPNL_COMM_DISTANCE = B.GPNL_COMM_DISTANCE AND A.GPNL_COMM_DAYS_WK = B.GPNL_COMM_DAYS_WK AND A.FREQUENCY_ID = C.FREQUENCY_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPNL_COMM_CLNG B_ED WHERE B.GPNL_COMM_TYPE = B_ED.GPNL_COMM_TYPE AND B.GPNL_COMM_DISTANCE = B_ED.GPNL_COMM_DISTANCE AND B.GPNL_COMM_DAYS_WK = B_ED.GPNL_COMM_DAYS_WK AND B_ED.EFFDT <= A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 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.
Default Value: M
Prompt Table: GPNL_FREQ_VW

4 FREQ_ANNUAL_FACTOR Number(12,7) DECIMAL(11,7) NOT NULL Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.

5 GPNL_COMM_AMT Number(11,2) DECIMAL(10,2) NOT NULL Commuting Amount

6 GPNL_COMM_AMT_WEEK Number(11,2) DECIMAL(10,2) NOT NULL Commuting Limit per Week

7 GPNL_COMM_AMT_MNTH Number(11,2) DECIMAL(10,2) NOT NULL Commuting Limit per Month

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	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. Default Value: M Prompt Table: GPNL_FREQ_VW
4	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
5	GPNL_COMM_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Amount
6	GPNL_COMM_AMT_WEEK	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Limit per Week
7	GPNL_COMM_AMT_MNTH	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Limit per Month