RY_CNST_ACT_LVW

(SQL View)
 Index Back

VC Type

Related language reocrd of the main variable content record, used to control all of the various flavors of VC.

SELECT B.RY_VC_TYPE_ID , B.LANGUAGE_CD , B.RY_NAME254 , B.DESCR254 FROM PS_RY_VC_TYPE A , PS_RY_VC_TYPE_LNG B WHERE A.RY_VC_TYPE_ID = B.RY_VC_TYPE_ID AND A.DEVELOPER = 'S' AND A.RY_VC_TYPE_STATUS = 'A' AND A.GROUP_ID = 'C'

  • Related Language Record for RY_CONST_ACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_VC_TYPE_ID Number(18,0) DECIMAL(18) NOT NULL Custom Variable Contentt Type ID.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254