KB_SQL STORED PROCEDURES FOR TELEPHONE DIRECTORY

NAME: ST_PHONE_IEN

SET STORED_PROCEDURE ON
SET PARAMETERS = 'ien'
SELECT REAL_NAME, REAL_SECTION, SERVICE_FK@NAME AS SERV, DIGITAL_PAGER,
DISPLAY_EXTENSION, ROUTING_SYMBOL, TITLE, VOICE_PAGER, DEGREE_FK@NAME AS DEG,   ROOM_BLDG_FK@ROOM_NUMBER AS RM
FROM TELEPHONE_DIRECTORY_RECORD WHERE TELEPHONE_DIRECTORY_RECORD_ID = ?

This stored procedure is called by the "staff.asp" page.

NAME: ST_PHONE_LETTER

SET STORED_PROCEDURE ON
SET PARAMETERS = 'letter’
SELECT TELEPHONE_DIRECTORY_RECORD_ID, REAL_NAME, REAL_SECTION, SERVICE_FK@NAME AS SERV
FROM TELEPHONE_DIRECTORY_RECORD
WHERE EXTRACT(REAL_NAME,1,1) = ? AND RECORD_TYPE <> 'O'
ORDER BY REAL_NAME

This stored procedure is called by the "phone.asp" page.

NAME: ST_PHONE_NAME

SET STORED_PROCEDURE ON
SET PARAMETERS = 'name'
SELECT TELEPHONE_DIRECTORY_RECORD_ID, REAL_NAME, REAL_SECTION,
SERVICE_FK@NAME AS SERV
FROM TELEPHONE_DIRECTORY_RECORD
WHERE REAL_NAME [ ? AND RECORD_TYPE <> 'O’
ORDER BY REAL_NAME

This stored procedure is called by the "phone2.asp" page.

NAME: ST_PHONE_SERVICE

SET STORED_PROCEDURE ON
SET PARAMETERS = 'service'
SELECT TELEPHONE_DIRECTORY_RECORD_ID, REAL_NAME, DISPLAY_EXTENSION, TITLE, SERVICE_FK@NAME AS SERV, ROOM_BLDG_FK@ROOM_NUMBER AS RM
FROM TELEPHONE_DIRECTORY_RECORD
WHERE SERVICE_FK@NAME [ ? AND RECORD_TYPE <> 'O'
ORDER BY REAL_NAME

This stored procedure is called by the "phone3.asp" page.

Back