LM_ADHC_LRNR_VW

(SQL View)
 Index Back

Adhoc Type View

Adhoc Type View

SELECT LM_ADHC_ID ,LM_ADHC_TYPE FROM PS_LM_ADHC_TBL WHERE %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT AND LM_ACTIVE = 'Y'

  • Related Language Record: LM_ADHC_LRLG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id

    Default Value: 9999999999

    Prompt Table: LM_ADHC_TBL

    2 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type