GPNL_COMM_DTL

#	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	GPNL_COMM_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Commuting Transport type Prompt Table: GPNL_COMM_TBL
4	GPNL_COMM_DISTANCE	Character(1)	VARCHAR2(1) NOT NULL	Commuting One Way Distance 1=0-10 Km 2=10-15 Km 3=15-20 Km 4=20 km or more
5	GPNL_COMM_DAYS_WK	Character(1)	VARCHAR2(1) NOT NULL	Traveling Days per Week 1=1 Day per Week 2=2 Days per Week 3=3 Days per Week 4=4 or more Days per Week
6	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
7	GPNL_COMM_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL
9	GPNL_COMM_TX_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Taxable Amount
10	GPNL_COMM_FTX_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Tax Free Amount
11	GPNL_COMM_AMT_WEEK	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Limit per Week
12	GPNL_COMM_AMT_MNTH	Number(11,2)	DECIMAL(10,2) NOT NULL	Commuting Limit per Month