GPFR_DUCS_TYPEGPFR_DUCS_MR1LANGUAGE_CDGPFR_DU_MRVWLNG(SQL View) |
Index Back |
|---|---|
DUCS Reciever Contact Lang VWDUCS 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 |