GP_WC_SRCH (SQL View)	Index Back
GP Workcenter GP Workcenter - Serach record for Work Items Page

GP_WC_SRCH

(SQL View)

GP Workcenter

GP Workcenter - Serach record for Work Items Page

SELECT DISTINCT A.OPRID , A.CAL_RUN_ID , A.PTAI_LIST_ID FROM PS_GP_WC_AG_TBL A , PS_PTAI_CONTEXT CON WHERE CON.FIELDNAME = 'CAL_RUN_ID' AND CON.PTAI_KEY_VALUE = A.cal_run_id AND A.PTAI_LIST_ID = CON.PTAI_LIST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	PTAI_LIST_ID	Character(31)	VARCHAR2(31) NOT NULL	Action Items - Action Item List ID