RA_DBCONTENT_VW(SQL View) |
Index Back |
|---|---|
Content view for DashboardContent view for generating information for dashboard |
| SELECT A.SETID , A.RA_CONTENT_ID , A.DESCR , A.BO_ID_OWNER , A.RA_CONTENT_TYPE , B.DESCR , A.RA_CONTENT_SUBTYPE , C.DESCR , A.RA_CONTENT_STATUS , D.XLATLONGNAME FROM PS_RA_CONTENT A , PS_RA_UD_CONT_TYPE B , PS_RA_UD_CNT_STYPE C , PSXLATITEM D WHERE A.SETID = B.SETID AND A.RA_CONTENT_TYPE=B.RA_CONTENT_TYPE AND A.SETID = C.SETID AND A.RA_CONTENT_TYPE = C.RA_CONTENT_TYPE AND A.RA_CONTENT_SUBTYPE = C.RA_CONTENT_SUBTYPE AND D.FIELDNAME = 'RA_CONTENT_STATUS' AND A.RA_CONTENT_STATUS = D.FIELDVALUE AND D.EFF_STATUS = 'A' |
| # | 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 | RA_CONTENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing - Content ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |
| 5 | RA_CONTENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Marketing - Content Type |
| 6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 7 | RA_CONTENT_SUBTYPE | Character(4) | VARCHAR2(4) NOT NULL | Marketing - Content Sub Type |
| 8 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 9 | RA_CONTENT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Marketing - Content Status
CMPL=Completed EXPR=Expired IREV=In Review NEW=New PLAN=Planning RWRK=Re-Work |
| 10 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |