CS_DOCT_ACT_LVW

(SQL View)
 Index Back

Available Document Types

SCC 12/02/05: Available Document Types

SELECT A.SETID , A.CS_DOCUMENT_TYPE , B.LANGUAGE_CD , B.DESCR254 , B.DESCR FROM PS_CS_DOC_TYPE_TBL A , PS_CS_DOCTYPE_LANG B WHERE A.SETID = B.SETID AND B.CS_DOCUMENT_TYPE = A.CS_DOCUMENT_TYPE

  • Related Language Record for CS_DOCT_ACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    2 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description