HR_OBD_ITMDCR_V

(SQL View)
 Index Back

SELECT DISTINCT ITM.PTAI_LIST_ID , ITM.PTAI_ITEM_ID , LST.AGC_CATEGORY_ID , STP.AGC_STEP_ID FROM PS_AGC_TMPL_STEPS STP , PS_AGC_TMPL_TBL LST , PS_PTAI_LIST AGLIST , PS_PTAI_ITEM ITM WHERE STP.AGC_TEMPLATE_ID = LST.AGC_TEMPLATE_ID AND LST.AGC_LIST_ID = AGLIST.PTAI_PARENT_TMPL AND AGLIST.ptai_list_id = ITM.ptai_list_id AND ITM.PTAI_ITEM_ID = STP.AGC_ACTION_ITEM_ID || '_' || ITM.ptai_list_id AND STP.EFFDT = ( SELECT MAX(EFFDT) FROM PS_AGC_TMPL_STEPS TMP1 WHERE TMP1.AGC_TEMPLATE_ID = STP.AGC_TEMPLATE_ID AND TMP1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
2 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
3 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category
4 AGC_STEP_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Step Id