EMPLIDPrompt Table: PERSONAL_DATA
CALENDAR_YEARDISTANCE_TYPE3=Metres
K=Kilometers
M=Miles
TRANSPORT_IDEX_EE_DISTANCE(SQL Table) |
Index Back |
|---|---|
Employee Distance Per YearEmployee Distance Per Year |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 3 | DISTANCE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Distance Type
3=Metres K=Kilometers M=Miles |
| 4 | TRANSPORT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Transportation ID |
| 5 | TOTAL_DISTANCE | Number(18,2) | DECIMAL(17,2) NOT NULL | Total Distance |