TEXT_IDGP_ABS_LDHR_TXT(SQL View) |
Index Back |
|---|---|
HR Txt Catalg for Leave DonatnHR Text Catalog for Abs Mgmt Leave Donations |
| SELECT A.TEXT_ID FROM PS_HR_SSTEXT_TEXT A WHERE A.OBJECTOWNERID = 'HGA' AND A.HR_SSTEXT_SUB_ID = 'LVDN' 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 |