FE_LOC_TXN_VW (SQL View)	Index Back
Federal Location Change Record being used with Federal Location Change transaction

FE_LOC_TXN_VW

(SQL View)

Federal Location Change

Record being used with Federal Location Change transaction

SELECT A.TRANSACTION_NBR , O.OPRID FROM PS_FE_MGR_LOC_XREF A , PS_EOAW_STEPINST C , PS_EOAW_USERINST D , PSOPRDEFN O WHERE A.EOAWTHREAD_ID = C.EOAWTHREAD_ID AND A.EOAWPRCS_ID = C.EOAWPRCS_ID AND A.EOAWDEFN_ID = C.EOAWDEFN_ID AND C.EOAWSTEP_INSTANCE = D.EOAWSTEP_INSTANCE AND ((A.ORIGINATORID = O.OPRID OR A.EOAWREQUESTOR_ID = O.OPRID) OR ((D.OPRID = O.OPRID OR D.EOAWORIG_OPRID = O.OPRID)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).