FO_PWD_SEC_A_VW

(SQL View)
 Index Back

Secret Question View

This view is used to retrieve Secret Questions and is used as Prompt to list Secret question

SELECT FO_PWD_HINT_ID , FO_PWD_HINT_DESC , FO_PWD_HINT_ACTIVE FROM PS_FO_PWD_SECRET_Q WHERE FO_PWD_HINT_ACTIVE='Y'

  • Related Language Record: FO_PWD_SECQ_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FO_PWD_HINT_ID Character(2) VARCHAR2(2) NOT NULL Secret Question ID
    2 FO_PWD_HINT_DESC Character(100) VARCHAR2(100) NOT NULL Secret Question
    3 FO_PWD_HINT_ACTIVE Character(1) VARCHAR2(1) NOT NULL Secret Question Active ?
    N=No
    Y=Yes