RA_MKT_CENTERRA_MC_VW(SQL View) |
Index Back |
|---|---|
Marketing CenterMarketing center view used by documents, templates, dialog |
| SELECT A.RA_MKT_CENTER , A.DESCR50 , B.INSTITUTION , B.DESCR , C.XLATSHORTNAME FROM PS_RA_UD_MKTCENTER A LEFT OUTER JOIN PS_RA_CTRMAXEFF_VW C ON A.RA_HE_CENTER_TYPE=C.FIELDVALUE AND C.FIELDNAME='RA_HE_CENTER_TYPE' , PS_INSTITUTION_TBL B WHERE A.CS_INSTITUTION=B.INSTITUTION AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_INSTITUTION_TBL BB WHERE B.INSTITUTION = BB.INSTITUTION AND BB.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_MKT_CENTER |
Character(10) | VARCHAR2(10) NOT NULL | Marketing Center code |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Institution field to store institution information in campus solution system. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Center Type |