HRS_ONL_SCRN_VW

(SQL View)
Index Back

Online Screening Definitions

This view is used to show all Screening Levels that have been defined as available for Online Screening.

SELECT HRS_SCREENING_ID , DESCR , DESCRSHORT , HRS_ONLINE_SCR_FLG FROM PS_HRS_SCREEN_TBL WHERE STATUS = 'A' AND HRS_ONLINE_SCR_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID

Prompt Table: HRS_SCREEN_TBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 HRS_ONLINE_SCR_FLG Character(1) VARCHAR2(1) NOT NULL This field determines that a Screening Level definition is to be used for Online Screening.

Default Value: Y