| EXPORT_TR_HDR_iD |
N/A |
INT |
N |
A unique number (Bobid). |
| EXPORT_HDR_STATUS |
N/A |
SMALLINT |
N |
Status of the export document. Export System used values are 1, 2, 4 and 5. User defined values range is 100 or higher. |
| EXPORT_HDR_STATUS_ DATETIME |
N/A |
DATETIME |
N |
This is the date/time that the export_hdr_status col. is updated. The value equals export_create_date when inserting a new row. The purge process to determine when to delete a document from the export tables. |
| EXPORT_CREATE_DATE |
N/A |
DATETIME |
N |
The date/time that the export form of the document is created (i.e., row was inserted into this table). This is not to be confused with the travel plan document create date. |
| EXTR_WORK_ITEM_ID |
alwf_work_item - work_item_id |
INT |
N |
The ID of the work item that is associated with this document. |
| EXTR_TRACKING_NUMBER |
alwf_work_item - document_id |
VARCHAR (255) |
Y |
The document-identifying ID. This is the same value found in the work_item col. document_id. Currently it consists of 10 characters formatted as follows: Pos 1-2: TP Pos 3_10: Eight digit sequence number unique for the database. |
| EXTR_TITLE |
altr_travel_request - tr_title |
VARCHAR (255) |
Y |
Title of the proposed trip. |
| EXTR_PURPOSE |
altr_travel_request - tr_purpose |
VARCHAR (255) |
Y |
Identifies purpose (BOb) of the trip, like "Sales Call." |
| EXTR_NUM_GOING |
altr_travel_request - tr_num_going |
INT |
Y |
Number of people going on trip. |
| EXTR_DATE_CREATED |
altr_travel_request - tr_date_created |
DATETIME |
Y |
Date travel request (travel plan) document was created. |
| EXTR_DATE_FILED |
altr_travel_request - tr_date_filed |
DATETIME |
Y |
Date document was submitted. |
| EXTR_DATE_FROM |
altr_travel_request - tr_date_from |
DATETIME |
Y |
Trip starts on this date. |
| EXTR_DATE_TO |
altr_travel_request - tr_date_to |
DATETIME |
Y |
Trip goes until this date. |
| EXTR_DATE_APPROVED |
altr_travel_request - tr_date_approved |
DATETIME |
Y |
Date document was approved. |
| EXTR_CURRENCY_ISO |
|
CHAR (3) |
Y |
ISO code for currency used in amounts (excluding native amounts). |
| EXTR_TOT_AIR |
altr_travel_request - tr_tot_air |
NUMERIC (20, 10) |
Y |
Total airfare cost. |
| EXTR_TOT_HOTEL |
altr_travel_request - tr_tot_hotel |
NUMERIC (20, 10) |
Y |
Total hotel cost. |
| EXTR_TOT_HOTEL_TAX |
altr_travel_request - tr_tot_htax |
NUMERIC (20, 10) |
Y |
Total hotel tax. |
| EXTR_TOT_CAR |
altr_travel_request - tr_tot_car |
NUMERIC (20, 10) |
Y |
Total car rental cost. |
| EXTR_TOT_CAR_TAX |
altr_travel_request - tr_tot_ctax |
NUMERIC (20, 10) |
Y |
Total car tax. |
| EXTR_TOT_MEALS |
altr_travel_request - tr_tot_meals |
NUMERIC (20, 10) |
Y |
Total meal cost. |
| EXTR_TOT_OTHER |
altr_travel_request - tr_tot_other |
NUMERIC (20, 10) |
Y |
Total of misc. costs. |
| EXTR_TOTAL_COST |
altr_travel_request - tr_total_cost |
NUMERIC (20, 10) |
Y |
Total cost of planned trip. |
| EXTR_MAX_AIR_TICKET_ AMT |
altr_travel_request - max_air_ticket_amt |
NUMERIC (20, 10) |
Y |
Maximum airline ticket amount that the approver is willing to spend for the itinerary associated with the travel plan. |
| EXTR_TRIP_TYPE_LABEL |
altr_travel_request - trip_type_id |
VARCHAR (255) |
Y |
This is the label for trip type item associated with this line item (example: international). |
| EXTR_ORD_KEY |
altr_travel_request - ord_key |
VARCHAR (255) |
Y |
The order key. This is a unique key into external system that identifies each itinerary. |
| EXTR_INTEGRATION_PARTNER_NAME |
altr_travel_request - integration_partner_ id |
VARCHAR (255) |
Y |
Name of the integration partner associated with this line item (from table alob_integration_partner). |
| EXTR_USER_ID |
altr_travel_request - user_id |
INT |
Y |
Owner of document. |
| EXTR_USER_LOGIN |
alco_user - user_login |
VARCHAR (255) |
Y |
User login of the owner of the travel plan. |
| EXTR_USER_FULL_NAME |
alco_user - user_full_name |
VARCHAR (255) |
Y |
User full name. |
| EXTR_EMPLOYEE_ NUMBER |
alco_user - employee_number |
VARCHAR (255) |
Y |
User employee number. |
| EXTR_USER_EMAIL_ ADDRESS |
alco_user - user_email_address |
VARCHAR (255) |
Y |
User email address. |
| EXTR_USER_LOCATION |
alco_user - user_location |
VARCHAR (255) |
Y |
User location. |
| EXTR_USER_PAYROLL_ SYSTEM_CODE |
alco_user - payroll_system_code |
VARCHAR (255) |
Y |
User payroll system code. |
| EXTR_USER_SSN |
alco_user - user_ssn |
VARCHAR (255) |
Y |
User social security number. |
| EXTR_USER_COST_CENTER_NAME |
alco_cost_center - cost_center_name |
VARCHAR (255) |
Y |
User default cost center name. |
| EXTR_USER_COST_CENTER_CODE |
alco_cost_center - cost_center_code |
VARCHAR (255) |
Y |
User default cost center code. |
| EXTR_USER_DEPT_NAME |
alco_department - department_name |
VARCHAR (255) |
Y |
Department name of user's default cost center. |
| EXTR_USER_DIVISION_NAME |
alco_division -division_name |
VARCHAR (255) |
Y |
Division name of user's default cost center. |
| EXTR_USER_DEPT_CODE |
alco_department - department_code |
VARCHAR (255) |
Y |
Department code of user's default cost center. |
| EXTR_USER_DIVISION_CODE |
alco_division -division_code |
VARCHAR (255) |
Y |
Division code of user's default cost center. |
| EXTR_USER_COMPANY_NAME |
alco_company -company_name |
VARCHAR (255) |
Y |
Company name of user's default cost center. |
| EXTR_USER_COMPANY_CODE |
alco_company -company_code |
VARCHAR (255) |
Y |
Company code of user's default cost center. |
| PURPOSE_EKEY |
altr_travel_request - tr_purpose |
VARCHAR (255) |
Y |
External key identifying the purpose of the travel plan. |
| CURRENCY_EKEY |
altr_travel_request - tr_total_cost_id |
VARCHAR (255) |
Y |
External key identifying the currency used for the amount fields. |
| USER_EKEY |
altr_travel_request - user_id |
VARCHAR (255) |
Y |
External key identifying the user who is the owner of the travel plan. |
| ITINERARY_STATE |
altr_travel_request - itinerary_state |
INT |
Y |
-2 = queued -1 = canceled 0 = active but no ticket 1 = confirmed 2 = ticketed |
| EXTR_USER_SEGMENT1_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 1 name of user default cost center |
| EXTR_USER_SEGMENT1_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 1 code of user default cost center |
| EXTR_USER_SEGMENT2_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 2 name of user default cost center |
| EXTR_USER_SEGMENT2_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 2 code of user default cost center |
| EXTR_USER_SEGMENT3_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 3 name of user default cost center |
| EXTR_USER_SEGMENT3_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 3 code of user default cost center |
| EXTR_USER_SEGMENT4_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 4 name of user default cost center |
| EXTR_USER_SEGMENT4_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 4 code of user default cost center |
| EXTR_USER_SEGMENT5_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 5 name of user default cost center |
| EXTR_USER_SEGMENT5_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 5 code of user default cost center |
| EXTR_USER_SEGMENT6_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 6 name of user default cost center |
| EXTR_USER_SEGMENT6_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 6 code of user default cost center |
| EXTR_USER_SEGMENT7_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 7 name of user default cost center |
| EXTR_USER_SEGMENT7_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 7 code of user default cost center |
| EXTR_USER_SEGMENT8_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 8 name of user default cost center |
| EXTR_USER_SEGMENT8_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 8 code of user default cost center |
| EXTR_USER_SEGMENT9_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 9 name of user default cost center |
| EXTR_USER_SEGMENT9_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 9 code of user default cost center |
| SEGMENT_COUNT |
alco_cost_center_config - segment_count |
INTEGER |
Y |
The number of segments in this document owner's cost center. |
| EXTR_USER_REVIEW_SEGMENT_NAME |
alco_cost_center_rev_segment - segment_name |
VARCHAR(255) |
Y |
The review segment name of this document owner's cost center. |
| EXTR_USER_REVIEW_SEGMENT_CODE |
alco_cost_center_rev_segment - segment_code |
VARCHAR(255) |
Y |
The review segment code of this document owner's cost center. |