EP_APPR_SUM_VW (SQL View)	Index Back
HTML Email Email Hdr Record view used to provide header data to HTMl Email Approval template.

EP_APPR_SUM_VW

(SQL View)

HTML Email Email Hdr

Record view used to provide header data to HTMl Email Approval template.

SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , STA.SEQNO ,STA.TRANS_DT , %DateOut(A.PERIOD_BEGIN_DT ) %Concat ' - ' %Concat %DateOut(A.PERIOD_END_DT ) , B.NAME FROM PS_EP_APPR A , PS_PERSON_NAME B ,PS_EP_APPR_STA STA WHERE A.EMPLID = B.EMPLID AND A.EP_APPRAISAL_ID = STA.EP_APPRAISAL_ID AND STA.SEQNO=1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

5 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

7 TRANS_DT Date(10) DATE Transaction Date

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

9 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
6	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
7	TRANS_DT	Date(10)	DATE	Transaction Date
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name