EX_PE_TEXP_PRS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	BUSINESS_UNIT_GL1	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with an internal counterparty. Prompt Table: SP_BU_GL_NONVW
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	DEPT_PROJ_VIEW	Character(1)	VARCHAR2(1) NOT NULL	Department Project View D=View by Department P=View by Project Default Value: D
9	GL_BU_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	GL Business Unit Source S=Specify U=From Employee Profile Default Value: U
10	PC_BU_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	A flag to indicate where the Business Unit personalization filter will come from: User Preference or a Specified Value. S=Specify U=Projects User Preferences Default Value: U
11	PROJECT_OPT_FILTER	Character(2)	VARCHAR2(2) NOT NULL	Project Filters MP=My Projects NO=No Additional Filters PM=Project Manager SP=Project ID Default Value: NO
12	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: EX_PE_CALEND_VW
13	NUMBER_PERIODS_EX	Character(2)	VARCHAR2(2) NOT NULL	Number of Past Periods 01=01 02=02 03=03 04=04 05=05 06=06 07=07 08=08 09=09 10=10 11=11 12=12
14	TARGET_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Target Sales
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	WARNING_PERCENT	Number(3,0)	SMALLINT NOT NULL	The percentage of the target threshold that would trigger a warning.
17	SHOW_ALERT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator to determine whether to always show threshold alert or only when in Alert condition. N=No Y=Only if Alert