HREC_AWDSTS_VW

(SQL View)
 Index Back

Award Status

Award Status view used for Fluid View Compensation History setup page.

SELECT DISTINCT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='VC_AWARD_STATUS' AND A.FIELDVALUE IN ('A','D','P','S') AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PSXLATITEM A2 WHERE A2.EFFDT <= %CurrentDateIn AND A.FIELDNAME = A2.FIELDNAME AND A.FIELDVALUE =A2.FIELDVALUE) AND A.EFF_STATUS = 'A'

  • Related Language Record: HREC_AWDSTS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_AWARD_STATUS Character(2) VARCHAR2(2) NOT NULL Award Status
    A=Approved
    C=Cancelled
    D=Ready to Submit
    E=Error
    I=Initial Calculation
    J=Rejected
    P=Paid/Granted
    R=Recommended
    S=Submitted
    T=Accepted
    2 VC_AWD_STATUS_NAME Character(30) VARCHAR2(30) NOT NULL Award Status Description