SCC_COM_PRF_STG (SQL Table)	Index Back
Communication preferences Stg This CTM staging table stores the communication preferences for an individual at an Institution.

SCC_COM_PRF_STG

(SQL Table)

Communication preferences Stg

This CTM staging table stores the communication preferences for an individual at an Institution.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

2 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
Prompt Table: SCC_COMM_LANG
Set Control Field: LANG_CD

3 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: SCC_COMM_MTHD
Set Control Field: COMM_METHOD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
2	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese Prompt Table: SCC_COMM_LANG Set Control Field: LANG_CD
3	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: SCC_COMM_MTHD Set Control Field: COMM_METHOD