EX_USER_DFLT_VW

(SQL View)
Index Back

Expenses User Defaults


SELECT B.EMPLID , CASE WHEN A.EXPENSE_TYPE IS NULL THEN ' ' ELSE A.EXPENSE_TYPE END , CASE WHEN A.PREF_MRCHNT_FLG IS NULL THEN ' ' ELSE A.PREF_MRCHNT_FLG END , CASE WHEN A.MERCHANT_CD IS NULL THEN ' ' ELSE A.MERCHANT_CD END , A.MERCHANT , CASE WHEN A.EXPEND_MTHD IS NULL THEN B.EXPEND_MTHD ELSE A.EXPEND_MTHD END , CASE WHEN A.BILL_CODE_EX IS NULL THEN B.BILL_CODE_EX ELSE A.BILL_CODE_EX END , B.TRAVEL_FROM , B.TXN_LOCATION , B.TRANSPORT_TYPE , B.TRANSPORT_ID , B.CRDMEM_ACCT_NBR , B.BILLING_ACTION , B.NBR_NIGHTS FROM PS_EX_EE_USER_PREF B LEFT OUTER JOIN PS_EX_EE_USER_DTL A ON A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
3 PREF_MRCHNT_FLG Character(1) VARCHAR2(1) NOT NULL Preferred Merchant
N=No
Y=Yes
4 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
5 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
6 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
7 BILL_CODE_EX Character(3) VARCHAR2(3) NOT NULL Expense Billing Code
8 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.
9 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location
10 TRANSPORT_TYPE Character(5) VARCHAR2(5) NOT NULL Transportation Type
11 TRANSPORT_ID Character(15) VARCHAR2(15) NOT NULL Transportation ID
12 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
13 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
14 NBR_NIGHTS Number(3,0) SMALLINT NOT NULL Number of Nights