GP_GL_PREP1_VW (SQL View)	Index Back
Cal Runs prepared for GL Search view of CAL RUN and GL PREP STRM

GP_GL_PREP1_VW

(SQL View)

Cal Runs prepared for GL

Search view of CAL RUN and GL PREP STRM

SELECT B.OPRID ,A.CAL_RUN_ID , A.DESCR FROM PS_GP_CAL_RUN A ,PS_GP_OPR_RULE_PRF B WHERE A.USE_AS_TMPLT_IND = 'N' AND (B.USED_BY = 'A' OR A.COUNTRY = B.COUNTRY) AND EXISTS ( SELECT 'X' FROM PS_GP_GL_PREP_STRM S WHERE S.CAL_RUN_ID = A.CAL_RUN_ID)

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

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

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description