HRS_PASS_MSG_VW (SQL View)	Index Back
User Configurable Text Selects the Pass Message TEXT_ID's

HRS_PASS_MSG_VW

(SQL View)

User Configurable Text

Selects the Pass Message TEXT_ID's

SELECT A.TEXT_ID FROM PS_HR_SSTEXT_TEXT A WHERE A.OBJECTOWNERID = 'HRS' AND A.TEXT_ID LIKE 'HRS_%_PASS%' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HR_SSTEXT_TEXT B WHERE B.TEXT_ID = A.TEXT_ID AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID