RB_UAD_CTIQ_VW

(SQL View)
Index Back

UAD Default Queue

This View is used to contain the UAD Default Queue

SELECT DISTINCT CTI.OPRID , CTI.PT_CTI_QUEUE , CTI.EFFDT FROM PS_PT_CTI_AGENT CTI

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DFLT_AGENT_QUEUE Character(32) VARCHAR2(32) NOT NULL Default UAD Agent Queue
3 EFFDT Date(10) DATE Effective Date

Default Value: %date