PC_CRITERIA_SEQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	CRITERIA_ID	Character(10)	VARCHAR2(10) NOT NULL	Selection Criteria ID
4	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
5	CLEAR_PB	Character(1)	VARCHAR2(1) NOT NULL	Description Date Initials Issue ------------------ ------- ---------- -------- Modified field by adding a label 032105 SR 533368003 so that the mouse over text appears correctly on the price list maintenance page.
6	ACT_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Activity I=Include Activity X=Exclude Activity Default Value: I
7	RESTYP_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Resource Type I=Include Resource Type X=Exclude Resource Type Default Value: I
8	CAT_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Category I=Include Category X=Exclude Category Default Value: I
9	SUBCAT_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Subcategory I=Include Subcategory X=Exclude Subcategory Default Value: I
10	DATE_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Date I=Include Date X=Exclude Date Default Value: I
11	DEPTID_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Department I=Include Deptartment X=Exclude Department Default Value: I
12	PROFILE_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Profile ID I=Include Profile ID X=Exclude Profile ID Default Value: I
13	LOCATION_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Location I=Include Location X=Exclude Location Default Value: I
14	FIELD_IX_SW	Character(1)	VARCHAR2(1) NOT NULL	Exclude Field I=Include Field X=Exclude Field Default Value: I
15	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM Prompt Table: SP_BU_AM_NONVW