CM_SPDKEYTBL_LN (SQL Table)	Index Back
Comm Speed Key Table COMM_SPDKEY_TBL 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 communications in background processes either when associated with Checklist Items or when used in the Communication Generation process.

CM_SPDKEYTBL_LN

(SQL Table)

Comm Speed Key Table

COMM_SPDKEY_TBL 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 communications in background processes either when associated with Checklist Items or when used in the Communication Generation process.

Related Language Record for COMM_SPDKEY_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
Prompt Table: ADM_FUNCTN_TBL

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

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 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 Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
3	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description