PC_NOTIFY_VW (SQL View)	Index Back
Status Report Notify view This view selects all employees who have to receive reminder to complete the Status Report

PC_NOTIFY_VW

(SQL View)

Status Report Notify view

This view selects all employees who have to receive reminder to complete the Status Report

SELECT TW.PROJECT_ID , TW.TEAM_MEMBER , TW.EMAILID , DT.SR_START_DATE , DT.SR_END_DATE , DT.REPORT_DUE_DATE FROM PS_PC_TEAM_EMP_VW TW , PS_PC_SR_FRQS FQ , PS_PC_SR_DATES DT WHERE TW.BUSINESS_UNIT = DT.BUSINESS_UNIT AND TW.PROJECT_ID = DT.PROJECT_ID AND TW.BUSINESS_UNIT = FQ.BUSINESS_UNIT AND TW.PROJECT_ID = FQ.PROJECT_ID AND TW.END_DT >= %CurrentDateIn AND FQ.SEND_REMINDER_FLAG = 'Y' AND %DateAdd(DT.REPORT_DUE_DATE,(FQ.DAYS_AHEAD * -1))= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_ALL_VW

2 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
Prompt Table: %EDITTABLE

3 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

4 SR_START_DATE Date(10) DATE Status Report start date

5 SR_END_DATE Date(10) DATE Status Report end date

6 REPORT_DUE_DATE Date(10) DATE Report Due Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ALL_VW
2	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member Prompt Table: %EDITTABLE
3	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
4	SR_START_DATE	Date(10)	DATE	Status Report start date
5	SR_END_DATE	Date(10)	DATE	Status Report end date
6	REPORT_DUE_DATE	Date(10)	DATE	Report Due Date