YEAR1YEAR_PROMPT_VW(SQL View) |
Index Back |
|---|---|
AP Default Year Prompt ListConstruct the default Year prompt list from the oldest fiscal year to current year |
| SELECT DISTINCT fiscal_year FROM PS_CAL_DETP_TBL WHERE fiscal_year <= %Sql(EOEW_FUNCLIB_DATE_YEAR_UPD, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | YEAR1 |
Character(4) | VARCHAR2(4) NOT NULL | Year |