COMM_SPDKEY_VW (SQL View)	Index Back
Comm Speed Key View COMM_SPDKEY_VW is used to create a combination of Communication Category, Context, Method, and Direction with one key. Communication Keys created in this table are used to generate communication in background processes either when associated with Checklist Items or when used in the Communication Generation process.

COMM_SPDKEY_VW

(SQL View)

Comm Speed Key View

COMM_SPDKEY_VW is used to create a combination of Communication Category, Context, Method, and Direction with one key. Communication Keys created in this table are used to generate communication in background processes either when associated with Checklist Items or when used in the Communication Generation process.

SELECT institution , comm_key , admin_function , descr FROM PS_COMM_SPDKEY_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key
3	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description