COMPANYPrompt Table: COMPANY_TBL
ESTABIDPrompt Table: ESTAB_COMP_VW
OPS_TYPE_FRAPrompt Table: OPS_NCTYPE_VW
FUND_INST_VAL_FRAPrompt Table: FUND_VALUEID_VW
OPS_DUCS_DUP_VW(SQL View) |
Index Back |
|---|---|
Get Duplicate DUCS DataGet Duplicate DUCS Data |
| SELECT COMPANY ,ESTABID ,OPS_TYPE_FRA ,FUND_INST_VAL_FRA FROM PS_OPS_ESTAB_IMP IMP WHERE EXISTS ( SELECT 'X' FROM PS_OPS_ESTAB_IMP IGRP WHERE IGRP.COMPANY = IMP.COMPANY AND IGRP.ESTABID = IMP.ESTABID AND IGRP.OPS_TYPE_FRA = IMP.OPS_TYPE_FRA GROUP BY COMPANY ,ESTABID ,OPS_TYPE_FRA HAVING COUNT(FUND_INST_VAL_FRA) > 1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_COMP_VW |
| 3 | OPS_TYPE_FRA |
Character(10) | VARCHAR2(10) NOT NULL |
OPSType (FRA)
Prompt Table: OPS_NCTYPE_VW |
| 4 | FUND_INST_VAL_FRA |
Character(20) | VARCHAR2(20) NOT NULL |
Deligate instutiion ID
Prompt Table: FUND_VALUEID_VW |