EX_TA_TMPLT_VW

(SQL View)
 Index Back

Travel Authorization Template

Stores travel authorization templates.

SELECT SETID , TEMPLATE , DESCR FROM PS_EX_TEMPLATE_TBL WHERE TEMPLATE_TYPE = 'T' AND EFFDT <= ( SELECT MAX(A.EFFDT) FROM PS_EX_TEMPLATE_TBL A WHERE A.SETID = SETID AND A.TEMPLATE = TEMPLATE AND A.EFFDT <= %CurrentDateIn)

  • Related Language Record: EX_TATMPLT_L_V

    • # 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 TEMPLATE Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Prompt Table: EX_TA_TMPLT_VW