DP_VWFLD10_LNG(SQL View) |
Index Back |
---|---|
VWFLD 10 LNG VWSELECT DP_FIELDID ,DP_CAPTION FROM PS_DP_FIELD_SELS WHERE (DP_FIELDID LIKE 'DP_UD0%' OR DP_FIELDID Like 'DP_UD1%' OR DP_FIELDID Like 'DP_UD2%' OR DP_FIELDID Like 'DP_UD3%' OR DP_FIELDID Like 'DP_UD4%' OR DP_FIELDID Like 'DP_UD5%' OR DP_FIELDID = 'DP_LOCATION') |
SELECT DP_CONFIGVIEW , DP_FIELDID ,LANGUAGE_CD , DP_CAPTION FROM PS_DP_VWFLDSEL_LNG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
2 | DP_FIELDID | Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |