TRX_SE_IMP_SRCH (SQL View)	Index Back
Security Market Import Search Security Market Values Import Search

TRX_SE_IMP_SRCH

(SQL View)

Security Market Import Search

Security Market Values Import Search

SELECT oprid , run_cntl_id , import_object FROM PS_BSP_IMPORT WHERE import_object='60'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 IMPORT_OBJECT Character(2) VARCHAR2(2) NOT NULL Import Object
10=Bank Statement
20=Payment Acknowledgement
30=Payment Import
40=Investment Pools Import
50=Stock Quote Import
60=Security Market Value Import
70=Security Definition Import
80=Sanctions List Import
90=Cash Forecast Import

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPR_DEF_TBL_FS
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	IMPORT_OBJECT	Character(2)	VARCHAR2(2) NOT NULL	Import Object 10=Bank Statement 20=Payment Acknowledgement 30=Payment Import 40=Investment Pools Import 50=Stock Quote Import 60=Security Market Value Import 70=Security Definition Import 80=Sanctions List Import 90=Cash Forecast Import