POS_NOD_SRC_VW2

(SQL View)
 Index Back

Sources used by node


select DISTINCT SETID, TREE_NAME, POS_SOURCE_ID from PS_POS_WHERE_HDR WHERE USE_SOURCE = 'Y'

  • Parent record: POS_HDR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

    Prompt Table: POS_SOURCE_TBL