PGM_BUD_PLAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJ_NONVW
3	PC_BUDGET_ID	Number(3,0)	SMALLINT NOT NULL	Budget Plan ID Default Value: 1
4	PC_BUD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field defines a Projects Budget as either Cost or Revenue Based. C=Cost Budget R=Revenue Budget Default Value: C
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	START_DT	Date(10)	DATE NOT NULL	Start Date Default Value: PROJECT.START_DT
7	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Default Value: INSTALLATION_PC.PC_SUM_CAL_ID Prompt Table: PGM_CAL_BP_VW
8	NUM_PERIODS	Number(2,0)	SMALLINT NOT NULL	Number of Time Periods Default Value: INSTALLATION_PC.NUM_PERIODS
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: PROJECT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
10	BUD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Status 1=Active 2=Inactive 3=Submitted 4=Returned Default Value: 2
11	BASELINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Baseline Flag Y/N Table Edit Default Value: N
12	BASELINE_DT	Date(10)	DATE	Baseline Date
13	APPROVAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Approval Indicator Y/N Table Edit Default Value: N
14	APPROVAL_DT	Date(10)	DATE	Date of Approval
15	COMMENTS_254	Character(254)	VARCHAR2(254) NOT NULL	EDI Comments
16	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
17	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
18	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
19	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.