WP_EE_FUND_VW(SQL View) |
Index Back |
|---|---|
EE Fund |
| SELECT SEC.OPRID , SEC.ROWSECCLASS , A.WP_AGREEMENT_ID , A.PERIOD_ID , A.EMPLID , A.EMPL_RCD , SEC.NAME , A.ORDER_SEQ , A.WP_GROSS_PAY , A.WP_FORMULA_ID , A.WP_ROUND_RULE , A.DEC_PLACES , A.WP_MAXDIS_FORM_ID , A.WP_MAXSAL_FORM_ID , A.WP_MAXSAL_PRO_FLG , A.WP_MAXALC_FORM_ID , A.WP_MAXALC_PRO_FLG , A.WP_EE_PRO_FACTOR , A.WP_SALARY_PRO_PCT , A.WP_DURAT_PRO_PCT , A.WP_UNIFORM_PRO_PCT , A.WP_TOTAL_GROSS_AMT , A.WP_TOTAL_NET_AMT , A.WP_TOTIN_GROSS_AMT , A.WP_TOTIN_NET_AMT , A.WP_GROSS_PAY_MAX , A.WP_RELEASE_FLG , A.WP_GLOBAL_FUND_AMT , A.CURRENCY_CD , A.ELIG_FLG FROM PS_WP_EE_FUND A , PS_EMPLMT_SRCH_GBL SEC WHERE SEC.EMPLID = A.EMPLID AND SEC.EMPL_RCD = A.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ROWSECCLASS |
Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | WP_AGREEMENT_ID |
Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 4 | PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table: WP_AGRT_PERIOD |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DT_FST |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB_CURR_VW |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL |
Sequence Order for Processing
Default Value: 0 |
| 9 | WP_GROSS_PAY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Salary |
| 10 | WP_FORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL | Profit Sharing Formula ID |
| 11 | WP_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Down S=Standard U=Up |
| 12 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 13 | WP_MAXDIS_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | Global Fund Limit Formula |
| 14 | WP_MAXSAL_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Individ. Salary Limit Formula
Prompt Table: WP_FORMULA_TBL |
| 15 | WP_MAXSAL_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorated |
| 16 | WP_MAXALC_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | Individual Alloc Limit Formula |
| 17 | WP_MAXALC_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorated |
| 18 | WP_EE_PRO_FACTOR | Number(19,6) | DECIMAL(18,6) NOT NULL | Prorate factor used in profit-sharing calculation |
| 19 | WP_SALARY_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Salary |
| 20 | WP_DURAT_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Prorate with Working Duration |
| 21 | WP_UNIFORM_PRO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Uniform Distribution |
| 22 | WP_TOTAL_GROSS_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Gross Amount |
| 23 | WP_TOTAL_NET_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Net Amount |
| 24 | WP_TOTIN_GROSS_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Interest Gross Amount |
| 25 | WP_TOTIN_NET_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Interest Net Amount |
| 26 | WP_GROSS_PAY_MAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Profit Sharing Amount |
| 27 | WP_RELEASE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Release Request
A=Amount N=None T=Total Release Default Value: N |
| 28 | WP_GLOBAL_FUND_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Global Fund Amount |
| 29 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: WP_AGREEMENT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 30 | ELIG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
If Criteria Met
E=Eligible I=Ineligible Y/N Table Edit Default Value: N |