GPNL_COMM_DTL(SQL Table) |
Index Back |
|---|---|
EE Commuting DetailsCommuting Details for Employees |
| # | 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 2=2 Days 3=3 Days 4=4 or more Days |
| 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 |