BUSINESS_UNITRA_CAMPAIGN_IDBO_IDRY_TEAM_TASK_VW(SQL View) |
Index Back |
|---|---|
Task Team ViewTask Team Business object search (team members) View.This view is created for an ice [refer project RY_1831302000_IDC_HVALA_UT] |
| SELECT B.BUSINESS_UNIT , B.RA_CAMPAIGN_ID , A.BO_ID , B.BO_ROLE_TYPE_ID , A.BO_NAME , ' ' FROM PS_BO A , PS_RA_TEAM B , PS_RA_PROGRAM_TBL C ,PS_RY_DLG_TEAM D WHERE A.BO_ID = D.BO_ID_PERSON AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID AND C.DIALOG_ID=D.DIALOG_ID AND B.SEQNO=1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RA_CAMPAIGN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 3 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 4 | BO_ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | BO_ROLE_TYPE_ID |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |