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_DELDTL(SQL Table) |
Index Back |
|---|---|
DUCS Deleted DataDUCS Deleted Data |
| # | 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 |