TRW_STMT_NM_VW

(SQL View)
Index Back

Statement Name

View derives total rewards statement names.

SELECT EE.TRW_STMT_ID , EE.EMPLID , EE.TRW_STMT_RCD , STMT.TEMPLATE_ID , STMT.FROMDATE , STMT.THRUDATE , EE.TRW_EE_STMT_STS , EE.CURRENCY_CD , STMT.TRW_DESCR50 FROM PS_TRW_STMT_TBL STMT , PS_TRW_EE_STMT EE WHERE STMT.TRW_STMT_ID = EE.TRW_STMT_ID AND EE.TRW_EE_STMT_STS = 'PUB'

  • Related Language Record: TRW_STMT_NM_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRW_STMT_ID Character(15) VARCHAR2(15) NOT NULL Reward Statement ID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 TRW_STMT_RCD Number(3,0) SMALLINT NOT NULL Statement Record
    4 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Template ID

    Prompt Table: TRW_TEMPLATE

    5 FROMDATE Date(10) DATE From Date
    6 THRUDATE Date(10) DATE End Date
    7 TRW_EE_STMT_STS Character(3) VARCHAR2(3) NOT NULL Employee Statement Status
    BER=Build Error
    BLT=Built
    CAN=Cancelled
    EER=Extract Error
    EXT=Extracted
    INT=Initialized
    PBE=Publish Error
    PUB=Published
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 TRW_DESCR50 Character(50) VARCHAR2(50) NOT NULL Description field character 50