EX_GETRANGE_VW

(SQL View)
 Index Back

Per Diem Detail Table


SELECT A.SETID ,A.EXPENSE_TYPE ,A.COUNTRY ,A.CURRENCY_CD ,A.EFFDT ,A.RANGE_CATEGORY ,A.TXN_LOCATION ,B.RANGE_ID FROM PS_EX_PER_DIEM_DTL A , PS_EX_PER_DIEM_TBL B WHERE A.SETID = B.SETID AND A.EXPENSE_TYPE = B.EXPENSE_TYPE AND A.COUNTRY = B.COUNTRY AND A.CURRENCY_CD = B.CURRENCY_CD AND A.EFFDT = B.EFFDT

  • Parent record: EX_PER_DIEM_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

    Prompt Table: EX_TYPES_TBL

    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: EX_PER_DIEM_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 RANGE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Range Category

    Default Value: LOC

    7 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location

    Prompt Table: EX_LOCATION_TBL

    8 RANGE_ID Character(5) VARCHAR2(5) NOT NULL Range ID