GPFR_DU_MRVWLNG

(SQL View)
Index Back

DUCS Reciever Contact Lang VW

DUCS Reciever Contact Related Lang View.

SELECT DISTINCT D.GPFR_DUCS_TYPE , D.GPFR_DUCS_MR1 , C0.LANGUAGE_CD , C0.DESCR FROM PS_GPFR_DUCS_DECL D , PS_GPFR_DUCSC0_LNG C0 WHERE D.GPFR_DUCS_TYPE = '903' AND C0.GPFR_CONT_CD = D.GPFR_DUCS_MR1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DUCS_TYPE Character(3) VARCHAR2(3) NOT NULL GPFR: DUCS Type
2 GPFR_DUCS_MR1 Character(10) VARCHAR2(10) NOT NULL Contact code for the Urssaf, Assedic, agirc/Arrco which will receive the Ducs file
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description