RA_CONTENT_VW (SQL View)	Index Back
Content View Marketing Content view with status and the long and short status descriptions

RA_CONTENT_VW

(SQL View)

Content View

Marketing Content view with status and the long and short status descriptions

SELECT A.SETID , A.RA_CONTENT_ID , A.DESCR , A.RA_CONTENT_STATUS , B.XLATSHORTNAME , B.XLATLONGNAME FROM PS_RA_CONTENT A , PSXLATITEM B WHERE B.FIELDNAME = 'RA_CONTENT_STATUS' AND A.RA_CONTENT_STATUS = B.FIELDVALUE AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn )

# 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 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

5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

6 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	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	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
5	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
6	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name