VC_GROUP_LVW

(SQL View)
Index Back

Prompt view for groups R Lang

Related Language prompt view for groups

SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , B.GB_GROUP_ID , B.LANGUAGE_CD , B.DESCR FROM PS_VC_PAYPRD_TBL A , PS_GB_GROUPTBL_LNG B WHERE B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GB_GROUPTBL_LNG C WHERE C.GB_GROUP_ID = B.GB_GROUP_ID AND C.EFFDT <= A.PRD_END_DT )

  • Related Language Record for VC_GROUP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    2 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
    3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description