HR_GSS_PTAI_VW (SQL View)	Index Back
Action Items Lists Action Items Lists

HR_GSS_PTAI_VW

(SQL View)

Action Items Lists

SELECT PTAI_LIST_ID , PORTAL_NAME , PTAI_LABEL FROM PS_PTAI_LIST WHERE PTAI_IS_TMPL='Y' AND PTAI_ACTIVE_FLG = 'Y'

Related Language Record: HR_GSS_PTAI_LVW

# 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 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

3 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label

#	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	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
3	PTAI_LABEL	Character(100)	VARCHAR2(100) NOT NULL	Action Items - Label