RS_MYASSGN_VWL

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.ASSIGNMENT_ID , L.LANGUAGE_CD , L.DESCR FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSGN_STS) B , %Table(RS_ASSGN_ST_LNG) L WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = 'RS' AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) WHERE ASSIGNMENT_ID = A.ASSIGNMENT_ID) AND L.ASSIGN_STS = B.ASSIGN_STS

  • Related Language Record for RS_MYASSGN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2