GPCN_PAY_APP_VW (SQL View)	Index Back
Only submmited Calendar For approval search page

GPCN_PAY_APP_VW

(SQL View)

Only submmited Calendar

For approval search page

SELECT CAL_RUN_ID , GPCN_APP_STATUS FROM PS_GPCN_PAY_APP WHERE GPCN_APP_STATUS IN ('SUB', 'APP','DEN')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GPCN_REQ_IN_VW

2 GPCN_APP_STATUS Character(3) VARCHAR2(3) NOT NULL record's status :submitted and saved and denied and approved
APP=Approved
DEN=Denied
SAV=Saved
SUB=Submitted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPCN_REQ_IN_VW
2	GPCN_APP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	record's status :submitted and saved and denied and approved APP=Approved DEN=Denied SAV=Saved SUB=Submitted