BUDGET_BUS_UNIT (SQL Table)	Index Back
Budget Period - Bus. Unit Budget Period - Business Unit

BUDGET_BUS_UNIT

(SQL Table)

Budget Period - Bus. Unit

Budget Period - Business Unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
Prompt Table: BUDGET_PERIOD

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

3 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency
Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

4 FROZEN_SW Character(1) VARCHAR2(1) NOT NULL Frozen
N=Not Frozen
Y=Frozen
Default Value: N

5 TRN_PLN_CATEGORY Character(1) VARCHAR2(1) NOT NULL Feild for Training Plan Category
0=Not Specified
1=Adaptation to Job Changement
2=Job Preservation
3=Skill Development
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period Prompt Table: BUDGET_PERIOD
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
3	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
4	FROZEN_SW	Character(1)	VARCHAR2(1) NOT NULL	Frozen N=Not Frozen Y=Frozen Default Value: N
5	TRN_PLN_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Feild for Training Plan Category 0=Not Specified 1=Adaptation to Job Changement 2=Job Preservation 3=Skill Development Default Value: 0