FAZIPREGNVWLNG

(SQL View)
 Index Back

Zip Code Region Base Node View

This view returnsr the lowest-level regions on the Region tree.

SELECT A.SETID , B.REGION , B.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PSTREENODE A , PS_BDGT_REGION_LNG B WHERE A.TREE_NAME = 'FA_ZIPCODE_REGION' AND A.TREE_NODE = B.REGION AND A.SETID = B.SETID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BDGT_REGION_LNG B1 WHERE B1.SETID = B.SETID AND B1.REGION = B.REGION AND B1.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE A1 WHERE A1.SETID = A.SETID AND A1.TREE_NAME = A.TREE_NAME AND A1.TREE_BRANCH = A.TREE_BRANCH AND A1.TREE_NODE_NUM = A.TREE_NODE_NUM AND A1.TREE_NODE = A.TREE_NODE AND A1.EFFDT <= %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PSTREELEAF D WHERE D.TREE_NODE_NUM=A.TREE_NODE_NUM AND D.SETID = A.SETID AND D.TREE_NAME = A.TREE_NAME AND D.EFFDT = A.EFFDT)

  • Related Language Record for FA_ZIP_REGN_VW

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

    Prompt Table: REGION_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description