EOCF_YESNO_PRMT

(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 EOCF_YESNO Character(1) VARCHAR2(1) NOT NULL Yes/No
N=No
Y=Yes