POS_SELECT_VW (SQL View)	Index Back
Position Source Data View View of the position source fields. Used in the position monitor to display the date, amount, and reference fields.

POS_SELECT_VW

(SQL View)

Position Source Data View

View of the position source fields. Used in the position monitor to display the date, amount, and reference fields.

SELECT A.RECNAME , A.SETID , A.POS_SOURCE_ID , C.POS_FIELD_TYPE , B.FIELDNAME FROM PS_POS_SOURCE_TBL A , PS_POS_SOURCE_TBL2 B , PS_POS_FIELD_TYPE C WHERE A.SETID = B.SETID AND A.POS_SOURCE_ID = B.POS_SOURCE_ID AND B.ALIAS_NAME = C.ALIAS_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

4 POS_FIELD_TYPE Character(2) VARCHAR2(2) NOT NULL "The type of data field (character
01=Business Date
02=Business Unit
03=Amount
04=Bank SetID
05=Currency Code
06=Bank Code
07=Source Business Unit
08=Bank Account
09=Reference ID
10=Other
11=Facility ID
12=Bank Account Key
13=Payment Method
14=WorkSheetID

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
4	POS_FIELD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	"The type of data field (character 01=Business Date 02=Business Unit 03=Amount 04=Bank SetID 05=Currency Code 06=Bank Code 07=Source Business Unit 08=Bank Account 09=Reference ID 10=Other 11=Facility ID 12=Bank Account Key 13=Payment Method 14=WorkSheetID
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).