GP_ABS_HR_TEXT

(SQL View)
Index Back

HR Text Catalog for Absence

HR Text Catalog for Absence

SELECT A.TEXT_ID FROM PS_HR_SSTEXT_TEXT A WHERE A.OBJECTOWNERID = 'HGA' AND %EffdtCheck(HR_SSTEXT_TEXT,A,%CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID