DST_CNTRL_VW_LG

(SQL View)
 Index Back

AP Acctg Entry Tmplt View Lang

AP Acctg Entry Template View, Related Language View.

SELECT a.setid , a.dst_cntrl_id , b.effdt , a.language_cd , a.descr , a.descrshort FROM PS_DST_CNTRL_HDR_L a , ps_dst_cntrl_tbl b WHERE a.SETID = b.SETID AND a.DST_CNTRL_ID = b.DST_CNTRL_ID AND b.EFF_STATUS = 'A' AND b.EFFDT = ( SELECT MAX(c.EFFDT) FROM PS_DST_CNTRL_TBL c WHERE c.SETID = a.SETID AND c.DST_CNTRL_ID = a.DST_CNTRL_ID AND c.EFFDT <= %CurrentDateIn)

  • Related Language Record for DST_CNTRL_VW

    • # 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: SETID_TBL

    2 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description