GL_PE_CF_DEP_VW (SQL View)	Index Back
GL Pagelet Dept Security GL Pagelet Department ID Security

GL_PE_CF_DEP_VW

(SQL View)

GL Pagelet Dept Security

GL Pagelet Department ID Security

SELECT OPRID ,BUSINESS_UNIT , FIELDNAME , CHARTFIELD_VALUE FROM PS_GL_PE_CF_SEC_TB D , PS_BUS_UNIT_TBL_GL B , PS_SET_CNTRL_GROUP S WHERE FIELDNAME=%Sql(DEPTID_QUOTES) AND D.SETID=S.SETID AND B.BUSINESS_UNIT=S.SETCNTRLVALUE AND S.REC_GROUP_ID='FS_06'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

4 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value