EP_ACCESS_VW_VW

(SQL View)

SELECT EP_APPRAISAL_ID , 0 , 'DEFINE CRITERIA' , 'DTL_EST_DESCR' FROM PS_EP_APPR WHERE EP_EST_STATUS = 'CO' UNION ALL SELECT EP_APPRAISAL_ID , 14 , 'FINALIZE TP' , 'TP_DOC_SUB_STATUS' FROM PS_EP_APPR WHERE EP_TRKPROG_STATUS = 'CO' UNION ALL SELECT EP_APPRAISAL_ID , EP_CHKPT_NBR , 'CHECKPOINT ' || %NumToChar(ep_chkpt_nbr) , 'TP_DOC_SUB_STATUS' FROM PS_EP_APPR_CHECKPT WHERE ep_chkpt_complete IN ('C', 'S') UNION ALL SELECT EP_APPRAISAL_ID , 16 , 'SELF-EVALUATION' , 'DTL_SLF_DESCR' FROM PS_EP_APPR_ROLE WHERE EP_ROLE = 'E' AND EP_REVIEW_STATUS = 'CO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EP_SUB_SEQ Number(2,0) SMALLINT NOT NULL Sub-Item sequence number

3 EP_STEP_TITLE Character(50) VARCHAR2(50) NOT NULL Work field used to display a Step Title from a Text Catalog entry.

4 EP_SELECT_LINK Character(60) VARCHAR2(60) NOT NULL Generic "Select Link" hyperlink

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_SUB_SEQ	Number(2,0)	SMALLINT NOT NULL	Sub-Item sequence number
3	EP_STEP_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Work field used to display a Step Title from a Text Catalog entry.
4	EP_SELECT_LINK	Character(60)	VARCHAR2(60) NOT NULL	Generic "Select Link" hyperlink