TR_FISCPRD_CLS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DETL_VW
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: CAL_FY_NOSET_VW
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. Prompt Table: CAL_DETP_ALL_VW
5	CLS_FISCPRD_ACCTG	Character(1)	VARCHAR2(1) NOT NULL	Fiscal Period Accounting close indicator. Y/N Table Edit Default Value: N
6	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
7	ORIG_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the original creation and saving of a given transaction.
8	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
9	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
10	RESET_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Identifies the Operator who reset the Fiscal Close indicators for a given Fiscal Year/Accounting Period.
11	RESET_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time the Fiscal Close indicators were last reset for a given Fiscal Year/Accounting Period.
12	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description