GP_ABS_CALNA_LN

(SQL View)
 Index Back

Calendar Run for PNA Interface

Search view of Calendar Run ID's for Absence Management Create PNA Interface File.

SELECT DISTINCT A.CAL_RUN_ID ,D.LANGUAGE_CD ,D.DESCR FROM PS_GP_CAL_RUN A ,PS_GP_OPR_RULE_PRF B , PS_GP_CAL_RUN_LANG D WHERE (A.CAL_RUN_ID = D.CAL_RUN_ID) AND (A.RUN_FINALIZED_IND = 'Y') AND (B.USED_BY = 'A' OR A.COUNTRY = B.COUNTRY) AND ((OFF_CYCLE<>'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')) OR OFF_CYCLE = 'Y') AND (NOT EXISTS ( SELECT 'X' FROM PS_GP_ABS_INTF_LOG I WHERE I.CAL_RUN_ID=A.CAL_RUN_ID AND I.ABS_PAY_SYSTEM_CD='NA' AND I.STRM_NUM=0) OR EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_STRM S WHERE S.CAL_RUN_ID=A.CAL_RUN_ID AND S.STRM_NUM>0 AND NOT EXISTS ( SELECT 'X' FROM PS_GP_ABS_INTF_LOG J WHERE J.CAL_RUN_ID=S.CAL_RUN_ID AND J.ABS_PAY_SYSTEM_CD='NA' AND J.STRM_NUM=S.STRM_NUM)))

  • Related Language Record for GP_ABS_CALNA_VW

    • # 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