WP_AGREEMENT_IDPERIOD_IDPrompt Table: WP_AGRT_PERIOD
EMPLIDDefault Value: WP_AGRT_CUST_VW.EMPLID
EMPL_RCDDefault Value: WP_AGRT_CUST_VW.EMPL_RCD
I=Immediate
N=No Interest
R=Re-Invest
Default Value: WP_AGREEMENT.WP_INTEREST_FLG
WP_AGRT_EE_INRT(SQL Table) |
Index Back |
|---|---|
Agreemt Custo |
| # | 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 | PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table: WP_AGRT_PERIOD |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: WP_AGRT_CUST_VW.EMPLID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: WP_AGRT_CUST_VW.EMPL_RCD |
| 5 | WP_INTEREST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Profit-Sharing
I=Immediate N=No Interest R=Re-Invest Default Value: WP_AGREEMENT.WP_INTEREST_FLG |