SRCCD_EXCL_SRCH

(SQL View)
 Index Back

Source Code Exclusions Search

Search record for SRC_CD_EXCLUSIONS component Date Initials Issue Description 102501 dms D-RBADARIN-6 New

SELECT e.setid , e.source_cd , s.descr FROM PS_SRC_CD_EXCLUSNS e , ps_ord_source_cd s WHERE s.setid = e.setid AND s.source_cd = e.source_cd AND s.eff_status = 'A' AND %EffdtCheck(ord_source_cd, s, %CurrentDateIn)

  • Related Language Record: SRCCD_EXCL_LNG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

    Prompt Table: ORD_SOURCE_CD

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description