KK_KEY_CF_VW3 (SQL View)	Index Back
Distinct setid,effdt,lg,cf This view is used to support the CC Budget Overview (selection criteria). Returns distinct key,Effective Date and Effective Status are considered because we want the user to see key Chartfields that are the most current.

KK_KEY_CF_VW3

(SQL View)

Distinct setid,effdt,lg,cf

This view is used to support the CC Budget Overview (selection criteria). Returns distinct key,Effective Date and Effective Status are considered because we want the user to see key Chartfields that are the most current.

SELECT DISTINCT SETID1 ,EFFDT , LEDGER_GROUP , CHARTFIELD FROM PS_KK_KEY_CF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
4	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField