EOEW_CODESRC_VW

(SQL View)
Index Back

Source input for Translatn Set

Used for the translation set prompt to determine the source input on the map field detail.

SELECT DISTINCT A.RECNAME , B.EOEW_CODE_OBJ , A.FIELDNAME FROM PS_EOEW_ETLC_FLST A , PS_EOEW_CODE_TBL B WHERE A.FIELDTYPE = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 EOEW_CODE_OBJ Character(50) VARCHAR2(50) NOT NULL Translation Set

Prompt Table: EOEW_CODE_TBL
Set Control Field: EOEW_CODE_OBJ

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EOEW_ETLC_FLST
Set Control Field: RECNAME