RAD_ADV_STP_VWL(SQL View) |
Index Back |
---|---|
Step View for AdvisorLanguage view for Steps for Advisor |
SELECT A.RAD_ADVISOR_TYP_ID , A.RAD_STEP_ID , C.LANGUAGE_CD , C.DESCR , C.DESCR254 FROM PS_RAD_ADV_TYP_STP A , PS_RAD_STEPS B , PS_RAD_STEPS_LNG C WHERE A.RAD_STEP_ID = B.RAD_STEP_ID AND B.RAD_STEP_ID = C.RAD_STEP_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RAD_ADVISOR_TYP_ID | Character(20) | VARCHAR2(20) NOT NULL | Advisor Type Guid - internally represents the Type |
2 | RAD_STEP_ID | Character(20) | VARCHAR2(20) NOT NULL | Step ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |