POS_SRC_FLD_VW2 (SQL View)	Index Back
Positions Data Source Table 2 View for determining when to enable the Default Value field for input.

POS_SRC_FLD_VW2

(SQL View)

Positions Data Source Table 2

View for determining when to enable the Default Value field for input.

SELECT A.SETID ,A.POS_SOURCE_ID ,A.ALIAS_NAME ,B.FIELDNAME_TO FROM PS_POS_SOURCE_TBL2 A , PS_CSH_FCST_GRP_BY B , PS_CSH_FCST_GROUP C WHERE A.ALIAS_NAME= B.ALIAS_NAME AND C.CSH_FCST_MAP_ID = B.CSH_FCST_MAP_ID AND C.EFFDT = B.EFFDT AND C.EFFDT = ( SELECT MAX (EFFDT) FROM PS_CSH_FCST_GROUP D WHERE D.CSH_FCST_MAP_ID = C.CSH_FCST_MAP_ID AND D.EFFDT <=%CurrentDateIn) AND C.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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

3 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

4 FIELDNAME_TO Character(18) VARCHAR2(18) NOT NULL Destination Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
3	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym
4	FIELDNAME_TO	Character(18)	VARCHAR2(18) NOT NULL	Destination Field