RA_YESNON=No
Y=Yes
RA_YESNO_PROMPT(SQL View) |
Index Back |
|---|---|
Yes/No Prompt View |
| SELECT %Substring(A.FIELDVALUE,1,1) FROM PSXLATITEM A WHERE A.FIELDNAME = 'RA_YESNO' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSXLATITEM A_ED WHERE A.FIELDNAME = A_ED.FIELDNAME AND A.FIELDVALUE = A_ED.FIELDVALUE AND A_ED.EFFDT <= %CurrentDateIn AND A_ED.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_YESNO |
Character(1) | VARCHAR2(1) NOT NULL |
This field denotes if Profile can be updated or not.
N=No Y=Yes |