SCC_NTF_HDR_VW

(SQL View)
Index Back

Notification Request Hdr view

Notification Request Hdr view

SELECT SCC_NTFREQ_ID ,SCC_NTF_CON_ID ,SCC_NTFREQ_STATUS FROM %Table(SCC_NTFREQ_HDR)

  • Parent Record Of SCC_NTF_DTL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    2 SCC_NTF_CON_ID Character(40) VARCHAR2(40) NOT NULL Consumer ID
    3 SCC_NTFREQ_STATUS Character(1) VARCHAR2(1) NOT NULL Notification Status
    E=Error
    P=Pending
    R=Partial Success
    S=Success