SEC_LOC2_PR_VW (SQL View)	Index Back
Sec view for Loc by BU Prompt view for Locations where SCRTY_KEY2 is the first key instead of BUSINESS_UNIT.

SEC_LOC2_PR_VW

(SQL View)

Sec view for Loc by BU

Prompt view for Locations where SCRTY_KEY2 is the first key instead of BUSINESS_UNIT.

SELECT SETTBL.SETCNTRLVALUE , LOC.LOCATION , LOC.DESCR , LOC.SETID FROM PS_LOCATION_TBL LOC , PS_SET_CNTRL_REC SETTBL WHERE %EffdtCheck(LOCATION_TBL B, LOC, %CurrentDateIn) AND LOC.SETID = SETTBL.SETID AND SETTBL.RECNAME = 'LOCATION_TBL' AND EXISTS ( SELECT 'x' FROM PS_BUS_UNIT_TBL_HR BUS WHERE BUS.BUSINESS_UNIT = SETTBL.SETCNTRLVALUE)

Related Language Record: SEC_LOC2_PR_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_KEY2 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

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

4 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_KEY2	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID