RA_PROVGRPV_LNG

(SQL View)
 Index Back

Provider Group Related Lang

This is the Related Language table for Provider Groups. It holds translations for the Provider Group name.

SELECT A.PROVIDER_GRP_ID , A.LANGUAGE_CD , A.NAME1 , A.SETID FROM PS_RF_PROVGRP_LNG A , PS_RF_PROVIDER_GRP B WHERE B.STATUS = 'A' AND A.PROVIDER_GRP_ID = B.PROVIDER_GRP_ID AND A.SETID = B.SETID

  • Related Language Record for RA_PROVGRP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID