EP_CCKPT_ITM_VW (SQL View)	Index Back
Completed/skipped checkpoints Returns item ratings and comments for completed and skipped checkpoint steps and completed Finalize Criteria step. Finalize Criteria step = chkpt type "C" (there could be multiple rows if this step was reopened). Checkpoint step = chkpt type "S". ("Complete" or "Skipped" checkpoints are selected).

EP_CCKPT_ITM_VW

(SQL View)

Completed/skipped checkpoints

Returns item ratings and comments for completed and skipped checkpoint steps and completed Finalize Criteria step. Finalize Criteria step = chkpt type "C" (there could be multiple rows if this step was reopened). Checkpoint step = chkpt type "S". ("Complete" or "Skipped" checkpoints are selected).

SELECT A.EP_APPRAISAL_ID , C.EP_SECTION_TYPE , C.EP_ITEM_ID , C.EP_ITEM_SEQ , B.EP_CHKPT_NBR , B.EP_CHKPT_TYPE , B.EP_CHKPT_COMPLETE , A.EP_EST_STATUS , C.EP_EE_REVW_RATING , C.EP_ITEM_EE_CMNTS , C.EP_MGR_REVW_RATING , C.EP_ITEM_MGR_CMNTS FROM PS_EP_APPR A , PS_EP_APPR_C D , PS_EP_APPR_CHECKPT B , PS_EP_APPR_C_ITEM C WHERE D.EP_APPRAISAL_ID = A.EP_APPRAISAL_ID AND B.EP_APPRAISAL_ID = D.EP_APPRAISAL_ID AND B.EP_CHKPT_NBR = D.EP_CHKPT_NBR AND C.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND C.EP_CHKPT_NBR = B.EP_CHKPT_NBR AND (((B.EP_CHKPT_COMPLETE = 'C' OR B.EP_CHKPT_COMPLETE = 'S') AND B.EP_CHKPT_TYPE = 'S') OR (B.EP_CHKPT_TYPE = 'C' AND B.EP_CHKPT_NBR = (select MAX(EP_CHKPT_NBR) from PS_EP_APPR_CHECKPT B1 where B1.EP_APPRAISAL_ID=B.EP_APPRAISAL_ID and EP_CHKPT_TYPE='C') and A.EP_TRKPROG_STATUS = 'CO' And A.EP_TP_SUB_STATUS = 'F'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

3 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier

4 EP_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Item sequence number

5 EP_CHKPT_NBR Number(2,0) SMALLINT NOT NULL the number of the checkpoint during the track progress step

6 EP_CHKPT_TYPE Character(1) VARCHAR2(1) NOT NULL Checkpoint Type
A=Approved
C=Completed
S=Scheduled

7 EP_CHKPT_COMPLETE Character(1) VARCHAR2(1) NOT NULL Completed
C=Completed
S=Skipped

8 EP_EST_STATUS Character(4) VARCHAR2(4) NOT NULL Translate field that determines the state (status) of the establish criteria step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started

9 EP_EE_REVW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

10 EP_SEC_EE_CMNTS Long Character CLOB Track progress document - EE comments at section level

11 EP_MGR_REVW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

12 EP_SEC_MGR_CMNTS Long Character CLOB Track progress document - mgr comments at section level

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type
3	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier
4	EP_ITEM_SEQ	Number(2,0)	SMALLINT NOT NULL	Item sequence number
5	EP_CHKPT_NBR	Number(2,0)	SMALLINT NOT NULL	the number of the checkpoint during the track progress step
6	EP_CHKPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Type A=Approved C=Completed S=Scheduled
7	EP_CHKPT_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Completed C=Completed S=Skipped
8	EP_EST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the establish criteria step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started
9	EP_EE_REVW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
10	EP_SEC_EE_CMNTS	Long Character	CLOB	Track progress document - EE comments at section level
11	EP_MGR_REVW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
12	EP_SEC_MGR_CMNTS	Long Character	CLOB	Track progress document - mgr comments at section level