CAL_DOFY_VW (SQL View)	Index Back
View of Dtl Cal Periods FromYr

CAL_DOFY_VW

(SQL View)

View of Dtl Cal Periods FromYr

SELECT DISTINCT setid , calendar_id , fiscal_year FROM PS_CAL_DETP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

3 OPEN_YEAR_FROM Number(4,0) SMALLINT NOT NULL Open Year From

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
3	OPEN_YEAR_FROM	Number(4,0)	SMALLINT NOT NULL	Open Year From