SETIDDefault Value: OPR_DEF_TBL_CS.SETID_CAREER
Prompt Table: SETID_TBL
ENRL_ACTIOND=Drop
N=Manual Add
ENRL_ACTION_REASONEFFDTDefault Value: %date
SSR_ENR_RSN4_VW(SQL View) |
Index Back |
|---|---|
Enrollment Reason ViewUnique by SETID and ENRL_ACTION |
| SELECT DISTINCT a.setid , a.enrl_action , a.enrl_action_reason , a.effdt FROM PS_ENRL_RSN_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_ENRL_RSN_TBL b WHERE b.setid = a.setid AND b.enrl_action = a.enrl_action AND b.enrl_action_reason = a.enrl_action_reason AND b.effdt <= %CurrentDateIn AND b.eff_status = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL |
| 2 | ENRL_ACTION |
Character(2) | VARCHAR2(2) NOT NULL |
Enrollment Action
D=Drop N=Manual Add |
| 3 | ENRL_ACTION_REASON |
Character(4) | VARCHAR2(4) NOT NULL | Enrollment Action Reason |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |