CLOSE_STAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	CLOSE_BOOKCD	Character(1)	VARCHAR2(1) NOT NULL	Close by Book Code Option Y/N Table Edit Default Value: N
6	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	CLOSING_SET	Character(20)	VARCHAR2(20) NOT NULL	Closing Rule
9	CLOSE_GRP_ID	Character(20)	VARCHAR2(20) NOT NULL	Closing Process Group Default Value: CLOSE_STAT_TBL.CLOSING_SET
10	CLOSE_STEP	Number(3,0)	SMALLINT NOT NULL	Closing Step Default Value: 1
11	EFFDT	Date(10)	DATE	Effective Date
12	BEGIN_DT	Date(10)	DATE	Begin Date
13	END_DT	Date(10)	DATE	End Date
14	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
16	AS_OF_DATE	Date(10)	DATE	As of Date
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
19	CLOSING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Type I=Interim Y=Year End
20	CLOSING_SCOPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Scope C=Incremental Current Period I=Incremental Year to Date Y=Incremental Year to Curr Per
21	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
22	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
23	UNCLOSED	Character(1)	VARCHAR2(1) NOT NULL	A flag to indicate whether the time frame in the log entry is unclosed.
24	UNDO_PREV_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Undo Previous Process