GP_ABS_MNGCALLN

(SQL View)
 Index Back

Abs Mgmt - Gen PI Cal Run

Abs Mgmt - Prompt view of Calendar Run IDs that are finalized but not yet processed by conversion programs.

SELECT A.CAL_RUN_ID ,D.LANGUAGE_CD ,D.DESCR FROM PS_GP_CAL_RUN A , PS_GP_CAL_RUN_LANG D WHERE (A.CAL_RUN_ID = D.CAL_RUN_ID) AND (A.RUN_FINALIZED_IND = 'Y') AND EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL DTL WHERE A.CAL_RUN_ID = DTL.CAL_RUN_ID AND DTL.CALC_TYPE = 'A') AND (NOT EXISTS ( SELECT 'X' FROM PS_GP_ABS_INTF_LOG I WHERE I.CAL_RUN_ID=A.CAL_RUN_ID))

  • Related Language Record for GP_ABS_MNGCALVW

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