RA_CONTENT_SRCH(SQL View) |
Index Back |
|---|---|
Campaign Content search viewSearch record for Contents of a campaign |
| SELECT A.SETID , A.RA_CONTENT_ID , A.DESCR , A.RA_CONTENT_STATUS , A.RA_AVAIL_QTY , A.RA_CONTENT_TYPE , A.RA_CONTENT_SUBTYPE , A.RA_PAR_CONTENT_ID , A.BO_ID_OWNER FROM PS_RA_CONTENT 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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | RA_CONTENT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Marketing - Content ID
Default Value: NEXT |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | 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 Default Value: NEW |
| 5 | RA_AVAIL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Requested Quantity to have available |
| 6 | RA_CONTENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Marketing - Content Type
Prompt Table: RA_UD_CONT_TYPE |
| 7 | RA_CONTENT_SUBTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Marketing - Content Sub Type
Prompt Table: RA_UD_CNT_STYPE |
| 8 | RA_PAR_CONTENT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Marketing Content Parent ID
Prompt Table: RA_CONTENT |
| 9 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |