GPNL_COMM_TYPEPrompt Table: GPNL_COMM_TBL
EFFDTDefault Value: %date
GPNL_COMM_DISTANCE1=0-10 Km
2=10-15 Km
3=15-20 Km
4=20 km or more
Default Value: 1
GPNL_COMM_DAYS_WK1=1 Day
2=2 Days
3=3 Days
4=4 or more Days
Default Value: 1
GPNL_COMM_CLNG(SQL Table) |
Index Back |
|---|---|
Ceilings for Travel AllowanceCeilings for tax free amount for Travel Allowance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPNL_COMM_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Commuting Transport type
Prompt Table: GPNL_COMM_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | 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 Default Value: 1 |
| 4 | GPNL_COMM_DAYS_WK |
Character(1) | VARCHAR2(1) NOT NULL |
Traveling Days per Week
1=1 Day 2=2 Days 3=3 Days 4=4 or more Days Default Value: 1 |
| 5 | GPNL_COMM_AMT_WEEK | Number(11,2) | DECIMAL(10,2) NOT NULL | Commuting Limit per Week |
| 6 | GPNL_COMM_AMT_MNTH | Number(11,2) | DECIMAL(10,2) NOT NULL | Commuting Limit per Month |