RUN_CNTL_CNTCT

(SQL Table)
Index Back

User email preference

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LM_USREML_PREF Character(1) VARCHAR2(1) NOT NULL Contact Preference
P=Learner Primary Email
T=Specific Email Type
U=Primary Email

Default Value: P

4 LM_CM_PURP_TYPE Character(4) VARCHAR2(4) NOT NULL Contact Method Purpose Type

Prompt Table: LM_CM_PURP_TYPE

5 EMAILTYPE Character(4) VARCHAR2(4) NOT NULL Email Type
BB=Blackberry
BUS=Business
HOME=Home
OTH=Other
WORK=Work