COMM_CTXME_SFVW (SQL View)	Index Back
Communication Context Meth Vw COMM_CTX_ME_VW is used to select the appropriate letter codes for a communication context, method and direction within the communication record.

COMM_CTXME_SFVW

(SQL View)

Communication Context Meth Vw

COMM_CTX_ME_VW is used to select the appropriate letter codes for a communication context, method and direction within the communication record.

SELECT DISTINCT a.Comm_Context , a.Comm_Method , a.SCC_Letter_Cd FROM PS_COMM_CTX_ME_TBL A WHERE A.SCC_LETTER_CD <> ' ' AND a.effdt = ( SELECT MAX(b.effdt) FROM PS_COMM_CTX_ME_TBL b WHERE b.Institution = a.Institution AND b.Comm_context = a.Comm_Context AND b.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
Prompt Table: COMM_CTXT_TBL

2 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

3 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
Prompt Table: SCC_STN_LTR_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMM_CONTEXT	Character(6)	VARCHAR2(6) NOT NULL	Communication Context Prompt Table: COMM_CTXT_TBL
2	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
3	SCC_LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter Code Prompt Table: SCC_STN_LTR_TBL