GPFR_DUCS_TYPEGPFR_DUCS_MR1GPFR_DUCS_MR1VW(SQL View) |
Index Back |
|---|---|
DUCS MR1 ViewDUCS MR1 View for DUCS Type 903 |
| SELECT DISTINCT D.GPFR_DUCS_TYPE , D.GPFR_DUCS_MR1 , C0.DESCR FROM PS_GPFR_DUCS_DECL D , PS_GPFR_DUCS_CONT0 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |