RAD_ADV_STT_VW

(SQL View)
 Index Back

Status View

Link status table with Advisor Type Table

SELECT A.RAD_ADVISOR_TYP_ID , A.RAD_STATUS_ID , A.SEQNO , B.DESCR , A.RAD_SHOW_FLAG , B.RAD_STATUS_TYP FROM PS_RAD_ADV_TYP_STT A , PS_RAD_STATUS B WHERE A.RAD_STATUS_ID = B.RAD_STATUS_ID

  • Related Language Record: RAD_ADV_STT_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_ADVISOR_TYP_ID Character(20) VARCHAR2(20) NOT NULL Advisor Type Guid - internally represents the Type
    2 RAD_STATUS_ID Character(20) VARCHAR2(20) NOT NULL Advisor Status
    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RAD_SHOW_FLAG Character(1) VARCHAR2(1) NOT NULL show flag
    6 RAD_STATUS_TYP Character(1) VARCHAR2(1) NOT NULL Advisor Status type - used to indicate the type for the status
    A=Archived
    D=Deployed
    I=In Progress
    N=New
    O=Past Deployed
    V=Validated