EVNT_COMM_MC_VW

(SQL View)
 Index Back

Comm Speed Key Table for MC

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

SELECT A.INSTITUTION ,A.EVENT_3CS_ID ,A.ADMIN_FUNCTION ,B.COMM_KEY ,B.COMM_CATEGORY ,B.COMM_CONTEXT ,B.COMM_METHOD ,B.COMM_DIRECTION ,B.UNSUCCESSFUL ,B.OUTCOME_REASON ,B.SCC_LETTER_CD ,B.COMMENT_PRINT_FLAG ,B.ACTIVITY_COMPLETED FROM PS_EVNT_3CS_TBL A , PS_EVNT_COMM_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_EVNT_3CS_TBL A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.EVENT_3CS_ID=A.EVENT_3CS_ID) AND A.EFFDT = B.EFFDT AND A.EFF_STATUS<> 'I'

# 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 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID
3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

Prompt Table: ADM_FUNCTN_TBL

4 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key
5 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

Prompt Table: COMM_CATG_TBL

6 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

Prompt Table: COMM_CA_CTX_TBL

7 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
B=Publication
D=Document
E=Email
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web

Prompt Table: COMM_CTX_ME_TBL

8 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
IN=Incoming Communication
OUT=Outgoing Communication
PERS=In Person
9 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome

Y/N Table Edit

Default Value: N

10 OUTCOME_REASON Character(1) VARCHAR2(1) NOT NULL Outcome Reason
C=Missing Critical Data
E=Invalid Email Address
M=Left Message on Machine
N=No Answer
O=No Org Recipients found
P=Left Message with Person
R=Returned Mail
S=Email Send Error
11 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
12 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

Y/N Table Edit

Default Value: N

13 ACTIVITY_COMPLETED Character(1) VARCHAR2(1) NOT NULL Activity Completed

Y/N Table Edit

Default Value: N