TRN_FZN_BDGT_VW (SQL View)	Index Back
Frozen Budget Period Table Contains the from and the thru date of the training budget period. And the base currency used during th simulation to display the costs.

TRN_FZN_BDGT_VW

(SQL View)

Frozen Budget Period Table

Contains the from and the thru date of the training budget period. And the base currency used during th simulation to display the costs.

SELECT A.BUDGET_PERIOD, A.EFFDT, A.DESCR, A.DESCRSHORT, A.THRU_DATE, B.BASE_CURRENCY FROM PS_BUDGET_PERIOD A, PS_BUDGET_BUS_UNIT B WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND B.FROZEN_SW = 'Y'

Related Language Record: TN_FZNBGTVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 THRU_DATE Date(10) DATE NOT NULL Thru Date

6 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	THRU_DATE	Date(10)	DATE NOT NULL	Thru Date
6	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency