CLOSTAT_PI_VW

(SQL View)

SELECT DISTINCT PROCESS_INSTANCE , LEDGER_GROUP , FISCAL_YEAR , AS_OF_DATE FROM PS_CLOSE_STAT_TBL A WHERE A.UNCLOSED = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

4 AS_OF_DATE Date(10) DATE As of Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	AS_OF_DATE	Date(10)	DATE	As of Date