ORG_TRACK_SRCH

(SQL View)
 Index Back

Org Tracking Groups Search

This search view is used to include the city, state, and country address fields as alternate search keys. It was created to be used on external organization traking group panels.

SELECT A.COMMON_ID , A.TRACKING_SEQ , A.ADMIN_FUNCTION , A.TRACKING_GROUP , B.DESCR , B.OTH_NAME_SORT_SRCH , B.EXT_ORG_TYPE , B.CITY , B.STATE , B.COUNTRY FROM PS_TRACKING_GRPS A , PS_EXT_ORG_PRI_VW B WHERE A.COMMON_ID = B.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_TBL B1, B, %CurrentDateIn)

  • Related Language Record: ORGTRACKSRCHLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

    Prompt Table: EXT_ORG_TBL

    2 TRACKING_SEQ Number(3,0) SMALLINT NOT NULL Tracking Sequence
    3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    4 TRACKING_GROUP Character(6) VARCHAR2(6) NOT NULL Tracking Group
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    7 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Default Value: SCHL

    Prompt Table: SCC_ORG_TYP_TBL

    8 CITY Character(30) VARCHAR2(30) NOT NULL City
    9 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL