TV_TRAVEL_PTNR(SQL Table) |
Index Back |
|---|---|
Travel Partner Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL | Travel Partner |
| 2 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 5 | HYPERLINK_LABEL | Character(50) | VARCHAR2(50) NOT NULL | Label for Hyperlink |
| 6 | TP_ENDPNT_ADDR | Character(254) | VARCHAR2(254) NOT NULL | Travel Partner Endpoint address for services |
| 7 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
| 8 | TV_ADMN_USERID | Character(10) | VARCHAR2(10) NOT NULL | Travel Administrator UserID |
| 9 | TV_ADMN_PSW | Character(44) | VARCHAR2(44) NOT NULL | Travel Administrator Password |
| 10 | SITE_CODE | Character(8) | VARCHAR2(8) NOT NULL | travel site identifier (site code) |
| 11 | SINGLE_TRVL_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Single Travel Group
N=Assign user to multiple groups Y=Assign user to single group Default Value: Y |
| 12 | IMP_PEND_RES | Character(1) | VARCHAR2(1) NOT NULL |
Import Pending Reservations
Y/N Table Edit Default Value: N |
| 13 | CONFIRM_ON_APPRV | Character(1) | VARCHAR2(1) NOT NULL |
Confirm on final approval
Y/N Table Edit Default Value: N |
| 14 | IMP_CONF_RES | Character(1) | VARCHAR2(1) NOT NULL |
Import Confirmed Reservations
Y/N Table Edit Default Value: N |
| 15 | USE_SYSMAINT_PSW | Character(1) | VARCHAR2(1) NOT NULL |
Use system-maintained password
Y/N Table Edit Default Value: N |
| 16 | TV_PSW | Character(44) | VARCHAR2(44) NOT NULL | Travel Password |
| 17 | TV_PSW_NEW | Character(44) | VARCHAR2(44) NOT NULL | Travel Password |
| 18 | TV_PREV_PSW1 | Character(44) | VARCHAR2(44) NOT NULL | Previous travel password |
| 19 | TV_PREV_PSW2 | Character(44) | VARCHAR2(44) NOT NULL | Previous travel password |
| 20 | TV_PREV_PSW3 | Character(44) | VARCHAR2(44) NOT NULL | Previous travel password |