HRS_SSTP_DUM_VW (SQL View)	Index Back
Resume substep dummy view Dummy view on HRS_RES_SUBSTEP, used as a prompt for the Substep drop-down in the Sections grid. SQL is purposely written to return no rows. The drop-down is populated dynamically via PeopleCode.

HRS_SSTP_DUM_VW

(SQL View)

Resume substep dummy view

Dummy view on HRS_RES_SUBSTEP, used as a prompt for the Substep drop-down in the Sections grid. SQL is purposely written to return no rows. The drop-down is populated dynamically via PeopleCode.

SELECT HRS_RES_TMPL_ID , HRS_PAGE_SEQ , HRS_SEQ_NUM , HRS_SUBSTEP_TXT_ID FROM PS_HRS_RES_SUBSTEP WHERE HRS_RES_TMPL_ID = -1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_RES_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Resume Template ID

2 HRS_PAGE_SEQ Number(3,0) SMALLINT NOT NULL Page Sequence

3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 HRS_SUBSTEP_TXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_RES_TMPL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Resume Template ID
2	HRS_PAGE_SEQ	Number(3,0)	SMALLINT NOT NULL	Page Sequence
3	HRS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	HRS_SUBSTEP_TXT_ID	Character(18)	VARCHAR2(18) NOT NULL	Text ID