SDB_E_SYSDFN_VW

(SQL View)
Index Back

ERMS System Definition View

ERMS System Definition View for Contact Center Dashboard

SELECT SYSTEM_ID , TMPLT_CATEGRY_ID FROM PS_RB_ERMS_SYSDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYSTEM_ID Character(5) VARCHAR2(5) NOT NULL System ID
2 TMPLT_CATEGRY_ID Number(6,0) INTEGER NOT NULL Template Category ID