EX_PERDIEM_VW

(SQL View)
 Index Back

Per Diem Detail Table


SELECT SETID ,EXPENSE_TYPE ,COUNTRY ,RANGE_CATEGORY ,EFFDT ,TXN_LOCATION ,CURRENCY_CD ,DATA_SOURCE_EX ,AMT1 ,AMT2 ,AMT3 ,AMT4 ,AMT_GOVT1 ,AMT_GOVT2 ,AMT_GOVT3 ,AMT_GOVT4 ,EX_CALC_CD1 ,EX_CALC_CD2 ,EX_CALC_CD3 ,EX_CALC_CD4 ,PD_LODGING_AMT ,LASTUPDDTTM ,LASTUPDOPRID FROM PS_EX_PER_DIEM_DTL WHERE RANGE_CATEGORY = 'LOC'

  • 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 RANGE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Range Category

    Default Value: LOC

    Prompt Table: EX_CATEGORY_TBL
    Set Control Field: SETID

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: EX_LOCATION_TBL

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

    Default Value: EX_PER_DIEM_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    8 DATA_SOURCE_EX Character(3) VARCHAR2(3) NOT NULL External Data Sources for PS Expenses
    AIR=Airline Ticket
    AMA=American Express
    AMG=American Express
    AMH=American Express-Hotel Folio
    AMM=American Express - Member List
    AMX=American Express
    CNS=CONUS
    DC=Diners Club
    IPH=iReceipts
    MC=MasterCard CDFv2
    MCX=MasterCard CDFv3
    MSG=Text Message
    NAP=PS NA Payroll
    PDA=PDA
    RNZ=Runzheimer
    SAB=Sabre
    UBT=User Chatbot
    USB=US Bank
    USR=User Input
    VI4=Visa
    VIS=Visa

    Default Value: USR

    9 AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step
    10 AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step
    11 AMT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step
    12 AMT4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step
    13 AMT_GOVT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Government Amount 1
    14 AMT_GOVT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Government Amount 2
    15 AMT_GOVT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Government Amount 3
    16 AMT_GOVT4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Government Amount 4
    17 EX_CALC_CD1 Character(5) VARCHAR2(5) NOT NULL Calculation Code 1
    18 EX_CALC_CD2 Character(5) VARCHAR2(5) NOT NULL Calculation Code 2
    19 EX_CALC_CD3 Character(5) VARCHAR2(5) NOT NULL Calculation Code 3
    20 EX_CALC_CD4 Character(5) VARCHAR2(5) NOT NULL Calculation Code 4
    21 PD_LODGING_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Per Diem Lodging Amount
    22 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    23 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.