WP_AGREEMENT_IDWP_INVESTMENT_CDEFFDTA=Active
I=Inactive
Default Value: A
WP_AGRT_DT_VST(SQL Table) |
Index Back |
|---|---|
Agreemt Invest EffDt TblEffective Dated data associated to the investment options for profit-sharing agreement |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WP_AGREEMENT_ID |
Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 2 | WP_INVESTMENT_CD |
Character(12) | VARCHAR2(12) NOT NULL | Investment Code for Profit-Sharing |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | INTEREST_RATE | Number(16,6) | DECIMAL(15,6) NOT NULL | Interest Rate |