SUJ:Added a join for system source field to list only Resource management assignments in My assignments "Assignments " grid.

RS_MYASSGN_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.ASSIGNMENT_ID , A1.START_DT , A1.END_DT , A.DESCR , A.EMPLID , A.PROJ_ROLE , B.ASSIGN_STS , C.DESCR FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSIGNDET_VW) A1 , %Table(RS_ASSGN_STS) B , %Table(RS_ASSGN_ST_TBL) C WHERE A.ASSIGNMENT_ID = A1.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = 'RS' AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) WHERE ASSIGNMENT_ID = A.ASSIGNMENT_ID) AND C.ASSIGN_STS = B.ASSIGN_STS

  • Related Language Record: RS_MYASSGN_VWL

    • # 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 START_DT Date(10) DATE Start Date
    6 END_DT Date(10) DATE End Date
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    10 ASSIGN_STS Character(2) VARCHAR2(2) NOT NULL Assignment Status
    A=Assign
    C=Complete
    I=Interview
    P=Propose
    R=Reject
    S=Reserve
    V=Pending Approval
    X=Cancel
    11 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2