RB_INT_CNT_PHVW(SQL View) |
Index Back |
|---|---|
Contact Phone InformationThis is a view used to view the Contact Phone Information. |
| SELECT A.SETID , A.CONTACT_ID , B.BO_CM_START_DT , D.FIELDVALUE , C.COUNTRY_CODE , C.PHONE , C.EXTENSION , C.ROW_LASTMANT_OPRID , %DatePart(C.ROW_LASTMANT_DTTM) FROM PS_RB_INT_CONTACT A , PS_BO_CM B , PS_CM_PHONE C , PS_CM_PURP_TYPE D , PS_BO_CM_USE E WHERE A.BO_ID = B.BO_ID AND B.CM_TYPE_ID = 2 AND B.CM_ID = C.CM_ID AND B.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND B.CM_TYPE_ID = D.CM_TYPE_ID AND A.BO_ID = E.BO_ID AND B.PROFILE_CM_SEQ = E.PROFILE_CM_SEQ AND E.ROLE_TYPE_ID = 8 AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn |
| # | 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.
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | 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 |
| 5 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 7 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 8 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |
| 9 | DATE_LAST_MAINT | Date(10) | DATE | This field determines the date of last maintenance. |