CA_ENTRY_ACT_VW

(SQL View)
 Index Back

Activity Entry View

Activity Entry View

SELECT CA.BUSINESS_UNIT , CA.CONTRACT_NUM , CA.DESCR , CA.SOLD_TO_CUST_ID , CUST.NAME1 , CA.CA_RQST_SRC , CA.CA_STATUS , CA.CONTRACT_TYPE , CA.CA_PROC_STATUS , CA.CONTRACT_ADMIN FROM PS_PTAI_CONTEXT PT ,PS_PTAI_LIST PL ,PS_CA_CONTR_HDR CA , PS_CUSTOMER CUST , PS_SET_CNTRL_REC SCREC WHERE PT.PTAI_LIST_ID=PL.PTAI_LIST_ID AND PT.FIELDNAME = 'CONTRACT_NUM' AND PT.RECNAME = 'CA_CONTR_HDR' AND PT.PTAI_KEY_VALUE <> ' ' AND PT.PTAI_LIST_ID LIKE 'CA_ENTRYLL%' AND PT.PTAI_KEY_VALUE=CA.CONTRACT_NUM AND CA.SOLD_TO_CUST_ID = CUST.CUST_ID AND CA.BUSINESS_UNIT = SCREC.SETCNTRLVALUE AND SCREC.RECNAME = 'CUSTOMER' AND SCREC.SETID = CUST.SETID

  • Related Language Record: CA_ENT_ACT_LGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
    FED=Federal Reimbursable Agreement
    GEN=Generic Application
    GOV=Government
    INT=Internal
    OND=CRM Field Services On Demand
    STD=Standard
    7 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
    8 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
    9 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
    10 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.