| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
BUSINESS_PURPOSE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Purpose
Prompt Table:
EX_PURPOSE_TBL
|
| 3 |
SHEET_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Description
|
| 4 |
ADVANCE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Advance Description
|
| 5 |
TRAVEL_AUTH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.
|
| 6 |
POPULATE_MTHD_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to create an Expense Report.
C=Copy From Existing Travel Auth
K=Open a Blank Expense Report
S=Copy From Existing Report
T=Use a Template
|
| 7 |
POPULATE_MTHD_TA |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to populate a travel authorization
A=Copy From Travel Authorization
B=Open a Blank Travel Auth
C=Copy From Existing Travel Auth
T=Use a Template
|
| 8 |
POPULATE_MTHD_TM |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to create a Time Report.
Y=Copy from Previous Time Report
Z=Open a Blank Time Report
|
| 9 |
TRAVEL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
Prompt Table:
EX_LOCATION_VW5
|
| 10 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW
|
| 11 |
BILL_CODE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Billing Code
Prompt Table:
EX_BILL_CD_TBL
|
| 12 |
TRANSPORT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transportation Type
Prompt Table:
EX_TRNSPT_TYPES
|
| 13 |
NEW_EX_PIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Expense Report
1=Open a Blank Report
2=Copy an Existing Report
3=Copy From a Travel Auth.
4=Copy From a Template
Default Value: 1
|
| 14 |
NEW_EX_MOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Mobile Expense Report
1=Open a Blank Report
2=Copy an Existing Report
3=Copy From a Travel Auth.
4=Copy From a Template
Default Value: 1
|
| 15 |
NEW_TA_PIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to populate a travel authorization
1=Open a Blank Authorization
2=Copy an Existing Authorization
3=Copy From a Template
Default Value: 1
|
| 16 |
NEW_TA_MOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to populate a travel authorization
1=Open a Blank Authorization
2=Copy From a Travel Auth.
3=Copy an Existing Authorization
4=Copy From a Template
Default Value: 1
|
| 17 |
NEW_TM_PIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to create a Time Report.
1=Open a Blank Report
2=Copy an Existing Report
Default Value: 1
|
| 18 |
NEW_TM_MOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to allow a user to determine how they would like to create a Time Report when using Mobile.
1=Open a Blank Report
2=Copy an Existing Report
Default Value: 1
|
| 19 |
TRANSPORT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transportation ID
Prompt Table:
EX_EE_TRNSPT_VW
|
| 20 |
RANGE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Per Diem Range
Prompt Table:
EX_DUR_VW
|
| 21 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Credit Card
Prompt Table:
EX_EMP_CARD_VW
|
| 22 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 23 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 24 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_VW
|
| 25 |
BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
|
| 26 |
SHOW_DESCR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Descriptions Option
D=Default :
N=Codes
Y=Descriptions
Default Value: D
|
| 27 |
EXPEND_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Type
Prompt Table:
EX_EXP_MTHD_TBL
|
| 28 |
NBR_NIGHTS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Nights
|
| 29 |
ACCTNG_DFLT_VIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Detail Default View
C=Collapsed
E=Expanded
Default Value: C
|
| 30 |
RECEIPT_REQ_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Required
Y/N Table Edit
Default Value: N
|