SETIDDefault Value: OPR_DEF_TBL_CS.SETID_CAREER
Prompt Table: SETID_TBL
ENRL_ACTIOND=Drop
N=Manual Add
ENRL_ACTION_REASONLANGUAGE_CDSSR_ENRSN7VWLNG(SQL View) |
Index Back |
|---|---|
Rel Lang Enroll Reason Viewlanguage record related to SSR_ENR_RSN7_VW A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT l.setid , l.enrl_action , l.enrl_action_reason , l.language_cd , l.descr FROM PS_SSR_ENR_RSN4_VW a ,ps_enrl_rsn_lang l WHERE l.setid = a.setid AND l.enrl_action = a.enrl_action AND l.enrl_action_reason= a.enrl_action_reason AND l.effdt = a.effdt AND l.acad_career = ( SELECT MIN(l2.acad_career) FROM ps_enrl_rsn_lang l2 WHERE l2.setid = a.setid AND l2.enrl_action = a.enrl_action AND l2.enrl_action_reason = a.enrl_action_reason AND l2.effdt = a.effdt) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |