BC_PORTFLIO_DFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PORTFOLIO_ID	Character(18)	VARCHAR2(18) NOT NULL	Portfolio ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
7	BC_OBJ_LIST_TYPE	Character(2)	VARCHAR2(2) NOT NULL	identifies whether the Objects for the Portfolio are defined by a Filter or by Object IDs. 01=Defined by Selection Rule 02=Defined by Object ID Default Value: 02
8	BC_FILTER_NAME	Character(18)	VARCHAR2(18) NOT NULL	identifies the name of this Selection Rule.
9	DESCRLONG	Long Character	CLOB	Long Description
10	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
11	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
12	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
13	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.