ON_OR_OFFOFF=Off
ON=On
EQTN_ON_OFF_VW(SQL View) |
Index Back |
|---|
| SELECT %Substring(A.FIELDVALUE,1,3) FROM PSXLATITEM A WHERE A.FIELDNAME = 'ON_OR_OFF' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ON_OR_OFF |
Character(3) | VARCHAR2(3) NOT NULL |
Field value is either 'ON' or 'OFF".
OFF=Off ON=On |