EMPLIDTRAVEL_PARTNERSEQNUMDefault Value: 1
TV_TRVL_PGRP(SQL Table) |
Index Back |
|---|---|
TV Travel ProfileTravel Employee Profile |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL | Travel Partner |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | TRAVEL_GROUP | Character(8) | VARCHAR2(8) NOT NULL | Travel Group |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |