COMM_CTX_LET_VW

(SQL View)
Index Back

Communication ContextLetter Vw

COMM_CTX_LET_VW is used to select the appropriate letter codes for a communication context within the communication spreed key record.

SELECT DISTINCT A.Institution , A.Comm_Context , A.EFFDT , A.Comm_Method , A.SCC_Letter_Cd FROM PS_COMM_CTX_ME_TBL A WHERE SCC_LETTER_CD <> ' '

# 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 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

Prompt Table: COMM_CTXT_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 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
5 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

Prompt Table: SCC_STN_LTR_TBL