VISA_PMT_SUP_VW

(SQL View)
 Index Back

Visa Supporting Docs Needed

Use VISA_PERMIT_SUP to specify supporting documents required for a visa or permit identified on VISA_PERMIT_TBL. Use VISA_PERMIT_TBL to track visa or permit requirements for each country where your company's employees live or work.

SELECT A.COUNTRY , A.VISA_PERMIT_TYPE , A.SUPPORT_DOC_ID FROM PS_VISA_PERMIT_SUP A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VISA_PERMIT_SUP B WHERE A.COUNTRY = B.COUNTRY AND A.VISA_PERMIT_TYPE = B.VISA_PERMIT_TYPE AND B.EFFDT <= %CurrentDateIn)

  • Parent record: VISA_PERMIT_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type

    Prompt Table: VISA_PERMIT_TBL

    3 SUPPORT_DOC_ID Character(6) VARCHAR2(6) NOT NULL Supporting Document ID

    Prompt Table: SUPPORT_DOC_TBL