HGA_CALRUNID_VW

(SQL View)
 Index Back

Cal Run ID View

Cal Run ID view for Absence Exception

SELECT DISTINCT A.CAL_RUN_ID , B.DESCR FROM PS_GP_MESSAGES A , PS_GP_CAL_RUN B , PS_GP_CAL_RUN_DTL C WHERE A.CAL_RUN_ID=B.CAL_RUN_ID AND B.RUN_FINALIZED_IND = 'N' AND B.USE_AS_TMPLT_IND='N' AND B.CAL_RUN_ID = C.CAL_RUN_ID AND C.CALC_TYPE = 'A'

  • Related Language Record: HGA_CALRUN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description