BO_PMCT_NAM_VW(SQL View) |
Index Back |
---|---|
Primary Contact NameThis is the Primary Contact Name view. |
SELECT A.BO_ID_2 , D.BO_ID , G.PERSON_ID , D.BO_NAME , G.TITLE , A.BO_REL_ID , A.REL_TYPE_ID FROM PS_BO_REL A , PS_BO_REL_CAT_ITEM B , PS_RD_PERSON G , PS_BO D WHERE B.BO_REL_CATEGORY_ID = 2 AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND A.REL_TYPE_ID = B.REL_TYPE_ID AND A.BO_ID_1 = D.BO_ID AND D.BO_ID = G.BO_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
2 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
4 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Business Name Display. BO_NAME.NAME_DISPLAY |
5 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
6 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
7 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |