OI_XLAT_BP_VW(SQL View) |
Index Back |
|---|---|
Budget Period XLAT Itemsview for xlat items |
| SELECT TA.XLATLONGNAME , TA.FIELDVALUE , TA.FIELDNAME FROM PSXLATITEM TA WHERE TA.FIELDNAME='CALENDAR_TYPE' AND TA.EFF_STATUS = 'A' AND TA.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM TB WHERE TB.FIELDNAME='CALENDAR_TYPE' AND TA.FIELDVALUE =TB.FIELDVALUE AND TB.EFF_STATUS = 'A' AND TB.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 2 | FIELDVALUE | Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |