SETIDCONTACT_IDPHONE_TYPEBUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
CONTACT_PHN(SQL View) |
Index Back |
|---|---|
Contact Phone InformationCONTACT_PHN - Used by CDM EIP for CRM/SCM Integration. Handle Contact Phone. |
| SELECT A.SETID , A.CONTACT_ID , A.PHONE_TYPE , A.COUNTRY_CODE , A.PHONE , A.EXTENSION , A.LAST_MAINT_OPRID , A.DATE_LAST_MAINT FROM PS_RB_INT_CNT_PHVW A WHERE COUNTRY_CODE %Concat PHONE %Concat EXTENSION = ( SELECT MAX(B.COUNTRY_CODE %Concat B.PHONE %Concat B.EXTENSION) FROM PS_RB_INT_CNT_PHVW B WHERE A.SETID = B.SETID AND A.CONTACT_ID = B.CONTACT_ID AND A.PHONE_TYPE = B.PHONE_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 3 | PHONE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
phone type field to store value of phone type.
BUSN=Business Phone CAMP=Campus CELL=Cellular Phone DFLT=Default DORM=Dormitory FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 4 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 5 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 6 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 7 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |
| 8 | DATE_LAST_MAINT | Date(10) | DATE | This field determines the date of last maintenance. |