SSR_BR_MSGS_VW

(SQL View)
 Index Back

Errors and Suspense Statistics


SELECT 'IDENTIFICATION' , ( SELECT COUNT(*) FROM PS_SSR_BR_IDRVWNLD ) +( SELECT COUNT(*) FROM PS_SSR_BR_IDSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'ENROLLMENTS' , ( SELECT COUNT(*) FROM PS_SSR_BR_ENRJVWNL )+ ( SELECT COUNT(*) FROM PS_SSR_BR_ENSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'BPV' , ( SELECT COUNT(*) FROM PS_SSR_BR_BPRVWNLD )+ ( SELECT COUNT(*) FROM PS_SSR_BR_BPSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'DIPLOMAS' , ( SELECT COUNT(*) FROM PS_SSR_BR_DPRVWNLD ) + ( SELECT COUNT(*) FROM PS_SSR_BR_DPSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'RESULTS' , ( SELECT COUNT(*) FROM PS_SSR_BR_RSRVWNLD )+ ( SELECT COUNT(*) FROM PS_SSR_BR_RSSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'PRIOREDUCATIONDATA' , ( SELECT COUNT(*) FROM PS_SSR_BR_PERVWNLD ) +( SELECT COUNT(*) FROM PS_SSR_BR_PESVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'SUBSCRPRIOREDUDATA' , ( SELECT COUNT(*) FROM PS_SSR_BR_PSRVWNLD ) +( SELECT COUNT(*) FROM PS_SSR_BR_PSSVWNLD) "COUNT" FROM PS_INSTALLATION UNION SELECT 'APPLICATION' , ( SELECT COUNT(*) FROM PS_SSR_BR_EARJVWNL ) +( SELECT COUNT(*) FROM PS_SSR_BR_EASVWNLD) "COUNT" FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2 COUNT_ROWS Number(3,0) SMALLINT NOT NULL Count rows.