RA_REGRSTAT_VW

(SQL View)
 Index Back

Registration Status View

Translate Long Name of Registration Status View

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='RAE_REG_REASON_CD' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEM AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE=AA.FIELDVALUE AND AA.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_REGRSTAT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAE_REG_REASON_CD Character(4) VARCHAR2(4) NOT NULL Marketing Events - Registration Reason Code
    DCLN=Declined
    RGST=Registered
    WAIT=Waitlisted
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name