HRS_BIP_JEXP_VW(SQL View) |
Index Back |
---|---|
Used in XMLP report for Job OUsed 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 |