TI_GR_SEC_VW_LN

(SQL View)
 Index Back

RelLang of GB_GROUP_SEC_VW

Related Lang of GB_GROUP_SEC_VW

SELECT B.PNLGRPNAME ,B.GB_GROUP_ID , A.GB_OPRID , D.LANGUAGE_CD , D.DESCR FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_GB_GROUPTBL_LNG D WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND D.GB_GROUP_ID = A.GB_GROUP_ID AND A.GB_OPRID = B.GB_OPRID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_SECGRPOPR_TB WHERE A.GB_GROUP_ID = GB_GROUP_ID AND A.GB_OPRID = GB_OPRID AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_GROUP_TBL WHERE A.GB_GROUP_ID = GB_GROUP_ID AND EFF_STATUS = 'A' AND EFFDT <= %CurrentDateIn)

  • Related Language Record for TI_GROUP_SEC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description