GP_ABS_MNGCALVW

(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 ,A.DESCR FROM PS_GP_CAL_RUN A WHERE (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))

# 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