AM_WC_CAL_PD_VW (SQL View)	Index Back
Calendar View Cur and Prev Calendar View for Current and Pervious Period`

AM_WC_CAL_PD_VW

(SQL View)

Calendar View Cur and Prev

Calendar View for Current and Pervious Period`

SELECT DISTINCT C.SETID , C.CALENDAR_ID , A.BUSINESS_UNIT , A.BOOK , C.FISCAL_YEAR , C.ACCOUNTING_PERIOD , CASE WHEN C.ACCOUNTING_PERIOD = 1 THEN (C.FISCAL_YEAR -1) ELSE FISCAL_YEAR END , CASE WHEN C.ACCOUNTING_PERIOD = 1 THEN ( SELECT MAX(D.ACCOUNTING_PERIOD) FROM PS_CAL_DETP_TBL D WHERE D.SETID = C.SETID AND D.CALENDAR_ID = C.CALENDAR_ID) ELSE (C.ACCOUNTING_PERIOD -1) END , C.BEGIN_DT ,C.END_DT FROM PS_BU_BOOK_TBL A , PS_SET_CNTRL_REC B , PS_CAL_DETP_TBL C WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'CAL_DETP_TBL' AND B.SETID = C.SETID AND A.CAL_DEPR_PD = C.CALENDAR_ID AND %CurrentDateIn BETWEEN C.BEGIN_DT AND C.END_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AM_NONVW

4 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
Prompt Table: SP_BU_BK_NONVW

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

6 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.

7 LAST_FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Last Fiscal Year

8 ACCOUNTING_PERIOD2 Number(3,0) SMALLINT NOT NULL Accounting Period

9 BEGIN_DT Date(10) DATE Begin Date

10 END_DT Date(10) DATE End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_BK_NONVW
5	CUR_FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Current Fiscal Year
6	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.
7	LAST_FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Last Fiscal Year
8	ACCOUNTING_PERIOD2	Number(3,0)	SMALLINT NOT NULL	Accounting Period
9	BEGIN_DT	Date(10)	DATE	Begin Date
10	END_DT	Date(10)	DATE	End Date