COMM_METHODB=Publication
D=Document
E=Email
F=Fax
L=Letter
P=Personal Contact
T=Telephone Call
W=Web
Prompt Table: SCC_PREF_COMMVW
SCC_PREF_COMMVW(SQL View) |
Index Back |
|---|---|
Language code viewLanguage code view for preferences |
| SELECT S.COMM_METHOD , A.XLATLONGNAME FROM PS_SCC_COMM_MTHD S , PSXLATITEM A WHERE A.FIELDNAME = 'COMM_METHOD' AND A.FIELDVALUE = S.COMM_METHOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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_PREF_COMMVW |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |