EMPLIDEMPL_RCDEFFDTSEQNUMDefault Value: %date
10=1 Day
20=1 Month
30=3 Months
40=6 Months
10=Fare
20=Toll
Default Value: 10
10=Cash
20=Non-Cash
Default Value: 10
Default Value: JPY
GPJP_CM_PYE_DT2(SQL Table) |
Index Back |
|---|---|
Commuting Allowance RouteThis record will store all the Commuting Allowance Route Section Entry and the Total Amount Entry for each employee. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | GPJP_START_DATE | Date(10) | DATE NOT NULL |
Appraisal Prd Start Date (14-1)
Default Value: %date |
| 6 | GPJP_PAY_CYCLE | Character(2) | VARCHAR2(2) NOT NULL |
Pay Cycle.
Translate Values:
'10' - '1 Day'
'20' - '1 Month'
'30' - '3 Months'
'40' - '6 Months'
10=1 Day 20=1 Month 30=3 Months 40=6 Months |
| 7 | GPJP_CM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Commuting Allowance Type field.
10=Fare 20=Toll Default Value: 10 |
| 8 | GPJP_FORM_OF_PAY | Character(2) | VARCHAR2(2) NOT NULL |
Form Of Payment for Commuting Allowance.
10=Cash 20=Non-Cash Default Value: 10 |
| 9 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 10 | GPJP_PLACE_FROM | Character(38) | VARCHAR2(38) NOT NULL | Start Point of commuting route. |
| 11 | GPJP_PLACE_TO | Character(38) | VARCHAR2(38) NOT NULL | End Point of commuting route. |
| 12 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: JPY |