CA_MYCAROLE_VW

(SQL View)
Index Back

Contract Role View

Contract Role View

SELECT DISTINCT CA.OPRID ,S.CONTRACT_ROLE ,S.DESCR FROM PS_CA_CONTR_ROLE S , PS_CA_CONTR_HDR HDR , PS_CA_OPRID_CONTR CA , PS_SET_CNTRL_REC REC WHERE CA.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.CONTRACT_ROLE = S.CONTRACT_ROLE AND REC.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND REC.RECNAME = 'CA_CONTR_ROLE' AND REC.SETID = S.SETID

  • Related Language Record: CA_MYCAROLE_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 CONTRACT_ROLE Character(15) VARCHAR2(15) NOT NULL Contract Role
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description