HCB_TEXT_DATA(SQL View) |
Index Back |
|---|---|
HCB_Text_DataTable used to setup Chatbot answers which only involves text information. |
| SELECT DISTINCT(J.EMPLID) FROM PS_JOB J WHERE J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD= J.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND J.EFFSEQ= ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID=J.EMPLID AND J2.EMPL_RCD=J.EMPL_RCD AND J2.EFFDT=J.EFFDT) AND J.HR_STATUS ='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |