KK_CLOSE_STATUS (SQL Table)	Index Back
Budget Closing Status

KK_CLOSE_STATUS

(SQL Table)

Budget Closing Status

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 SUBTYPE Character(10) VARCHAR2(10) NOT NULL Ruleset

4 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

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

6 KK_CLOSING_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Closing Status
A=All
C=Closed
I=Invalid
N=No Status
P=Partial
U=Unclosed
V=Validated

7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

10 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

11 CLOSING_RULE_SET Character(20) VARCHAR2(20) NOT NULL Commitment Control Closing Rule Set

12 DTTM_STAMP_SEC 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	SUBTYPE	Character(10)	VARCHAR2(10) NOT NULL	Ruleset
4	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
5	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
6	KK_CLOSING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Closing Status A=All C=Closed I=Invalid N=No Status P=Partial U=Unclosed V=Validated
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
11	CLOSING_RULE_SET	Character(20)	VARCHAR2(20) NOT NULL	Commitment Control Closing Rule Set
12	DTTM_STAMP_SEC	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.