SCC_GE_NTFDA_VW

(SQL View)
 Index Back

EMS Notification Request Data

View of Notification Request Data table to get Evaluation Instance ID.

SELECT SCC_NTFREQ_ID ,%TrimSubstr(TO_CHAR(SCC_NTFREQ_DAT_VAL), 1, 16) FROM %Table(SCC_NTFREQ_DATA) WHERE SCC_NTFREQ_DTL_SEQ = 1 AND SCC_NTFREQ_ITM_SEQ = 1 AND SCC_NTFREQ_DAT_KEY = 'SCC_GE_INSTANCE_ID'

  • Parent record: SCC_NTFREQ_ITM

    • # 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_GE_DESCR Character(50) VARCHAR2(50) NOT NULL Description