FT_XTRT_RUNID_V (SQL View)	Index Back
Run ID View Run ID View

FT_XTRT_RUNID_V

(SQL View)

Run ID View

SELECT DISTINCT FT_RUN_ID , 'TEST' FROM PS_FT_CWBOBJ_HDR WHERE FT_PROC_STATUS <> '50' AND FT_RUN_ID NOT IN ( SELECT FT_RUN_ID FROM PS_FT_CWBOBJ_HDR WHERE FT_PROC_STATUS = '50')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FT_RUN_ID	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description