EX_ER_HDR_AW_V2

(SQL View)
 Index Back

Expense Report Header View

Additional header information with descriptions

SELECT A.SHEET_ID , A.EMPLID , B.FIRST_NAME || ' ' || B.LAST_NAME , C.DESCR , CASE WHEN A.TXN_LOCATION <> ' ' THEN D.DESCR ELSE ' ' END , A.REFERENCE_ID , A.ACCOUNTING_DT , A.DST_CNTRL_ID FROM PS_EX_SHEET_HDR A LEFT OUTER JOIN PS_EX_CUR_LOC_VW D ON A.SETID = D.SETID AND A.TXN_LOCATION = D.TXN_LOCATION , PS_PERSONAL_DATA B , PS_EX_PURPOSE_TBL C , PS_SET_CNTRL_REC CTL WHERE A.EMPLID = B.EMPLID AND CTL.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND CTL.RECNAME = 'EX_PURPOSE_TBL' AND CTL.SETID = C.SETID AND A.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EX_PURPOSE_TBL X WHERE X.SETID = C.SETID AND X.BUSINESS_PURPOSE = C.BUSINESS_PURPOSE AND X.EFF_STATUS = 'A' AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

Default Value: NEXT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 NAME_60 Character(61) VARCHAR2(61) NOT NULL Name
4 BUS_PURP_DESCR Character(30) VARCHAR2(30) NOT NULL Business Purpose
5 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
6 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
8 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template