DEAL_CNF_TRN_VW

(SQL View)
 Index Back

Deal Confo Status View


SELECT %Substring(A.FIELDVALUE,1,2) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'DEAL_CONF_STATUS' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: DEAL_CNF_TRN_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEAL_CONF_STATUS Character(2) VARCHAR2(2) NOT NULL Reflects the confirmation status of a given deal transaction at any particular point in time.
    01=Pending
    02=Confirmed
    03=Invalid
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description