HRS_BIP_JEXP_VW

(SQL View)
Index Back

Used in XMLP report for Job O

Used in XMLP report for Job Opening

SELECT A.HRS_JOB_OPENING_ID , A.CHARGE_DT , ' ' , A.SEQ_NBR , A.HRS_PERSON_ID , B.NAME_DISPLAY , A.EXPENSE_CD , C.XLATLONGNAME , A.CURRENCY_CD , A.EXPENSE_AMT FROM PS_HRS_JO_EXP_I A LEFT OUTER JOIN PS_HRS_APP_NM_SRCH B ON (A.HRS_PERSON_ID = B.HRS_PERSON_ID) , PSXLATITEM C WHERE C.FIELDNAME = 'EXPENSE_CD' AND C.FIELDVALUE = A.EXPENSE_CD AND C.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM D,C,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
2 CHARGE_DT Date(10) DATE Charge Date
3 HRS_EXPDT_STR Character(15) VARCHAR2(15) NOT NULL Used for XMLP Print Job Opening
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
7 EXPENSE_CD Character(2) VARCHAR2(2) NOT NULL Expense code.
01=Airfare
02=Lodging
03=Car Rental
04=Meals
05=Telephone
06=Travel
07=Relocation
08=Entertainment
09=Parking
10=Mileage
11=Advertising
12=Referral Fee
13=Postage
14=Publication
15=Membership
16=Miscellaneous
17=Staff Time
18=Job Boards
19=Pre-Employment Request
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 EXPENSE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Expense Amount