SCP_CONTENT_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCP_CONTENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Content Type
2	SCP_CONTENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Content ID
3	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
4	SCP_CONTENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Content Status N=Not Published P=Published Default Value: N
5	SCP_SECURITY_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Content Security Group Prompt Table: SCP_CONTSEC_GRP
6	SCP_FAQ_GROUP	Character(4)	VARCHAR2(4) NOT NULL	FAQ Group Prompt Table: SCP_FAQ_GROUPS
7	SCP_SUMMARY	Character(254)	VARCHAR2(254) NOT NULL	Content Summary
8	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
9	END_DATE	Date(10)	DATE NOT NULL	End Date
10	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
11	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
12	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
14	USED_CNT	Number(6,0)	INTEGER NOT NULL	KPIs Considered for the Scorecard Count.
15	SCP_DETAIL	Long Character	CLOB	Content Detail
16	SCP_PLAIN_TEXT	Long Character	CLOB	Short Description
17	SCP_ALLOW_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Enable Selection by Subject N=N N=N Y=Y Y=Y Default Value: N
18	SCP_REG_LINK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Registration Link Type: S - Supplier; B - Bidder; U - User; B=Bidder S=Supplier U=User Default Value: S
19	PSIMAGEVER	Number(10,0)	DECIMAL(10) NOT NULL	Image Version
20	SCP_ICON	Image / Attachment	CLOB	Registration Links Icon