HR_OBD_PB_GRP_V

(SQL View)
 Index Back

List of steps not in a group

List steps in a obd activity guide that are not in a group.

SELECT A.PTAI_ITEM_ID , A.PTAI_LIST_ID , A.PTAI_DUE_DATE , A.PTAI_REQD , A.PTAI_SUMMARY , A.PTCS_SERVICEID , B.PTAI_PARENT_ACTION , B.PTAI_ACTIVE_FLG , A.PTAI_SEQ FROM PS_PTAI_ITEM A ,PS_PTAI_HIER B WHERE A.PTAI_ITEM_ID = B.PTAI_ITEM_ID AND B.PTAI_PARENT_ACTION <> 'ROOT' AND A.PTAI_STATUS <> '5'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
2 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
3 PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
4 PTAI_REQD Character(1) VARCHAR2(1) NOT NULL Required
N=No
Y=Yes
5 PTAI_SUMMARY Character(1) VARCHAR2(1) NOT NULL Summary
N=No
Y=Yes
6 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
7 PTAI_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Controller Action
8 PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
N=Display Inactive Lists
Y=Display Active Lists

Default Value: Y

9 PTAI_SEQ Number(4,0) SMALLINT NOT NULL Sequence