CS_OBJECTS2_LVW

(SQL View)
 Index Back

prompt for objects

uses effective date to get list of objects. based on object type

SELECT A.SETID , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , B.EFFDT , c.language_cd , c.descr60 FROM PS_CS_OBJECTS_HDR A , PS_CS_OBJECTS_DTL B , PS_CS_OBJS_HDR_LNG C WHERE A.SETID = B.SETID AND A.CS_OBJECT_ID = B.CS_OBJECT_ID AND A.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND A.SETID = C.SETID AND A.CS_OBJECT_ID = C.CS_OBJECT_ID AND A.CS_OBJECT_TYPE = C.CS_OBJECT_TYPE

  • Related Language Record for CS_OBJECTS2_VW CS_OBJECTS3_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CS_OBJ_TYPE_CHILD Character(4) VARCHAR2(4) NOT NULL Clause/section dependent
    0001=Clause
    0002=Section
    0004=Rule
    3 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description