WTHD_CD_VNDR_VW

(SQL View)
Index Back

Withholding Code Header


select b.wthd_entity, a.setid, a.wthd_cd, a.descr from ps_wthd_cd_hdr a, PS_WTHD_CD_DTL b where a.setid = b.setid and a.wthd_cd = b.wthd_cd

  • Related Language Record: WTHD_CD_VNDR_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    3 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description