CLOSING_RULE_VW (SQL View)	Index Back
Closing Rules available.

CLOSING_RULE_VW

(SQL View)

Closing Rules available.

SELECT DISTINCT SETID , CLOSING_SET , CLOSING_TYPE FROM PS_CLOSE_DEFN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CLOSING_SET Character(20) VARCHAR2(20) NOT NULL Closing Rule

3 CLOSING_TYPE Character(1) VARCHAR2(1) NOT NULL Closing Type
I=Interim
Y=Year End

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CLOSING_SET	Character(20)	VARCHAR2(20) NOT NULL	Closing Rule
3	CLOSING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Type I=Interim Y=Year End