TL_ESIGN_ID_LVW

(SQL View)
 Index Back

Acknowledgement Header

View against ESIGN_HDR to have prompt in Workgroup approval page

SELECT B.ESIGN_ID , B.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_ESIGN_HDR A , PS_ESIGN_HDR_LNG B WHERE A.ESIGN_ID = B.ESIGN_ID AND A.EFFDT = B.EFFDT UNION SELECT B.HCSC_ESIGN_ID , B.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_HCSC_ESIGN_HDR A , PS_HCSC_ES_HDR_LNG B WHERE A.HCSC_ESIGN_ID = B.HCSC_ESIGN_ID AND A.EFFDT = B.EFFDT

  • Related Language Record for TL_ESIGN_ID_VW

  • Audit Record: AUDIT_ESIGN_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TL_ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description