GPFR_CONTCD3_VW

(SQL View)
 Index Back

Retrieves Contact definition

View to retrieve contact defintion to be used as prompts on the ducs definition page. This view filters out contacts based on the DUCS type.

SELECT A.GPFR_DUCS_TYPE ,A.GPFR_CONT_CD ,B.DESCR , B.GPFR_CONT_AD_TYPE FROM PS_GPFR_DUCS_CONT1 A , PS_GPFR_DUCS_CONT0 B WHERE A.GPFR_CONT_CD=B.GPFR_CONT_CD AND A.GPFR_CONT_TYP = 'S'

  • Related Language Record: GPFR_CONLNG3_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DUCS_TYPE Character(3) VARCHAR2(3) NOT NULL GPFR: DUCS Type
    2 GPFR_DUCS_CD Character(10) VARCHAR2(10) NOT NULL GPFR: DUCS Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 GPFR_CONT_AD_TYPE Character(1) VARCHAR2(1) NOT NULL GPFR: Address Type
    1=Company Address
    2=Establishment Address
    3=Other