OPS_TYPE_FRAPrompt Table: OPS_TYPE_VW
FUND_INST_VAL_FRAEFFDTDefault Value: %date
A=IRC ARRCO
B=Caisse CIBTP
C=IRC AGIRC
D=Delegate
G=IRC Group
M=Mutuelle
P=Pr�voyance
S=Assurance
U=URSSAF
X=Not Applicable
Prompt Table: FUND_FRA_TBL
OPS_FUND_INST_V(SQL View) |
Index Back |
|---|---|
Pendion Institution ViewPendion Institution View |
| SELECT OPS_TYPE_FRA ,FUND_INST_VAL_FRA ,EFFDT ,DESCR50 ,DESCRSHORT ,FUND_INST_FRA ,FND_INST_TYPE_FRA ,FUND_CD_FRA FROM PS_FUND_INST_FRA A WHERE A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPS_TYPE_FRA |
Character(10) | VARCHAR2(10) NOT NULL |
OPSType (FRA)
Prompt Table: OPS_TYPE_VW |
| 2 | FUND_INST_VAL_FRA |
Character(20) | VARCHAR2(20) NOT NULL | Deligate instutiion ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | FUND_INST_FRA | Character(4) | VARCHAR2(4) NOT NULL | Fund Institution Number |
| 7 | FND_INST_TYPE_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Pensions/Contingency Funds Institution Type (FRA)
A=IRC ARRCO B=Caisse CIBTP C=IRC AGIRC D=Delegate G=IRC Group M=Mutuelle P=Pr�voyance S=Assurance U=URSSAF X=Not Applicable |
| 8 | FUND_CD_FRA | Character(6) | VARCHAR2(6) NOT NULL |
Fund Code - France
Prompt Table: FUND_FRA_TBL |