AP_EM_DFLT_DATE (SQL View)	Index Back
AP EM Default Date Construct the default 90 days date range

AP_EM_DFLT_DATE

(SQL View)

AP EM Default Date

Construct the default 90 days date range

SELECT %Sql(EOEW_FUNCLIB_DATE_DAYADD_UPD, %CurrentDateIn, -90) , %CurrentDateIn , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, %Sql(EOEW_FUNCLIB_DATE_DAYADD_UPD, %CurrentDateIn, -90)) , %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, %CurrentDateIn) , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, %Sql(EOEW_FUNCLIB_DATE_DAYADD_UPD, %CurrentDateIn, -90)) , %Sql(EOEW_FUNCLIB_DATE_MONTH_UPD, %CurrentDateIn) FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FROM_DATE Date(10) DATE From Date

2 TO_DATE Date(10) DATE To Date

3 YEAR_FROM Character(4) VARCHAR2(4) NOT NULL From Year
1=NONE

4 YEAR_TO Character(4) VARCHAR2(4) NOT NULL To Year
1=NONE

5 MONTH_FROM Character(2) VARCHAR2(2) NOT NULL Month From

6 MONTH_TO Character(2) VARCHAR2(2) NOT NULL Month To

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FROM_DATE	Date(10)	DATE	From Date
2	TO_DATE	Date(10)	DATE	To Date
3	YEAR_FROM	Character(4)	VARCHAR2(4) NOT NULL	From Year 1=NONE
4	YEAR_TO	Character(4)	VARCHAR2(4) NOT NULL	To Year 1=NONE
5	MONTH_FROM	Character(2)	VARCHAR2(2) NOT NULL	Month From
6	MONTH_TO	Character(2)	VARCHAR2(2) NOT NULL	Month To