SCC_EMAIL_PVW

(SQL View)
 Index Back

E-mail change messaging table


SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.E_ADDR_TYPE , A.EMAIL_ADDR , A.PREF_EMAIL_FLAG , A.AUDIT_ACTN FROM PS_SCC_EMAIL_STG A WHERE A.AUDIT_ACTN = 'C' OR A.AUDIT_ACTN = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCC_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequence ID
3 SCC_SEQ_ID3 Number(3,0) SMALLINT NOT NULL Sequence Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
6 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
7 PREF_EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred

Y/N Table Edit

8 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values