CA_MYCA_STAT_VW

(SQL View)
 Index Back

All Status values


SELECT DISTINCT CA.OPRID ,S.CA_STATUS ,S.DESCR ,S.CA_PROC_STATUS FROM PS_CA_STATUS_TBL 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.CA_STATUS = S.CA_STATUS AND REC.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND REC.RECNAME = 'CA_STATUS_TBL' AND REC.SETID = S.SETID

  • Related Language Record: CA_MYCA_STA_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 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
    A=Active
    C=Closed
    P=Pending

    Default Value: P