HR_TBH_RECSCHVW

(SQL View)
 Index Back

Template Record Search View

This is the search view for theTemplate Record Setup Table. It exludes the instance number and includes the description.

SELECT A.RECNAME , A.EFF_STATUS , B.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFN B WHERE A.INSTANCE = 1 AND B.RECNAME = A.RECNAME

  • Related Language Record: HR_TBH_RECSCVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: HR_TBH_RECLKPVW

    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description