COURSETRN_T_ACTION_ESPEFFDTDefault Value: %date
XML_TRN_ACT_VW2(SQL View) |
Index Back |
|---|---|
FT Actions for XML ReportingFT Actions for XML Reporting. Used by XML Complex Nodes. |
| SELECT DISTINCT B.COURSE , A.TRN_T_ACTION_ESP , A.EFFDT FROM PS_TRN_T_ACT_ESP A , PS_TRN_T_SESSN_ESP B , PS_CRSE_SESSN_TBL D WHERE A.TRN_T_ACTION_ESP = B.TRN_T_ACTION_ESP AND D.COURSE = B.COURSE AND D.SESSION_NBR = B.SESSION_NBR AND A.EFFDT = ( SELECT MAX (ED.EFFDT) FROM PS_TRN_T_ACT_ESP ED WHERE ED.TRN_T_ACTION_ESP = A.TRN_T_ACTION_ESP AND ED.EFFDT <= D.COURSE_START_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | TRN_T_ACTION_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Training Action |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |